I’ve recently worked with customers using replication rings with 4+ servers; several servers accepting writes. The idea behind this design is always the same: by having multiple servers, you get high availability and by having multiple writer nodes, you get write scalability. Alas, this is simply not true. Here is why.
My 2 sessions from 2014’s MySQL Central at Oracle OpenWorld are now available:
HAProxy is frequently used as a load-balancer in front of a Galera cluster. While diagnosing an issue with HAProxy configuration, I realized that logging doesn’t work out of the box on CentOS 6.5. Here is a simple recipe to fix the issue.If you look at the top of
/etc/haproxy/haproxy.cfg, you will see something like:
I have 2 sessions at Oracle OpenWorld in San Francisco this Thursday (2nd October 2014); please come along if your in town and feel free to grab me after the sessions for any extra questions:
NoSQL and SQL: The Best of Both Worlds [CON2853]
Thursday, Oct 2, 9:30 AM – 10:15 AM – Moscone South – 252