Raising the Bar on MySQL, MariaDB, PostgreSQL & MongoDB Management
I’d like to take advantage of the quiet days between holidays to look back on 2018 at Severalnines as we continue to advance automation and management of the world’s most popular open source databases: MySQL,...
MySQL in 2018: What’s in 8.0 and Other Observations
With most, if not all of 2018 behind us (depending on when you are reading this post), there is no doubt that it was a fantastic year for open-source SQL databases. PostgreSQL 11 and MySQL...
Database High Availability Comparison – MySQL / MariaDB Replication vs Oracle Data Guard
In the “State of the Open-Source DBMS Market, 2018”, Gartner predicts that by 2022, 70 percent of new in-house applications will be developed on an open-source database. And 50% of existing commercial databases will have...
How to Improve Replication Performance in a MySQL or MariaDB Galera Cluster
In the comments section of one of our blogs a reader asked about the impact of wsrep_slave_threads on Galera Cluster’s I/O performance and scalability. At that time, we couldn’t easily answer that question and back...
Webinar Replay: How to Manage Replication Failover Processes for MySQL, MariaDB & PostgreSQL
If you’re looking at minimizing downtime and meet your SLAs through an automated or semi-automated approach, then this webinar replay is for you: A detailed overview of what failover processes may look like in MySQL,...
MySQL & MariaDB Query Caching With ProxySQL & ClusterControl
Queries have to be cached in every heavily loaded database, there is simply no way for a database to handle all traffic with reasonable performance. There are various mechanisms in which a query cache can...
Multiple Delayed Replication Slaves for Disaster Recovery with Low RTO
Delayed replication allows a replication slave to deliberately lag behind the master by at least a specified amount of time. Before executing an event, the slave will first wait, if necessary, until the given time...
Database Backup Encryption – Best Practices
Offsite backup storage should be a critical part of any organisation’s disaster recovery plan. The ability to store data in a separate physical location, where it could survive a catastrophic event which destroys all the...
Cloud Backup Options for MySQL & MariaDB Databases
The principal objective of backing up your data is, of course, the ability to roll back and access your archives in case of hardware failure. To do business today, you need the certainty of knowing...
How to Encrypt Your MySQL & MariaDB Backups
We usually take care of things we value, whether it is an expensive smartphone or the company’s servers. Data is one of the most important assets of the organisation, and although we do not see...
Webinar Replay: Backup Management for MySQL, MariaDB, PostgreSQL & MongoDB with ClusterControl
Thanks to everyone who participated in this week’s webinar on ‘Backup Management with ClusterControl’. The replay is now available to watch online as well as the slide deck. If you feel frustrated by traditional, labour-intensive...
Percona Live Frankfurt 2018 – Event Recap & Our Sessions
Severalnines was pleased to yet again sponsor Percona Live Europe which was held this year in Frankfurt, Germany. Thanks to the Percona Team for having us and the great organisation. At the Conference Severalnines team...