Manuale d’uso / di manutenzione del prodotto X4540 del fabbricante Sun Microsystems
Vai alla pagina 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 punto importante, dopo l’acquisto del dispositivo (o anche prima di acquisto) è quello di leggere il manuale. Dobbiamo farlo per diversi motivi semplici:
Se non hai ancora comprato il Sun Microsystems X4540 è un buon momento per familiarizzare con i dati di base del prodotto. Prime consultare le pagine iniziali del manuale d’uso, che si trova al di sopra. Dovresti trovare lì i dati tecnici più importanti del Sun Microsystems X4540 - in questo modo è possibile verificare se l’apparecchio soddisfa le tue esigenze. Esplorando le pagine segenti del manuali d’uso Sun Microsystems X4540 imparerai tutte le caratteristiche del prodotto e le informazioni sul suo funzionamento. Le informazioni sul Sun Microsystems X4540 ti aiuteranno sicuramente a prendere una decisione relativa all’acquisto.
In una situazione in cui hai già il Sun Microsystems X4540, ma non hai ancora letto il manuale d’uso, dovresti farlo per le ragioni sopra descritte. Saprai quindi se hai correttamente usato le funzioni disponibili, e se hai commesso errori che possono ridurre la durata di vita del Sun Microsystems X4540.
Tuttavia, uno dei ruoli più importanti per l’utente svolti dal manuale d’uso è quello di aiutare a risolvere i problemi con il Sun Microsystems X4540. Quasi sempre, ci troverai Troubleshooting, cioè i guasti più frequenti e malfunzionamenti del dispositivo Sun Microsystems X4540 insieme con le istruzioni su come risolverli. Anche se non si riesci a risolvere il problema, il manuale d’uso ti mostrerà il percorso di ulteriori procedimenti – il contatto con il centro servizio clienti o il servizio più vicino.
