Which factor will have the LEAST impact on the success of ZDP?
Binary logging is enabled, or binary log replication is in progress.
Current SSL connections are open to the database.
Temporary tables or table locks are in use.
The value of the lower_case_table_names server parameter was set to 0 when the tables were created.
Explanations:
Binary logging or replication could be impacted during ZDP as it may require a restart, which could affect replication consistency during patching.
Open SSL connections may be impacted during patching as connections might be dropped or reset during the ZDP process.
Temporary tables or table locks could affect ZDP as their presence may require additional handling or could block changes during patching.
Thelower_case_table_namessetting is less likely to be impacted by ZDP, as this is primarily relevant to the filesystem and table naming, which doesn’t affect ZDP operations.
I arrange that the answer is:
The value of the lower_case_table_names server parameter was set to 0 when the tables were created.
If I’m correct, the answer is:
The value of the lower_case_table_names server parameter was set to 0 when the tables were created.