Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

How to Run and Configure ProxySQL 2.0 for MySQL Galera Cluster on Docker

ProxySQL 2.0 has become GA and it comes with new exciting features such as GTID consistent reads, frontend SSL, Galera and MySQL Group Replication native support. This blog post shows how to run the new ProxySQL 2.x for Galera Cluster on Docker container, which is quite a bit different as compared to ProxySQL 1.x.

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.

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.

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.

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.

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.

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.

Considerations for Administering MongoDB

This is an excerpt from our whitepaper “MongoDB Management and Automation with ClusterControl”. This white paper reviews the challenges involved in managing MongoDB at scale and introduces mitigating features of ClusterControl from Severalnines. As a best of breed database management solution, ClusterControl brings consistency and reliability to your database environment, and simplifies your database operations at scale.

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.

An Overview of the Index Changes in PostgreSQL 11

PostgreSQL 11 introduced several changes to the way it handles database indexes. In this blog, we provide an overview of these changes and how you can take advantage of them.

Pages