HP-UX OSRA for Web Services 2.5 Blueprint and Configuration Guide

MySQL and other vendors provide data extraction tools, which capture and store the data from
the database. Each storage engine in MySQL has unique characteristics that impact backup.
HP Data Protector
HP Data Protector manages backup and recovery from both disks and tapes. It automates high
performance backup and recovery, from disk or tape over unlimited distances, to ensure 24/7
business continuity and seamless integration with HP storage hardware and management
solutions.
MySQL Replication
The MySQL replication feature allows the database on one server to be precisely duplicated on
one or more other servers. This capability is enabled through an asynchronous master/slave
relationship. Each slave server starts out with an exact copy of the data held on the master server.
The master server publishes a binary log to the slave servers of all changes made to the data in
the database. The slave servers read changes to the binary logs that have occurred since the last
successful update. In this way, the slave servers are able to update their copies of the database.
All changes to the database must be made to the master server, but clients may access data for
reading through either the master server or any slave server. Figure 4-2 depicts the replication
configuration.
Figure 4-2 MySQL Replication Configuration
This replication scheme can offer one key advantage, which is that backing up the database is
easier and safer. A slave server can be taken off line and all of its data can be backed up without
impacting the overall operation of the live database. During backup, the master server and other
slave servers continue responding to queries uninterrupted. When the backup is complete, the
backed-up slave server is brought up to date with any changes that have occurred during the
backup, and then the slave server is returned to normal operation. In this section the backup is
performed based on the MySQL replication configuration.
Backing Up MySQL Using HP Data Protector 39