In a previous post I wrote about how read/write split is implemented in ProxySQL, and what I believe is the best practice for read/write split on top of MySQL servers:

• start sending all traffic to MySQL master
• identify what queries can be routed to the MySQL slaves
• create rules to route these queries

I believe I am remarking that in ProxySQL read/write split is a special case of query routing.
ProxySQL doesn't try to magically perform read/write split for every use case scenarios, but instead it gives you the tools and the power to route traffic dynamically, on demand, through a simple and powerful Admin interface.
It is a tool for DBAs that need to maintain a farm of MySQL servers, and guarantee uptime, high availability, and performance.

In this blog post I will present a use case on how …

In this blog, we’ll look at the

mysqlpump

 utility.

mysqlpump

 is a utility that performs logical backups (which means backing up your data as SQL statements instead of a raw copy of data files). It was added in MySQL Server version 5.7.8, and can be used to dump a database or a set of databases to a file and then loaded on another SQL server (not necessarily a MySQL server).

Its usage is similar to

mysqldump

, but it includes a new set of features. Many of the options are the same, but it was written from scratch to avoid being limited to

mysqldump

 compatibility. The Main Features Include:

• To make the dump process faster, it allows parallel processing of databases and objects within databases.
…

Once again, Pythian is organizing the traditional Open Source Database Community dinner in Santa Clara!

• When: Tuesday April 25, 7pm-10pm
• Where: David’s Restaurant, a short 5-minute walk from the Santa Clara Convention center.
• Tickets: Register here!

Among the attendees will be Pythian’s amazing lineup of speakers at the PerconaLive Conference.

This event is open to all open source database community members who will be in the area; many will be in town for the …

In MySQL 8.0.1, in addition to new as_cs collations (accent sensitive, case sensitive) for utf8mb4, we have also added a new collation for Japanese.

Introducing utf8mb4_ja_0900_as_cs

Collating rules for for Japanese are complex.  Japanese has multiple writing systems with katakana, hiragana, kanji, romaji.…

In a previous post I wrote about how read/write split is implemented in ProxySQL, and what I believe is the best practice for read/write split on top of MySQL servers:

• start sending all traffic to MySQL master
• identify what queries can be routed to the MySQL slaves
• create rules to route these queries

I believe I am remarking that in ProxySQL read/write split is a special case of query routing.
ProxySQL doesn't try to magically perform read/write split for every use case scenarios, but instead it gives you the tools and the power to route traffic dynamically, on demand, through a simple and powerful Admin interface.
It is a tool for DBAs that need to maintain a farm of MySQL servers, and guarantee uptime, high availability, and performance.

In this blog post I will present a use case on how …

In a week, me and some Booking.com colleagues will be in Santa Clara for Percona Live.

Booking.com is sponsoring the conference and we will be present at the Monday Evening Reception.  You do not need a tutorial pass to attend the dinner (even if it is on the tutorial day): any valid pass will do.  If you do not have your ticket yet, it is time to register (you can use the discount code “

While me and Fred were presenting Inexpensive Datamasking for MySQL with ProxySQL at FOSDEM 2017, we got a very interesting question: can ProxySQL be used to obfuscate backups obtained from mysqldump?
The short answer is yes!

Instead of dumping directly from MySQL Server, you can point mysqldump to ProxySQL that will perform the datamasking/obfuscation.
The dump file can then be used to provision new staging database without using production data, and follow compliance requirements.
This extremely simplify the "common" approach of dumping original data and storing it in an not obfuscated format (not good for compliance I believe), load the original data into a database, and finally perform some obfuscating query (that can really take a lot of time).

For this …

While me and Fred were presenting Inexpensive Datamasking for MySQL with ProxySQL at FOSDEM 2017, we got a very interesting question: can ProxySQL be used to obfuscate backups obtained from mysqldump?
The short answer is yes!

Instead of dumping directly from MySQL Server, you can point mysqldump to ProxySQL that will perform the datamasking/obfuscation.
The dump file can then be used to provision new staging database without using production data, and follow compliance requirements.
This extremely simplify the "common" approach of dumping original data and storing it in an not obfuscated format (not good for compliance I believe), load the original data into a database, and finally perform some obfuscating query (that can really take a lot of time).

For this …

Want to get your web development ideas in front of a live audience? The
call for papers for the ConFoo Vancouver 2017 web developer conference is open! If you have
a burning desire to hold forth about PHP, databases, JavaScript, or any
other web development topics, we want to see your proposals. The window is
open only from April 10 to May 8, 2017, so hurry. An added benefit: If your
proposal is selected and you live outside of the Vancouver area, we will
cover your travel and hotel.

You’ll have 45 minutes for the talk, with 35 minutes for your topic and
10 minutes for Q&A. We can’t wait to see your proposals!

Until the talks are picked, the price for the tickets will be at its
lowest. Once …

Consider the scenario that you execute a query. You expect it to be fast - typically subsecond - but now it take not return until after 50 seconds (innodb_lock_wait_timeout seconds) and then it returns with an error:

mysql> UPDATE world.City SET Population = Population + 999 WHERE ID = 130;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

You continue to investigate the issue using the sys.innodb_lock_waits view or the underlying Information Schema tables (INNODB_TRX, INNODB_LOCKS and INNODB_LOCK_WAITS).

Note: …