Galera node master <-> master local write
I have the following setup :
Two galera nodes in a master <> master setup. On top of the galera nodes (same machine) I want to setup web servers that will do inserts into the database. Infront of the webservers/nodes I will put HAProxy for a load balancer to the webservers. I want the webservers to connect via localhost and do their inserts. On theory this setup should work fine but do you have any concerns and experience in this kind of setup? Should I expect problems with any kind ?
About the Galera nodes, the recommendation is to have at least 3 nodes to avoid a split-brain issue.
As you mentioned, this should work, but I recommend creating a test environment and a stress test, to avoid issues in the future.
Btw, you can create this environment with ClusterControl in a user-friendly way :)
Please sign in to leave a comment.