yeah ive tried doing scheduled mysqldump and scp but dumped files are very big to transfer, so i think that doing a replication will only copy or update latest query
i also planned a scheduled uptime for the slave to minimize hassle on peak hours of database usage. -----Original Message----- From: ian sison (mailing list) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2003 4:16 AM To: Philippine Linux Users Group Mailing List Subject: Re: [plug] MySQL replication On Tue, 16 Sep 2003, Aris Santillan wrote: > hi > > > is it possible to implement DB replication over the internet? > meaning Master and Slave is far far away from each other? In theory yes. In practice, if you are concerned about your databases being more or last syncronized, you will be disappointed especially if the transactions on your main DB are a lot and the link to your slave is slow. But if it's just for backup, then it may be acceptable. But then, i'd rather batch a cronned mysqldump + scp than do that. -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie -- Philippine Linux Users' Group (PLUG) Mailing List [EMAIL PROTECTED] (#PLUG @ irc.free.net.ph) Official Website: http://plug.linux.org.ph Searchable Archives: http://marc.free.net.ph . To leave, go to http://lists.q-linux.com/mailman/listinfo/plug . Are you a Linux newbie? To join the newbie list, go to http://lists.q-linux.com/mailman/listinfo/ph-linux-newbie
