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.

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.

Recent End Of Lifes:

  • MariaDB 10.1: 17th October 2020

Next EOLs are:

  • MySQL 5.6: 5th February 2021
  • Apache Cassandra 2.*: Until Cassandra 4 is stable (currently in beta)
  • PostgreSQL 9.5: 11th February 2021
Official sources: MariaDBCassandra, 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.

← Back to Services

Get in touch

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