Hi all,
The manual states (under 16.7 MySQL Cluster Limitations in 4.1):
MySQL Replication will not work right off if updates are done on several
MySQL servers. If a partitioning scheme of the database is done at the
application level, and no transactions takes place across these
partitions, it will work.
Can someone explain what this means?
One of the main reasons we want to use a cluster setup is to avoid
worrying (in the application) about connecting only to the Master DB for
update operations. We want to be able to connect to the local DB server
on any node, and be able to insert/update at will, and have the updates
replicated to all nodes in the setup. It seems to me this is one of the
main advantages cluster will give us over traditional master-slave
replication.
Does this paragraph mean to tell us that we can't do this? What is a
"partitioning scheme of the database"?
Thanks,
Ephraim
2 messages in com.mysql.lists.clusterupdates on multiple servers?
