Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

Configuring PostgreSQL for Business Continuity

Business continuity for databases means databases must be continuously operational even during the disasters. It is imperative to ensure that production databases are available for the applications all the time even during the disasters, otherwise, could end-up being an expensive deal.

How to Replicate PostgreSQL Data to Remote Sites

In a busy database environment with larger size databases, the need for real-time data replication is a common occurrence. Applications often need the production data to be replicated in real-time to remote sites for analytics and other critical business operations needs. This blog provides an overview of several options you can use to replicate your PostgreSQL data to a remote site.

An Introduction to Database High Availability for MySQL & MariaDB

These days high availability is a must for any serious deployment. Long gone are days when you could schedule a downtime of your database for several hours to perform a maintenance. Making a database environment highly available is one of the highest priorities nowadays alongside data integrity. For a database, which is often considered the single source of truth, compromised data integrity can have catastrophic consequences.

HA for MySQL and MariaDB - Comparing Master-Master Replication to Galera Cluster

Replication and Galera Cluster are both widely used to implement high availability for MySQL/MariaDB, but when should you pick one over the other? What are the limitations of each solution, and what are the trade offs?
In this blog post, we will look at the differences in terms of data consistency, conflict resolution, failover, node provisioning and robustness.

Dealing with Unreliable Networks When Crafting an HA Solution for MySQL or MariaDB

Networks may not be always stable or reliable, but your database clusters have to. This blog discusses the things to keep in mind when designing an HA solution for MySQL or MariaDB, deployed across potentially unreliable networks.

A Review of the New Analytic Window Functions in MySQL 8.0

This blog provides an overview of MySQL window functions. A window function performs an aggregate-like operation on a set of query rows. However, whereas an aggregate operation groups query rows into a single result row, a window function produces a result for each query row.

MongoDB vs MySQL NoSQL - Why Mongo is Better

As the great database wars rage some users may be considering whether to use the new document storage features of MySQL 8.0 instead of the traditional MongoDB NoSQL setup. This blog explains why Mongo is still the king of the NoSQL world.

Migrating from Oracle Database to MariaDB - What You Should Know

For many organizations, migrating from Oracle to an open source database platform is just a matter of time. An Oracle to MariaDB migration can be a complex multistage process, but choosing the right database architecture and features can reduce the cost and time of the operation. This blog aims to help you better understand the details of the complexities involved and how to overcome them.

Migrating from DB2 to PostgreSQL - What You Should Know

This blog provides a high level overview of what you should know if considering a move from IBM’s DB2 to PostgreSQL including a comparison of commands and an examination of the incompatibilities of the databases.

How to Cluster Odoo 12 with PostgreSQL Streaming Replication for High Availability

Automating all your business processes with Odoo puts stringent requirements on the availability of the platform. What do you do if a server fails? In this blog post, we’ll show you how to cluster Odoo to achieve better availability and scalability on multiple servers. The softwares used are Odoo 12, HAProxy 1.8.8, Keepalived 1.3.9, PostgreSQL 11 and OCFS2 (Oracle Cluster File System).