4 ms·
MySQL has had a myriad of easy-to-use solutions for over a decade that offer point-in-time cloning: - Percona xtrabackup - Linux LVM snapshots - master-slave
by redis_mlc 5y ago
MySQL has had a myriad of easy-to-use solutions for over a decade that offer point-in-time cloning:
- Percona xtrabackup
- Linux LVM snapshots
- master-slave replication
- then built-in replication for point-in-time catchup.
I do some work with pg, but it seems clunky compared to MySQL for typical HA and failover scenarios, but it can be done. All the MySQL methods I mentioned above can and have been scripted. With MySQL GTIDs, it's usually trivial.
MySQL 8 and Percona Cluster are easy-to-use multi-master topologies. (I only use them with less than 100 GB of data in case of state transfers.)
Source: MySQL DBA.