V11 SP8
Loading...

Proxy Backup - Advanced - MySQL iDataAgent

Table of Contents

Enabling the Failover to Source If Proxy Is Unavailable

By default, the backups will be performed on the proxy server. However, you can opt for the backup to be performed on the production (master) server, If the proxy server is offline or unavailable.

Use the following steps to enable the backups on a master server, if the proxy is unavailable:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL | master <Instance>.
  2. Right-click the <subclient> and then click Properties.

  3. Click the Proxy Backup tab.
  4. Select Use Proxy.
  5. Select Use source if proxy is unavailable.

  6. Click OK.

Transaction Log Backups

Transaction Log Backups for Full Instance or Partial Replication

If the slave server is configured to replicate only the selected databases (partial replication), then the log backups are not performed on proxy server. When configured, the log backup will be redirected to the master server. This behavior can be overwritten with bAllowLogBackupsOnPartialRep key on proxy server. 

If the proxy is replicating an entire server (no filters for replication) the log backups are performed on proxy servers.

The following table displays the behavior of log backups based on replication types:

S.No. Replication Type Configuration Log Backup Destination
1. FULL INSTANCE REPLICATION 1.1  When all the subclients are using proxy. PROXY SERVER
1.2  When at least one subclient is not using proxy and the Use source if proxy is unavailable check box is selected. MASTER SERVER
1.3  When at least one subclient is not using proxy and the Use source if proxy is unavailable check box is not selected (cleared). NONE. The log backups cannot be run at either of the servers.
1.4  When the Always run transaction log backups check box on source is selected in the instance properties. MASTER SERVER
 
2. PARTIAL REPLICATION 2.1  In this case, by default. MASTER SERVER
2.2  To overwrite the above behavior and allow log backups on proxy, set bAllowLogBackupsOnPartialRep key to 1 on proxy under <InstanceRoot>/MySQL. This additional setting is not applicable for scenario 1.3. PROXY SERVER

Performing the Transaction Log Backups at Source

If you are using multiple proxy servers in a multi-level replication environment, it is always better to perform the transaction log backups on a master server. Also, the proxy sever might contain some events related to proxy-only operations such as the creation of non-replicated tables, temporary tables and their queries. You may not need to backup these transactions. Hence, you can choose to perform the log backups on a master server.

Use the following steps to set and perform the log backups on a master server:

  1. From the CommCell Browser, navigate to Client Computers | <Client> | MySQL.
  2. Right-click the master <Instance> and then click Properties.

  3. Click the Proxy Settings tab.
  4. Select Enable proxy backup.
  5. Select Always run transaction log backups on source.

  6. Click OK.

Managing the Logs on Master Server

You need to perform the deletion of logs on master server with an utmost caution. Any deletion of logs which are not replicated to slave will break the replication. As Commvault's proxy configuration assumes that there is only one master and one proxy server , the log file on master server that is replicated to proxy is considered eligible for deletion after backup. These logs on the master server are not deleted by default. You can select Truncate Logs on Source to automatically delete the eligible log files for each job at the job level. You can always select this option irrespective of the job running on master or proxy server. if the backup is running on the proxy server, Commvault will delete the logs on the master server. See How is the deletion of Logs implemented on Master Server for more information on the deletion of logs on master server.

Use the following steps to delete the logs on the master server:

  1. From the CommCell Browser, navigate to Client Computers | <Client> |  MySQL | <Master> <Instance>.
  2. Right-click the <subclient> and then click Backup.

  3. Select Truncate Logs on Source. You can view this option only if you enable proxy (Use Proxy) at the instance/subclient level.

  4. Click OK.

Managing the Logs on Proxy Server

Deleting the Logs on Proxy Server

By default, when you perform the backup on proxy server, the system deletes the logs that are backed up. Make sure to clear the Do not Truncate the Logs on Proxy option in the backup options of the subclient to enable the deletion of logs.

Use the following steps to enable the deletion of logs on proxy server:

  1. From the CommCell Browser, navigate to Client Computers | <Client> |  MySQL | <Master> <Instance>.
  2. Right-click the <subclient> and then click Backup.

  3. Make sure to clear Do Not Truncate Log on Proxy.

  4. Click OK.

Disabling the Deletion of Logs on Proxy Server

In certain cases such as cascading master slave configuration, you may be required to maintain the logs on proxy server.  When you disable the deletion of logs, the system will skip the deletion of logs on the  proxy server.

Use the following steps to disable the deletion of logs:

  1. From the CommCell Browser, navigate to Client Computers | <Client> |  MySQL | <Master> <Instance>.
  2. Right-click the <subclient> and then click Backup.

  3. Select Do Not Truncate Log on Proxy.

  4. Click OK.

Deletion of Logs on Proxy and Source for Various Backup Options

The following table displays the deletion of logs for various backup options:

S.No. Options Deletion type
1. When backups are running on proxy:  
a.  Do not truncate logs on proxy is selected. Logs will not be deleted on proxy server after the backup.
b.  Truncate logs on source is selected. Logs will be truncated at the master server till one log number less than which has been replicated / read by the proxy.
c.  When none of the options are selected in backup dialog box. Logs are deleted on proxy server after the backup.
 
2. When backups are running on master (due to failover/ configuration):  
a.  When none of the options are selected in backup dialog box. Logs will not be deleted on master server.
b.  When Do not truncate logs on Proxy is selected. This option is not applicable to master jobs.
c.  When Truncate logs on source is selected. Logs will be truncated at the master server till one log number less than which has been replicated / read by the proxy.