Galera Phrases

| Keine Kommentare | Keine TrackBacks

I confess I am a Galera fanboy. This post is going to present two slogans about Galera reminding you about Galera “limitations”. This is for the sake of user experience:)

Galera Phrases:

  • One Cluster
  • Replication

One Cluster

Think about Galera as One Cluster. As every transaction is committed virtually synchronously, the slowest node determines the (DML) speed of the cluster. This is true regarding the network too.

Replication

  • Galera is still some kind of replication. So keep in mind to provide PK as for (ROW based) Replication. There is a Featurerequest of mine to have a PK option to enforce creating of Tables with a PK. Please vote for it:)

  • With traditional MySQL Replication the slave might lag. This is not hurting the performance of the master. With Galera there is no lag. So if applying takes time it stalls the cluster (flow control). DDL statements run in Total Order Isolation (TOI) as a default. This will not only block the table. The whole cluster stalls till the DDL finishes.

Of course there is much more to tell. This two slogans are just a result of my experience with customers etc.

Viel Spaß

Erkan

Keine TrackBacks

TrackBack-URL: http://linsenraum.de/mt/mt-tb.cgi/298

Jetzt kommentieren

Über diese Seite

Diese Seite enthält einen einen einzelnen Eintrag von erkan vom 23.01.14 3:53.

Using MySQL with Docker ist der vorherige Eintrag in diesem Blog.

Benchmarking Galera Cluster ist der nächste Eintrag in diesem Blog.

Aktuelle Einträge finden Sie auf der Startseite, alle Einträge in den Archiven.

Seiten

Powered by Movable Type 4.23-en