I need to replicate MySQL DB of mulltiple server on SiteA to my DR-Site Site_B... all DB are alocated on RHEL,SuSE,Centos,Debian, FreeBSD servers. I need a script to take Multiple MySql DataBase Backup and then import to SiteB, the replica can be done as cold or hotbackup and cron it Thanks -- Madunix_at_Gmail Sysadmin "Computers are useless. They can only give you answers" - Pablo Picasso "Never trust a computer you can't throw out a window." - Steve Wozniak -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20080903/b169a3d4/attachment-0002.html>
Mad Unix wrote:> I need to replicate MySQL DB of mulltiple server on SiteA to my > DR-Site Site_B... all DB > are alocated on RHEL,SuSE,Centos,Debian, FreeBSD servers. > I need a script to take Multiple MySql DataBase Backup and then import > to SiteB, the replica > can be done as cold or hotbackup and cron itthats nice. sounds like a reasonable task to undertake. do you have a question?
On Wed, Sep 3, 2008 at 2:45 PM, Mad Unix <madunix at gmail.com> wrote:> I need to replicate MySQL DB of mulltiple server on SiteA to my DR-Site > Site_B... all DB > are alocated on RHEL,SuSE,Centos,Debian, FreeBSD servers. > I need a script to take Multiple MySql DataBase Backup and then import to > SiteB, the replica > can be done as cold or hotbackup and cron it > ThanksI'm sure there are several folks on the list who would be willing to contract out for the creation of such a script. If you're looking for cheaper stuff though, you might want to have a look at maatkit or zmanda. -- During times of universal deceit, telling the truth becomes a revolutionary act. George Orwell
Mad Unix wrote:> I need to replicate MySQL DB of mulltiple server on SiteA to my > DR-Site Site_B... all DB > are alocated on RHEL,SuSE,Centos,Debian, FreeBSD servers. > I need a script to take Multiple MySql DataBase Backup and then import > to SiteB, the replica > can be done as cold or hotbackup and cron it > Thanks > > -- > Madunix_at_Gmail > Sysadmin > > "Computers are useless. They can only give you answers" - Pablo Picasso > "Never trust a computer you can't throw out a window." - Steve Wozniak > ------------------------------------------------------------------------ > > _______________________________________________ > CentOS mailing list > CentOS at centos.org > http://lists.centos.org/mailman/listinfo/centos >there is of course this also: http://dev.mysql.com/doc/refman/5.1/en/replication.html