[kwlug-disc] MySQL Backups

[Khalid Baheyeldin]

If you have really huge databases, with many millions of rows in one or
more tables, backup may take more than a few minutes, and that cause
application lockups. In this case, mysqldump is no longer an option.

You can use MyDumper, which does backup in parallel for tables with large
numbers of rows, and ensures consistency.

It is not straightforward to get going on Ubuntu 12.04, since the version
in the repositories does not work. You need to compile from source after
you apply a patch.

But once you go through these steps, a backup that takes 8 minutes can be
done in less than a minute!

I detailed the steps here, and use it for backup for a site that used to
lockup daily when backup is run. Now it takes far less time for backup.

http://2bits.com/backup/fast-parallel-mysql-backups-and-imports-mydumper.html


On Sat, Feb 15, 2014 at 12:01 PM, Jonathan D. Poole
<jpoole at digitaljedi.ca>wrote:

> This is what I have been using, pretty simple, but has the flexibility of
> doing things PRE and POST run.  I generally put a copy to s3 storage POST
> hook.   Works on both slaves, masters, but be warned on masters you should
> lock tables to ensure integrity (Causes application outage, although if in
> your environment you have a window of maintenance, you should be fine)
>
> http://sourceforge.net/projects/automysqlbackup/
>
>
> Regards,
>
>
> -----Original Message-----
> From: kwlug-disc [mailto:kwlug-disc-bounces at kwlug.org] On Behalf Of Joe
> Wennechuk
> Sent: Friday, February 14, 2014 3:06 PM
> To: kwlug-disc at kwlug.org
> Subject: [kwlug-disc] MySQL Backups
>
> Hello All.
>
> I am looking for an open source free mysql backup and monitoring tool. I
> would like to have a web GUI where I can see the status of all of my
> servers
> and backups. Similar
> to www.manageengine.com/sql-server-monitoring-launch.html
>
>
> _______________________________________________
> kwlug-disc mailing list
> kwlug-disc at kwlug.org
> http://kwlug.org/mailman/listinfo/kwlug-disc_kwlug.org
>
>
>
> _______________________________________________
> kwlug-disc mailing list
> kwlug-disc at kwlug.org
> http://kwlug.org/mailman/listinfo/kwlug-disc_kwlug.org
>



-- 
Khalid M. Baheyeldin
2bits.com, Inc.
Fast Reliable Drupal
Drupal optimization, development, customization and consulting.
Simplicity is prerequisite for reliability. --  Edsger W.Dijkstra
Simplicity is the ultimate sophistication. --   Leonardo da Vinci
For every complex problem, there is an answer that is clear, simple, and
wrong." -- H.L. Mencken
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://kwlug.org/pipermail/kwlug-disc_kwlug.org/attachments/20140215/74cd6467/attachment.htm>