Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

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.

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.

MySQL to MongoDB - An Admin Cheat Sheet

This blog provides a quick reference for DBAs and SysAdmins who are either new to MySQL or MongoDB with regards to the terms and commands available within the database and how they compare with one another.

How Roles Have Changed in MySQL 8.0 and How to Use Them

Making sure the right people have access to your MySQL data is very important. This blog shares what has changed with user management in MySQL 8.0.

MySQL Performance Benchmarking: MySQL 5.7 vs MySQL 8.0

MySQL 8.0 features a lot of great improvements, comprehensive support for technologies, and most importantly, its enhanced performance under high read/write workloads. In this blog, we’ll have a look at how MySQL 8.0 performs as compared to its predecessor MySQL 5.7.