Manuel d'utilisation / d'entretien du produit X4540 du fabricant Sun Microsystems
Aller à la 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.
Un point important après l'achat de l'appareil (ou même avant l'achat) est de lire le manuel d'utilisation. Nous devons le faire pour quelques raisons simples:
Si vous n'avez pas encore acheté Sun Microsystems X4540 c'est un bon moment pour vous familiariser avec les données de base sur le produit. Consulter d'abord les pages initiales du manuel d'utilisation, que vous trouverez ci-dessus. Vous devriez y trouver les données techniques les plus importants du Sun Microsystems X4540 - de cette manière, vous pouvez vérifier si l'équipement répond à vos besoins. Explorant les pages suivantes du manuel d'utilisation Sun Microsystems X4540, vous apprendrez toutes les caractéristiques du produit et des informations sur son fonctionnement. Les informations sur le Sun Microsystems X4540 va certainement vous aider à prendre une décision concernant l'achat.
Dans une situation où vous avez déjà le Sun Microsystems X4540, mais vous avez pas encore lu le manuel d'utilisation, vous devez le faire pour les raisons décrites ci-dessus,. Vous saurez alors si vous avez correctement utilisé les fonctions disponibles, et si vous avez commis des erreurs qui peuvent réduire la durée de vie du Sun Microsystems X4540.
Cependant, l'un des rôles les plus importants pour l'utilisateur joués par les manuels d'utilisateur est d'aider à résoudre les problèmes concernant le Sun Microsystems X4540. Presque toujours, vous y trouverez Troubleshooting, soit les pannes et les défaillances les plus fréquentes de l'apparei Sun Microsystems X4540 ainsi que les instructions sur la façon de les résoudre. Même si vous ne parvenez pas à résoudre le problème, le manuel d‘utilisation va vous montrer le chemin d'une nouvelle procédure – le contact avec le centre de service à la clientèle ou le service le plus proche.
