In this blog, I will provide answers to the Q & A for the Performance Schema for MySQL Troubleshooting webinar.
First, I want to thank everybody for attending my March 1, 2018, webinar. The recording and slides for the webinar are available here. Below is the list of your questions that I was unable to answer fully during the webinar.
Q: Is Workbench able to take advantage of the enhancements to Perf schema?
A: MySQL Workbench is a graphical tool for database …
[Read more]Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible.
There are a number of significant updates in Percona Monitoring and Management 1.9.0 that we hope you will like, some of the key highlights include:
We are happy to announce a list of events which we - MySQL &/or MySQL Community Team - are attending and speaking at during the period of time of April to June 2018. Please be aware that the list does not have to be final, during the time more events could be added or some of them removed.
April 2018:
PHP Yorkshire, Yorkshire, UK, April 13-Workshop, April 14-Conference, 2018
In this blog post, we’ll compare the performance of pattern matching queries vs. full-text indexes.
In my previous blog post, I looked for a
solution on how we can search only a part of the email address
and how can we make faster queries where the condition is
email LIKE '%n.pierre%'. I showed two possible ways
that could work. Of course, they had some pros and cons as well
but were more efficient and faster than a like
'%n.prierre%'.
But you could also ask why I would bother with this? Let’s add a FULLTEXT index, and everybody is happy! Are you sure about that? I’m not. Let’s investigate and test a bit. (We have some nice blog posts that explain how FULLTEXT …
[Read more]In order to spot database misuse and/or to prove compliance to popular regulations including GDPR, PCI DSS, HIPAA, ... database administrators can be required to record and audit database activities. In this fifth episode of the MySQL Security series, we will see what MySQL Enterprise Audit provide to help organizations implement stronger security controls and satisfy regulatory compliance.
In this post, we'll look at how to implement ProxySQL with AWS Aurora. Recently, there have been a few discussions and customer requests that focused on AWS Aurora and how to make the various architectures and solutions more flexible. Flexible how, you may ask? Well, there are the usual expectations:
The inclusion of ProxySQL solves many of the points above. We in Consulting design the solutions for our customers by applying the different functionalities to better match customers needs. Whenever we deal with Aurora, we've had …
[Read more]In this blog post, I’ll look at how you can use ProxySQL with AWS Aurora to further leverage database performance.
My previous article described how easy is to replace the native Aurora connector with ProxySQL. In this article, you will see WHY you should do that.
It is important to understand that aside from the basic optimization in the connectivity and connection management, ProxySQL also provides you with a new set of features that currently are not available in Aurora.
Just think:
We will cover areas like scalability, security and performance. In short, I think is more than worth it to spend some time and give …
[Read more]In this post, we’ll look at how to implement ProxySQL with AWS Aurora.
Recently, there have been a few discussions and customer requests that focused on AWS Aurora and how to make the various architectures and solutions more flexible.
Flexible how, you may ask? Well, there are the usual expectations:
The inclusion of ProxySQL solves many of the points above. We in Consulting design the solutions for our customers by applying the different functionalities to better match customers needs. Whenever we deal …
[Read more]MySQL 8.0 introduces partial update of JSON values, which is a nice performance improvement for applications that frequently update small portions of large JSON documents. Before, in MySQL 5.7, whenever you made a change to a stored JSON document, the full new JSON document would be written to the database, even if the update just changed a few bytes in the document.…
Recently on MySQL Forums, somebody was looking for documentation or procedure to upgrade a MySQL InnoDB Cluster (or Group Replication cluster) to a newer version.
In this post I am illustrating the best practices to achieve this task safely.
To illustrate the procedure, I will use an InnoDB Cluster of 3
members: mysql1, mysql2 and
mysql3. The cluster is setup in Single-Primary mode
(mysql1) and runs MySQL 5.7.21.
Let’s have a look at the cluster status:
MySQL / mysql1:3306 / JS / cluster.status()
{
"clusterName": "MyCluster",
"defaultReplicaSet": {
"name": "default",
"primary": "mysql1:3306",
"ssl": "DISABLED",
"status": "OK",
"statusText": "Cluster is ONLINE and can tolerate up to …[Read more]