https://shlomi-noach.github.io/blog/mysql/mmm-for-mysql-single-reader-role Blog by Shlomi Noach Fri, 13 Aug 2010 04:22:01 +0000 hourly 1 https://wordpress.org/?v=5.3.3 https://shlomi-noach.github.io/blog/mysql/mmm-for-mysql-single-reader-role/comment-page-1#comment-16626 Fri, 13 Aug 2010 04:22:01 +0000 https://shlomi-noach.github.io/blog/?p=2824#comment-16626 Shlomi, you are correct. Clumsy wording on my part, haha!

]]> https://shlomi-noach.github.io/blog/mysql/mmm-for-mysql-single-reader-role/comment-page-1#comment-16625 Fri, 13 Aug 2010 04:15:16 +0000 https://shlomi-noach.github.io/blog/?p=2824#comment-16625 Walter,
“The official rule is that no host will have more then 2 more roles then any other host…”
It appears as if the rule is that no host will have 2 or more roles more than any other host — am I wrong here?

]]> https://shlomi-noach.github.io/blog/mysql/mmm-for-mysql-single-reader-role/comment-page-1#comment-16600 Thu, 12 Aug 2010 17:35:40 +0000 https://shlomi-noach.github.io/blog/?p=2824#comment-16600 MMM is pretty smart like that. The official rule is that no host will have more then 2 more roles then any other host. Using that knowledge, you can even work out a scheme to have three roles: reader, writer and passive-master-reader if you will. It takes a bit of tinkering, but you can make it so that whenever possible, the writer and passive-master-reader role will always be on different master hosts whenever possible.

]]>