Hi,
We're doing something weird (what else is new). We're hoping to use
MySQL as the base of a distributed database with peer replication. Most
of the peering and control mechanisms will be in the core application
code, but we're counting on MySQL's ability to replicate for some of the
lower-level peer synchronization mechanisms. It appears from the docs
that most of this will be straightforward, however it is not clear (or I
missed it) if replication works with all table types.
This is important because the issue of complex transactions has recently
come up and we may need to use innodb tables.
It is not entirely clear wether replication will work with innodb
tables.
We're hoping to use MySQL 4.x
Can we build reliable, circular replication with innodb tables in MySQL?
We will have the application pick a single master node for any
particular table and/or database until all nodes are synchronized...
Then the app will vote for a new master if needed.
For example.
NODE1 NODE2 NODE3
MASTER OF A MASTER OF B MASTER OF C
...--->[ ABC ]-------->[ ABC ]--------->[ ABC ]----...
Will this work with innodb.
If not directly, then how?
Thanks in advacnce,
_M
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
