2017-12-19 06:53 AM
A potential customer are interested in using snapcenter to backup and clone their mssql databases.
They run Percona(MySQL) Galera Clusters with up to five nodes.
All the clusters runs on vmware and RH7.
The developers want to be able to clone all databases to an test environment.
They would like to take a snapshot backup of all databases so that they restore them all to the exact same point in time so that they are all in sync.
Would that be possible to handle via snapcenter?
Which method do the mysql plugin use to put a database in a consistent state when a snapshot is taken? What is the impact on the database? Freezes for a few seconds?
Does the plugin handle log_only backups?
2017-12-20 03:56 AM
there is no "Native" SnapCenter plugin to backup Precona(MySql)
Starting with version 2.0, NetApp SnapCenter introduces the capability to create your own SnapCenter plug-in for any application or database and manage it under the same single-pane of glass with other SnapCenter supported applications like Oracle Database and Microsoft SQL Server
With this in mind, the way on how SC will take snapshot is based on what the DB allows you to do..
8 hours ago
SnapCenter has a custom MySQL Plug-in which uses the "Flush tables with read lock" to put all the databases in the mysql instance to a read-only mode.
During this period, the create/update operations are frozen, the read operations continue to work.
To the mentioned usecase, consistency at each individual host databases is possible.