Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Percona announces the release of Percona Server 5.6.32-78.0 on August 22nd, 2016. Download the latest version from the Percona web site or the Percona Software Repositories.
Based on MySQL 5.6.32, including all the bug fixes in it, Percona Server 5.6.32-78.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – this is the …
[Read more]In this post, we’ll look at a scalability fix for issues the query rewrite plugin had on performance.
Several months ago, Vadim blogged about the impact of a query rewrite plugin on performance. We decided to re-evaluate the latest release of 5.7(5.7.14), which includes fixes for this issue.
I reran tests for MySQL 5.7.13 and 5.7.14 using the same setup and the same test: sysbench OLTP_RO without and with the query rewrite plugin enabled.
MySQL 5.7.14 performs much better, with almost no overhead. Let’s check PMP for these runs:
MySQL 5.7.13
206 …[Read more]
Dear MySQL users,
MySQL Connector/Net 7.0.4 is the first development release that expands cross-platform support to Linux and OS X when using Microsoft’s .NET Core framework. Now, .NET developers can use the X DevAPI with .NET Core and Entity Framework Core (EF Core) 1.0 to create server applications that run on Windows, Linux and OS X. We are very excited about this change and really look forward to your feedback on it!
MySQL Connector/Net 7.0.4 is also the third development release of MySQL Connector/Net to add support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL.
To learn more about how to write applications using the X DevAPI, …
[Read more]Dear MySQL users,
MySQL Connector/Net 6.8.8 and 6.9.9 are maintenance releases for the 6.8 and 6.9 series of the .NET driver for MySQL. They can be used for production environments.
It is appropriate for use with MySQL server versions 5.5-5.7.
These are now available in source and binary form from our downloads and mirror sites. (note that not all mirror sites may be up to date at this point-if you can’t find this version on some mirror, please try again later or choose another download site.)
Functionality Added or Changed
Bugs Fixed
MySQL Group Replication is just one component of the upcoming MySQL HA Solution as Matt Lord explained it in his GR quick start guide. So while mysql-router is back to school to become smarter and learn how to take the right decision we can already use existing 3rd party solutions. To be honest, if people are already using a load balancer/proxy with MySQL asynchronous, semi-sync or other virtual synchronous solution and want to evaluate and migrate to MySQL’s native Group Replication, they might not migrate load balancer at the same time as they move to GR. Step-by-step migration, one component at the time is always recommended in complex architecture.
So in this post, I want to cover HAProxy and a dedicated health check related to what might be the more common architecture. Matt already explained in his start guide how to use …
[Read more]We recently made a number of enhancements to the ClusterControl Ansible Role, so it now also supports automatic deployment of MySQL-based systems (MySQL Replication, Galera Cluster, NDB Cluster). The updated role uses the awesome ClusterControl RPC interface to automate deployments. It is available at Ansible Galaxy and Github.
TLDR; It is now possible to define your database clusters directly in a playbook (see below example), and let Ansible and ClusterControl automate the entire deployment:
cc_cluster:
- deployment: true
operation: "create"
cluster_type: "galera"
mysql_hostnames:
- "192.168.1.101"
- "192.168.1.102"
- "192.168.1.103"
mysql_password: "MyPassword2016"
mysql_port: 3306
mysql_version: "5.6" …[Read more]
All of us are very good in writing good queries, we know that ;)
but sometimes a bad query may escape our control and hit (badly)
our database.
There is also that probie, who just join the company and is writing all his code with SELECT * and no WHERE.
We have told him millions of time that doing this is bad, but he seems not listening.
Ah the other day we had another code injection that developers
will take some time to fix, and that take them some time to
isolate the part of the code sending the killing query to our
database.
All the above are true stories, things that happen every day in at least few environments.
The main problem in that case is not to isolate the bad query,
that is something that we can do very fast, but to identify the
code that is generating it and disable that part of the code
without killing the whole application.
That part can takes days. …
[Read more]Some time ago, feedback was requested on new replication default after MySQL 5.7. Some of the suggested default are:
relay-log-info-repository = TABLE (previous default FILE) relay-log-recovery = ON (previous default OFF) master-info-repository = TABLE (previous default FILE) sync-master-info = 1,000 (previous default 10,000) sync-relay-log = 1,000 (previous default 10,000)
I agree on the
Recently a colleague of mine ask me to provide a simple example
on how ProxySQL can perform sharding.
ProxySQL is a very powerful platform that allow us to manipulate
and manage our connections and query in a simple but effective
way.
In this article I will show you how.
{autotoc enabled=yes}
Before starting is better to clarify some basic concepts.
ProxySQL organize its internal set of servers in Host Groups (HG), each HG can be associate to users and to Query Rules (QR).
Each QR can be final (apply = 1) or can let ProxySQL continue to parse other QR.
A QR can be a rewrite action, or can be a simple match, it can have a specific target HG, or be generic, finally QR are defined using regex.
You can see QR as a sequence of filters and transformation that you can arrange as you like.
These simple basic rules give us enormous flexibility, …
[Read more]
Recently a colleague of mine ask me to provide a simple example
on how ProxySQL can perform sharding.
ProxySQL is a very powerful platform that allow us to manipulate
and manage our connections and query in a simple but effective
way.
In this article I will show you how.
{autotoc enabled=yes}
Before starting is better to clarify some basic concepts.
ProxySQL organize its internal set of servers in Host Groups (HG), each HG can be associate to users and to Query Rules (QR).
Each QR can be final (apply = 1) or can let ProxySQL continue to parse other QR.
A QR can be a rewrite action, or can be a simple match, it can have a specific target HG, or be generic, finally QR are defined using regex.
You can see QR as a sequence of filters and transformation that you can arrange as you like.
These simple basic rules give us enormous flexibility, …
[Read more]