Finally I’ve decided to publish the slides about Galera Cluster that I’ve presented twice, at the internal Trivadis TechEvent conference past April and at the Linux Day 2013.
They are a little dated since the new Galera library 3.0 is out and it supports MySQL 5.6.
Hope you find them interesting.
Cheers
—
Ludovico
The following two tabs change content below.
Latest posts by Ludovico (see all)
- New views in Oracle Data Guard 23c - January 3, 2024
- New in Data Guard 21c and 23c: Automatic preparation of the primary - December 22, 2023
- Does FLASHBACK QUERY work across incarnations or after a Data Guard failover? - December 13, 2023
Great, thanks. We are large organization with all flavours of rdbms. We have very good infrastructure with site licenses fot software. RAC is not yet implemented because of complexity to maintain and I also feel it may not be a right tool for consolidation of non critical databases where availability is of secondary concern. We can achieve OS level availability with VMware. Exadata is the preferred for consolidation, cost and maintennace are too high.
Hi Ramki,
LOL, you’re also administering all the major RDBMS platform if I understand well 🙂
Briefly, YES, if I suggest Galera for consolidation (I would go for Percona Cluster) even if I’ve never done it on a busy production. I’ve implemented it on 5.5 release, I know that new 5.6 patched servers are coming.
From the database and hardware point of view is much simpler to administer compared to other solutions like Oracle RAC or MySQL cluster, but you have to plan it carefully at VIP and load balancing level. Especially if you have the hotspots I’ve described in my slides, a VIP for each application pointing to different single servers would allow to avoid the problem.
Also, take care that the traditional LB doesn’t detect if a server isn’t available because the port 3306 (or whatever) will be available.
Compared to MySQL Cluster, the main advantage is that Galera uses innoDB. the NDB engine is not always compatible with the applications, it’s most suitable for applications developed in-house (IMHO).
cheers
—
Ludovico
We’ve installed Galera cluster in our organization. Do you suggest it for production? How do we compare this with Mysql Cluster NDB in terms of scalability? How do you handle similar applications (Drupal/Lamp/Redcap)? We had multilpe Drupal applications around. How can we consildate them with Galera?