wordpress

MySQL Master-Master Replication

Create MySQL user CREATE USER ‘droaming’@’localhost’ IDENTIFIED BY ‘DroamG.123’; CREATE USER ‘droaming’@’%’ IDENTIFIED BY ‘DroamG.123’; Drop Mysql User DROP USER ‘droaming’@’localhost’; DROP USER ‘droaming’@’%’; Create Mysql Database and grant permission CREATE DATABASE droaming; GRANT ALL ON droaming.* TO ‘droaming’@’localhost’; View MySQL users SELECT User, Host, Password FROM mysql.user; MySQL Master-Master Replication SERVER 01 [mysqld] datadir=/var/lib/mysql […]

Setting up Galera Arbitrator

Galera Arbitrator <http://galeracluster.com/documentation-webpages/arbitrator.html> is a member of Percona XtraDB Cluster that is used for voting in case you have a small number of servers (usually two) and don’t want to add any more resources. Galera Arbitrator does not need a dedicated server. It can be installed on a machine running some other application. Just make sure it has […]

How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?

This is the full step-by-step procedure to resync a master-slave replication from scratch: At the master: And copy the values of the result of the last command somewhere. Without closing the connection to the client (because it would release the read lock) issue the command to get a dump of the master: Now you can release the […]