MySQL Forums
Forum List  »  Backup

MySQL Scaleout Database Backup using SAN Storage Based Replication (Innodb Engine)
Posted by: Sanjoy Dasgupta
Date: April 10, 2013 05:54AM

Hi!

I plan to setup a MySQL Scale-out Multi-Node MySQL Database (using Galera - Multi-Master Replication);

Database for each node will use disks from a Common SAN Storage that supports storage based replication - Example EMC SRDF or 3PAR Virtual COPY, Hitachi Shadowimage.

I want to backup the databases using these "Storage based replication".

For a Point-in-Time consistent Replication of Production Disk volumes to Backup Disk volumes. If I am using Following Engines, how do I put database into a "Read-only" mode for the period the Storage replication is on-going ?

1. Innodb
2. MyISAM
3. NDB

Thanks in advance for any advice.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Scaleout Database Backup using SAN Storage Based Replication (Innodb Engine)
3303
April 10, 2013 05:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.