0

I've just successfully created my first Galera cluster using MariaDB 10.0.20 between three servers.

I have a few questions regarding my implementation: 1. what will happen if one server becomes isolated from the other servers but still has clients connected? 2. What happens if two servers can't directly communicate but the third server can talk with both servers? 3. Is it possible to upgrade one server at a time? 4. Is it possible to make configuration changes to one server at a time (e.g enabling query cache)

gijs007
  • 107
  • 1
  • 4
  • 17

1 Answers1

1
  1. what will happen if one server becomes isolated from the other servers but still has clients connected?

The isolated server becomes not read or writeable and will when the isolation ends get itself back in sync using one of the other nodes.

  1. What happens if two servers can't directly communicate but the third server can talk with both servers?

Its likely that those two servers will isolate themselves (non-primary mode).

  1. Is it possible to upgrade one server at a time?

yes. Wait until one is in sync before moving to the next.

  1. Is it possible to make configuration changes to one server at a time (e.g enabling query cache)

Yes. Be careful about changing some of the setting related to galera as these may create a writeset that the other nodes can't understand.

danblack
  • 36
  • 2
  • Perfect, thanks for answering :) Just curious, what do the timeout for Gallera do then? Does the server immediately become isolated or only after it times out? Lets say we use: wsrep_provider_options = "evs.keepalive_period = PT3S; evs.suspect_timeout = PT30S; evs.inactive_timeout = PT1M; evs.install_timeout = PT1M" What will happen before the timeouts are reached when there is an outage? Will the whole cluster lock? – gijs007 Jul 16 '15 at 00:34