Hi Rafael, On Wed, Oct 29, 2014 at 10:15 AM, Rafał Radecki <radecki.ra...@gmail.com> wrote:
> I am creating an environment based on about 15 hardware nodes. 6 of them > will be for mysql databases. They will be divided into three pairs (3x2 > nodes). Nodes in every pair will be configured with replication. > > I done similar configuration about an year ago. I used than: > - percona 5.5 with standard asynchronous replication; > - Multi Master Replication Manager for MySQL (http://mysql-mmm.org/ > <https://t.yesware.com/tl/2627942011ccc3835f76c6e9ba4c0af91f3d3722/407ea34fcfb29332bbc93cdb34f13e4f/df42c03e188abb8c80b981666b82e7ff?ytl=http%3A%2F%2Fmysql-mmm.org%2F>) > for > automatic assignment/failover of read and write IP addresses and checking > the status of replication (mmm provides status scripts); > While it works fine for many situations, I wouldn't recommend using it for any new setups. There hasn't been any updates for years and there are a decent number of edge cases where MMM fails miserably. There are better alternatives out there these days. > My question is: I heard that there are other options than standard > asynchronous replication which sometimes was problematic (for example there > was one slave thread only in percona 5.5 and there was a possibility that > slave node will fall behind master node in high load situations). I also am > thinking which MySQL fork is the best option if I plan to use replication. > What can you propose based on your experience? > If you want to stick with standard replication, either MariaDB 10 or Percona 5.6 will do just fine. Instead of MMM you can google for MHA for instance. I would recommend taking a look at Galera though, which takes a different approach but with some nice benefits. The one thing is that with Galera your data generally lives on 3 or more servers (2 is possible, but not recommended). If that is a good idea to you, then Galera would be my personal preference. -- Best regards, Walter Heck CEO / Founder OlinData <https://t.yesware.com/tl/2627942011ccc3835f76c6e9ba4c0af91f3d3722/407ea34fcfb29332bbc93cdb34f13e4f/fd1ca40450db4c95f61e02cfe4940db2?ytl=http%3A%2F%2Folindata.com%2F%3Fsrc%3Dwh_gapp> - Open Source Training & Consulting Check out our upcoming trainings <https://t.yesware.com/tl/2627942011ccc3835f76c6e9ba4c0af91f3d3722/407ea34fcfb29332bbc93cdb34f13e4f/63ebe1eaf25f15c25c5b43a8b2954a8d?ytl=http%3A%2F%2Folindata.com%2Ftraining%2Fupcoming>
