Embedded Files
Pre-Requsites
Pre-Requsites
Upgrade MySQL Router...
Upgrade MySQL Shell...
dnf update percona-mysql-shell
Check
Check
util.checkForServerUpgrade("root@localhost:3306", {"targetVersion":"8.4"})
The MySQL server at localhost:3306, version 8.0.42-33 - Percona Server (GPL),Release 33, Revision 9dc49998, will now be checked for compatibility issues forupgrade to MySQL 8.4.8.
1) Removed system variables (removedSysVars) No issues found
2) System variables with new default values (sysVarsNewDefaults) Warning: Following system variables that are not defined in your configuration file will have new default values. Please review if you rely on their current values and if so define them before performing upgrade.
binlog_transaction_dependency_tracking - default value will change from COMMIT_ORDER to WRITESET. group_replication_consistency - default value will change from EVENTUAL to BEFORE_ON_PRIMARY_FAILOVER. group_replication_exit_state_action - default value will change from READ_ONLY to OFFLINE_MODE. innodb_adaptive_hash_index - default value will change from ON to OFF. innodb_buffer_pool_in_core_file - default value will change from ON to OFF. innodb_buffer_pool_instances - default value will change from 8 (or 1 if innodb_buffer_pool_size < 1GB) to MAX(1, #vcpu/4). innodb_change_buffering - default value will change from all to none. innodb_doublewrite_files - default value will change from innodb_buffer_pool_instances * 2 to 2. innodb_doublewrite_pages - default value will change from innodb_write_io_threads to 128. innodb_flush_method - default value will change from fsynch (unix) or unbuffered (windows) to O_DIRECT. innodb_io_capacity - default value will change from 200 to 10000. innodb_io_capacity_max - default value will change from 200 to 2 x innodb_io_capacity. innodb_log_buffer_size - default value will change from 16777216 (16MB) to 67108864 (64MB). innodb_log_writer_threads - default value will change from ON to OFF ( if #vcpu <= 32 ). innodb_numa_interleave - default value will change from OFF to ON. innodb_page_cleaners - default value will change from 4 to innodb_buffer_pool_instances. innodb_parallel_read_threads - default value will change from 4 to MAX(#vcpu/8, 4). innodb_purge_threads - default value will change from 4 to 1 ( if #vcpu <= 16 ). innodb_read_io_threads - default value will change from 4 to MAX(#vcpu/2, 4). innodb_redo_log_capacity - default value will change from 104857600 (100MB) to MIN ( #vcpu/2, 16 )GB.
More information: https://dev.mysql.com/blog-archive/new-defaults-in-mysql-8-0/
3) Issues reported by 'check table x for upgrade' command (checkTableCommand) No issues found
4) Checks for foreign keys not referencing a full unique index(foreignKeyReferences) No issues found
5) Check for deprecated or invalid user authentication methods.(authMethodUsage) No issues found
6) Check for deprecated or removed plugin usage. (pluginUsage) No issues found
7) Check for deprecated or invalid default authentication methods in systemvariables. (deprecatedDefaultAuth) No issues found
8) Check for deprecated or invalid authentication methods in use by MySQLRouter internal accounts. (deprecatedRouterAuthMethod) No issues found
9) Checks for errors in column definitions (columnDefinition) No issues found
10) Check for allowed values in System Variables. (sysvarAllowedValues) No issues found
11) Checks for user privileges that will be removed (invalidPrivileges) Verifies for users containing grants to be removed as part of the upgrade process.
Notice: The following users have the SET_USER_ID privilege which will be removed as part of the upgrade process: - 'root'@'localhost'
Solution: - If the privileges are not being used, no action is required, otherwise, ensure they stop being used before the upgrade as they will be lost.
12) Checks for partitions by key using columns with prefix key indexes(partitionsWithPrefixKeys) No issues foundErrors: 0Warnings: 20Notices: 1
NOTE: No fatal errors were found that would prevent an upgrade, but some potential issues were detected. Please ensure that the reported issues are not significant before upgrading.
1) Removed system variables (removedSysVars) No issues found
2) System variables with new default values (sysVarsNewDefaults) Warning: Following system variables that are not defined in your configuration file will have new default values. Please review if you rely on their current values and if so define them before performing upgrade.
binlog_transaction_dependency_tracking - default value will change from COMMIT_ORDER to WRITESET. group_replication_consistency - default value will change from EVENTUAL to BEFORE_ON_PRIMARY_FAILOVER. group_replication_exit_state_action - default value will change from READ_ONLY to OFFLINE_MODE. innodb_adaptive_hash_index - default value will change from ON to OFF. innodb_buffer_pool_in_core_file - default value will change from ON to OFF. innodb_buffer_pool_instances - default value will change from 8 (or 1 if innodb_buffer_pool_size < 1GB) to MAX(1, #vcpu/4). innodb_change_buffering - default value will change from all to none. innodb_doublewrite_files - default value will change from innodb_buffer_pool_instances * 2 to 2. innodb_doublewrite_pages - default value will change from innodb_write_io_threads to 128. innodb_flush_method - default value will change from fsynch (unix) or unbuffered (windows) to O_DIRECT. innodb_io_capacity - default value will change from 200 to 10000. innodb_io_capacity_max - default value will change from 200 to 2 x innodb_io_capacity. innodb_log_buffer_size - default value will change from 16777216 (16MB) to 67108864 (64MB). innodb_log_writer_threads - default value will change from ON to OFF ( if #vcpu <= 32 ). innodb_numa_interleave - default value will change from OFF to ON. innodb_page_cleaners - default value will change from 4 to innodb_buffer_pool_instances. innodb_parallel_read_threads - default value will change from 4 to MAX(#vcpu/8, 4). innodb_purge_threads - default value will change from 4 to 1 ( if #vcpu <= 16 ). innodb_read_io_threads - default value will change from 4 to MAX(#vcpu/2, 4). innodb_redo_log_capacity - default value will change from 104857600 (100MB) to MIN ( #vcpu/2, 16 )GB.
More information: https://dev.mysql.com/blog-archive/new-defaults-in-mysql-8-0/
3) Issues reported by 'check table x for upgrade' command (checkTableCommand) No issues found
4) Checks for foreign keys not referencing a full unique index(foreignKeyReferences) No issues found
5) Check for deprecated or invalid user authentication methods.(authMethodUsage) No issues found
6) Check for deprecated or removed plugin usage. (pluginUsage) No issues found
7) Check for deprecated or invalid default authentication methods in systemvariables. (deprecatedDefaultAuth) No issues found
8) Check for deprecated or invalid authentication methods in use by MySQLRouter internal accounts. (deprecatedRouterAuthMethod) No issues found
9) Checks for errors in column definitions (columnDefinition) No issues found
10) Check for allowed values in System Variables. (sysvarAllowedValues) No issues found
11) Checks for user privileges that will be removed (invalidPrivileges) Verifies for users containing grants to be removed as part of the upgrade process.
Notice: The following users have the SET_USER_ID privilege which will be removed as part of the upgrade process: - 'root'@'localhost'
Solution: - If the privileges are not being used, no action is required, otherwise, ensure they stop being used before the upgrade as they will be lost.
12) Checks for partitions by key using columns with prefix key indexes(partitionsWithPrefixKeys) No issues foundErrors: 0Warnings: 20Notices: 1
NOTE: No fatal errors were found that would prevent an upgrade, but some potential issues were detected. Please ensure that the reported issues are not significant before upgrading.
Page updated
Google Sites
Report abuse