[kwlug-disc] MySQL Backups

[Khalid Baheyeldin]

I prefer to backup MySQL using cron automated scripts. This is just boils
down to a simple:

mysqldump db_name | gzip -c > db_name.sql.gz

If there is a need for a remote copy, then the dump is sent via rsync to
another server, and that is all that is needed. You can keep one backup per
week day (Sat, Sun, ...), and also keep an older backup from a month ago.

Monitoring depends on what you want monitored. Munin provides historical
graphs for MySQL (and other services). The monitored things that come by
default on Ubuntu (and I assume Debian) when you install Munin from the
repos are the following:

- Queries: Select, Update, Delete, Insert and cache hits per seconds.
- Number of slow queries per second
- Number of MySQL threads
- Throughput (bytes received/sent per second)

The following are also available, but not enabled by default:
- InnoDB stats
- Log activity (binary log)

All the above is plotted in different graphs, by day, week, month and year.

You can add other things that you can query MySQL for, e.g. anything that
can be queries via SHOW VARIABLE, SHOW STATUS, ...etc.)



On Fri, Feb 14, 2014 at 3:06 PM, Joe Wennechuk <
youcanreachmehere at hotmail.com> wrote:

> 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
>



-- 
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/20140214/991a846c/attachment.htm>