MySQL

Long running queries are pretty much inevitable in MySQL or MariaDB, and unfortunately, they can lead to disastrous results. But why do queries take long time to execute? How do you deal with them?This blog post shows how you can use ClusterControl to easily detect them, especially in environments with many database instances.

To insulate our database infrastructure from failures, we build redundant cluster systems. For instance, MySQL and MariaDB high availability can be implemented by master-slave as well as master-master replication solutions. There are a number of variables that affect our choice solution. In this blog, we will look into considerations around latency.

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.

These days high availability is a must for any serious deployment. Long gone are days when you could schedule a downtime of your database for several hours to perform a maintenance. Making a database environment highly available is one of the highest priorities nowadays alongside data integrity. For a database, which is often considered the single source of truth, compromised data integrity can have catastrophic consequences.

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.

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.

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

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Please meet SCUMM - Severalnines CMON Unified Monitoring and Management - our agent-based monitoring infrastructure, which is the cornerstone of our latest ClusterControl release.

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.

Restoring backups on newly deployed clusters can be time consuming. There are a number of procedures and checks to go through, and it is a task that lends itself to automation. This blog post shows you how to automate the entire process and deliver improvements in terms of speed, efficiency and cost.