EmergencyEMERGENCY? Get 24/7 Help Now!

What Are Full, Incremental, and Differential Backups?

 | January 23, 2012 |  Posted In: Insight for DBAs, MySQL

Sometimes you might hear people talk about full backups, and differential backups versus incremental backups. What is the difference? A full backup is pretty self-explanatory. It makes a copy of all of your MySQL data. A differential backup, on the other hand, simply records the differences since your last full backup. The advantage of taking […]

Read More

How Does Semisynchronous MySQL Replication Work?

 | January 19, 2012 |  Posted In: Insight for DBAs, MySQL

With the recent release of Percona XtraDB Cluster, I am increasingly being asked about MySQL’s semi-synchronous replication. I find that there are often a number of misconceptions about how semi-synchronous replication really works. I think it is very important to understand what guarantees you actually get with semi-synchronous replication, and what you don’t get. The […]

Read More