Keep using MySQL instead of MariaDB

kelaskakap · 12-13-2013, 04:01 PM

Hello,

I just upgrade my Slackware from 14.0 to 14.1. I know 14.1 comes with Maria DB packages, but actually I still wanna use MySQL instead of Maria DB. How to use MySQL instead of Maria DB? I want to uninstall Maria DB and re-install MySQL (is there package/slackbuild script of MySQL 5.6.x for Slackware 14.1?)

this is my packages list

Code:

bash-4.2$ ls /var/log/packages/|grep mysql
mysql-5.5.27-x86_64-1
mysql-compat32-5.5.27-x86_64-1compat32
mysql-workbench-gpl-5.2.47-x86_64-1_SBo
bash-4.2$ ls /var/log/packages/|grep maria
mariadb-5.5.32-x86_64-1
mariadb-compat32-5.5.32-x86_64-1compat32
bash-4.2$

actually I have uninstall MariaDB with this command

Code:

#removepkg mariadb

removing mariadb-5.5.32-x86_64-1 and mariadb-compat32-5.5.32-x86_64-1compat32

but I still cannot run my old mysql

Help me, please, guys..

thank you so much

Alien Bob · 12-13-2013, 04:07 PM

kikinovak · 12-13-2013, 04:30 PM

Here's some information:

http://www.linux.com/news/enterprise...adb-from-mysql

kelaskakap · 12-13-2013, 04:53 PM

Quote:

Originally Posted by Alien Bob

Why?

I don't know, just still not familiar with MariaDB. is this compitable with all database I've already created with MySQL? query language, php code, are those still same ? like connecting ex, mysql_connect() , etc. one of my database using innodb, is maria db support it?

thanks

kelaskakap · 12-13-2013, 04:56 PM

Quote:

Originally Posted by kikinovak

Here's some information:

http://www.linux.com/news/enterprise...adb-from-mysql

thank you

astrogeek · 12-13-2013, 04:56 PM

Quote:

Originally Posted by kelaskakap

I don't know, just still not familiar with MariaDB. is this compitable with all database I've already created with MySQL? query language, php code, are those still same ? like connecting ex, mysql_connect() , etc. one of my database using innodb, is maria db support it?

thanks

Literally everything will work exactly as before, except better!

MariaDB is a "drop in replacement" for MySQL, even the filenames are the same.

*** UPDATE ***

I had many of the same reservations when I made the switch. I installed MariaDB and did the normal MySQL version update functions on my live databases. Not a single hickup. Not a single issue. The only difference was improved performance.

kelaskakap · 12-13-2013, 05:03 PM

Quote:

Originally Posted by astrogeek

Literally everything will work exactly as before, except better!

MariaDB is a "drop in replacement" for MySQL, even the filenames are the same.

*** UPDATE ***

I had many of the same reservations when I made the switch. I installed MariaDB and did the normal MySQL version update functions on my live databases. Not a single hickup. Not a single issue. The only difference was improved performance.

thank you for the information. so if I want to remove my mysql package by executing #removepkg mysql, maria db can still running?

kelaskakap · 12-13-2013, 05:08 PM

sorry forget to ask,
if I use maria db to build database for website, and the hosting provider still using mysql, is this still possible to dump file.sql then import into hosting provider? are they still compatible?

astrogeek · 12-13-2013, 05:14 PM

Not sure what you mean by that.

If you mean can you install MariaDB and have it running, then remove MySQL, no.

As I said, the filenames are identical, so only one can be installed at a time.

You should read this quick reference to convert to mariadb for oreintation. But as it says, you should view it just as a mysql version update.

If you are updating a live box you will need to kill the MySQL server, then removepkg mysql, then installpkg mariadb and run mysql_upgrade.

As ALWAYS even with MySQL upgrades it is wise to first do mysqldump of your databases - just in case.

kelaskakap · 12-13-2013, 05:23 PM

Quote:

Originally Posted by astrogeek

Not sure what you mean by that.

If you mean can you install MariaDB and have it running, then remove MySQL, no.

