Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
149 blog posts in 1 category

Real Time Data Streaming with MongoDB Change Streams

MongoDB Change streams allow applications to access real-time data changes without the complexity and risk of tailing the oplog. Applications can use change streams to subscribe to all data changes on a single collection, a database, or an entire deployment, and immediately react to them. This blog provides an overview of this feature.

MySQL Performance Benchmarking: MySQL 5.7 vs MySQL 8.0

MySQL 8.0 features a lot of great improvements, comprehensive support for technologies, and most importantly, its enhanced performance under high read/write workloads. In this blog, we’ll have a look at how MySQL 8.0 performs as compared to its predecessor MySQL 5.7.

Operational Factors to Consider During MongoDB Data Modeling

This blog describes the major factors to consider when performing MongoDB data modeling including scalability, atomicity, performance / data usage, sharding, indexing, storage optimization, document structure, growth, and the data lifecycle.

PostgreSQL High Availability with Master-Slave & Master-Master Architectures

Database servers can work together to allow a second server to take over quickly if the primary server fails (high availability), or to allow several computers to serve the same data (load balancing).

For HA PostgreSQL configurations we can have several architectures, but the basic ones would be master-slave and master-master architectures.

How to Optimize Performance of ClusterControl and Its Components

This blog post explains a number of ways to improve performance of ClusterControl and its components.

How to Monitor MongoDB with Prometheus & ClusterControl

ClusterControl’s new agent-based monitoring of MongoDB with Prometheus offers dashboards with graphs of high resolution metrics data. In this blog, we will have a look at the different graphs that are available to users.

Announcing ClusterControl 1.7.1: Support for PostgreSQL 11 and MongoDB 4.0, Enhanced Monitoring

This blog provides an overview of the next iteration of the agent-based monitoring features for MySQL, Galera Cluster, PostgreSQL and ProxySQL in ClusterControl with its 1.7.1 release, support for PostgreSQL 11 and MongoDB 4.0, as well as a whole range of new monitoring and backup management features for PostgreSQL … and more.

MySQL Performance Cheat Sheet

You would be surprised by the number of MySQL installations running default configurations, regardless of the workload. However, what works well for a read-intensive workload might not work as well for a write-intensive one. Configuration parameters also need to take into account the underlying hardware. This cheat sheet provides some quick tips on how to tune some of the key MySQL variables in order to improve performance.

An Overview of Just-in-Time Compilation (JIT) for PostgreSQL

Just-in-Time (JIT) compilation is the process of turning some form of interpreted program evaluation into a native program, and doing so at runtime. This blog shows hows to use this with PostgreSQL, which has built-in support to perform JIT compilation using LLVM when PostgreSQL is built with --with-llvm.

Database High Availability Comparison - MySQL / MariaDB Replication vs Oracle Data Guard

This blog compares MySQL replication vs Oracle Data Guard solution for High Availability.