MySQL Snapshots

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi everybody,I'm studying mysql virtualization. I understood why delphix needs staging mysql instance. However I'm wondering if it is strictly necessary take a new backup from physical instance when snapshot of the dSource is requested. Is it not enough taking a snapshot of the virtual datafile of the staging instance? Is it not enough the mysql replication process to guarantee the synchronization with the physical source?
Thanks
Best Regards. 
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 1,220 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Ankur Sarin

Ankur Sarin, Employee

  • 460 Points 250 badge 2x thumb
Official Response
Hi,

The backup is only used to initialize the staging server which is setup as a slave of the production MySQL Server. The staging server stays up to date with production using MySQL replication.
Once the staging server is initialized, you can setup a SYNC policy, to generate subsequent snapshots, based on a schedule, which uses the staging server. No other backups are required, unless the staging server runs into errors or is not able to keep up with the production MySQL Server

I hope this helps, do let us know if you have more questions.