Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
748 blog posts in 13 categories

How to Migrate from MSSQL to MySQL

Migrating from proprietary engines into open source engines is a trend that is growing in the industry. In this blog we’ll see what is needed to move from Microsoft SQL Server to MySQL and why and how to do it.

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.

The Current State of Open Source Backup Management for PostgreSQL

This blog takes a deep-dive into the most popular open source backup programs available for PostgreSQL, what their current state is, and how they compare to one another.

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.

Hybrid OLTP/Analytics Database Workloads in Galera Cluster Using Asynchronous Slaves

Reporting and analytics is a common requirement, but should you run it on your production database? For Galera Cluster, heavy OLAP queries may interfere with the performance of regular OLTP operations. In this blog post, we’ll describe an easy way to offload OLAP workload from Galera Cluster to asynchronous replication slave.

Hybrid OLTP/Analytics Database Workloads: Replicating MySQL Data to ClickHouse

Columnar data stores provide much better performance for analytics queries than regular relational databases like MySQL. ClickHouse is an example of such datastore, queries that take minutes to execute in MySQL would take less than a second instead. In this blog post we show how to tackle the challenge of replicating the data from MySQL to ClickHouse.

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).

How to Migrate from Oracle to MySQL / Percona Server

Migrating from Oracle RDBMS to MySQL/Percona Server is an enormous task. This blog offers a basic guide to migration, especially if you're coming from Oracle and have limited knowledge of MySQL. The blog does not offer a step-by-step process, but it provides general information of what you should consider before a migration from Oracle to MySQL/Percona Server.