[CentOS] best ways to do mysql backup
Benjamin Franz
jfranz at freerun.com
Sat Aug 14 20:03:59 UTC 2010
On 08/14/2010 12:59 PM, Benjamin Franz wrote:
> 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.
>
Correction: rsync the *snapshot* of the mysql data directory to the
other machine.
--
Benjamin Franz
More information about the CentOS
mailing list