Community maintenance is complete. Thank you for your patience!

Data Backup and Recovery

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

jiayih

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
Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public