MySQL or its forks?

What is your preferred choice when working with MySQL databases? The top 3 are MySQL itself, MariaDB and Percona. I currently use MariaDB 10.1 across all servers and can’t wait to roll out 10.2 which offers a great performance increase in my testing!...

Creating another MYSQL instance and restoring DB (R1soft)

1. Restore the raw DB files from the recovery point: ib_logfile0 ib_logfile1 ibdata1 /var/lib/mysql/mysql /var/lib/mysql/_dbname The log files, ibdata and mysql tables must always be restored in addition to the actual user database(s). Important: Restore to an...

MySQL Master-Slave Replication

MySQL master slave replication gives you two copies of your database: the “live” one and the backup one. You always write your data to your master and read from the master too, but you will always have an up-to-date copy on your slave. Setting up the master Server...