When the consistent option is set to true for MySQL Shell's instance dump utility
util.dumpInstance()
, schema dump utilityutil.dumpSchemas()
, and table dump utilityutil.dumpTables()
, the utility locks the tables for backup during the dump. If the user ID used to run the utility has theRELOAD
privilege, the utility uses aFLUSH TABLES WITH READ LOCK
statement to set a global read lock. If the user ID does not have that privilege but does have theLOCK TABLES
privilege, the utility issues a series ofLOCK TABLES
statements. Previously, the utility would issue these statements in the same session, causing previously locked tables to be unlocked. The utility now locks the system tables in the main thread’s session, and creates additional sessions to lock the other tables that are being dumped. (Bug #32788788)MySQL Database Service validates that all user accounts have passwords, but MySQL Shell's instance dump utility
util.dumpInstance
did not previously check this when theocimds
option was specified, resulting in errors when loading the dump files. The utility now includes this in the compatibility checks and returns an error if a user account does not have a password set, except where the user account is identified as a role. Theskip_invalid_accounts
modification, which can be applied using thecompatibility
option, now also removes user accounts that do not have passwords set. In the case of a user account that is identified as a role, the utility dumps the account using theCREATE ROLE
statement. (Bug #32741098)In some situations, MySQL Shell's dump loading utility
util.loadDump()
did not delete the progress state file when theresetProgress
option was specified. (Bug #32734880)When MySQL Shell's dump loading utility
util.loadDump()
was used to apply a dump that was still in the process of being created (with thewaitDumpTimeout
option), and pre-authenticated requests were used for the dump, an authorization error could be returned when fetching the.idx
file for a table. The utility’s behavior when handling the manifest has now been refactored to create the correct handle to the.idx
files and use the correct pre-authenticated request URL. (Bug #32734817)