Re: best ways to do mysql backup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux