[General] mysql sync

[Eng. Sabah Al-Sabah]

Have you thought of using DRBD?

 

 

Best Regards,

============================

Eng. Sabah Al-Sabah

General Manager

Technical Systems Est.

 <mailto:sabah at techsys.net> sabah at techsys.net

 <http://www.techsys.net/> www.techsys.net

============================

 

From: general-bounces at oskw.org [mailto:general-bounces at oskw.org] On Behalf Of Bashar Al-Abdulhadi
Sent: 08 أبريل, 2007 02:55 ص
To: Kuwait OpenSource Community
Subject: [General] mysql sync

 

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,

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://oskw.org/pipermail/general_oskw.org/attachments/20070409/a44fb517/attachment.html>