include additional flags for mysqldump action

Bug #2039482 reported by Adam Vest
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL InnoDB Cluster Charm
New
Undecided
Unassigned

Bug Description

Hello,

This is a feature request for the "mysqldump" charm action. Right now, it only includes the following flags by default:

 --triggers --routines --events

It's typically suggested to dump innodb databases with the "--single-transaction" flag[1], and those docs also suggest the "--quick" flag[2] as well (for large tables, anyway). To reduce impact, it might also be useful to include "--no-lock-tables"[3].

Just opening this report to start discussion around possibly including these as defaults, or maybe adding them as optional params to the action?

Thanks!

[1] https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_single-transaction
[2] https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_quick
[3] https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html#option_mysqldump_lock-tables

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.