Hi all,
I'm a little confused about a couple things.
The background is that I want to deploy an HA cluster with MySQL 4.1.12 on FreeBSD. An application will connect to the database and do database things.
First question is: I need at least three servers, correct? According to this thread, Jonathan Miller says I need at least two, but everything else I read seems to say I need at least three to avoid splitbrain.
http://forums.mysql.com/read.php?25,30251,30362#msg-30362
Secondly, I understand that I can run two management nodes and obviously two data nodes, but I can find nothing that says that I can run two MySQL nodes.
If I only have one MySQL node, I only have essentially one 'entry point' into the data store. If the MySQL node goes down, do I have to change the application to point to a different node? If so, then what's the point of having a cluster?
My goal is to have three machines - one will be just a management node (among other things), the other two will be data storage nodes and hopefully MySQL nodes as well.