Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Manage MySQL - for Oracle DBAs

So, you are an Oracle DBA and your manager asked you to migrate a couple of Oracle databases to MySQL. Databases are migrated, and now what? How do you manage these MySQL databases?

In this blog, we show you how Oracle DBAs can best manage MySQL by covering the basic operations of MySQL with reference to similar tasks in your Oracle environment.

High Availability on a Shoestring Budget - Deploying a Minimal Two Node MySQL Galera Cluster

Learn how to set up a Galera cluster with just 2 nodes and use Garbd to retain high availability.

Benchmarking Managed PostgreSQL Cloud Solutions - Part One: Amazon Aurora

A multi-part series of articles on PostgreSQL benchmarking in the cloud. Part one is an overview of available benchmarking tools for PostgreSQL followed by testing Amazon Aurora PostgreSQL based on the Amazon Guide for Benchmarking PostgreSQL.

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.

Migration from Oracle Database to MariaDB - A Deep Dive

Following our recent blogs showcasing how to migrate from Oracle to MySQL/Percona, then to MariaDB and what you should know, this blog offers extra thoughts and insights before you plan to migrate to MariaDB.

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.