How to upgrade from MariaDB 10.4 to MariaDB 10.5
In this blog we have explained how to upgrade from MariaDB 10.4 to MariaDB 10.5 safely. We strongly recommend you to do a complete MariaDB database backup using Mariabackup before upgrading from MariaDB 10.4 to MariaDB 10.5. The following process is recommended to successfully upgrade from MariaDB 10.4 to MariaDB 10.5:
- Modify the repository configuration, so the system’s package manager installs MariaDB 10.4. For example,
- On Debian, Ubuntu, and other similar Linux distributions, see Updating the MariaDB APT repository to a New Major Release for more information.
- On RHEL, CentOS, Fedora, and other similar Linux distributions, see Updating the MariaDB YUM repository to a New Major Release for more information.
- On SLES, OpenSUSE, and other similar Linux distributions, see Updating the MariaDB ZYpp repository to a New Major Release for more information.
- Stop MariaDB.
- Uninstall the old version of MariaDB.
- On Debian, Ubuntu, and other similar Linux distributions, execute the following:
sudo apt-get remove mariadb-server - On RHEL, CentOS, Fedora, and other similar Linux distributions, execute the following:
sudo yum remove MariaDB-server - On SLES, OpenSUSE, and other similar Linux distributions, execute the following:
sudo zypper remove MariaDB-server
- On Debian, Ubuntu, and other similar Linux distributions, execute the following:
- Install the new version of MariaDB.
- On Debian, Ubuntu, and other similar Linux distributions, see Installing MariaDB Packages with APT for more information.
- On RHEL, CentOS, Fedora, and other similar Linux distributions, see Installing MariaDB Packages with YUM for more information.
- On SLES, OpenSUSE, and other similar Linux distributions, see Installing MariaDB Packages with ZYpp for more information.
- Make any desired changes to configuration options in option files, such as my.cnf. This includes removing any options that are no longer supported.
- Start MariaDB.
- Run mysql_upgrade.
- mysql_upgrade does two things:
- Ensures that the system tables in the#mysql database are fully compatible with the new version.
- Does a very quick check of all tables and marks them as compatible with the new version of MariaDB
- mysql_upgrade does two things:
Reference links:
MariaDB upgrades: https://mariadb.com/kb/en/upgrading/
☛ Contact MinervaDB for MariaDB Upgrades and Migration Services:
| Business Function | Contact |
|---|---|
| ☎ CONTACT GLOBAL SALES (24*7) | 📞 (844) 588-7287 (USA) 📞 (415) 212-6625 (USA) 📞 (778) 770-5251 (Canada) |
| ☎ TOLL FREE PHONE (24*7) | 📞 (844) 588-7287 |
| 🚩 MINERVADB FAX | +1 (209) 314-2364 |
| 📨 MinervaDB Email - General / Sales / Consulting | contact@minervadb.com |
| 📨 MinervaDB Email - Support | support@minervadb.com |
| 📨 MinervaDB Email -Remote DBA | remotedba@minervadb.com |
| 📨 Shiv Iyer Email - Founder and Principal | shiv@minervadb.com |
| 🏠 CORPORATE ADDRESS: CALIFORNIA | MinervaDB Inc., 340 S LEMON AVE #9718 WALNUT 91789 CA, US |
| 🏠 CORPORATE ADDRESS: DELAWARE | MinervaDB Inc., PO Box 2093 PHILADELPHIA PIKE #3339 CLAYMONT, DE 19703 |
| 🏠 CORPORATE ADDRESS: HOUSTON | MinervaDB Inc., 1321 Upland Dr. PMB 19322, Houston, TX 77043, US |
☛ Partial list of customers ( from approximately 300 globally) – What we did for them ?
- APC – PostgreSQL Consultative Support and Remote DBA Services
- Prada – PostgreSQL Consultative Support and Remote DBA Services
- Tiffany & Co – PostgreSQL Consultative Support and Remote DBA Services
- Tiffany & Co – ClickHouse Consultative Support
- Strabag – PostgreSQL Consultative Support and Remote DBA Services
- Danone – MySQL Consultative Support
- Asahi – PostgreSQL Consultative Support and Remote DBA Services
- Castel Group – MySQL Consultative Support and Remote DBA Services
- Shell Petroleum – PostgreSQL Consultative Support
- GoDaddy – MySQL Consulting and Enterprise-Class Support
- DataCloud – MySQL Consulting and Professional Services
- Garmin – ClickHouse Consulting and Enterprise-Class Support
- ClassPlus – Amazon RDS Support and Managed DBA Services
- ClassPlus – ClickHouse Enterprise-Class Support
- MPL – PostgreSQL Consulting and Managed DBA Services
- WrestleMania – MySQL Consultative Support
- Kirin – PostgreSQL Consultative Support
- Blue Dart – ClickHouse Consulting / Professional Services and Enterprise-Class Consultative Support
- LibLynx – MySQL Consulting and Managed Remote DBA Services
- Callaway Golf – MySQL Consultative Support
- YONEX – MySQL Consultative Support
- BharatPe – MySQL and ClickHouse Consultative Support
- Dean Food Group – MySQL Remote DBA and Consultative Support
- Flip.id – MySQL Consultative Support
- Fitbit – MySQL Consulting and Support
- Sprint Global – PostgreSQL Enterprise-Class Consultative Support
- Sony – PostgreSQL Consultative Support and Managed Remote DBA Services
- Chevrolet – PostgreSQL Remote DBA Services and Enterprise Support
- BankBazaar– MariaDB consultative support and Remote DBA services.
- MIX– MySQL Consulting and Professional Services.
- AOL– Performance benchmarking, capacity planning & sizing, Remote DBA Services and Site Reliability Engineering Services.
- eBay– Remote DBA services, MySQL DevOps. & automation, on-call DBA Support (24*7) and MySQL upgrades / migration.
- Forbes.com– Remote DBA services, architecting & building highly available MySQL infrastructure operations and consulting & professional services for MySQL.
- National Geographic– MySQL Consulting & Professional services, performance audit & optimization and MySQL upgrades.
- Apigee– PostgreSQL Support and Remote DBA Services.
- PayPal– MySQL Consulting & Professional Services, MySQL performance audit & recommendations and MySQL SRE.
- Yahoo– MySQL Consulting & Professional services, on-call DBA Services and MySQL Emergency Support.
- Priceline.com – Consulting & Professional Services for MySQL & Percona Server for MySQL, Performance optimization & tuning and MySQL SRE.
- Freshdesk – MySQL performance audit & recommendation, MySQL scale-out & replication solutions and MySQL Consultancy.
- OLA – MySQL Consultative Support.
- Flipkart – MySQL Consulting Services and MySQL Consultative Cupport.
- Paytm– MySQL Consultative Support.
- PetSmart– MySQL Consulting Services and MySQL Consultative Support.
- CallForAmerica – MySQL Consultative Support
- SunTec Business Solutions – MariaDB Consulting and Support
- ESPN – Architected & deployed MySQL high availability solution and MySQL Consulting & Professional Services.
- Mashable – MySQL Consulting Services and Remote DBA Services.
- Proteans – MySQL performance audit & optimization and MySQL Consulting & Professional Services.
- Symphony Software – MySQL performance audit & recommendations, custom MySQL sharding solution and MySQL upgrades / migration.
- Yatra – MySQL Consultative Support.
- Justdial– MySQL Consultative Support.
- Victoria’s Secret– MySQL performance audit & recommendations and MySQL replication solutions.
- Airpush– MySQL Remote DBA Services and MySQL Consultancy.
- Virsec – Remote DBA services and Consulting & Professional Services .
- Go-Jek – Deployed MySQL high availability solution using Percona XtraDB Cluster, MySQL emergency support, performance optimization and Consultative Support.
- Midtrans – 24*7 MySQL Remote DBA Services, MySQL high availability & fault tolerance solution using Percona XtraDB Cluster & ProxySQL and MySQL Consultative Support.
- Bukalapak– MySQL Consultative Support.
- Sequoia Capital – MySQL Professional Services, Remote DBA Services & Consultative Support for Sequoia APAC and Southeast Asia portfolio companies.
- Housing.com – Consultative support and PostgreSQL Consulting Services.
- Electronic Arts – MySQL Consulting Services addressing performance and scalability.
- Adyen – MySQL Consulting and Professional Services.
- Pinterest – MySQL Consulting & Professional services addressing performance and scalability.