Help us improve your experience.

Let us know what you think.

Do you have time for a two-minute survey?

 

Resetting MySQL Replication

 

From Junos Space Network Management Platform Release 17.2R1 onward, you can reset MySQL replication in runtime. In releases before Junos Space Platform Release 17.2R1, the resetting of MySQL replication is done by backing up and restoring the Junos Space Platform database, which involves backing up the of MySQL database. You can now reset MySQL replication from the Reset MySQL Replication page under the Administration workspace in Junos Space Platform.

Resetting the replication of the MySQL database enables continuous and uninterrupted data replication between the VIP and non-VIP MySQL nodes. This uninterrupted data replication ensures that there is no loss of data or network downtime.

You are alerted on the break in MySQL replication through e-mail notification, an SNMP trap, the MySQL in out of sync state parameter in the System Health Report, or the Database column on the Administration > Fabric page.

To reset MySQL replication in Junos Space Network Management Platform, a user must be a Super Administrator or a System Administrator.

To reset the replication of the MySQL database:

  1. On the Junos Space Network Management Platform UI, select Administration > Fabric.

    The Fabric page is displayed.

  2. Click the Reset MySQL Replication button.

    The Reset MySQL Replication page is displayed.

  3. To reset the database replication, click the Reset MySQL Replication button.

    The Reset MySQL Replication dialog box appears, displaying the job ID corresponding to the reset action.

    1. Click the job ID to view the details of the job.

      You are redirected to the Job Management page with a filtered view of the job corresponding to the reset action.

      Double-click the row corresponding to the job to view details of the job. The View Job Details page displays the details of the job.

    2. Click OK to close the page and return to Reset MySQL Replication page.

Failure of the reset job indicates that the database nodes are still not synchronized. You can retry the procedure to reset the replication.

Note

Resetting the MySQL replication resets only the replication between database nodes on the active site. If you have configured disaster recovery, we recommend that you back up and restore MySQL database nodes on the standby site as well. To back up and restore MySQL nodes on the standby site, stop and restart the disaster recovery process on Junos Space Network Management Platform.

To stop the backup process at the active site:

  1. Log in to the CLI of the Junos Space node at the active site on which the VIP or the eth0:0 interface is configured.

    The Junos Space Settings Menu is displayed.

  2. Enter 6 (if you are using a hardware appliance) or 7 (if you are using a virtual appliance) at the Junos Space Settings Menu prompt to run shell commands.

    You are prompted to enter the administrator password.

  3. Enter the administrator password.
  4. Type jmp-dr stop at the shell prompt and press Enter.

    The disaster recovery process on both sites is stopped.

  5. To restart the disaster recovery process on both sites, type jmp-dr start and press Enter.

    The disaster recovery process is restarted on both sites.

The MySQL nodes at the standby site are backed up and restored.