MySQL minor version upgrade from 8.0.22 to 8.0.29
A minor upgrade is easy to perform just install the new version using the package manager like yum of your distribution. Installing the new version of a package requires the MySQL service to be stopped.
In a recent blog, we have installed MySQL Server 8.0.22 using Yum Repository Method Click here to read more. We will use the same MySQL Server to perform the minor upgrade to version 8.0.29.
Follow the below steps to perform a minor version upgrade
1. Take the Full backup of the MySQL server
2. Check the current MySQL version
3. Check for the latest available version
4. Force dump of buffer pool & flush dirty pages
5. Stop the MySQL server
6. Run yum update to update new binaries
7. Start MySQL server and check Version
Step 1. Take the Full backup of the MySQL server: We are using Percona Xtrabackup to perform a physical level Full MySQL server backup. Click here to read more about Percona Xtrabackup.
[mysql@test-machine01 mysql_bkp]$ xtrabackup --backup --target-dir=/u01/mysql_bkp/full_bkp/ -uroot -p
xtrabackup: recognized client arguments: --backup=1 --target-dir=/u01/mysql_bkp/full_bkp/ --user=root --password
Enter password:
xtrabackup version 8.0.26-18 based on MySQL server 8.0.26 Linux (x86_64) (revision id: 4aecf82)
211117 11:48:27 version_check Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'root' (using password: YES).
Failed to connect to MySQL server: DBI connect(';mysql_read_default_group=xtrabackup','root',...) failed: Authentication plugin 'caching_sha2_password' cannot be loaded: /usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory at - line 1535.
211117 11:48:27 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
Using server version 8.0.22
211117 11:48:27 Executing LOCK INSTANCE FOR BACKUP...
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql/
xtrabackup: open files limit requested 0, set to 1024
xtrabackup: using the following InnoDB configuration:
xtrabackup: innodb_data_home_dir = .
xtrabackup: innodb_data_file_path = ibdata1:12M:autoextend
xtrabackup: innodb_log_group_home_dir = ./
xtrabackup: innodb_log_files_in_group = 2
xtrabackup: innodb_log_file_size = 50331648
Number of pools: 1
xtrabackup: inititialize_service_handles suceeded
211117 11:48:27 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
xtrabackup: Redo Log Archiving is not set up.
211117 11:48:27 >> log scanned up to (1061140266)
xtrabackup: Generating a list of tablespaces
xtrabackup: Generating a list of tablespaces
Scanning './'
Directory '/var/lib/mysql/.cache' will not be scanned because it is a hidden directory.
Directory '/var/lib/mysql/.config' will not be scanned because it is a hidden directory.
Directory '/var/lib/mysql/.bash_history' will not be scanned because it is a hidden directory.
Directory '/var/lib/mysql/.bash_profile' will not be scanned because it is a hidden directory.
Scanning '/u01/mysql/'
Completed space ID check of 2 files.
Allocated tablespace ID 74 for grouprepl_test/t1, old maximum was 0
Using undo tablespace './undo_001'.
Using undo tablespace './undo_002'.
Opened 2 existing undo tablespaces.
211117 11:48:27 [01] Copying ./ibdata1 to /u01/mysql_bkp/full_bkp/ibdata1
211117 11:48:27 [01] ...done
211117 11:48:27 [01] Copying ./sys/sys_config.ibd to /u01/mysql_bkp/full_bkp/sys/sys_config.ibd
211117 11:48:27 [01] ...done
211117 11:48:27 [01] Copying ./grouprepl_test/t1.ibd to /u01/mysql_bkp/full_bkp/grouprepl_test/t1.ibd
211117 11:48:27 [01] ...done
211117 11:48:27 [01] Copying ./mysql_innodb_cluster_metadata/clusters.ibd to /u01/mysql_bkp/full_bkp/mysql_innodb_cluster_metadata/clusters.ibd
211117 11:48:27 [01] ...done
211117 11:48:28 [01] ...done
211117 11:48:28 [01] Copying performance_schema/clone_progress_507.sdi to /u01/mysql_bkp/full_bkp/performance_schema/clone_progress_507.sdi
211117 11:48:28 [01] ...done
211117 11:48:28 [00] Writing /u01/mysql_bkp/full_bkp/test/db.opt
211117 11:48:28 [00] ...done
211117 11:48:28 Finished backing up non-InnoDB tables and files
211117 11:48:28 Executing FLUSH NO_WRITE_TO_BINLOG BINARY LOGS
211117 11:48:28 Selecting LSN and binary log position from p_s.log_status
211117 11:48:28 [00] Copying /var/lib/mysql/binlog.000019 to /u01/mysql_bkp/full_bkp/binlog.000019 up to position 156
211117 11:48:28 [00] ...done
211117 11:48:28 [00] Writing /u01/mysql_bkp/full_bkp/binlog.index
211117 11:48:28 [00] ...done
211117 11:48:28 [00] Writing /u01/mysql_bkp/full_bkp/xtrabackup_binlog_info
211117 11:48:28 [00] ...done
211117 11:48:28 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
xtrabackup: The latest check point (for incremental): '1061140266'
xtrabackup: Stopping log copying thread at LSN 1061140266.
Starting to parse redo log at lsn = 1061140014
211117 11:48:28 Executing UNLOCK INSTANCE
211117 11:48:28 All tables unlocked
211117 11:48:28 [00] Copying ib_buffer_pool to /u01/mysql_bkp/full_bkp/ib_buffer_pool
211117 11:48:28 [00] ...done
211117 11:48:28 Backup created in directory '/u01/mysql_bkp/full_bkp/'
MySQL binlog position: filename 'binlog.000019', position '156', GTID of the last change '13ecba9c-444a-11eb-a397-000c29f9d9e6:1,4cb6a75d-9ac5-11eb-98d9-000c293ab022:1-4871:1000012-1000187,81646864-9069-11eb-bb04-000c293ab022:1-98'
211117 11:48:28 [00] Writing /u01/mysql_bkp/full_bkp/backup-my.cnf
211117 11:48:28 [00] ...done
211117 11:48:28 [00] Writing /u01/mysql_bkp/full_bkp/xtrabackup_info
211117 11:48:28 [00] ...done
xtrabackup: Transaction log of lsn (1061140266) to (1061140276) was copied.
211117 11:48:30 completed OK!
[mysql@test-machine01 mysql_bkp]$
[mysql@test-machine01 mysql_bkp]$
[mysql@test-machine01 mysql_bkp]$ cd full_bkp
[mysql@test-machine01 full_bkp]$ ls -ltr
total 61508
-rw-r-----. 1 mysql mysql 12582912 Nov 17 11:48 ibdata1
drwxr-x---. 2 mysql mysql 28 Nov 17 11:48 sys
drwxr-x---. 2 mysql mysql 20 Nov 17 11:48 grouprepl_test
drwxr-x---. 2 mysql mysql 4096 Nov 17 11:48 mysql_innodb_cluster_metadata
drwxr-x---. 2 mysql mysql 4096 Nov 17 11:48 employees
drwxr-x---. 2 mysql mysql 4096 Nov 17 11:48 repl_test
drwxr-x---. 2 mysql mysql 93 Nov 17 11:48 repl_test1
-rw-r-----. 1 mysql mysql 25165824 Nov 17 11:48 mysql.ibd
-rw-r-----. 1 mysql mysql 12582912 Nov 17 11:48 undo_002
-rw-r-----. 1 mysql mysql 12582912 Nov 17 11:48 undo_001
drwxr-x---. 2 mysql mysql 4096 Nov 17 11:48 mysql
drwxr-x---. 2 mysql mysql 8192 Nov 17 11:48 performance_schema
drwxr-x---. 2 mysql mysql 20 Nov 17 11:48 test
-rw-r-----. 1 mysql mysql 156 Nov 17 11:48 binlog.000019
-rw-r-----. 1 mysql mysql 29 Nov 17 11:48 binlog.index
-rw-r-----. 1 mysql mysql 159 Nov 17 11:48 xtrabackup_binlog_info
-rw-r-----. 1 mysql mysql 2560 Nov 17 11:48 xtrabackup_logfile
-rw-r-----. 1 mysql mysql 108 Nov 17 11:48 xtrabackup_checkpoints
-rw-r-----. 1 mysql mysql 4275 Nov 17 11:48 ib_buffer_pool
-rw-r-----. 1 mysql mysql 475 Nov 17 11:48 backup-my.cnf
-rw-r-----. 1 mysql mysql 138 Nov 17 11:48 xtrabackup_tablespaces
-rw-r-----. 1 mysql mysql 643 Nov 17 11:48 xtrabackup_info
[mysql@test-machine01 full_bkp]$
Step 2. Check the current MySQL version: Login to the MySQL server and check the current version. We can use commands like status or @@version to get the current version.
[root@test-machine01 ~]#
[root@test-machine01 ~]# mysql -hlocalhost -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 8.0.22 MySQL Community Server - GPL
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql>
mysql> status
--------------
mysql Ver 8.0.22 for Linux on x86_64 (MySQL Community Server - GPL)
Connection id: 16
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.0.22 MySQL Community Server - GPL
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/lib/mysql/mysql.sock
Binary data as: Hexadecimal
Uptime: 46 sec
Threads: 8 Questions: 12 Slow queries: 0 Opens: 120 Flush tables: 3 Open tables: 39 Queries per second avg: 0.260
--------------
mysql> select @@version;
+-----------+
| @@version |
+-----------+
| 8.0.22 |
+-----------+
1 row in set (0.00 sec)
mysql>
mysql>
Step 3. Check for the latest available version: To review a list of the package updates that are available for your distribution use OS Command yum check-update. And yum list command will show installed and available packages.
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]# yum repolist enabled | grep "mysql.*-community.*"
mysql-connectors-community/x86_64 MySQL Connectors Community 192
mysql-tools-community/x86_64 MySQL Tools Community 90
mysql80-community/x86_64 MySQL 8.0 Community Server 343
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]#
[root@test-machine01 ~]# yum check-update mysql*
Loaded plugins: langpacks, ulninfo
mysql-connectors-community | 2.6 kB 00:00:00
mysql-tools-community | 2.6 kB 00:00:00
mysql80-community | 2.6 kB 00:00:00
mysql-community-client.x86_64 8.0.29-1.el7 mysql80-community
mysql-community-client-plugins.x86_64 8.0.29-1.el7 mysql80-community
mysql-community-common.x86_64 8.0.29-1.el7 mysql80-community
mysql-community-libs.x86_64 8.0.29-1.el7 mysql80-community
mysql-community-libs-compat.x86_64 8.0.29-1.el7 mysql80-community
mysql-community-server.x86_64 8.0.29-1.el7 mysql80-community
mysql-connector-odbc.x86_64 8.0.29-1.el7 mysql-connectors-community
mysql-router-community.x86_64 8.0.29-1.el7 mysql-tools-community
mysql-shell.x86_64 8.0.29-1.el7 mysql-tools-community
mysql80-community-release.noarch el7-6 mysql80-community
[root@test-machine01 ~]#
[root@test-machine01 ~]#
[root@test-machine01 ~]# yum list mysql-community-server*
Loaded plugins: langpacks, ulninfo
Repodata is over 2 weeks old. Install yum-cron? Or run: yum makecache fast
Installed Packages
mysql-community-server.x86_64 8.0.22-1.el7 @mysql80-community
Available Packages
mysql-community-server.x86_64 8.0.29-1.el7 mysql80-community
mysql-community-server-debug.x86_64 8.0.29-1.el7 mysql80-community
[root@test-machine01 ~]#
[root@test-machine01 ~]#
Step 4. Force dump of buffer pool & flush dirty pages: Flush the buffer pool and dirty pages before stopping the MySQL server.
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]# mysql -hlocalhost -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 18
Server version: 8.0.22 MySQL Community Server - GPL
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> show global status like 'Innodb_buffer_pool_dump_status';
+--------------------------------+------------------------------------+
| Variable_name | Value |
+--------------------------------+------------------------------------+
| Innodb_buffer_pool_dump_status | Dumping of buffer pool not started |
+--------------------------------+------------------------------------+
1 row in set (0.01 sec)
mysql>
mysql> set global innodb_buffer_pool_dump_at_shutdown=OFF, innodb_buffer_pool_dump_now=ON;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> show global status like 'Innodb_buffer_pool_dump_status';
+--------------------------------+--------------------------------------------------+
| Variable_name | Value |
+--------------------------------+--------------------------------------------------+
| Innodb_buffer_pool_dump_status | Buffer pool(s) dump completed at 220621 17:28:38 |
+--------------------------------+--------------------------------------------------+
1 row in set (0.00 sec)
mysql>
mysql>
mysql> set global innodb_max_dirty_pages_pct=0;
Query OK, 0 rows affected, 2 warnings (0.00 sec)
mysql>
mysql> show global status like 'Innodb_buffer%dirty';
+--------------------------------+-------+
| Variable_name | Value |
+--------------------------------+-------+
| Innodb_buffer_pool_pages_dirty | 0 |
| Innodb_buffer_pool_bytes_dirty | 0 |
+--------------------------------+-------+
2 rows in set (0.01 sec)
mysql>
mysql>
Step 5. Stop the MySql server: Stop MySQL server using systemctl stop.
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]# systemctl stop mysqld@inst1
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]# systemctl status mysqld@inst1
â mysqld@inst1.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld@.service; disabled; vendor preset: disabled)
Active: inactive (dead)
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Jun 21 15:58:22 test-machine01 systemd[1]: Starting MySQL Server...
Jun 21 15:58:28 test-machine01 systemd[1]: Started MySQL Server.
Jun 21 17:30:51 test-machine01 systemd[1]: Stopping MySQL Server...
Jun 21 17:30:52 test-machine01 systemd[1]: Stopped MySQL Server.
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]#
Step 6. Execute command yum update to update new binaries: Use OS command yum update to update existing MySQL binaries.
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]# yum update mysql mysql-server
Loaded plugins: langpacks, ulninfo
mysql-connectors-community | 2.6 kB 00:00:00
mysql-tools-community | 2.6 kB 00:00:00
mysql80-community | 2.6 kB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.22-1.el7 will be updated
---> Package mysql-community-client.x86_64 0:8.0.29-1.el7 will be an update
--> Processing Dependency: mysql-community-client-plugins = 8.0.29-1.el7 for package: mysql-community-client-8.0.29-1.el7.x86_64
---> Package mysql-community-server.x86_64 0:8.0.22-1.el7 will be updated
---> Package mysql-community-server.x86_64 0:8.0.29-1.el7 will be an update
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.29-1.el7 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Processing Dependency: mysql-community-icu-data-files = 8.0.29-1.el7 for package: mysql-community-server-8.0.29-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client-plugins.x86_64 0:8.0.22-1.el7 will be updated
--> Processing Dependency: mysql-community-client-plugins = 8.0.22-1.el7 for package: mysql-community-libs-8.0.22-1.el7.x86_64
---> Package mysql-community-client-plugins.x86_64 0:8.0.29-1.el7 will be an update
---> Package mysql-community-common.x86_64 0:8.0.22-1.el7 will be updated
---> Package mysql-community-common.x86_64 0:8.0.29-1.el7 will be an update
---> Package mysql-community-icu-data-files.x86_64 0:8.0.29-1.el7 will be installed
--> Running transaction check
---> Package mysql-community-libs.x86_64 0:8.0.22-1.el7 will be updated
---> Package mysql-community-libs.x86_64 0:8.0.29-1.el7 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
==============================================================================================================================================================================================
Package Arch Version Repository Size
==============================================================================================================================================================================================
Updating:
mysql-community-client x86_64 8.0.29-1.el7 mysql80-community 14 M
mysql-community-server x86_64 8.0.29-1.el7 mysql80-community 53 M
Installing for dependencies:
mysql-community-icu-data-files x86_64 8.0.29-1.el7 mysql80-community 2.1 M
Updating for dependencies:
mysql-community-client-plugins x86_64 8.0.29-1.el7 mysql80-community 2.5 M
mysql-community-common x86_64 8.0.29-1.el7 mysql80-community 633 k
mysql-community-libs x86_64 8.0.29-1.el7 mysql80-community 1.5 M
Transaction Summary
==============================================================================================================================================================================================
Install ( 1 Dependent package)
Upgrade 2 Packages (+3 Dependent packages)
Total download size: 74 M
Is this ok [y/d/N]: y
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
(1/6): mysql-community-client-plugins-8.0.29-1.el7.x86_64.rpm | 2.5 MB 00:00:01
(2/6): mysql-community-common-8.0.29-1.el7.x86_64.rpm | 633 kB 00:00:00
(3/6): mysql-community-icu-data-files-8.0.29-1.el7.x86_64.rpm | 2.1 MB 00:00:01
(4/6): mysql-community-libs-8.0.29-1.el7.x86_64.rpm | 1.5 MB 00:00:00
(5/6): mysql-community-client-8.0.29-1.el7.x86_64.rpm | 14 MB 00:00:06
(6/6): mysql-community-server-8.0.29-1.el7.x86_64.rpm | 53 MB 00:00:11
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total 4.6 MB/s | 74 MB 00:00:15
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Warning: RPMDB altered outside of yum.
Updating : mysql-community-common-8.0.29-1.el7.x86_64 1/11
Updating : mysql-community-client-plugins-8.0.29-1.el7.x86_64 2/11
Updating : mysql-community-libs-8.0.29-1.el7.x86_64 3/11
Updating : mysql-community-client-8.0.29-1.el7.x86_64 4/11
Installing : mysql-community-icu-data-files-8.0.29-1.el7.x86_64 5/11
Updating : mysql-community-server-8.0.29-1.el7.x86_64 6/11
Cleanup : mysql-community-server-8.0.22-1.el7.x86_64 7/11
Cleanup : mysql-community-client-8.0.22-1.el7.x86_64 8/11
Cleanup : mysql-community-libs-8.0.22-1.el7.x86_64 9/11
Cleanup : mysql-community-common-8.0.22-1.el7.x86_64 10/11
Cleanup : mysql-community-client-plugins-8.0.22-1.el7.x86_64 11/11
Verifying : mysql-community-icu-data-files-8.0.29-1.el7.x86_64 1/11
Verifying : mysql-community-client-8.0.29-1.el7.x86_64 2/11
Verifying : mysql-community-client-plugins-8.0.29-1.el7.x86_64 3/11
Verifying : mysql-community-server-8.0.29-1.el7.x86_64 4/11
Verifying : mysql-community-common-8.0.29-1.el7.x86_64 5/11
Verifying : mysql-community-libs-8.0.29-1.el7.x86_64 6/11
Verifying : mysql-community-libs-8.0.22-1.el7.x86_64 7/11
Verifying : mysql-community-server-8.0.22-1.el7.x86_64 8/11
Verifying : mysql-community-client-plugins-8.0.22-1.el7.x86_64 9/11
Verifying : mysql-community-common-8.0.22-1.el7.x86_64 10/11
Verifying : mysql-community-client-8.0.22-1.el7.x86_64 11/11
Dependency Installed:
mysql-community-icu-data-files.x86_64 0:8.0.29-1.el7
Updated:
mysql-community-client.x86_64 0:8.0.29-1.el7 mysql-community-server.x86_64 0:8.0.29-1.el7
Dependency Updated:
mysql-community-client-plugins.x86_64 0:8.0.29-1.el7 mysql-community-common.x86_64 0:8.0.29-1.el7 mysql-community-libs.x86_64 0:8.0.29-1.el7
Complete!
[root@test-machine01 yum.repos.d]#
Step 7. Start MySQL server and check Version: Start the MySql server using the command systemctl start and check version. You will notice the is upgraded version from 8.0.22 to 8.0.29. Also, note that the mysql_upgrade option is deprecated. The upgrade process automatically starts by running a new MySQL binary with an older data directory.
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]# systemctl start mysqld@inst1
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]# systemctl status mysqld@inst1
â mysqld@inst1.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld@.service; disabled; vendor preset: disabled)
Active: active (running) since Wed 2022-06-22 10:05:35 +03; 6s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 67215 ExecStartPre=/usr/bin/mysqld_pre_systemd %I (code=exited, status=0/SUCCESS)
Main PID: 67239 (mysqld)
Status: "Server is operational"
CGroup: /system.slice/system-mysqld.slice/mysqld@inst1.service
ââ67239 /usr/sbin/mysqld --defaults-group-suffix=@inst1
Jun 22 10:05:28 test-machine01 systemd[1]: Starting MySQL Server...
Jun 22 10:05:35 test-machine01 systemd[1]: Started MySQL Server.
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]# mysql_upgrade -hlocalhost -uroot -p
The mysql_upgrade client is now deprecated. The actions executed by the upgrade client are now done by the server.
To upgrade, please start the new MySQL binary with the older data directory. Repairing user tables is done automatically. Restart is not required after upgrade.
The upgrade process automatically starts on running a new MySQL binary with an older data directory. To avoid accidental upgrades, please use the --upgrade=NONE option with the MySQL binary. The option --upgrade=FORCE is also provided to run the server upgrade sequence on demand.
It may be possible that the server upgrade fails due to a number of reasons. In that case, the upgrade sequence will run again during the next MySQL server start. If the server upgrade fails repeatedly, the server can be started with the --upgrade=MINIMAL option to start the server without executing the upgrade sequence, thus allowing users to manually rectify the problem.
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]#
[root@test-machine01 yum.repos.d]# mysql -hlocalhost -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 22
Server version: 8.0.29 MySQL Community Server - GPL
Copyright (c) 2000, 2022, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> select @@version
-> ;
+-----------+
| @@version |
+-----------+
| 8.0.29 |
+-----------+
1 row in set (0.00 sec)
mysql>
mysql>
mysql> status
--------------
mysql Ver 8.0.29 for Linux on x86_64 (MySQL Community Server - GPL)
Connection id: 23
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 8.0.29 MySQL Community Server - GPL
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/lib/mysql/mysql.sock
Binary data as: Hexadecimal
Uptime: 12 min 19 sec
Threads: 2 Questions: 18 Slow queries: 0 Opens: 532 Flush tables: 4 Open tables: 42 Queries per second avg: 0.024
--------------
mysql>
[root@test-machine01 mysql]#
[root@test-machine01 mysql]# pwd
/var/lib/mysql
[root@test-machine01 mysql]# vi mysqld.log
2022-06-22T07:05:29.107089Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2022-06-22T07:05:29.107112Z 0 [Warning] [MY-011069] [Server] The syntax '--master-info-repository' is deprecated and will be removed in a future release.
2022-06-22T07:05:29.107119Z 0 [Warning] [MY-011069] [Server] The syntax '--relay-log-info-repository' is deprecated and will be removed in a future release.
2022-06-22T07:05:29.107137Z 0 [Warning] [MY-011068] [Server] The syntax 'log_slave_updates' is deprecated and will be removed in a future release. Please use log_replica_updates instead.
2022-06-22T07:05:29.108516Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.29) starting as process 67239
2022-06-22T07:05:29.114623Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-06-22T07:05:30.720597Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-06-22T07:05:31.461835Z 0 [System] [MY-013587] [Repl] Plugin group_replication reported: 'Plugin 'group_replication' is starting.'
2022-06-22T07:05:31.462293Z 0 [Warning] [MY-010918] [Repl] 'rpl_semi_sync_master' is deprecated and will be removed in a future release. Please use rpl_semi_sync_source instead.
2022-06-22T07:05:31.462325Z 0 [Warning] [MY-010918] [Repl] 'rpl_semi_sync_slave' is deprecated and will be removed in a future release. Please use rpl_semi_sync_replica instead.
2022-06-22T07:05:31.484335Z 5 [System] [MY-013381] [Server] Server upgrade from '80022' to '80029' started.
2022-06-22T07:05:35.217346Z 5 [System] [MY-013381] [Server] Server upgrade from '80022' to '80029' completed.
2022-06-22T07:05:35.304303Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2022-06-22T07:05:35.304345Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
[root@test-machine01 mysql]#
This document is only for learning purposes and always validate in the LAB environment first before applying in the LIVE environment.
Hope so you like this article!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to understand more about our pursuit.
Related Articles
- MySQL major version upgrade from 5.7 to 8.0.30
- MySQL minor version upgrade from 8.0.22 to 8.0.29
- Steps to create a Database Link from Oracle to MySQL
- Multiplexing of Control Files Using RMAN, SPFILE & PFILE in Oracle
- Create MySQL Instance Replica using Clone Command
