Answer the question
In order to leave comments, you need to log in
How to install mariadb on top of mysql?
Good afternoon. There is a question about optimizing our web servers. Still vacillating between percona and mariadb.
The essence of the question is that in our infrastructure it is arranged in such a way that the application itself lies next to the database. Now a bunch of tomcat7 and muscle 5.5 and a night dump of the database. For optimization, we plan to set up master-slave replication. But to make it really good - also instead of a muscle - its fork.
How, without unnecessary manipulations - to make a muscle - Maria (or perkona)
Google does not understand my requests)
Answer the question
In order to leave comments, you need to log in
demolish the muscle, put Maria. in general, in centos 7 yum install muscle, I remember putting Maria already, or putting Maria, but #mysql starts Maria's client by alias
Raise a new server, put everything you need from the very beginning. Transfer data, transfer everything to a new server, start everything from it and then turn off the old server.
Regarding migration:
In a general situation, the following may be sufficient:
/var/log/mysql.log
or /var/log/mysql.err
. /etc/apt/sources.list
or /etc/apt/sources.list.d/
), then sudo apt-get update
, then install the mysql-server package back. Before doing this, it's a good idea to roll back the /etc/mysql and /var/lib/mysql backups to their original locations in order to eliminate the consequences of changing the data files / configs by upgrading to MariaDB. Then analyze what went wrong and better prepare for the next migration attempt.Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question