In this blog, we discuss Galera Cluster and synchronous versus asynchronous replication. We also discuss some of the differences between Galera Cluster and Tungsten Cluster rooted in this difference in foundation. And how Tungsten has served a critical niche - mission-critical, geo-distributed, highly-performant MySQL applications - for a long time.
Real time database replication is a must for clustering and other key business purposes, like reporting. There are a number of replication technologies available for MySQL, and some are even bundled into various solutions. When choosing a replication methodology, it is paramount to understand just how the data moves from source to target. In this blog post, we will examine how asynchronous, synchronous, and "semi-synchronous" replication behave when used for clustering. Also, we will explore how replication affects database performance and data availability.