I've setup mysql in haproxy so that both servers are checked every 2 seconds for availability. I think for now in the application side I will attempt to connect to the local instance and if that fails connect to haproxy (which will effectively be the other instance at this point).
I'm not sure how this will be extended in the future, however this allows options for most paths and I can see mysql stats along with the other servers in one place.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment