Database Upgrades

Upgrade

Vettabase upgrades your database servers for you.
No downtime, no surprises.

The purpose of an upgrade is to ensure the reliability of your technology by staying up to date with the actively maintained versions, and maximise performance and security by taking advantage of the latest optimisations and features.

We cover the following technologies: MariaDB, MySQL, PostgreSQL, Cassandra.

We recommend to use this opportunity to setup deployment and configuration automation, and we can help you to do that.

Next urgent upgrades

If your servers versions are close to their End Of Life, upgrading is urgent.

No security patches or bug fixes are released after a version EOL. Third-party tools may stop support them, and incompatibilities will not be fixed. Vendor support may not be available. Online documentation and downloadable tools may disappear.

Next EOLs are:

  • Apache Cassandra 2.2: April 2022
  • Apache Cassandra 3.0: April 2022
  • MySQL 5.7: ?

Recent EOLs:

  • Apache Cassandra 2.1: 26 July 2021, despite the promise to support it for 6 months after the release of Cassandra 4.0
  • MariaDB 10.1: 17th October 2020
  • MySQL 5.6: 5th February 2021
  • PostgreSQL 9.5: 11th February 2021

Official sources: MariaDB, Cassandra, PostgreSQL.

Upgrading procedure

A proper upgrade consists of several steps. The exact steps depend on the technology, but the general idea is the following:

  • Decide a target version.
  • Test the upgrade:
    • Correctness and speed of the queries.
    • Speed and stability of the servers.
    • Performance tuning on the new version.
  • Plan production upgrade.
  • Upgrade.
  • Monitor for some time, while being ready to roll back.

To upgrade servers without causing a service disruption, a failover mechanism needs to be in place. It can be implemented on the application side, as a proxy layer, or as DNS service discovery. Whichever solution is selected, it is highly recommended to implement it before the upgrade, as a separate engagement.

An upgrade may be much simpler than the procedure described here. However, a detailed upgrade procedure minimises the risks of a disaster.

Automation

You decided to upgrade. Make sure that the next version of your databases is fully automated with technologies like Ansible or Puppet.

See our Database Automation Service.

← Back to Services

Get a Quote

Contact us to discuss your next upgrade.

We will define the details based on your specific situation,
and we will send you a quote.

Contact Us