Dealing with Unreliable Networks When Crafting an HA Solution for MySQL or MariaDB
Long gone are the days when a database was deployed as a single node or instance - a powerful, standalone server which was tasked to handle all the requests to the database. Vertical scaling was...
Migration from Oracle Database to MariaDB – A Deep Dive
In previous blogs, we discussed the topic of How to Migrate from Oracle to MySQL / Percona Server and most recently Migrating from Oracle Database to MariaDB - What You Should Know. Over the years...
Migrating from Oracle Database to MariaDB – What You Should Know
Gartner predicts that by 2022, 50% of existing commercial databases will have been converted to open source databases. Even more, 70% of new in-house applications will be developed on an open source database platform (State...
Analytics with MariaDB AX – tThe Open Source Columnar Datastore
Long gone are the days of the one-database-fits-all approach. With increasing requirements on velocity, performance and agility, numerous datastores emerged, which are intended to solve one particular problem. We have relational databases, document stores, time-series...
What is MariaDB TX? How to Manage the New MariaDB MySQL Fork!
You may have heard about MariaDB TX and you may have wondered what it is? Is there a difference between it and MariaDB Server 10.3? In this blog post we would like to give you...
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,...
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...