Instruction/ maintenance manual of the product X4540 Sun Microsystems
Go to page of 23
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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 repor.
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.
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.
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.
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.
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.
An important point after buying a device Sun Microsystems X4540 (or even before the purchase) is to read its user manual. We should do this for several simple reasons:
If you have not bought Sun Microsystems X4540 yet, this is a good time to familiarize yourself with the basic data on the product. First of all view first pages of the manual, you can find above. You should find there the most important technical data Sun Microsystems X4540 - thus you can check whether the hardware meets your expectations. When delving into next pages of the user manual, Sun Microsystems X4540 you will learn all the available features of the product, as well as information on its operation. The information that you get Sun Microsystems X4540 will certainly help you make a decision on the purchase.
If you already are a holder of Sun Microsystems X4540, but have not read the manual yet, you should do it for the reasons described above. You will learn then if you properly used the available features, and whether you have not made any mistakes, which can shorten the lifetime Sun Microsystems X4540.
However, one of the most important roles played by the user manual is to help in solving problems with Sun Microsystems X4540. Almost always you will find there Troubleshooting, which are the most frequently occurring failures and malfunctions of the device Sun Microsystems X4540 along with tips on how to solve them. Even if you fail to solve the problem, the manual will show you a further procedure – contact to the customer service center or the nearest service center
