[CentOS] best ways to do mysql backup
Benjamin Franz
jfranz at freerun.com
Sat Aug 14 19:59:55 UTC 2010
On 08/14/2010 12:51 PM, Agnello George wrote:
> we have multiple servers approx 10 and each has about 100 GB of data
> in the /var/lib/mysql dir , excluding tar , mysqldump and replication
> how do we take backup for these databases on to a remote machine and
> store them datewise , ( the remote machine is a 2TB HDD )
>
> currently tar is not feasible as the data is too huge and the same
> goes with mysqldump
>
> suggestion will be of great help
Assuming you installed using LVM partitions (and that you left space for
snapshots ;) ), stop the database, take a LVM snapshot, restart the
database, rsync the mysql data directory to the other machine, then
release the snapshot.
--
Benjamin Franz
More information about the CentOS
mailing list