On Tue, 2004-07-06 at 04:07, Thomas SchwanhÃ¤user wrote:
> Is the following possible or does anyone have experience with such a
> 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).
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