Hello Ryan, >> thanx for info; do you know if mysql4 supports what i want? i need the >> mysql4 configured on 2 hosts with master-master databases. both dbs >> should sync their data [replication] but it should be possible to write >> in both dbs.
RB> I'm pretty sure it doesn't. I thought I read on a roadmap on their site RB> somewhere that master <-> master replication was planned for the 4.2 RB> series Per the MySQL documentation, specifically the Replication Features and Known Problems http://www.mysql.com/doc/en/Replication_Features.html section: --- Starting in Version 3.23.26, it is safe to connect servers in a circular master-slave relationship with log-slave-updates enabled. Note, however, that many queries will not work right in this kind of setup unless your client code is written to take care of the potential problems that can happen from updates that occur in different sequence on different servers. This means that you can do a setup like the following: A -> B -> C -> A This setup will only works if you only do non conflicting updates between the tables. In other words, if you insert data in A and C, you should never insert a row in A that may have a conflicting key with a row insert in C. You should also not update the sam rows on two servers if the order in which the updates are applied matters. Note that the log format has changed in Version 3.23.26 so that pre-3.23.26 slaves will not be able to read it. --- It would seem that the biggest problem would be in auto-increment items, such as message numbers, if there were any disruption of the connection between servers. -- Jeff Brenton President, Engineered Software Products, Inc http://espi.com Questionable web page: http://dididahdahdidit.com Liberalism grants you the freedom to advocate any idea*. * Please see http://www.dididahdahdidit.com/except.php for a current list of exceptions
