From Mariadb to Mysql good idea?
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
@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
am using mariadb 10.1 now, will there be problems if i downgrade?
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