Questions tagged [galera]

Galera Cluster for MySQL is a true Multimaster Cluster based on synchronous replication.

124 questions
-1
votes
1 answer

PHP can't connect to 127.0.0.1 or localhost to galera but can iva mysql cmd

I am having an issue with MySQL where I can't connect via localhost or 127.0.0.1, I get "Access denied ". On the same box if I use mysql -p -h localhost -u mysuser -p'mypassword' or mysql -p -h 127.0.0.1 -u mysuser -p'mypassword' I am able to get…
Dovid Bender
  • 427
  • 2
  • 7
  • 19
-1
votes
1 answer

Best practice connecting to a galera cluster?

If I have 7 servers, with 7 IPs, what is the best way to connect to them? I have thought of: 1.) Pointing all my queries through one IP 2.) Using rand() to randomly select an IP and connect to it, distributing all the queries across the servers
Kevin
  • 1
  • 2
-1
votes
1 answer

Setup Galera Cluster with two servers

Can I Create Gallera Cluster with two servers ?? Actually I have 6 servers: 2 Server for Load Balancer 2 Server for Apache Or anyone here can suggest me how to create High Availability Web Server with 6 servers? Thanks
-2
votes
1 answer

Does Galera Arbitrator require a SST?

Does Galera Arbitrator require a SST? It says it's stateless but it's not clear if a SST i required. The reason for asking is that I'm having a large database and would like to skip the SST if possible.
Chrille
  • 463
  • 2
  • 5
  • 10
1 2 3
8
9