Actually, we've been runnning mySQL replication for ~4 months now
We've never had a problem with the slaved machines losing their position
in the log, nor do we ever run a reset slave...
Try the following script instead out of cron...
#!/bin/sh
FIRST_LOG=`echo 'SHOW MASTER LOGS ;' | mysql|head
I'm only a digest subscriber, so I apologise in advance for any
mis-quotes:
Ok here is my experience with MySQL replication:
1) it's been very stable, and haven't noticed any drift in the
replicating servers
2) we have ~7 replicating servers-- 3 in circular replication which
recieve all of the
Is it possible to enable compression between replicating database servers?
I'm assuming that there is already compression code in place, because of
the need to link with the compression libraries on the client end
sometimes.
Compressing the replication connection has certain advantages where the
Hi,
We're attempting to get mysql running on our
System: SunOS hsNavMrySun2 5.6 Generic_105182-21 i86pc i386 i86pc
Architecture: i86pc
We're using the Workshop pro compilers, and can compile the source v
3.23.33 without problems.
However, nothing on the system that I've found can create tables
I have a couple of questions regarding replication in MySQL:
1) does it work well/handle loss of connections due to network
outages/delays; we have a geographically diverse environment, and were
hoping to be able to replicate the data across the connections (which
may have outages from time to