Sun Microsystems X4540 manual

Using Sun Fire TM X4540 Server With Zmanda Recove ry Manage r 2.2 for MySQL T M Database Thomas Hanve y (Sun Microsystems) Dmitri Jouko vski and Ken Crandall (Zmanda) October 2008[...]

Copyright © 2008 Sun Microsyste ms, Inc., 4150 Net work Cir cle, San ta Clara, Californ ia 95054, U.S.A. All righ ts reser ve d. U.S. Gove rnm ent Rights - Comme rcial softw are. Gover nme nt users are subj ect to the Sun Microsystems, Inc . standar d license agree me nt and applicable provi sions of t he FAR and its suppl emen ts. Use is subj ect[...]

Sun Microsystems, Inc. Table of Content s Introduct ion................................................................................................. .................................... ................1 Config uration ................................................... .................. .................. ............ .................. .....[...]

[...]

1 Introduct ion Sun Microsystems, Inc. Introduct ion This paper discusses how to quickly configure and deploy the Sun Fire X4 540 s erver 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 become the world's most popular open s[...]

2 Configura tion Sun Microsystems, Inc. Configura tion Overvi ew Figure 1 shows an example of Zmanda Recovery Manager (ZRM) running on the Sun Fire X4540 s erver and protect ing remote MySQL servers running on So laris OS, Linux, and Microsoft Windows machines with MyISAM and InnoDB tables, and a MySQL Cluster with NDB storage engine. Figure 1. C e[...]

3 Overview Sun Microsystems, Inc. Solaris Configuration For this guide, the Sun Fire X45 40 server used for ZRM certification was running the S olaris 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 powered by up to 8 CPUs operating at 2300 MHz a[...]

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 c5t0d0 bash-3.00# zpool add zmanda raidz2 c0t2d0 c1t2d0 c2t2d0 c3t2d0 c4t2d0 c5t2d0 bash-3.00# zpool list NAME SIZE USED AVAIL CAP HEALTH ALTROOT zmanda 10.9T 204K 10.9T 0% ONLI[...]

5 Zpool Configura tion 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 con tains information vital to business operations. RAIDZ2 ca n survive up to two drive failures, rega[...]

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 fr om Sunfreeware at http://sunfreeware.org and from Blastwa[...]

7 ZRM Configuration Sun Microsystems, Inc. The follo wing software components are installed: • The ZRM for MySQL software • Zmanda Managem ent Console with MySQL, PH P, Apach e, PHPmyad min, Perl and various Perl modules and their dependencies. These are installed under the /opt/zmanda/zrm a nd /opt/zmanda/common directories. Zmanda Management [...]

8 Sun Microsystems, Inc. • Backup time and parameters for backup-leve l scheduling • (OPTIO NAL) Snapshot technol ogy used to make backups • (OPTIO NAL) Local storage location of snapshot s for n ear-CDP protection of MySQL databases Each backup set conta ins at least one database or database table. Backup sets ar e easy to copy, add, and mod[...]

9 Sun Microsystems, Inc. Note : For many ZMC forms, the fields change depending on the context; selecting different values can change the options that are displayed. For example, if you choose to back up the MySQL cluster, Backup What displays options that are different from what is shown in Figure 2. The Server Parameters section lets you specify [...]

10 Sun Microsystems, Inc. Configuring Storage Figure 4 shows the Backup Where page, w hich specifies where the backup images for the backup set will be sto red and how long t o retain them. Figure 3. Backup Where Page for Configuring Storage Regardless of where the remote MySQL server is hosted, backups are stored under the b ackup directory of th [...]

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 h ave sufficient space to hold at least one full backup on the MySQL server during backup and on the backup host during [...]

12 Conf iguring ZFS Snapsh ots Sun Microsystems, Inc. To take advantage of ZFS snapshots, all MySQL database files (data, log, indexes) belonging to th e backup set must be stored in ZFS volumes to ensure consistency. If any of the files are not on ZFS volumes, a raw backup (using mysqlhotcopy ) or a logical backup (using mysqldump ) is performed, [...]

13 Configuring ZFS Snapshots Sun Microsystems, Inc. ZRM Mon itoring and Reporting The complexity of backup operations for MySQL databases makes it d ifficult t o estimate how well you meet the business objectives of data protection. The comprehensive monitoring and backup reporting provided by ZRM helps you to ensure your MySQL data is protected we[...]

14 ZRM Monitoring and Reporting Sun Microsystems, Inc. Figure 6. C alendar View of Recent Backup Reports ZRM provides nine pre-defined reports, all of which ca n be easily customized: • Backup report • Backup application performance re port • Backup status report • Backup methods report • Backup retention policies r eport • Backup perfo[...]

15 Database Events Viewer Sun Microsystems, Inc. The date and time of each database event is shown as an individual record. You can easily s croll thro ugh the entries and search the lo gs with queries. Using the search, you can locate any event that caused harm to your d atabase. You can also jump to a given date and timestamp. To help you navigat[...]

16 Recovery Using ZMC Sun Microsystems, Inc. After selecting what t o 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 automaticall y finds the full backup and al l the incremental backups required to restore your database to t he requested [...]

17 Summa ry Sun Microsystems, Inc. Summary This guide was a quick introduction to configuring t he Sun Fire X454 0 server as a backup server for Zmanda Recovery Manager 2.2. It provides examples for installing the Zmanda Recovery Manager for MySQL and configuring a zpool and the ZFS file system on the Solaris OS to utilize the Sun Fire X45 40 serve[...]

18 For Mor e Information Sun Microsystems, Inc. ● Wikis: ● Sun BluePrints T M wiki ( http://wikis.sun.com/display/BluePrints/Main , especially the following: ● Storage BluePrints page: http://wikis.sun.com/display/BluePrints/Storage+BluePrints ● Sun BluePrints article: Optimize My SQL Server on Sun x64 Servers and Storage: http://wikis.sun.[...]

19 Licensing Information Sun Microsystems, Inc. Licensi ng Infor mation Unless otherwise specified, the use of this software is authorized pursuant to the terms of the license fou nd at http://www.sun.com/bigadmin/common/berkeley_license.html . Using Sun Fire X4540 Server With Zmanda Recovery Manager 2.2 for MySQ L Database[...]