3 messages in com.mysql.lists.clusterRe: mysql DB replication across clust...
FromSent OnAttachments
Daniel Corbe16 Dec 2006 21:31 
Martin Skold18 Dec 2006 00:33 
Geert Vanderkelen18 Dec 2006 04:20 
Subject:Re: mysql DB replication across cluster nodes
From:Geert Vanderkelen (gee@mysql.com)
Date:12/18/2006 04:20:36 AM
List:com.mysql.lists.cluster

Hi Daniel,

On Dec 17, 2006, at 06:32, Daniel Corbe wrote:

I was wondering if it is possible to get some of the tables in the mysql DB to replicate across my cluster nodes.

Martin already replied, but I think you mean doing something like this: mysql> ALTER TABLE mysql.user ENGINE=NDB;

It would be nice to be able to add Users and Databases to the system without having to do it on each storage node, each API node, etc. It would really make user management across the cluster much easier.

It would be useful for those who want to run large clusters, with many users, many DBs, etc.

Yes, it would be useful and I just tried it using 5.1 and made a bug report :)

http://bugs.mysql.com/bug.php?id=25139

It either shouldn't work and give an error when you do the ALTER TABLE as stated above. Or it should work completely. My vote goes for giving an error for now, but it would be great to have it working/tested in later versions..

Cheers,

Geert