Unsolved
This post is more than 5 years old
5 Practitioner
•
274.2K Posts
0
4540
RecoverPoint and SQL
- Is Recoverpoint/SE supported for MySQL (with Apache)?
- When Recoverpoint/SE (CRR) is used to provide Consistent replicas on the Remote site, with SQL (under use of Microsoft VDI),
or also in Oracle setup.
Is there a need to propose Replication Manager in combination or not?
In other words… in an MS/SQL solution, is Recoverpoint/SE (CRR) able To handle the process under Microsoft VDI mode without need Replication Manager ?
When I read the white paper for SQL here attached, I see on page 16 that RecoverPoint CRR can leverage Microsoft VDI …
forshr
1.1K Posts
0
March 31st, 2011 12:00
RecoverPoint is application agnostic, however if you asking whether kutils sqlsnap/sqlrestore (which uses vdi) is supported with MySQL, the supported SQL database versions with kutils are SQL 2005 and 2008. As for whether it can handle it, the answer is yes and that's what the kutils are provided.
Replication Manager uses its own set of application integration utilities, one of which is vdi.
forshr
1.1K Posts
0
April 1st, 2011 03:00
SQL is supported, not MySQL.
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
April 1st, 2011 03:00
So for my understanding, RecoverPoint/SE is supported on MySQL to take application consistent bookmarks with the help of the kutils?
Thanks for your answer!
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
April 1st, 2011 04:00
MySQL is not supported at all with RP? Or just not the integration with the kutils?
forshr
1.1K Posts
0
April 1st, 2011 05:00
Not with kutils.
Gary_Archer
45 Posts
0
April 1st, 2011 08:00
Richard is accurate in thatRecoverPoint does not have MySQL agents that perform the freeze/thaw using vendor supplied API's. For example for Microsoft Exchange we use Microsoft's VSS API, for SQL Server we use their VDI API. But we don't use an API for MySQL. What we do is that we replicate MySQL as crash-consistent. If you want application consistent then you must use a CLI to freeze MySQL (such as issuing the SQL command 'ALTER DATABASE BEGIN BACKUP'), you cthen issue RecoverPoint commands that bookmark that specific image as an application consistent image for MySQL and then 'thaw' MySQL. At a later point you can roll-back to that bookmark and restart MySQL from this application-consistent point in time.
In general when the question comes up: does RP support application x? The answer is YES as long as we support the underlying OS, Clustering, multi-pathing, and by support I mean that it is on the EMC support matrix.
Gary
RickBrunner1
117 Posts
0
April 1st, 2011 20:00
Confirming Gary's statement .. MySQL can be replicated with RP. As Gary pointed out there is no kutils integration, this is limited to MS SQL. Other database such as Oracle, mySQL, DB2, etc.. must utilize native mechanisms for placing the DB in a quieted state, and then free it up again.
forshr
1.1K Posts
0
April 2nd, 2011 02:00
To reiterate my previous message please ensure the underlying OS, Cluster, Multi-pathing etc is on the EMC Support Matrix.
RickWalsworth
20 Posts
0
April 2nd, 2011 17:00
One clarification, while Richard is correct that the OS, Multi-pathing and infrastructure must all be on the ESM, the database (in this case mySQL) may not be, but is still considered supported.
See Rick Brunner and Gary's note pasted below..
.. MySQL can be replicated with RP. As Gary pointed out there is no kutils integration, this is limited to MS SQL. Other database such as Oracle, mySQL, DB2, etc.. must utilize native mechanisms for placing the DB in a quieted state, and then free it up againConfirming Gary's statement .. MySQL can be replicated with RP. As Gary pointed out there is no kutils integration, this is limited to MS SQL. Other database such as Oracle, mySQL, DB2, etc.. must utilize native mechanisms for placing the DB in a quieted state, and then free it up again.
Regards,
Rick Walsworth
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
April 4th, 2011 02:00
Ok! This really makes sense!
Thanks a lot guys!