Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 82

Displaying posts with tag: MySQL Backup and Recovery (reset)

Backup Software and The Long Tail of Open Source
+0 Vote Up -0Vote Down

An addition to The Long Tail of “The Long Tail” related blogs

The Long Tail effect of open source has been discussed in several contexts. Some of the interpretations are likely very different from what Chris Anderson intended, but more and more niche needs of a relatively small set of people (which don’t have economies to justify product development by proprietary software companies) are being met by open source software. Witness more than 140,000 projects registered on SourceForge.

Whenever I install Red Hat Linux I am amused by some of the choices available for the language of the operating system - what is different when running a Red Hat box with English(Singapore) vs. English(India)!? It is also heartening to see support for regional languages making computers accessible to

  [Read more...]
Talking at Scale 5X - Southern California Linux expo
+0 Vote Up -0Vote Down

I will be talking about backup and recovery of Web applications at SCALE 5x. Characteristics of Web applications create unique requirements for backup and recovery. The talk will discuss open source backup and recovery tools for file systems, MySQL and PostgreSQL databases. Conference guru blog provides more information on my session.

I would be happy to meet folks who are interested in Amanda, ZRM for MySQL and open source backups in general before or after the session.

ZRM for MySQL 1.1.4 released
+0 Vote Up -0Vote Down
Version 1.1.4 of Zmanda Recovery Manager (ZRM) for MySQL, a robust and
intelligent solution for backup and recovery of MySQL databases is available
for download at Zmanda downloads page. Changes since 1.1.3 release: * Support for aborting backup runs
* Support for character sets and stored routines
* Bug fixes Take a look at ZRM for MySQL user documentation for more information on how to install and configure it. Find bugs and report them at bugzilla (http://forums.zmanda.com/bugzilla). Feel free to contribute to ZRM for

  [Read more...]
Personal comments about recently published results of Amanda usage survey
+0 Vote Up -0Vote Down

We just published the results of Amanda usage survey and I want to share my personal observations.One of the most inspiring findings is that 95% of respondents would recommend Amanda to a friend. The Loyalty expert Fred Reichheld would be very impressed with such a result. The overall satisfaction with Amanda is also highlighted by the fact that 70% of respondents have been using Amanda for more than 2 years. People use software for such a long time only if it does the job well. Many users reported that Amanda was up to the task recovering files in most critical situations.

I think it is just great that more than 60% of users provided suggestions for new functionality.

Here are the

  [Read more...]
Webinar on Backing up your MySQL server remotely over the internet
+0 Vote Up -0Vote Down

Next week, backup experts from Zmanda, will present a webinar on how you can use ZRM for MySQL to backup your MySQL server remotely over the internet. If you are a ISP or host your own site, you would want to attend this webinar. For that matter, the infromation will be useful for any MySQL dba. This is a technical seminar where we will go through step by step of actually implementing the solution. We already published a detailed white paper on this topic. You can get to that white paper by registering with Zmanda Network.

Hope to see you at the Webinar.

Event Information

Topic: Backing up your MySQL server over the internet using Zmanda  [Read more...]
ZRM for MySQL users manual Updated
+0 Vote Up -0Vote Down

ZRM for MySQL users manual has been rewritten based on user feedback. It is available at ZRM for MySQL wiki

Thanks to everyone who provided feedback. User contributions to the manual are welcome.

Backup and recovery of the remote MySQL server with ZRM
+0 Vote Up -0Vote Down

We just published a technical document about what to consider for backup and recovery of the remote MySQL server, for example, when your online forums and wiki are located at managed hosting service provider.

For any database backup the primary considerations are the consistency of the backup and impact on users and applications. A backup of the remote MySQL, however, has extra challenges related to:

  • network usage
  • security, and
  • flexibility of recoverability of MySQL data to a different host.

We discuss the trade-offs to consider, and describe how to use Zmanda Recovery Manager (ZRM) for several common scenarios. For example, we provide HOWTO for a use case when you want to ensure security of backup data on the wire and at rest.

ZRM for MySQL 1.1.3 released
+0 Vote Up -0Vote Down

Version 1.1.3 of Zmanda Recovery Manager (ZRM) for MySQL, an enterprise solution for backup and recovery of MySQL databases is available for download at Zmanda downloads page.

Changes since 1.1.2 release:
* Supports Ubuntu Edgy (6.10) release
* Works with MySQL enterprise 5.0
* User configuration for custom plugins
* Bug fixes

Documentation is available in ZRM for MySQL wiki. Please use forums to provide feedback on the release.

Thanks to all users for providing valuable feedback as well as finding bugs in earlier

Webinar on configuring Zmanda Recovery Manager [ZRM] for MySQL
+0 Vote Up -0Vote Down

Last month, Paddy gave a great webinar on ZRM for MySQL. The playback is available as part of documentation in Zmanda Network, at no cost. You can register to Zmanda Network here. As a follow-up, we will be hosting a very hands on webinar on configuring ZRM for MySQL this Thursday, the 14th of Decemeber at 10.00 am PST. You can register for this webinar here.

Detecting malicious database activity
+0 Vote Up -0Vote Down

I was talking to a customer yesterday and the customer was surprised that database backups can be used to detect malicious database activity from legitimate users and hackers.

ZRM for MySQL stores MySQL binary logs as part of the database backups. The binary logs provide a good audit trail of all database activity. ZRM for MySQL binary log parsing capability, usually used for selective point in time recovery, can also be used to detect malicious database activity using SQL inspection.

ZRM for MySQL plugin interface allows DBAs to write log parser plugin scripts to track the database activity that they are interested in. For example: the following script can be used to detect deletion of data from the PRODUCTS table in the database. This script

  [Read more...]
Retain your MySQL Binary Logs until needed - but no longer (using Zmanda Recovery Manager)
+0 Vote Up -0Vote Down

ZRM for MySQL requires binary logging to be enabled on the MySQL server to do incremental backups. Enabling binary logs has minimal impact on MySQL performance. But, in an active database, the binary logs can grow to hundreds of gigabytes or even terabytes.

ZRM of MySQL has multiple plugin interfaces to customize the backup and recovery process to user environment. One of the plugin interfaces is the post backup plugin. The binary logs are no longer required after a backup. The post backup plugin can purge the binary logs after the backup. This will allow the system

  [Read more...]
To err is Human?..
+0 Vote Up -0Vote Down

DBA’s working in environments where MySQL database is for production critical applications are constantly pushed to their limits. Database Users and DBA’s are humans too. So, a dropped table here or a misconstrued MySQL statement there is not out of ordinary. Recovering from these kinds of user errors is extremely vital to production databases. Zmanda Recovery Manager (ZRM) for MySQL, is a good way to recover from user errors. Consider this example - You [DBA] find out that an user has made an unforced error which is affecting your production database. You further find out that this has happened in the last half hour. Lucky for you, you use ZRM for MySQL in your environment to make nightly backups. You spring into action! You first verify that a nightly backup was run. You then make an incremental backup now. Using ZRM for MySQL, you

  [Read more...]
What is the optimal backup method for MySQL databases?
+0 Vote Up -0Vote Down

Goal of a MySQL system administrator is to have regular, consistent backups of the
databases with minimal impact on the database application. The backup process should
also limit the use of CPU, memory, network resources so that application is not impacted.
Optimal backup method must be choosen to keep the backup window as small as possible.
The backup parameters depends on various factors - number and size of databases, number
of MySQL servers, MySQL configuration, data security.

ZRM for MySQL provides consolidated backup and recovery for MySQL databases. ZRM
for MySQL provides extensive list of options to tune the backup process for the user
environment. It also tracks lots of backup parameters that are available to the administrator
to tune the backup process.

  [Read more...]
ZRM for MySQL 1.1.2 released, Debian packages available
+0 Vote Up -0Vote Down

Zmanda recovery manager for MySQL 1.1.2 is available from Zmanda downloads page. This release has been tested on Debian distribution and on MySQL server 4.0.24.

I want to acknowledge Thorsten Schifferdecker’s contribution to this release. He helped us by creating debian packages for earlier releases and provided good feedback on the product.

Lots of bugs have been fixed and this release has underwent more testing with different MySQL configurations.

Take a look at ZRM for MySQL wiki for changes, documentation, try it in your MySQL configuration and feel free to provide feedback on forums.

Amazon S3 Backup Testing Results
+0 Vote Up -0Vote Down

Digg this article

So, I’ve been playing around with Amazon’s new S3 service. It’s essentially an on-demand storage-and-bandwidth combination; Amazon will scale their service transparantly to provide as much as you need of either. It’s pretty cheap, too, at $0.15 per GB per month for storage and $0.20 per GB per month for data transfer. I wanted to see what would be the best way to use Amazon S3 for backups with Amanda and MySQL ZRM, so I did some tests to evaluate the performance under various circumstances.

Amazon requires that you upload data in complete ‘objects’, and it wasn’t clear to me what the

  [Read more...]
ZRM for MySQL and MySQL Online Backup
+0 Vote Up -0Vote Down

I had organized a session at MySQL camp on Saturday on the above topic. I should say I was one of the guilty ones who had slides for the session in an “unconference“.

Brian Aker (of MySQL) graciously stepped in to answer some questions and provided reasons for some of the design decisions in MySQL OnlineBackup. Some of them are:

  • Envelope format for backup archive. This would allow backup as well as recovery to continue in case the storage engines failed to do backup or recovery respectively.
  • Block size and envelope format will help in handling tape errors.
  • Logical backup will be done in case storage engine does not have online backup API implementation.
  [Read more...]
?We can do it, you can help?
+0 Vote Up -0Vote Down

This is how Marten Mickos (MySQL CEO) described the relationship between MySQL and the open source community at MySQL Camp. MySQL Camp held at Google over last weekend, was an useful opportunity to listen and talk to developers in the broad MySQL ecosystem (including Oracle VP) as well as MySQL users.

The most interesting talk was about the efforts made by MySQL folks to attract and reward MySQL community contributors. They have made significant efforts in this direction - MySQL forge, Planet MySQL, MySQL winter of code, MySQL community server and availability of MySQL work logs (roadmap)

We, at Zmanda, also understand the need to have vibrant open source community behind our work and

  [Read more...]
MySQL Online Backup
+0 Vote Up -0Vote Down

Digg this article

There are several methods to do live MySQL database backups. These methods are either storage engine specific (InnoDB hot backup, mysqlhotcopy), or require read locks (mysqldump), or require additional hardware (backup using replication, LVM snapshot). Some of these backup methods can do backups of remote MySQL servers also. So far, there is no backup method that provides storage engine agnostic, consistent full backups of local and remote servers. Goal of Zmanda Recovery Manager (ZRM) of MySQL is to consolidate all these and future methods of MySQL backup and use the optimal method for the MySQL configuration.

One of the exciting developments in MySQL is the development of MySQL Online backup. The

  [Read more...]
Oops, I deleted my MySQL binary logs
+0 Vote Up -0Vote Down

Yesterday, I was testing various backup and recovery methods supported by ZRM for MySQL before 1.1.1 release. ZRM for MySQL requires binary logging to be enabled on the MySQL server. I ran out of disk space during testing and removed the binary logs. Accidently, I deleted the last binary log used by MySQL server. MySQL server uses the most recent binary log.

I could not start MySQL server again.

# service mysqld start
061031 17:38:48  mysqld started
061031 17:38:48  InnoDB: Started; log sequence number 14 1645228884
/usr/libexec/mysqld: File '/var/lib/mysql/mysql-bin.000017' not found
(Errcode: 2)
061031 17:38:48 [ERROR] Failed to open log (file
  [Read more...]
Zmanda recovery manager for MySQL 1.1.1 released
+0 Vote Up -0Vote Down

Version 1.1.1 of Zmanda Recovery Manager (ZRM) for MySQL, a robust and
intelligent solution for backup and recovery of MySQL databases is available
for download at Zmanda downloads page.

Changes since 1.1 release:
* FHS compliance (plugins are now in /usr/share/mysql-zrm directory)
* Bug fixes

ZRM for MySQL users manual is available in the wiki.

Please use bugzilla to report bugs in the release and product improvements.

You can setup your MySQL database backup within minutes!
+0 Vote Up -0Vote Down

Using freely available ZRM for MySQL , you can set up a solution to backup and restore your MySQL database, within minutes. This article has all the details.

ZRM for MySQL 1.1 release - Get involved!!!
+0 Vote Up -0Vote Down

Zmanda Recovery Manager (ZRM) for MySQL is a robust and intelligent solution for live backup and recovery of local and remote MySQL databases. In case you are not familiar with it, take a look at ZRM for MySQL project page.

Key features in 1.1 release
- Backup images can be compressed and encrypted using platform tools
- Custom plugin interfaces for
- Backup encryption
- Pre backup actions
- Post backup actions
- Flexible scheduling
- Binary log parser
- Secure file transfer
- Automatic HTML and Text backup report generation
- Backup reports are available as RSS feed

This is an open source community project. Feel free to check out the project wiki, go to

  [Read more...]
Previous 30 Newer Entries Showing entries 61 to 82

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.