MySQL Scaleout Database Backup using SAN Storage Based Replication (Innodb Engine)

[Sanjoy Dasgupta]

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.