Sun Microsystems X4540 manual Sun Microsystems, Inc

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 the connection details for the MySQL server to back up. Choosing Port lets you enter a port number for communication with the MySQL server; choosing Socket File lets you enter a path to the socket file. You need to specify the host name or IP address of the MySQL server being backed up, or localhost if the MySQL server and the ZRM server are on the same machine.

If you installed the same versions of MySQL client commands on the ZRM server and the MySQL server (typically in /usr/bin), use the factory (Or Site Settings) defaults for all backup sets. If you installed different versions of MySQL software on the ZRM server and the MySQL server (that is, the backup client), enter the full path to where MySQL binary commands are installed on the backup client.

In the MySQL User Parameters section, enter the user name and password of the MySQL user on the MySQL server. If no user is specified here, ensure that you have the MySQL backup user (with appropriate privileges) specified explicitly as a Site Default, or ensure that the MySQL user specified in the my.cnf or --optionsfile has the necessary privileges described in System Requirements. If the connection from the ZMC server to the remote server is via SSL, specify the MySQL SSL parameters here. If you are backing up databases on the localhost, leave this field empty.

For remote MySQL backups, the UID and GID of the MySQL user need to be the same on the ZRM client machine (where the MySQL software runs) as on the ZRM server.

ZRM allows you to back up the following:

•All Database(s). Choosing this option includes all databases and all tables for backup.

•Specific Database(s). Choosing this option displays a list of databases available for backup on the MySQL server. Select all the databases that you want to add to this backup set.

•Specific Table(s). Choosing this option displays a drop-down menu that lets you select a database from which to select tables to backup, followed by the list of tables in the selected database; select all the tables that you want to add to this backup set.

Clicking Save commits any changes you made to the currently selected backup set. You can then proceed to the Backup Where page to select a target device (or directory) to store the backup image.

Using Sun Fire X4540 Server With Zmanda Recovery Manager 2.2 for MySQL Database