search

delphix / mysqllinux

MySQLVirtualization Plugin for Delphix
Apache License 2.0
1 stars 9 forks source link

"07/14/2021: mysqldump directory option" #7

Open ranjeeth12 opened 3 years ago

ranjeeth12 commented 3 years ago

Is your feature request related to a problem? Please describe. [Ranjeeth] Yes. When we choose Delphix to take mysqldump from source the dump is by default routed to /tmp folder. Customer installation is such that they have OS level restriction for tmp folder and due to which mysqldump is failing after the limit is reached.

Describe the solution you'd like [Ranjeeth] Provide an option to customer to chose the dump directory; Otherwise, utilize mount directory for dump and pass on the instructions to increase mount size so that it includes dump size.

Describe alternatives you've considered [Ranjeeth] Customer added disk space and performed directory level mapping from tmp to another folder. This is a manual workaround and took significant time.

Additional context

smouhssine commented 2 years ago

A more consistent option would be using a hidden folder (eg: ./tmp) under the staging mount_point to host the backup and remove it once we restore successfully

arunskurian commented 2 years ago

@smouhssine - that's a great idea. I think we can pursue that option. However, do you think this will slow down the backup process because now the backup file has to be written to Delphix Storage ( NFS + Network delays)