NetApp Community Update
This site will enter Read Only mode on July 23 as we prepare to move to a new platform. You will still be able to view content, but posting and replying will be temporarily disabled.
We're excited to launch our new Community experience on July 30 and more information will follow soon.
Stay connected during the transition - Join our Discord community today.

Data Protection

SnapCreator MySQL plug-in does not support backup and restore operations for multiple databases?

jiayih
2,755 Views

Questions about the statement in "Snap Creator Framework 4.3 Administration Guide" page 77, as the subject.

https://library.netapp.com/ecmdocs/ECMLP2397466/html/GUID-7A61B00D-76CE-4114-A46D-FF877EB4834E.html

 

1. Does this mean that it can only backup and restore MySQL server with a single database? 

2. Why can we input "A list of MySQL database(s) and the username/password" for parameter "MYSQL_DATABASES" then? 

3. What are the requirements of privileges or user rights for the database user?

 

4. There is an SnapCreator implementation that the customer wish to backup MySQL enterprise server 5.6.3 on Linux Centos 6.5, with multiple databases reside on a single NetApp data and log iSCSI LUNs. Is this possible?

- MySQL enterprise server 5.6.3 on Linux Centos 6.5 (slave)

- Data ONTAP 8.3.1 Clustered-mode

- one iSCSI LUN for Data (2.3TB)

- one iSCSI LUN for Log (1.1TB)

- 32 databases (including system database)

- SnapCreator Server on Windows 2012 DCE

- nightly backup

 

5. There is a BUG 604517 that seems to related to this. Will it be fixed?

 

 

Thanks.

 

0 REPLIES 0
Public