¡Hi!
you can make a dump of the entire database and then periodically
(once per hour, once every two hours, etc....) you can backup MySQL's
binlogs.
Regarding the dump file, it's much better if you dump each database
in its own file instead of having only one big file with all the
databases inside (It will help in the restoration process).
¡Bye!
On 10/25/2011 07:54 AM, Konstantin Khomoutov wrote:
> On Tue, 25 Oct 2011 12:03:37 +0200
> Alexandre Chapellon<a.chapellon AT horoa DOT net> wrote:
>
>>> I have some servers with MySQL databases. I want to know what is the
>>> best way to backup these databases ?
>>>
>>> For now, i think i will do mysqldump on each server to local disk
>>> and after that, backup that files. Is there a better way ? MySQL
>>> module for bacula, backup mysql files (.myd and .myi) directly,...?
>>> How are you doing it ?
>> I use mysqldump and backup my dumps using bacula, just like you.
>> I doubt backing up MyIsam files directly is a good idea, especially
>> if you have big tables, foreign keys and so on... you could endup
>> with tables inconsistencies.
>> Using LVM snapshot would help backing up raw files... but you need to
>> have you mysql datadir on an lvm volume.
> Using filesystem snapshots can't solve the problem of backing up live
> database files just by itself, it merely can help reduce downtime of
> the database (by going lock/flush -> snapshot -> unlock -> back up
> from the snapshot). I'm not implying you are not aware of this issue,
> just want to state it clear to not delude the original poster that
> snapshotting is a kind of silver bullet.
>
> ------------------------------------------------------------------------------
> The demand for IT networking professionals continues to grow, and the
> demand for specialized networking skills is growing even more rapidly.
> Take a complimentary Learning@Cisco Self-Assessment and learn
> about Cisco certifications, training, and career opportunities.
> http://p.sf.net/sfu/cisco-dev2dev
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
-----
CeSPI
Centro Superior para el Procesamiento de la Información
Universidad Nacional de La Plata
-------------------------------------------------------------------------------
Proteja el Medioambiente. No imprima este mail si no es absolutamente necesario
------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn
about Cisco certifications, training, and career opportunities.
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
