Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

My Favorite PostgreSQL Queries and Why They Matter

In today's data-driven world, data is valuable. Extracting insight, answering questions, and meaningful metrics from data by way of querying and data manipulation is an integral component of SQL in general. This blog presents a combination of 8 interesting, differing PostgreSQL queries or types of queries to explore, study, learn, or otherwise manipulate data sets.

New Whitepaper: How to Design Highly Available Open Source Database Environments

Download our new whitepaper on how to design highly available open source database environments. It discusses the requirements for high availability in database setups, and how to design the system from the ground up.

Comparing Replication Solutions from Oracle and MySQL

In this post, we are going to compare Oracle 12c logical replication with MySQL 5.7. Both technologies offer reliable standby systems to offload production workload and help in case of disaster. We will take a look at their architectures, analyze pros and cons and go through the steps on how to set them up.

Webinar Replay: How to Design Open Source Databases for High Availability

Watch this webinar replay on how to design open source databases for high availability. From discussing high availability concepts through to failover or switch over mechanisms, we cover all the need-to-know information when it comes to building highly available database infrastructures.

A Guide to Using pgBouncer for PostgreSQL

This blog provides an overview of pgBouncer, a connection pooler for PostgreSQL that dramatically reduces processing time.

Updated: Become a ClusterControl DBA: Making your DB components HA via Load Balancers

There are various ways to retain high availability with databases. You can use Virtual IPs (VRRP) to manage host availability, you can use resource managers like Zookeeper and Etcd to (re)configure your applications or use load balancers/proxies to distribute the workload over all available hosts.

Comparing Oracle RAC HA Solution to Galera Cluster for MySQL or MariaDB

This blog provides a comparison of achieving high availability with Oracle RAC vs MySQL Galera Cluster.

Top PG Clustering HA Solutions for PostgreSQL

Achieving high availability and clustering in PostgreSQL is not an easy task. In this blog entry we discuss some options for implementing these and not collapsing in the process!

Updated: ClusterControl Tips & Tricks: MySQL Query Performance Tuning

In this blog post, we’ll look into how ClusterControl can help you solve problems related to query performance using the Query Monitor.

An Overview of Database Indexing in PostgreSQL

This blog provides a high-level overview of database indexing and how you can use it to improve database performance.