List:Cluster« Previous MessageNext Message »
From:Arjen Lentz Date:July 5 2004 10:28pm
Subject:Re: Master-Slave Replication with MySQL Cluster
View as plain text  
Hi Thomas,

On Tue, 2004-07-06 at 04:07, Thomas Schwanhäuser wrote:
> Is the following possible or does anyone have experience with such a
> configuration?
> 
> There shall be a Master-Slave replication with around 20 slaves. But
> in order to have enough "Master" power for replication and safe
> inserts/updates, the Master shall not be a single computer but the
> whole MySQL Cluster. 
> 
> Thus, it's possible to have a cluster replicating to some salves
> running e.g. MyISAM or InnoDB tables?

That is possible, by simply doing an ALTER TABLE TYPE=MyISAM (or
=InnoDB) directly on the slaves. This will work fine as long as no
storage engine specific operation is executed.

It may be easier to leave the slaves on TYPE=NDBCLUSTER as well, but
have a different cluster setup. At the minimum, each slave could run
with only a single database node (i.e. 1 replica).


Regards,
Arjen.
-- 
Arjen Lentz, Technical Writer, Trainer
Brisbane, QLD Australia
MySQL AB, www.mysql.com

Sydney 18 Oct 2004 (4.5 days): DBMS Introduction Training
Training,Support,Licenses,T-shirts @ https://order.mysql.com/?ref=marl


Thread
Master-Slave Replication with MySQL ClusterThomas Schwanh√§user5 Jul
  • Re: Master-Slave Replication with MySQL ClusterArjen Lentz6 Jul
  • Re: Master-Slave Replication with MySQL ClusterLars Thalmann7 Jul