Success -- MySQL / MyODBC replication

[michael d hoskins]

Way cool!  And, it's created by my good friend Jason Orcutt, who helps
write IMP http://www.horde.org/imp/

Thanks!  I will look at this.

I used to work with Jason at JCCC (Johnson County Community College.)
He's extremely talented.

-----Original Message-----
From: era [mailto:era at sky.net]
Sent: Friday, April 07, 2000 3:15 PM
To: kclug
Cc: era
Subject: Re: kclug - Success -- MySQL / MyODBC replication

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/