High Availability for the SnapCenter MySQL Repository

MySQL replication is a feature of MySQL Server that enables you to replicate data from one MySQL database server ("master") to another MySQL database server ("slave"). SnapCenter supports MySQL replication for high availability only on two Network Load Balancing-enabled (NLB-enabled) nodes.

SnapCenter performs read or write operations on the master repository and routes its connection to the slave repository when there is a failure on the master repository. The slave repository then becomes the master repository. SnapCenter also supports reverse replication, which is enabled only during failover.

If you want to use the MySQL high availability (HA) feature, you must enable Application Request Routing (ARR) while installing SnapCenter and configure Network Load Balancing (NLB) on the first node. The MySQL repository is installed on this node as part of the installation. While installing SnapCenter on the second node, you must join to the NLB of the first node and create a copy of the MySQL repository on the second node.

SnapCenter provides the Get-SmRepositoryConfig and Set-SmRepositoryConfig PowerShell cmdlets to manage MySQL replication.

You must be aware of the limitations related to the MySQL HA feature: