Leveraging Replication to Optimize MySQL Backup & Disaster Recovery |
In a global market, the uptime and performance of your MySQL database is critical. Taking the database offline to perform backups is simply not an option, but using replication is not a backup solution. So, how do you backup your data with minimal impact to your production environment? Using the ZRM for MySQL in conjunction with your replication slave, the ZRM for MySQL can back up your environment with no impact to production. |
Outline:
|
MySQL databases are increasingly used by high volume, high
transaction applications
that support businesses running full throttle 24-hours a day,
seven days a week.
Backup and recovery operations need to be conducted in such as
way that is non-disruptive
to users and applications. The latest release of Zmanda Recovery
Manager (ZRM) 2.2 provides
Continuous Data Protection (CDP) as well as instant point-in-time
recovery for MySQL.
In this webinar, we will demonstrate the latest ZRM enhancements
so that you can use ZRM
to build a robust, flexible, and easy to use backup and recovery
solution.
When: Thursday May 29, 2008, 10:00am Pacific / 1:00pm Eastern
You have to have been living under a rock, if you did not know
that today is the first day of MySQL Users’ Conference and Expo.
We at Zmanda are so proud and privileged to have been awarded the
“Partner of The Year”. The award is very meaningful to our vision
of Simplified, Easy to use, commercial Open Source Backup and
Recovery. We appreciate the award and are committed to making the
life of the MySQL DBA hassle free. We have had a ton of visitors
from all walks of MySQL user community talk to us today. Its
fascinating to talk to customer and prospects on how they
leverage the power of MySQL. To learn more about how Zmanda
provides the Best in Class Backup and Recovery solution for
MySQL, you can attend Zmanda’s sessions at the MySQL Conference
& Expo include:
What: “Radically Simple Backup & Recovery
for Live MySQL”
Who: Chander Kant, Zmanda CEO and founder
…
Worried about Backup and Recovery of your MySQL Databases? MySQL Backup school from Zmanda provides hands on and in depth training on Backup and Recovery of MySQL. Just sign up and show up with your laptop. More information available here.
If you are migrating your production environment to MySQL database or even thinking about it, you do not want to miss this webinar Experts from Zmanda and MySQL will present various methods to backup MySQL database and correlate them with tools and terminology you may be familiar with in other databases, including Oracle.
A good pre-read for this webinar would be Paddy’s blog on online MySQL Backup
WHO:
Chander Kant, CEO, Zmanda
Robin Schumacher, Director Product Management, MySQL
WHAT:
MySQL Backup Techniques for the Oracle DBA (web presentation)
WHEN:
Thursday, December 13, 2007, 10:00 am PDT, 1:00 pm EDT, 18:00
GMT
The presentation will be approximately 45 minutes long followed
by Q&A.
… |
I was reading, this article (subscription required) by Ben Worthen on WSJ about a study on how well companies are prepared for a disaster. I was not at all surprised by (one of) the findings (paraphrased):
…While 70% of 189 tech leaders surveyed by Forrester Research Inc. said that their companies are prepared for a disaster, the reality was quite different…
We run into this all the time, in talking to (prospective) customers. People “think” they are prepared for a disaster. The truth hits them when you start peeling the layers of the supposed plan. Some things to keep an eye on are
- Is it robust and reliable?
- Do you have the right resources engaged in the plan - both design and implementation?
- How often are the plans tested?
- How well is the plan documented? …
The role of data stored in MySQL database in today’s world is already known - it powers business and mission critical apps. Protecting this data is of utmost important to any enterprise. Before you actually have a backup in place, that are some very important things to think about the backup implementation. Like for instance, how soon would you want your data recovered after a user or system error? This article provides an indepth analysis about the basics of what needs to be considered while planning a Backup and Recovery solution for your MySQL database.
Zmanda’s MySQL Backup and Recovery Solution is the only comprehensive backup solution that addresses the unique needs of MySQL databases — such as multiple database storage engines. Zmanda Recovery Manager (ZRM) for MySQL now features graphical tools to simplify the process of protecting MySQL data.
This free presentation from experts in open-source backup and recovery of MySQL will demonstrate Zmanda Management Console for ZRM , which is a web based service integrated with Zmanda Network. It provides management and visualization tools for defining all backup activities of a MySQL DBA:
- what to backup, e.g. all databases or just the selected tables
- where to store the backup images
- when to perform backups, e.g. schedule daily, weekly or monthly full and incremental backups
…
[Read more]Could not resist the title after reading what Matt wrote. Sexy and exciting, indeed. Most of the crew here have their heads buried with the upcoming releases of Amanda Enterprise and Zmanda Recovery Manager (ZRM) for MySQL. We are continuing to enhance the Management console for Network backup. And with the next release of ZRM for MySQL, backup of MySQL database will never be the same. Dmitri already wrote about how easy it will be to manage MySQL backups from Iphone. Additionally we are fixing stuff in the Management console for ease of use. You can see, touch and feel them at LinuxWorld. …
[Read more]