Delphix Products

Expand all | Collapse all

mysql dsource using xtrabackup

Jump to Best Answer
  • 1.  mysql dsource using xtrabackup

    Posted 03-28-2017 02:23:00 PM
    Delphix Experts.... This question is related to mysql dsourcing. We were able to successfully create dsource to mysql database using "mysqldump" dumptype but not with "xtrabackup". Anyone successful earlier using xtrabackup option. Our DBAs are concerned about not using xtrabackup as this db has lot of write transactions. Does delphix support Xtrabackup?
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1574309/RackMultipart20170328-129901-1t8af7z-mysql_dsource_inline.png?1490714555">


  • 2.  RE: mysql dsource using xtrabackup
    Best Answer

    Posted 03-28-2017 05:50:00 PM
    Yes, Delphix supports Xtrabackup. You'll have to manually dump the dbs using Xtrabackup and provide Delphix with the path of the backup directory.


  • 3.  RE: mysql dsource using xtrabackup

    Posted 03-28-2017 06:43:00 PM
    Thank you. We tried earlier in 5.0.2.3 version and it failed. Looks like we have to upgrade our version. From which delphix version this feature is enabled? Any idea


  • 4.  RE: mysql dsource using xtrabackup

    Posted 03-28-2017 10:02:00 PM
    Just want to make sure there's no confusion here. Basically, Delphix supports Xtrabackup for MySQL 5.5 and 5.6 on both Community and Enterprise versions. However, if you're running on MySQL 5.7, the version Delphix supports Xtrabackup is 5.1.5.1.