From Mariadb to Mysql good idea?

Hello;

I am using mariadb 10.1 and HHVM, recently am thinking about getting a control panel plesk, vesta or serverpilot on ubuntu 14 but they all install mysql 5.5.4. i want to know if there will be any issue during mysql upload because sometimes ago some fields and tags were stripped off when upload the database to the new server.

Thanks

5 Replies

Mariadb is fully supported by Plesk. More detail you can find here http://docs.plesk.com/en-US/12.5/advanc … ver.72943/">http://docs.plesk.com/en-US/12.5/advanced-administration-guide-linux/services-management/database-server.72943/

@pavuk:

Mariadb is fully supported by Plesk. More detail you can find here http://docs.plesk.com/en-US/12.5/advanc … ver.72943/">http://docs.plesk.com/en-US/12.5/advanced-administration-guide-linux/services-management/database-server.72943/

I know but how do i get mariadb on Ubuntu 14.04? by default it will install MYSQL also getting plesk to work with Ubuntu alway turn out bad for me

@pavuk:

Mariadb is fully supported by Plesk. More detail you can find here http://docs.plesk.com/en-US/12.5/advanc … ver.72943/">http://docs.plesk.com/en-US/12.5/advanced-administration-guide-linux/services-management/database-server.72943/

Here is what plesk wrote…

> Configure the MariaDB repository on your server. To generate the repository configuration for your operating system, use the wizard available at https://downloads.mariadb.org/mariadb/repositories/. When selecting the MySQL version, choose the version not less than your current MySQL version. Additionally, the version must not be higher than 5.5.

am using mariadb 10.1 now, will there be problems if i downgrade?

Try making test of un-installing MariaDBIf you need a non-blocking OPTIMIZE, and re-install mySQL. I think that should work without any issue. Oracle is the best supporter of migration from Mariadb to MySQL as it pretends non-existence of Mariadb (company politics-policies) and it doesn't provide the possibility of migration too.

The migration should be straightforward only if you don't utilize the special features (no storage engines besides MyISAM/Innodb). Shutdown Mariadb, save the data directory, remove MariaDB, install MySQL, copy the saved data directory back. In the worst case you'd need to remove parameters from my.ini/my.cnf that are not recognized by MySQL.

@EmmaT:

Try making test of un-installing MariaDBIf you need a non-blocking OPTIMIZE, and re-install mySQL. I think that should work without any issue. Oracle is the best supporter of migration from Mariadb to MySQL as it pretends non-existence of Mariadb (company politics-policies) and it doesn't provide the possibility of migration too.

The migration should be straightforward only if you don't utilize the special features (no storage engines besides MyISAM/Innodb). Shutdown Mariadb, save the data directory, remove MariaDB, install MySQL, copy the saved data directory back. In the worst case you'd need to remove parameters from my.ini/my.cnf that are not recognized by MySQL.

Alright thanks

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct