I have existing customer running MySQL on our FAS system I’d like to confirm what kind of information are required if SnapCreator can backup and restore MySQL database.
From my old knowledge, MySQL cannot hot-backup databases but things have changed. If anyone can advice us what we need to ask customer prior to propose SnapCreator it would be very helpful. They installed MySQL in 2005 that their MySQL version could be old.
Also we haven’t confirmed what kind of storage engine they are using.
SnapCreator works great with MySQL. This is what we do:
connect to DB
flush tables with read lock
The only thing MySQL offers is read-only mode but because SnapCreator / NetApp snapshots are so fast the DB will only be in read-only mode for a second. In the event of an error regardless what, SnapCreator will do an "unlock tables" to make sure the DB is at worst returned to read/write mode asap and automatically.
Also we connect to DB over TCP so we can backup MySQL remotely without our Agent.
Restore is a manual process. SnapCreator can restore data ie: snap restore or snapvault restore but does not do anything with the DB whihc is why we say restore is manual.
I see. I understood that SnapCreator will lock the table, not the DB, that if there are thousands of tables exist in one database, it may cause the lag to lock all tables. In that perspective, what could be the practical or actually experienced number of tables exsits in a database for using SnapCreator?
Yes, we onced thought to integrate with Zmanda, however they are quite small company far out from Tokyo area and our resellers do not have relationship with them that we've decided it could be troublesome to work with them.
For the snapcreator we need to consider the following
1. The storage engine is doesn't matter any storage engine OK, Because SC internally using "snap" API
2. For the database level backup keep each database in separate volume
3. For consistent backup, During backup particular database will be in readonly mode for a while.
4. Still the MySQL not have the Hot backup with the current release, but it's in the plan to release later.
5. If the MySQL database installed in 2005, it might be 3.x.x, which can be backup using mysqldump, readonly way.
keith: It will be great to do the multiple database backup at a time, if they are in different volume and different storage controller. This feature will help the MySQL Customer to take all the MySQL databases at time and can restore each one separately without depend on other database files.