Date: Wed, 3 Sep 2008 15:22:58 -0400 From: Derek Belrose <derekb@realgeeky.com> To: "Mad Unix" <madunix@gmail.com> Cc: freebsd-questions@freebsd.org Subject: Re: mysql Message-ID: <4EC04561-2F39-45B1-9A4E-932A53D6A625@realgeeky.com> In-Reply-To: <4d3f56c90809031149p77611502t5295ea273dab828e@mail.gmail.com> References: <4d3f56c90809031149p77611502t5295ea273dab828e@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Sep 3, 2008, at 2:49 PM, 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 Do you want replication or to copy the binary databases? You can just copy the databases: shut the server down, copy the database files over using scp. Or, you can set up replication where anytime you write to Site A you write to Site B. The latter is more work to setup but it's near instant replication while the prior is done at a scheduled time. -Derek
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4EC04561-2F39-45B1-9A4E-932A53D6A625>