Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

MySql Replication with VVR

Created: 11 Jul 2013 • Updated: 30 Jul 2013 | 2 comments
savas_irez's picture
This issue has been solved. See solution.

Hi,

A potential customer wishes to know if Mysql database replication is possible with Veritas Volume Replicator. The data is not too big (less than 50GB), but it's very critical.

As I'm not sure about how mysql can be kept consistent during an async (or sync) replication, is it possible?

Thanks.

Operating Systems:
Discussion Filed Under:

Comments 2 CommentsJump to latest comment

Wally_Heim's picture

Hi Savas_irez,

VVR replicates at the volume level and maintains write order fidelity.  This is needed for any database application to maintain consistency.  VVR has been used for Oracle, SQL and MySQL with many customers without issues.

The only issue that I've come across when replicating databases is that the drive containing the database files and the drive containing the log files need to be in the same Replication Data Set (RDS.)  When they are not in the same RDS they can be out of sync with each other during a takeover operation when replication is behind.  This can cause the database to fail to start after a takeover.

Thank you,

Wally

savas_irez's picture

I think that should be enough for me, thank you very much :)