Open Stack

On 11 August 2014 19:26, Jay Pipes <jaypipes at gmail.com> wrote:

> The above does not really make sense for MySQL Galera/PXC clusters *if only
> Galera nodes are used in the cluster*. Since Galera is synchronously
> replicated, there's no real point in segregating writers from readers, IMO.
> Better to just spread the write AND read load equally among all Galera
> cluster nodes.

Unfortunately it is possible to get bitten by the difference between
'synchronous' and 'virtually synchronous' in practice. I'll try to get
somebody more knowledgeable about the details to comment further.