Upgrading MySQL to 5.7 or MariaDB to 10.2 - Revision history

Vlasis: Vlasis moved page Upgrading MySQL to 4.7 or MariaDB to 10.2 to Upgrading MySQL to 5.7 or MariaDB to 10.2: Corrected title

2023-05-29T23:35:36Z

Vlasis moved page Upgrading MySQL to 4.7 or MariaDB to 10.2 to Upgrading MySQL to 5.7 or MariaDB to 10.2: Corrected title

← Older revision	Revision as of 23:35, 29 May 2023
(No difference)

Ducto at 17:12, 29 May 2023

2023-05-29T17:12:45Z

← Older revision		Revision as of 17:12, 29 May 2023
Line 19:		Line 19:
	</pre>		</pre>

	<~~code~~>		<pre>
	USE mysql;		USE mysql;
	CREATE TABLE `innodb_table_stats` (		CREATE TABLE `innodb_table_stats` (
Line 30:		Line 30:
	PRIMARY KEY (`database_name`,`table_name`)		PRIMARY KEY (`database_name`,`table_name`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;		) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
	</~~code~~>		</pre>

	<~~code~~>		<pre>
	USE mysql;		USE mysql;
	CREATE TABLE `slave_master_info` (		CREATE TABLE `slave_master_info` (
Line 60:		Line 60:
	PRIMARY KEY (`Host`,`Port`)		PRIMARY KEY (`Host`,`Port`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';		) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';
	</~~code~~>		</pre>

	<~~code~~>		<pre>
	USE mysql;		USE mysql;
	CREATE TABLE `slave_relay_log_info` (		CREATE TABLE `slave_relay_log_info` (
Line 75:		Line 75:
	PRIMARY KEY (`Id`)		PRIMARY KEY (`Id`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information';		) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information';
	</~~code~~>		</pre>

	<~~code~~>		<pre>
	USE mysql;		USE mysql;
	CREATE TABLE `slave_worker_info` (		CREATE TABLE `slave_worker_info` (
Line 94:		Line 94:
	PRIMARY KEY (`Id`)		PRIMARY KEY (`Id`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';		) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';
	</~~code~~>		</pre>

	* Restart the service, check and make sure that there is no error in database service after restarted.		* Restart the service, check and make sure that there is no error in database service after restarted.

Ducto at 17:12, 29 May 2023

2023-05-29T17:12:20Z

← Older revision		Revision as of 17:12, 29 May 2023
Line 4:		Line 4:
	If one or some of the above tables are missing, create them manually using the below queries:		If one or some of the above tables are missing, create them manually using the below queries:

	<~~code~~>		<pre>
	USE mysql;		USE mysql;
	CREATE TABLE `innodb_index_stats` (		CREATE TABLE `innodb_index_stats` (
Line 17:		Line 17:
	PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)		PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;		) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
	</~~code~~>		</pre>

	<code>		<code>

Ducto at 17:10, 29 May 2023

2023-05-29T17:10:18Z

Ducto at 17:08, 29 May 2023

2023-05-29T17:08:25Z

Ducto at 17:07, 29 May 2023

2023-05-29T17:07:53Z

← Older revision		Revision as of 17:07, 29 May 2023
Line 95:		Line 95:
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';		) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';
	</code>		</code>

			* Restart the service, check and make sure that there is no error in database service after restarted.

Ducto at 17:07, 29 May 2023

2023-05-29T17:07:04Z

@@ Line 1: / Line 1: @@
 * Make sure that 'mysql_upgrade' command is run
 * Check if the following tables are created: innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info, slave_worker_info
-  If one or some of the above tables are missing, create them manually using the below queries:
+If one or some of the above tables are missing, create them manually using the below queries:

Ducto: Created page with "* Make sure that 'mysql_upgrade' command is run * Check if the following tables are created: innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info, s..."

2023-05-29T17:02:39Z

Created page with "* Make sure that 'mysql_upgrade' command is run * Check if the following tables are created: innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info, s..."

New page

* Make sure that 'mysql_upgrade' command is run
* Check if the following tables are created: innodb_index_stats, innodb_table_stats, slave_master_info, slave_relay_log_info, slave_worker_info
If one or some of the above tables are missing, create them manually using the below queries:

← Older revision		Revision as of 17:10, 29 May 2023
Line 22:		Line 22:
	USE mysql;		USE mysql;
	CREATE TABLE `innodb_table_stats` (		CREATE TABLE `innodb_table_stats` (
	`database_name` varchar(64) COLLATE utf8_bin NOT NULL,		`database_name` varchar(64) COLLATE utf8_bin NOT NULL,
	`table_name` varchar(64) COLLATE utf8_bin NOT NULL,		`table_name` varchar(64) COLLATE utf8_bin NOT NULL,
	`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,		`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	`n_rows` bigint(20) unsigned NOT NULL,		`n_rows` bigint(20) unsigned NOT NULL,
	`clustered_index_size` bigint(20) unsigned NOT NULL,		`clustered_index_size` bigint(20) unsigned NOT NULL,
	`sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,		`sum_of_other_index_sizes` bigint(20) unsigned NOT NULL,
	PRIMARY KEY (`database_name`,`table_name`)		PRIMARY KEY (`database_name`,`table_name`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;		) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
	</code>		</code>
Line 35:		Line 35:
	USE mysql;		USE mysql;
	CREATE TABLE `slave_master_info` (		CREATE TABLE `slave_master_info` (
	`Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file.',		`Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file.',
	`Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',		`Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
	`Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last read event.',		`Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last read event.',
	`Host` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'The host name of the master.',		`Host` char(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '' COMMENT 'The host name of the master.',
	`User_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',		`User_name` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The user name used to connect to the master.',
	`User_password` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',		`User_password` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The password used to connect to the master.',
	`Port` int(10) unsigned NOT NULL COMMENT 'The network port used to connect to the master.',		`Port` int(10) unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
	`Connect_retry` int(10) unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',		`Connect_retry` int(10) unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
	`Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',		`Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
	`Ssl_ca` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',		`Ssl_ca` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
	`Ssl_capath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',		`Ssl_capath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
	`Ssl_cert` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',		`Ssl_cert` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL certificate file.',
	`Ssl_cipher` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',		`Ssl_cipher` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the cipher in use for the SSL connection.',
	`Ssl_key` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',		`Ssl_key` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The name of the SSL key file.',
	`Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',		`Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
	`Heartbeat` float NOT NULL,		`Heartbeat` float NOT NULL,
	`Bind` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',		`Bind` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
	`Ignored_server_ids` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',		`Ignored_server_ids` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
	`Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',		`Uuid` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The master server uuid.',
	`Retry_count` bigint(20) unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',		`Retry_count` bigint(20) unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
	`Ssl_crl` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',		`Ssl_crl` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
	`Ssl_crlpath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',		`Ssl_crlpath` text CHARACTER SET utf8 COLLATE utf8_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
	`Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',		`Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
	PRIMARY KEY (`Host`,`Port`)		PRIMARY KEY (`Host`,`Port`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';		) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Master Information';
	</code>		</code>
Line 65:		Line 65:
	USE mysql;		USE mysql;
	CREATE TABLE `slave_relay_log_info` (		CREATE TABLE `slave_relay_log_info` (
	`Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',		`Number_of_lines` int(10) unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
	`Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the current relay log file.',		`Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the current relay log file.',
	`Relay_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The relay log position of the last executed event.',		`Relay_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The relay log position of the last executed event.',
	`Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',		`Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
	`Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last executed event.',		`Master_log_pos` bigint(20) unsigned NOT NULL COMMENT 'The master log position of the last executed event.',
	`Sql_delay` int(11) NOT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',		`Sql_delay` int(11) NOT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
	`Number_of_workers` int(10) unsigned NOT NULL,		`Number_of_workers` int(10) unsigned NOT NULL,
	`Id` int(10) unsigned NOT NULL COMMENT 'Internal Id that uniquely identifies this record.',		`Id` int(10) unsigned NOT NULL COMMENT 'Internal Id that uniquely identifies this record.',
	PRIMARY KEY (`Id`)		PRIMARY KEY (`Id`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information';		) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Relay Log Information';
	</code>		</code>
Line 80:		Line 80:
	USE mysql;		USE mysql;
	CREATE TABLE `slave_worker_info` (		CREATE TABLE `slave_worker_info` (
	`Id` int(10) unsigned NOT NULL,		`Id` int(10) unsigned NOT NULL,
	`Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,		`Relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
	`Relay_log_pos` bigint(20) unsigned NOT NULL,		`Relay_log_pos` bigint(20) unsigned NOT NULL,
	`Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,		`Master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
	`Master_log_pos` bigint(20) unsigned NOT NULL,		`Master_log_pos` bigint(20) unsigned NOT NULL,
	`Checkpoint_relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,		`Checkpoint_relay_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
	`Checkpoint_relay_log_pos` bigint(20) unsigned NOT NULL,		`Checkpoint_relay_log_pos` bigint(20) unsigned NOT NULL,
	`Checkpoint_master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,		`Checkpoint_master_log_name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
	`Checkpoint_master_log_pos` bigint(20) unsigned NOT NULL,		`Checkpoint_master_log_pos` bigint(20) unsigned NOT NULL,
	`Checkpoint_seqno` int(10) unsigned NOT NULL,		`Checkpoint_seqno` int(10) unsigned NOT NULL,
	`Checkpoint_group_size` int(10) unsigned NOT NULL,		`Checkpoint_group_size` int(10) unsigned NOT NULL,
	`Checkpoint_group_bitmap` blob NOT NULL,		`Checkpoint_group_bitmap` blob NOT NULL,
	PRIMARY KEY (`Id`)		PRIMARY KEY (`Id`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';		) ENGINE=InnoDB DEFAULT CHARSET=utf8 STATS_PERSISTENT=0 COMMENT='Worker Information';
	</code>		</code>

← Older revision		Revision as of 17:08, 29 May 2023
Line 7:		Line 7:
	USE mysql;		USE mysql;
	CREATE TABLE `innodb_index_stats` (		CREATE TABLE `innodb_index_stats` (
	`database_name` varchar(64) COLLATE utf8_bin NOT NULL,		`database_name` varchar(64) COLLATE utf8_bin NOT NULL,
	`table_name` varchar(64) COLLATE utf8_bin NOT NULL,		`table_name` varchar(64) COLLATE utf8_bin NOT NULL,
	`index_name` varchar(64) COLLATE utf8_bin NOT NULL,		`index_name` varchar(64) COLLATE utf8_bin NOT NULL,
	`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,		`last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
	`stat_name` varchar(64) COLLATE utf8_bin NOT NULL,		`stat_name` varchar(64) COLLATE utf8_bin NOT NULL,
	`stat_value` bigint(20) unsigned NOT NULL,		`stat_value` bigint(20) unsigned NOT NULL,
	`sample_size` bigint(20) unsigned DEFAULT NULL,		`sample_size` bigint(20) unsigned DEFAULT NULL,
	`stat_description` varchar(1024) COLLATE utf8_bin NOT NULL,		`stat_description` varchar(1024) COLLATE utf8_bin NOT NULL,
	PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)		PRIMARY KEY (`database_name`,`table_name`,`index_name`,`stat_name`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;		) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin STATS_PERSISTENT=0;
	</code>		</code>