Microsoft Virtualization Discussions

SnapCenter 4.0 MySQL Plugin

Mannes
3,750 Views

Hello All Together,

 

i have a little Question about the mysql Plugin for SnapCenter 4.

I added in  the Custom Configurations Page on the Application settings the following three Settings for a test Database.

 

Name Value

HOS=Database.test.local

PORT=3306

MASTER_SLAVE=No

 

The Plugin runs fine and quiesces the Database and takes the snapshot without an consistency check.

 

Is it possible to set a setting for a Database Consistency check like an dbcc on MSSQL?

 

like

mysqlcheck=--check

 

 

I have seen in the mysql online Doku anything about checks but i´m not sure about the settings here in the plugin.

 

https://dev.mysql.com/doc/refman/8.0/en/mysqlcheck.html

 

 

 

thank you in advance for your reply

 

Jürgen Mannes

 

1 REPLY 1

amarnatr
3,630 Views

Hello,

 

 

In the Protect wizard, in the Application settings step, Under the scripts section,  

 

provide the "Mysqlcheck" command in the PRE QUIESCE command.  This command will be executed before the MySQL plugin puts the database to read only mode for taking app consistent snapshot.

 

 

Thanks,

Amar 

Public