- Creating a backup or a copy of the database as a snapshot
- Using replication applications to capture the incremental changes and apply to the snapshot created earlier. This is to keep the slave server up-to-date.
- MySQL Native Replication: an out-of-box replication tool for MySQL
- Oracle GoldenGate: Oracle replication tool which works for other databases as well.
- Continuent Tungsten: open source replication also supporting other database such as Oracle and PostgreSQL.
- Percona XtraBackup: an open-source hot backup utility for MySQL.
MySQL Native Replication
Database replication involves the following operations:
- Creating a backup or a copy of the database as a snapshot
- Using replication applications to capture the incremental changes and apply to the snapshot created earlier. This is to keep the slave server up-to-date.
There are several tools you can use to replicat MySQL database:
- MySQL Native Replication: an out-of-box replication tool for MySQL
- Oracle GoldenGate: Oracle replication tool which works for other databases as well.
- Continuent Tungsten: open source replication also supporting other database such as Oracle and PostgreSQL.
- Percona XtraBackup: an open-source hot backup utility for MySQL.
- How to enable binary logging for MySQL?
- How to find the directory storing MySQL binary logs?
- How to examining the MySQL binary logs?