Add a MySQL instance to a policy in DCC

{note:title=Notice}In DCC, end-user-level MySQL backup is not supported. Only super-users can make a MySQL backup. Sub-users are limited by Agent user permissions.

1. Select the "MySQL" tab in the Policy window. You can do this while [creating a new Policy|Create policies in DCC] as shown below.

!148dcc.png!

You can also select the "MySQL" tab in the "Edit Policy" window after the Policy has been saved, and even while it is running. See [Edit policies in DCC].

!152dcc.png!

2. On the "MySQL" tab of the Policy window, click on the "Add New MySQL Instance" button.

!149dcc.png!

3. The "Add Database Instance" wizard window will appear. Familiarize yourself with the introductory information, and click "Next" to proceed with adding the Instance.

!Add Database Instance_Introduction_English.png!

If you see the following error message, then the database driver is not installed on your Server.

!warn.png!

4. On the following "Name" screen, you can define the name for your database and enable or disable the database Instance.

!Add Database Instance_Name_English.png!

5. The next wizard screen is "Host." Here you can enter the information about the host to connect to. By default, the Agent's current host name is used.
* *Use Alternate Host Name/IP*
** *Host Name/IP -* Specify the host name or IP address if it differs from the Agent's current host name/IP address. When using MySQL on a Parallels Virtuozzo Containers (PVC) container, add the IP address of the MySQL container.
** *Port Number* \- By default, the "3306" port number is used. If you use another port number to connect to the database in your environment, specify the port number in this field.

{note:title=Notice}The "Use Alternate Host Name/IP" option is used in the following circumstances:
* Multiple network interfaces are configured on the host, each with a different IP address configured for connection. Example: {{eth1}}

_Or_
* When you configure multiple IP addresses over the same network interface. Example: {{eth0:1}} (Aliasing).
The "Use Alternate Host Name/IP" option is *not* used to connect to another host.{note}


!Add Database Instance_Host_English.png!

6. On the "Authentication" screen, you must specify the authentication credentials to connect to the database Instance.
* *Username* \- Enter the name of a user who has full administrator-level access to the database Instance you want to back up.
{info:title=Note}You do not need to create a new user to allow remote connections to a MySQL Instance. While adding a MySQL Instance to the Policy, you can use the credentials of any MySQL user with full access to MySQL server from {{localhost}}. For example, you can use the MySQL "root@localhost" account, which is typically created during MySQL server installation.
{info}
* *Password* \- Enter the password of the above-mentioned user.
* *Confirm Password*

!Add Database Instance_Authentication_English.png!

7. On the "Data Directory" screen, you can optionally define the path of the data directory. By default, the application discovers where the database stores its data files. In some environments, the data directory is under a different path than the discovered path. For these cases, you can specify the exact path to the database's data directory.


In order to properly restore the MySQL container, add the path of the MySQL container, e.g., {{/var/lib/mysql}}.

{info:title=Note}Do not use the PVC Hardware Node’s path.{info}

!Add Database Instance_Data Directory_English.png!

8. On the following screen, specify a base directory to use (if it differs from the standard directory). By default, the system attempts to automatically determine where on the file system the necessary program files are located. In some environments, the automatic method fails. To remedy this, you can choose to specify the exact path for the base directory. This will ensure that the system can locate the necessary files.

!Add Database Instance_Base Directory_English.png!

9. On the "Options" screen, you can "Specify a Virtuozzo Container ID" and "Get MySQL table statistics."
{info:title=Note}Receiving the MySQL table statistics may slow down the replication process.
{info}
!Add Database Instance_Options_English.png!

To set up a MySQL database in a PVC container, you will need to specify the following:
* *Host* \- "Use Alternate Host Name/IP" must be checked with the host name/IP address and port details added.
* *Authentication* \- Username and password for the MySQL Instance.
* *Options* \- "Specify a Virtuozzo Container ID" must be checked and the container ID added.

Read more in [Add a MySQL instance to a policy on a PVC container].


10. On the last "Summary" screen, the settings you have selected are displayed.

!Add Database Instance_Summary_English.png!

Once you have verified that the specified settings are correct, click "Add" to add your MySQL Instance to the Policy.

11. The wizard screen closes, and the added MySQL Instance appears on the "MySQL" tab of the Policy window. Instance options are displayed in the appropriate columns.

!150dcc.png!

12. Click "Save"

!Edit Policy_Save button_English.png!

or "Create" button.

!151dcc.png!

{excerpt:hidden=true}Instructions on how to add a MySQL Instance to a Policy.{excerpt}