The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB version number after upgrade from 5.5. to 10.0

Hi

We have recently upgraded MariaDB on RHEL 7.9 from 5.5 to 10.0 using the Redhat software collections repository. This was done on our test cluster. Everything has worked ok with the upgrade, happy days!

However when we check "STATUS" we get the following information:

MariaDB [(none)]> STATUS -------------- mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1

Connection id: 168703 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server: MariaDB Server version: 10.0.33-MariaDB MariaDB Server Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: utf8 Conn. characterset: utf8 UNIX socket: /var/lib/mysql/mysql.sock Uptime: 18 days 2 hours 41 min 30 sec

Threads: 88 Questions: 324295630 Slow queries: 3 Opens: 3881 Flush tables: 1 Open tables: 400 Queries per second avg: 207.232 --------------

The server version shows "10.0.33-MariaDB MariaDB Server" which is what we expect. However, the mysql is still showing 5.5 "mysql Ver 15.1 Distrib 5.5.68-MariaDB"

Is it normal to see this or has something not updated correctly? Is it looking back at dependent binaries and that is why it is showing "Distrib 5.5"? Any assistance would be greatly appreciated. We are reluctant to upgrade on PROD without knowing this.

Answer Answered by Ian Gilfillan in this comment.

STATUS shows you the client protocol details, so in this case you are correctly running MariaDB Server 10.0.33, just using the 5.5.68 client.

Note that MariaDB 10.0 reached end-of-life in March 2019.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.