As I said, the filenames are identical, so only one can be installed at a time.

You should read this quick reference to convert to mariadb for oreintation. But as it says, you should view it just as a mysql version update.

If you are updating a live box you will need to kill the MySQL server, then removepkg mysql, then installpkg mariadb and run mysql_upgrade.

As ALWAYS even with MySQL upgrades it is wise to first do mysqldump of your databases - just in case.

sorry my english's bad,
I have this packages

Code:

bash-4.2$ ls /var/log/packages/|grep mysql
mysql-5.5.27-x86_64-1
mysql-compat32-5.5.27-x86_64-1compat32
mysql-workbench-gpl-5.2.47-x86_64-1_SBo
bash-4.2$ ls /var/log/packages/|grep maria
mariadb-5.5.32-x86_64-1
mariadb-compat32-5.5.32-x86_64-1compat32
bash-4.2$

if I uninstall mysql-5.5.27-x86_64-1 mysql-compat32-5.5.27-x86_64-1compat32 by running removepkg, is that safe? I mean, I can still use maria db?

then, if I build website and use maria db in my computer, and I want to upload to the server, but the server still use mysql instead of maria db, is there any problem with that?

thank you, sorry

bosth · 12-13-2013, 05:24 PM

Quote:

Originally Posted by kelaskakap

sorry forget to ask,
if I use maria db to build database for website, and the hosting provider still using mysql, is this still possible to dump file.sql then import into hosting provider? are they still compatible?

That actually sounds like it could be a reason to keep using MySQL locally.

kelaskakap · 12-13-2013, 05:31 PM

Quote:

Originally Posted by bosth

That actually sounds like it could be a reason to keep using MySQL locally.

and I forgot to ask it lol

astrogeek · 12-13-2013, 05:40 PM

Quote:

Originally Posted by kelaskakap

sorry my english's bad,
I have this packages

Code:

bash-4.2$ ls /var/log/packages/|grep mysql
mysql-5.5.27-x86_64-1
mysql-compat32-5.5.27-x86_64-1compat32
mysql-workbench-gpl-5.2.47-x86_64-1_SBo
bash-4.2$ ls /var/log/packages/|grep maria
mariadb-5.5.32-x86_64-1
mariadb-compat32-5.5.32-x86_64-1compat32
bash-4.2$

if I uninstall mysql-5.5.27-x86_64-1 mysql-compat32-5.5.27-x86_64-1compat32 by running removepkg, is that safe? I mean, I can still use maria db?

then, if I build website and use maria db in my computer, and I want to upload to the server, but the server still use mysql instead of maria db, is there any problem with that?

thank you, sorry

It appears that you have BOTH mysql and mariadb packages installed at the same time which is not correct. So which is actually running as 'mysql' would be the last one that you installed because it would have overwritten the earlier one.

Code:

mysql -V

... will tell you which (I bet you are running MariaDB and don't know it! That would be reassuring!).

To make sure you have a clean installation I would suggset this (as root):

Code:

/etc/rc.d/rc.mysqld stop

removepkg mysql-compat
removepkg mysql
removapkg mariadb-compat
removepkg mariadb

installpkg mariadb path/to/package
installpkg mariadb-compat path/to/package

chmod +x /etc/rc.d/rc.mysqld
/etc/rc.d/rc.mysqld start

mysql_upgrade (see man page for options)

You should be good to go!

I don't think that you will need to rebuild mysql-workbench due to this change.

astrogeek · 12-13-2013, 05:42 PM

Quote:

Originally Posted by kelaskakap

sorry forget to ask,
if I use maria db to build database for website, and the hosting provider still using mysql, is this still possible to dump file.sql then import into hosting provider? are they still compatible?

That is not a problem - they will be compatible - I do it regularly.

bosth · 12-13-2013, 05:48 PM

Quote:

Originally Posted by astrogeek

That is not a problem - they will be compatible - I do it regularly.

So there are no SQL features in MariaDB that aren't in MySQL? (genuine question, I use PostgreSQL),