Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

How to Migrate MySQL from Amazon EC2 to your On-Prem Data Center Without Downtime

Database migrations are a pain. They often require maintenance windows and can be a cause of downtime. In this blog, we will see how we can migrate a MySQL database from Amazon EC2 to an on-premise datacenter without any downtime whatsoever.

Monitoring Your Databases with MySQL Enterprise Monitor

Keeping track of the state of your production databases is crucial for performance and availability. There are a number of database monitoring tools on the market, and MySQL Enterprise Monitor is probably one of the older ones. Let’s take a look at what MySQL Enterprise Monitor can do for us.

Basic Administration Comparison Between Oracle, MSSQL, MySQL, PostgreSQL

Supporting different types of databases in a mixed environment is not an easy task. In this blog post we will compare different types of RDBMS systems from the DBA/DevOps administration perspective.

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.

ClusterControl Tips and Tricks: Running ClusterControl on PHP 7

PHP 5 is deprecated since early this year, which may cause some concerns when running ClusterControl. This blog post shows you how to run ClusterControl on PHP 7.