Success -- MySQL / MyODBC replication

[Edgar Allen]

michael d hoskins writes:
>
>Are you needing to replicate those two machines' databases, keeping KC
>and St. Louis in-sync with each other?  Unfortunately, MySQL doesn't
>*directly* provide for that.
>
>There is a way to sorta force it to happen semi-live, using MySQL's
>logging feature and by piping the data to the other MySQL server node.
>However, (and the doc doesn't tell you this,) you need to write a script
>that periodically resyncs things, if they can't talk to each other for
>awhile.  Of course, you better use unique keys, if you try this option. 
>In the docs, there is a section on how to do backup and recovery,
>logging, and "replication:"
>http://www.mysql.net/Manual/manual.html#Common_problems  It's Chapter
>20, "Solving Common Problems."  Eventually, MySQL should be adding
>one-way replication as a standard feature:
>http://www.mysql.com/Manual_chapter/manual_TODO.html
>
Ask and you shall receive...

    Welcome to the Mysql Clustering Toolkit. 

This software provides a way to cluster a set of mysql servers to
provide high availablity and or distributed data.

http://prometheus.zerodivide.net/mysql_cluster/