securitybreach Posted March 25, 2013 Share Posted March 25, 2013 MariaDB is now officially our default implementation of MySQL. MariaDB is almost a drop in replacement, so an upgrade should be possible with minimum hassle. However, due to remaining compatibility concerns, an automatic replace is not done.It is recommended for all users to upgrade. MySQL will be dropped from the repositories to the AUR in a month. Users who want to switch will need to install mariadb, libmariadbclient or mariadb-clients and execute mysql_upgrade in order to migrate their systems. Migration example: # systemctl stop mysqld # pacman -S mariadb libmariadbclient mariadb-clients # systemctl start mysqld # mysql_upgrade -p percona-server is another MySQL fork available in [community]. It should be closer to Oracle MySQL Enterprise, but is missing the new features included in MariaDB. Together with mysql 5.5.30-7 in [extra], all packages depending on it have been rebuilt against their MariaDB counterparts. Other package maintainers should move their dependencies to the MariaDB packages. More information can be found on our mailing list. https://www.archlinux.org/news/mariadb-replaces-mysql-in-repositories/ Quote Link to comment Share on other sites More sharing options...
Guest LilBambi Posted March 25, 2013 Share Posted March 25, 2013 Shouldn't it just be another option like PostgreSQL Not replace it? Quote Link to comment Share on other sites More sharing options...
V.T. Eric Layton Posted March 25, 2013 Share Posted March 25, 2013 Well, alright then. Quote Link to comment Share on other sites More sharing options...
ichase Posted March 25, 2013 Share Posted March 25, 2013 Where have I heard this before. This sounds so familiar to me. Can't quite put my finger on it. Quote Link to comment Share on other sites More sharing options...
Guest LilBambi Posted March 25, 2013 Share Posted March 25, 2013 Quote Link to comment Share on other sites More sharing options...
V.T. Eric Layton Posted March 25, 2013 Share Posted March 25, 2013 Â Added Arch Linux to Maria DB Prominent Users at Wikipedia --> http://en.wikipedia.org/wiki/MariaDB#Prominent_users 2 Quote Link to comment Share on other sites More sharing options...
ichase Posted March 25, 2013 Share Posted March 25, 2013 Que Twighlight zone music NOW 1 Quote Link to comment Share on other sites More sharing options...
V.T. Eric Layton Posted March 25, 2013 Share Posted March 25, 2013 http://youtu.be/XVSRm80WzZk 1 Quote Link to comment Share on other sites More sharing options...
securitybreach Posted March 25, 2013 Author Share Posted March 25, 2013 Shouldn't it just be another option like PostgreSQL Not replace it? Â Yeah, I do not know why it replaced mysql but the migration worked beautifully on my server.... Quote Link to comment Share on other sites More sharing options...
securitybreach Posted March 25, 2013 Author Share Posted March 25, 2013 Shouldn't it just be another option like PostgreSQL Not replace it?  From the mailing list link in the first post: Hello guys, Because Oracle is Oracle is Oracle(…) I would like to propose migration to MariaDB.  Jokes aside, the biggest problem with MySQL situation is that it becomes more and more closed source. Oracle stopped publishing regression tests[1], informative security advisories, they even hide bug reports and not include them in release notes[2]. Very often their bzr repository is falling behind new releases[3].  On the other hand, MariaDB is truly open source (it doesn't have enterprise-only options) and has open development model. Security advisories are published first on the mailing list for packagers with a patch for current release and information when the bug will be fixed and when the information about security hole can be published (Another advantage for ricers -- some benchmarks show that MariaDB is faster.) Quote Link to comment Share on other sites More sharing options...
ichase Posted March 25, 2013 Share Posted March 25, 2013 So the question is this. Who did Oracle tick off? Quote Link to comment Share on other sites More sharing options...
V.T. Eric Layton Posted March 25, 2013 Share Posted March 25, 2013 Oracle's been parsing people off for quite some time already. Quote Link to comment Share on other sites More sharing options...
securitybreach Posted March 25, 2013 Author Share Posted March 25, 2013 Also, mysql will be moving out of the main repos into the AUR repos soon. Quote Link to comment Share on other sites More sharing options...
abarbarian Posted March 25, 2013 Share Posted March 25, 2013 Shame on Arch for falling behind. I believe the Slackware folk were taking action on this hours ago. 1 Quote Link to comment Share on other sites More sharing options...
V.T. Eric Layton Posted March 25, 2013 Share Posted March 25, 2013 Arch... copycats! Quote Link to comment Share on other sites More sharing options...
securitybreach Posted March 25, 2013 Author Share Posted March 25, 2013 Shame on Arch for falling behind. I believe the Slackware folk were taking action on this hours ago. Â Well it was mentioned on the Archlinux mailing list on Mon Feb 18 13:42:24 EST 2013 Quote Link to comment Share on other sites More sharing options...
securitybreach Posted March 25, 2013 Author Share Posted March 25, 2013 Also, the founder of MySQL was the one who created MariaDB: Specifically, "the MariaDB Foundation exists to improve database technology, including standards implementation, interoperability with other databases, and building bridges to other types of database such as transactional and NoSQL. To deliver this the Foundation provides technical work in reviewing, merging, testing, and releasing the MariaDB product suite. The Foundation also provides infrastructure for the MariaDB project and the user and developer communities."Â This might strike you as much ado about nothing. What's another DBMS in a world where Oracle owns the most popular open-source DBMS: MySQL? What makes it noteworthy is that a year after Sun brought MySQL in 2008 for a billion dollars, Michael 'Monty' Widenius, MySQL's founder went his own way and started his own fork of the DBMS. Today, we know that fork as MariaDB. http://www.zdnet.com...cle-7000008311/ Quote Link to comment Share on other sites More sharing options...
abarbarian Posted March 25, 2013 Share Posted March 25, 2013 Well it was mentioned on the Archlinux mailing list on Mon Feb 18 13:42:24 EST 2013 Â Ah ha righty. I was referring to this though, Â Added Arch Linux to Maria DB Prominent Users at Wikipedia --> http://en.wikipedia....Prominent_users Quote Link to comment Share on other sites More sharing options...
ichase Posted March 25, 2013 Share Posted March 25, 2013 For those of you that know me, you know that I love Arch, I really do. But I swear when it comes to any kind of update that requires user intervention, I must have the WORST luck. Â [root@arch64 ichase02]# systemctl stop mysqld [root@arch64 ichase02]# pacman -S mariadb libmariadbclient mariadb-clients resolving dependencies... looking for inter-conflicts... :: libmariadbclient and libmysqlclient are in conflict. Remove libmysqlclient? [y/N] y :: mariadb-clients and mysql-clients are in conflict. Remove mysql-clients? [y/N] y :: mariadb and mysql are in conflict. Remove mysql? [y/N] y Targets (6): libmysqlclient-5.5.30-6 [removal] mysql-5.5.30-6 [removal] mysql-clients-5.5.30-6 [removal] libmariadbclient-5.5.30-1 mariadb-5.5.30-1 mariadb-clients-5.5.30-1 Total Download Size: 16.86 MiB Total Installed Size: 152.41 MiB Net Upgrade Size: 28.51 MiB Proceed with installation? [Y/n] y :: Retrieving packages from extra... libmariadbclient-5.... 6.6 MiB 2.13M/s 00:03 [######################] 100% mariadb-clients-5.5... 873.8 KiB 2.34M/s 00:00 [######################] 100% mariadb-5.5.30-1-x86_64 9.4 MiB 2.23M/s 00:04 [######################] 100% (3/3) checking package integrity [######################] 100% (3/3) loading package files [######################] 100% (3/3) checking for file conflicts [######################] 100% (6/6) checking available disk space [######################] 100% (1/3) removing libmysqlclient [######################] 100% (2/3) removing mysql-clients [######################] 100% (3/3) removing mysql [######################] 100% (1/3) installing libmariadbclient [######################] 100% (2/3) installing mariadb-clients [######################] 100% (3/3) installing mariadb [######################] 100% >> If you are migrating from MySQL, don't forget to run 'mysql_upgrade' after mysqld.service restart. Optional dependencies for mariadb perl-dbd-mysql: mytop dependency perl-term-readkey: mytop dependency [root@arch64 ichase02]# systemctl start mysqld [root@arch64 ichase02]# mysql_upgrade -p Enter password: Phase 1/3: Fixing table and database names mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect FATAL ERROR: Upgrade failed Why would ROOT have to supply a password??????????? Quote Link to comment Share on other sites More sharing options...
securitybreach Posted March 25, 2013 Author Share Posted March 25, 2013 Try running: mysql_upgrade -u root -p password  Unless you made another account for MySQL. Quote Link to comment Share on other sites More sharing options...
ichase Posted March 25, 2013 Share Posted March 25, 2013 Same thing. [root@arch64 ichase02]# mysql_upgrade -u root -p password Enter password: Phase 1/3: Fixing table and database names mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect FATAL ERROR: Upgrade failed IN the off chance I made a seperate account for mysql (which I know I did not) I would have used the password I entered. What does it mean by using password: YES? Quote Link to comment Share on other sites More sharing options...
securitybreach Posted March 25, 2013 Author Share Posted March 25, 2013 Same thing. [root@arch64 ichase02]# mysql_upgrade -u root -p password Enter password: Phase 1/3: Fixing table and database names mysqlcheck: Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect FATAL ERROR: Upgrade failed IN the off chance I made a seperate account for mysql (which I know I did not) I would have used the password I entered. What does it mean by using password: YES?  Well part of the set up is deciding if you want to run MySQL as a root user (not the normal root account but the mysql one). The wiki entry says to add a root account for maintaining users and databases: Once you have started the MySQL server, you probably want to add a root account in order to maintain your MySQL users and databases. This can be done manually or automatically, as mentioned by the output of the above script. Either run the commands to set a password for the root account, or run the secure installation script.You now should be able to do further configuration using your favorite interface. For example you can use MySQL's command line tool to log in as root into your MySQL server: $ mysql -p -u root  https://wiki.archlin...index.php/MySQL  BTW when I said root account, I meant the one for MYSQL not the normal root account. http://dev.mysql.com...privileges.html Quote Link to comment Share on other sites More sharing options...
ichase Posted March 26, 2013 Share Posted March 26, 2013 (edited) Had to run out. Got to thinking. If I had not set a password for root for mysql, then try the line and enter (nothing) for password. Alas it worked. Â Thanks for the links Josh Would you recommend to reboot after this? Edited March 26, 2013 by ichase Quote Link to comment Share on other sites More sharing options...
securitybreach Posted March 26, 2013 Author Share Posted March 26, 2013 Good deal Quote Link to comment Share on other sites More sharing options...
securitybreach Posted March 26, 2013 Author Share Posted March 26, 2013 Would you recommend to reboot after this? No need to reboot as you just had to restart the service. Nothing more.. 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.