We can install mysql-server to get MySQL 5.5, but the MySQL 5.6 package is likely also available: sudo apt-get install -y mysql-server-5.6 We're using an Ubuntu server here, but this should work for Debian as well. This will show the use of debconf-set-selections and debconf-get-selections to configure MySQL setting that might normally be prompted for during installation.# Installing MySQL We'll cover install MySQL non-interactively (no prompts), useful for scripting installs. I have not fact checked any of these claims, but am including them here in case.Learn how to install MySQL 5.5 or 5.6. And the main reason people use MariaDB is to avoid possible licensing issues that honestly almost never come into play. MySQL is far more stable and refined and works great! I have had to upgrade many servers from MariaDB to MySQL for this reason. Your general assumption on MariaDB makes sense in basic situations, but in cases where large data comes into play, like more than 500,000 to millions of rows of data, MariaDB shows it’s flaws. Update: A user in the comments pointed out some flaws, their comment states: In my opinion, you don’t have to take my opinion, but I think MariaDB is a better choice than MySQL. Server supports Windows, Linux, FreeBSD, Solaris, and OS XĬan handle large amounts of data without becoming unstable Proprietary code is accessible in MySQL Enterprise. “MariaDB has a significantly high number of new > features, which makes it better in terms of performance > and user-orientation than MySQL.”īasically, MariaDB is a drop-in replacement for MySQL and here’s a table of all the differences: Then actually install MariaDB: sudo apt-get install mariadb-server mariadb-client mariadb-backup
Install the APT repo, just like MySQL curl -LsS | sudo bash To actually install MySQL server: sudo apt update Sudo dpkg -i mysql-apt-config_0.8.22-1_all.deb You can install MySQL via the APT repository. This has already been answered, but I might as well include it here. The question on how to install it has already been answered, so I will answer the cons and pros of MySQL and MariaDB, and how to install either one.
0 kommentar(er)
