Thanks to all who attended my webinar last week on Writing Application Code for MySQL High Availability. This blog is for me to address the extra questions I didn’t have time to answer on the stream.
What do you think about using Galera Cluster but writing to a single Node with LVS ?
Whatever HA strategy you like that can present a layer 3 or layer 4 to your application tier is fine. A lot of people using PXC us it in a single-writer (master/slave) kind of way.
Is there any way we can determine slave lag and then decide to use weather master or slave? for e.g. instead of using query to find if data is available in slave then …. use if lag_time < xyz?
One of my main points was that this is usually more expensive to implement inside your application code than it …[Read more]