How to Execute and Manage MySQL Backups for Oracle DBA’s
Migrating from Oracle database to open source can bring a number of benefits. The lower cost of ownership is tempting, and pushes a lot of companies to migrate. At the same time DevOps, SysOps or...
Advanced Database Monitoring & Management for TimescaleDB
Included in the 1.7.2 release of ClusterControl we are proud to announce an expansion of the databases we support to include TimescaleDB, a revolutionary new time-series that leverages the stability, maturity and power of PostgreSQL....
MongoDB in 2018 – A Year in Review
MongoDB is by far the most popular choice in NoSQL world as its distributed architecture allows for more scalability and its document data model provides good flexibility to developers. Almost every year, major MongoDB version...
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 Use MongoDB Data Modeling to Improve Throughput Operations
The efficiency of a database not only relies on fine-tuning the most critical parameters, but also goes further to appropriate data presentation in the related collections. Recently, I worked on a project that developed a...
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...
PostgreSQL on the Rise: 2018 Postgres Findings & 2019 Trends
A strong community coupled with an increasingly stable and feature-rich platform are making PostgreSQL a strong contender for replacing the “big boys” of enterprise data. We here at Severalnines have also seen this trend and...
Deploying MongoDB Using Docker
The main advantage of using MongoDB is that it’s easy to use. One can easily install MongoDB and start working on it in minutes. Docker makes this process even easier. One cool thing about Docker...
How to Take Advantage of the New Partitioning Features in PostgreSQL 11
What is Partitioning? Partitioning splits large tables into smaller pieces, which helps with increasing query performance, making maintenance tasks easier, improving the efficiency of data archival, and faster database backups. You can read more...
How to Upgrade PostgreSQL10 to PostgreSQL11 With Zero Downtime
Historically, the hardest task when working with PostgreSQL has been dealing with the upgrades. The most intuitive upgrade way you can think of is to generate a replica in a new version and perform a...
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...