Galera node master <-> master local write

Follow

Galera

• August 29, 2022 07:53

Hello,

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 ?

Thank you!

1

• 

  Sebastian Insausti

  • August 29, 2022 15:46

  Hi,

  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 :)

  Regards,

  Sebastian.

  0

  Comment actions Permalink
• 

  Galera

  • August 29, 2022 15:59

  Hi again, I am using ClusterControl with two galera mysql nodes and the controller is playing as 3rd node for the quorum.

  Thank you for your reply!

  0

  Comment actions Permalink

Please sign in to leave a comment.