[General] mysql sync

Bashar Al-Abdulhadi bashar at kuwaitnet.net
Sun Apr 8 14:26:51 +03 2007


W'Salaam El-Semmi :)


batch script for large changes kinda a killer especially the two servers 
are very far, one hosted at kuwait on 256k dsl and the other at my 
datacenter in the US, thats why i thought of someway of inserting SQL 
queries for changed entries only not the entire db.



bashar abdullah wrote:

> Salam Bashar,
>
> I'm sure you have thought about it, but why isn't a batch script good 
> for that?
>
>
> On 4/8/07, *Bashar Al-Abdulhadi* < bashar at kuwaitnet.net 
> <mailto:bashar at kuwaitnet.net>> wrote:
>
>     Salaam All,
>
>     what is the best way to sync mysql databases by inserting
>     new/changed  data into remote mysql box?
>
>
>     mysql replication would do it but it needs little changes on the
>     live server which i dont want to.
>
>
>     was wondering if a way to insert new lines into the remote db
>     every x amount of minutes or so instead of doing an entire dump
>     and restoring it remotely
>
>
>
>     any thoughts are much appreciated :)
>
>     Best Regards,
>
>
>
>     _______________________________________________
>     General mailing list
>     General at oskw.org <mailto:General at oskw.org>
>     http://mail.oskw.org/mailman/listinfo/general_oskw.org
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> General mailing list
> General at oskw.org
> http://mail.oskw.org/mailman/listinfo/general_oskw.org
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://oskw.org/pipermail/general_oskw.org/attachments/20070408/df974829/attachment-0004.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3249 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://oskw.org/pipermail/general_oskw.org/attachments/20070408/df974829/attachment-0002.bin>


More information about the General mailing list