3 ms·
What is the equivalent for MySQL?
by andrewmcwatters 5y ago
What is the equivalent for MySQL?
- redis_mlc 5y agoMySQL 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.