MySQL / MariaDB : re-sync a replicated slave to the master

/
Assumptions: 2 or more database servers in a master-slave with…

MySQL replicated cluster / replication change master node IP on slaves

/
On the master record the master_log_file and the master_log_pos [crayon-5954f007b7ff1575138983/]…

Debian 7 PowerDNS Enable Replication to Slave Servers ( MySQL 5.5+ Master Slave Replication )

/
Assumptions Minimal Debian 7 installation Completed Proxmox /…

Ubuntu / Debian / Redhat / CentOS : Nginx + PowerAdmin ( PowerDNS MySQL PHP Based Admin )

/
Poweradmin is a friendly web-based DNS administration tool for…

Debian 7 wheezy : 3 Node Percona XtraDB Cluster + XtraBackup + GLB Load Balancer ( aka MySQL + Galera )

/
Assumptions Minimal Debian 7 installation Completed Proxmox /…

Ubuntu 12.04 / LTS : Migrate / Move from MariaDB Cluster to Percona XtraDB Cluster ( aka MySQL + Galera )

/
Migrate / Move from MariaDB Cluster to Percona XtraDB Cluster…

Automated MySQL Backups with innobackupex ( Percona Xtrabackup )

/
Install the latest xtrabackup The main advantage of using xtrabackup…