标签归档:dlslaved

mysql slave延时同步

dlslaved 0.1

(Delayed Slave Daemon for MySQL)

dlslaved

allows delayed replication for MySQL databases.

 

The

dlslaved

syntax is really simple :

-> dlslaved -h ipAddress -u username -p password -P portNumber

  • 11/06/2007 : initial release

Well, it’s done. I finally put the source code on Internet. So, be gentle. It’s my first unix program.

 

    The internal architecture of

dlslaved

    is very simple. It uses the

SecondsBehindMaster

    MySQL internal variable, and the

STOP

    and

START

    slave command to try to have 7200 seconds (a constant in the program) constantly behind the master.

 

    Try it, use it, send back errors and source modifications.
    It compiles under Linux and Solaris (x86 and Sparc) using gcc.
    Download

dlslaved user’s manual

    (a PDF file).

 

    Download

dlslaved source code

    for Linux and Solaris (i think most Unix like systems). To compile, you need MySQL binaries and libraries to be install in

/usr/local/mysql

    directory.

Contact me at rodolphe.jouannet(at)free.fr for support or questions. 继续阅读