MySQL Forums
Forum List  »  Backup

Re: MySQL Scaleout Database Backup using SAN Storage Based Replication (Innodb Engine)
Posted by: Rick James
Date: April 11, 2013 08:17AM

> Database for each node will use disks from a Common SAN Storage

That is, you are willing to have the SAN as a single-point-of-failure?

If you have a _Slave_ (not another Master in a Galera setup), you can stop mysqld on the Slave, capture the disk (or the tree where mysql is). This will provide a point-in-time snapshot of the entire data. I am not familiar with what it would take to rebuild Galera from such a dump, but all the data would be there.

> 1. Innodb 2. MyISAM 3. NDB

Are you hoping to use all 3 in the same system?
InnoDB and MyISAM can coexist on a single Galera-based (or non-Galara) system. What I described above works for such.

NDB Cluster is a different animal. It does its own 'clustering' and 'scaleout', and is probably totally incompatible with Galera. (I could be wrong.)

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL Scaleout Database Backup using SAN Storage Based Replication (Innodb Engine)
1426
April 11, 2013 08:17AM


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.