MariaDB Server 10.4 came with a whole lot of Security related changes. Some of them are merely optimizations (like MDEV-15649), some improve existing features to be more robust (MDEV-15473, MDEV-7598) or convenient (MDEV-12835, MDEV-16266). Some are MySQL compatibility features, requested by our users (MDEV-7597, MDEV-13095). But the first thing any MariaDB Server user, whether an […]
The post Authentication in MariaDB 10.4 — Understanding the Changes appeared first on MariaDB.org.
For some time, there have been several requests to the MySQL dev team to add dedicated support for an admin to connect to the MySQL server. We received a contribution from Facebook, bug#90395 , to add this functionality, which we then paired with more requirements, implemented in WL#12138 and delivered in MySQL Server 8.0.14.…
Facebook Twitter Google+ LinkedIn
When your application get error "too many connections" underlying
problem might be caused by multiple things. For a in-depth
understanding of how MySQL handles connections read this blog.
In this blog we will investigate why and how to solve these
problems when running MySQL installed on Debian/Ubuntu using
systemd (default MySQL packages).
OS: Debian 9
MySQL Server version: 5.7.25 MySQL Community Server (GPL)
(will most likely be the same for MySQL 8.0 versions)
Goal is to have 10.000 working connections to MySQL!
The default value for max_connections is 151 connections so first
step is to increase the max_connections variable to 10.000.
This is documented in the manuals here:
-
https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html
- …
Today is World Backup Day, so I thought I would use the opportunity to discuss some best practices and general considerations regarding backing up MySQL instances. While I focus on MySQL, several of these tips apply to backups in general.
Backup your data
Before heading into the gory details, let’s first take a look at the best practices at a high level:
MySQL introduced Group Replication (GR) in version 5.7, and GR is part of the InnoDB Cluster high-availability solution. InnoDB Cluster consists of Group Replication, MySQL Shell and MySQL Router.
I am not going to explain InnoDB Cluster or Group Replication in this post. So, if you aren’t familiar with either one, I have some previous posts in which I have explained how to work with both. See:
MySQL 8.0 Group Replication – …
[Read more]Why Choose MySQL Replication?
Some basics first about the replication technology. MySQL Replication is not complicated! It is easy to implement, monitor, and tune as there are various resources you can leverage - google being one. MySQL Replication does not contain a lot of configuration variables to tune. SQL_THREAD and IO_THREAD's logical errors aren't that hard to understand and fix. MySQL Replication is very popular nowadays and offers a simple way of implementing database High Availability. Powerful features such as GTID (Global Transaction Identifier) instead of the old-fashioned binary log position, or lossless Semi-Synchronous Replication make it more robust.
Related resources
…
[Read more]
When you write stored procedures in MySQL, you sometimes need to
generate queries on the fly, for example as you process the
result of another query. This is supported using prepared statements. This blog explores how
you can take advantage of the sys schema to simplify
the use of dynamic queries.
Executing a query using the sys.execute_prepared_stmt() procedure.
The sys schema includes several stored procedures
and functions as well as views to make the database
administrator’s life easier. One of these is the …
In case you missed the Multimaster webinar recorded live on Thursday, March 28th, 2019:
Learn how NewVoiceMedia built a global, multi-region MySQL cloud back-end to support a high-volume cloud contact center.
Agenda:
Find out how to deploy Multimaster MySQL / MariaDB / Percona with the following design criteria:
Speaker:
Chris Parker
Director of Professional Services – EMEA/APAC, is based in the UK, and has over 20 years …
[Read more]So we have seen until now different built-in ways to easily collect diagnostics information on MySQL server at different level (Instance/Thread/Statement) :
But what about analyzing database load ? Does MySQL has a build-in way to display Active Session History ?
MySQL already offer an easy way to display currently active session using the “sys”.”session” view for example but sadly there is no build-in active …
[Read more]Long running queries/statements/transactions are sometimes inevitable in a MySQL environment. In some occasions, a long running query could be a catalyst to a disastrous event. If you care about your database, optimizing query performance and detecting long running queries must be performed regularly. Things do get harder though when multiple instances in a group or cluster are involved.
When dealing with multiple nodes, the repetitive tasks to check every single node is something that we have to avoid. ClusterControl monitors multiple aspects of your database server, including queries. ClusterControl aggregates all the query-related information from all nodes in the group or cluster to provide a centralized view of workload. Right there is a great way to understand your cluster as a whole with minimal effort.
In this blog post, we show you how to detect MySQL long running queries using ClusterControl.
Why a Query Takes …
[Read more]