[CentOS] best ways to do mysql backup

Sat Aug 14 20:03:59 UTC 2010
Benjamin Franz <jfranz at freerun.com>

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