Page 3 - Table of Contents
Sun Microsystems, Inc. Table of Contents Introduction.....................................................................................................................................................1 Configuration .....................................................................................
Page 5 - Introduction
1 Introduction Sun Microsystems, Inc. Introduction This paper discusses how to quickly configure and deploy the Sun Fire X4540 server with Zmanda Recovery Manager 2.2 for MySQL databases. For more information on ZRM Enterprise, see: http://zmanda.com/zrm-mysql-enterprise.html . MySQL TM software has...
Page 6 - Configuration; Overview; The complete ZRM deployment consists of the following:
2 Configuration Sun Microsystems, Inc. Configuration Overview Figure 1 shows an example of Zmanda Recovery Manager (ZRM) running on the Sun Fire X4540 server and protecting remote MySQL servers running on Solaris OS, Linux, and Microsoft Windows machines with MyISAM and InnoDB tables, and a MySQL Cl...
Page 7 - Solaris Configuration; dladm; Zpool Configuration; What is the required capacity?
3 Overview Sun Microsystems, Inc. Solaris Configuration For this guide, the Sun Fire X4540 server used for ZRM certification was running the Solaris 10 8/07 OS. This is the minimum recommended version to use because various ZFS improvements were introduced in this build. The Sun Fire X4540 server is...
Page 8 - Example
4 Zpool Configuration Sun Microsystems, Inc. Example zpool creation commands for a pool zmanda : bash-3.00# zpool create -f zmanda raidz2 c0t0d0 c1t0d0 c2t0d0 c3t0d0 c4t0d0 c5t0d0bash-3.00# zpool add zmanda raidz2 c0t2d0 c1t2d0 c2t2d0 c3t2d0 c4t2d0 c5t2d0 bash-3.00# zpool listNAME SIZE USED AVAIL CA...
Page 9 - zmanda; ZFS Configuration; Example of ZFS file system creation:; ZRM Configuration; Prerequisite packages:; Installing the Required Dependencies; , that you can download from the Zmanda Network:
5 Zpool Configuration Sun Microsystems, Inc. The next step was adding two spare drives. Lastly, we checked the pool status and verified the availability of the zmanda pool for configuring ZFS. RAIDZ2 is a natural choice for a backup server, which contains information vital to business operations. RA...
Page 10 - The dependency packages provided are as follows:; Installing ZRM
6 ZRM Configuration Sun Microsystems, Inc. The dependency packages provided are as follows: • SMCcoreu • CSWgcc3corert • CSWgcc3g++rt • SMCgpgme • SMCgrep • SMClgcc346 • SMClgpger • SMCliconv • SMClintl • SMCpcre • SMCsudo • SMCtar These packages are also available from Sunfreeware at http://sunfree...
Page 11 - Zmanda Management Console
7 ZRM Configuration Sun Microsystems, Inc. The following software components are installed: • The ZRM for MySQL software • Zmanda Management Console with MySQL, PHP, Apache, PHPmyadmin, Perl and various Perl modules and their dependencies. These are installed under the /opt/zmanda/zrm and /opt/zmand...
Page 14 - Configuring Storage; Figure 3. Backup Where Page for Configuring Storage
10 Sun Microsystems, Inc. Configuring Storage Figure 4 shows the Backup Where page, which specifies where the backup images for the backup set will be stored and how long to retain them. Figure 3. Backup Where Page for Configuring Storage Regardless of where the remote MySQL server is hosted, backup...
Page 15 - mysqlhotcopy; Configuring ZFS Snapshots
11 Configuring Storage Sun Microsystems, Inc. ZMC creates temporary files and directories during backup on both the ZRM server and the MySQL server. The temporary directory specified here should exist on both machines, and should have sufficient space to hold at least one full backup on the MySQL se...
Page 17 - ZRM Monitoring and Reporting; Figure 5. Monitor Page Showing Backup Progress
13 Configuring ZFS Snapshots Sun Microsystems, Inc. ZRM Monitoring and Reporting The complexity of backup operations for MySQL databases makes it difficult to estimate how well you meet the business objectives of data protection. The comprehensive monitoring and backup reporting provided by ZRM help...
Page 18 - Database Events Viewer
14 ZRM Monitoring and Reporting Sun Microsystems, Inc. Figure 6. Calendar View of Recent Backup Reports ZRM provides nine pre-defined reports, all of which can be easily customized: • Backup report • Backup application performance report • Backup status report • Backup methods report • Backup retent...
Page 19 - Figure 7. Database Events Viewer; Recovery Using ZMC
15 Database Events Viewer Sun Microsystems, Inc. The date and time of each database event is shown as an individual record. You can easily scroll through the entries and search the logs with queries. Using the search, you can locate any event that caused harm to your database. You can also jump to a...
Page 20 - Figure 8. Restore What Page
16 Recovery Using ZMC Sun Microsystems, Inc. After selecting what to restore from, choose a recovery point objective (RPO). ZRM catalogs all full and incremental backups performed. When you request a point-in-time restore, ZRM automatically finds the full backup and all the incremental backups requi...
Page 23 - Licensing Information
19 Licensing Information Sun Microsystems, Inc. Licensing Information Unless otherwise specified, the use of this software is authorized pursuant to the terms of the license found at http://www.sun.com/bigadmin/common/berkeley_license.html . Using Sun Fire X4540 Server With Zmanda Recovery Manager 2...