Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySQL Cluster or MariaDB Galera [closed]

Tags:

mysql

mariadb

I'm considering implementing a cluster server. I have currently used MySQL for my application for the past few years but I've read a lot of uncertainty over the past year on what is going to be happening with MySQL and also the advantages and improvements of MariaDB.

If it were a single server, based on everything I've read I would switch over to MariaDB right now so I wouldn't need to do it later, but since it's a cluster I am torn about whether I should switch to MariaDB Galera right now or wait awhile before it's more mature.

Does anyone have experience implementing both of these solutions and "pros" and "cons" of those implementations?

My other worry is that with improvements, MariaDB won't be a complete drop-in replacement after a year or 2 as it improves and adds new features, so now WOULD be a better time to switch to MariaDB.

like image 566
Benjamin Oman Avatar asked Jun 28 '13 15:06

Benjamin Oman


2 Answers

You can also use Galera in Percona XtraDB Cluster, which is backward compatible with MySQL.

(disclaimer: I work for Percona.)

No one can truthfully guarantee backward compatibility forever -- not even Oracle.

FWIW, if you're worried about drop-in replacement technology, then you should know that MySQL Cluster is a great example of not satisfying that criterion.

Because of the way the NDB storage engine partitions data, most users need to redesign their schema to take advantage of NDB. Many users "upgrade" an existing app to MySQL Cluster but experience worse performance, because their queries tend to touch every node in the cluster anyway. MySQL Cluster is a brilliant solution for the cases it handles well, but you can't assume it's a drop-in replacement for conventional InnoDB architecture. You have to do careful functional testing, performance testing, and load testing.

like image 110
Bill Karwin Avatar answered Oct 21 '22 20:10

Bill Karwin


First of all - I should point out that I'm part of the MySQL team within Oracle.

I'm not going to criticise MariaDB or Galera but suggest that if you switch to them then it should be because you're convinced that they provide a better solution and not because of any FUD you've heard that Oracle is planning to kill or wind down MySQL - the opposite is true. Take a look at this presentation by the VP of MySQL engineering (Oracle) from this year's Percona conference for details of the great stuff that's been happening.... http://www.youtube.com/watch?feature=player_embedded&v=OpHTV59I1gs#at=16

Regarding MySQL Cluster, we've just declared General Availability for MySQL Cluster 7.3 which contains some major enhancements such as:

  • Support for Foreign Keys
  • JavaScript/Node.js API
  • Performance enhnacements
  • Browser-based auto-installer

Take a look at http://www.clusterdb.com/mysql-cluster/mysql-cluster-7-3-is-now-ga/ for some details.

like image 39
Andrew Morgan Avatar answered Oct 21 '22 21:10

Andrew Morgan