4 messages in com.mysql.lists.clusterRe: Cluster without Replica
FromSent OnAttachments
Hayden Livingston16 Feb 2008 03:31 
Massimo16 Feb 2008 03:51 
Hayden Livingston16 Feb 2008 03:57 
Jeff Sturm16 Feb 2008 06:32 
Subject:Re: Cluster without Replica
From:Massimo (mass@mysql.com)
Date:02/16/2008 03:51:34 AM
List:com.mysql.lists.cluster

Hi Hayden,

in your situation you don't need MySQL Cluster: is designed for near reall-time applications with requirements of very low latency, high availability and scalability.

What you need probably is the MySQL Replication: an asynchronous replication from master (your node1) to the slave (your node 2).

I suggest to upgrade your MySQL Server to version 5.0 and set up the replication: is easy and you will find all the infos in the replication chapter on the manual.

If you have some trouble setting up your replication, you can write at the repl@lists.mysql.com mailing list.

Massimo

Hayden Livingston ha scritto:

The situation:

100GB of MyISAM data 3 physical machines (node1, node2, node3) MySQL 4.1.20

right now, all our queries goto one machine, node1, which is a webserver, as well among other things. We basically want to have an exact replica of node1, so that say node2 can be accessed. Most of our code is mysql_connect("localhost" ...);

So for node1 it goes to node1's mysql and for node2 it goes to node2's mysql.

We really don't have any need for load balanacing / high availabilty, just a live replica. Generally if we go down, it's almost always because of some other problem that takes the entire machine down in some way.

So, my problem is I'm confused about 4.1 Clustering, the manual says it's all in memory so I need 200GB of memory? Secondly, what's the difference between SQL nodes and data nodes? I would have thought they're the same, since we're hoping to run mysql and ndbd on node1 and node2, is this not possible?

Thanks a bunch!