J-F Gagné's MySQL Blog

Here are the last details about the Percona Live 2016 Community Dinner hosted at Booking.com : you can still register the menu is below...

Or should I say "to avoid getting soaked"... The  Amsterdam weather forecasts  for next week is out and even if it looks good fo...

I have a new blog post on blog.booking.com  describing MariaDB 10.1 Optimistic Parallel Replication (with benchmark results): Evaluating M...

If you are in San Francisco for Oracle Open World , here is the list of talks by Booking.com : MySQL’s State of the Dolphin and Customer E...

Percona Live Amsterdam is in 3 weeks, and on the evening of the second day of the conference (Tuesday October 4th 2016), there is the tradi...

Some time ago, feedback was requested on new replication default after MySQL 5.7 .  Some of the suggested default are: relay-log-info-repo...

In a previous post, I presented an Unexpected Memory Consumption for Bulk Index Creation in InnoDB .  This was triggered by an increased inn...

I am very happy that my talk,  MySQL Parallel Replication: inventory, use-cases and limitations , is included in the Sneak Peek of Percona ...

In a few days, I will be flying to San Francisco and then making my way to Santa Clara to attend the Percona Live Conference .  On the last...

Reminder: MTS = Multi-Threaded Slave. Update 2017-04-17 : since the publication of this post, many things happened: the procedure for fi...

This year, Percona introduced Community Voting for Percona Live submission.  This is what you can read on the conference website: In an e...

And by MySQL Ecosystem here, I do not only include Oracle but also MariaDB.

A common way to implement point in time recovery capability is: to regularly do a full backup of a database, and to save the binary logs...

Update 2016-01-30 : restarting the IO_THREAD might be considered useful in some situations (avoiding MDEV-9138 ).  Look for "in contras...

In the spirit of sharing war stories and avoiding others to do the same mistakes as I did, here are some sequences of commands that you shou...

Or should I say to: "not to get soaked"... The Amsterdam weather forecasts  for next week is out  and it does not look so good d...

http://blog.booking.com/abstracting_binlog_servers_and_mysql_master_promotion_wo_reconfiguring_slaves.html Follow the link above to read m...

In my last Booking.com Hackathon , I worked on MyISAM vs InnoDB for data loading ( LOAD DATA IN FILE ) and bulk index creation.  My motivat...

My latest post is online on the Booking.com blog : Evaluating MySQL Parallel Replication Part 3: Benchmarks in Production .  In this post, ...

The link to the slides of my talks can be found at the end of this post but first, let me share some thoughts about PLMCE . Talking with p...

Note: DO NOT use this procedure in production, this is a proof of concept ( POC ).  MaxScale 1.1.0 does not yet fully support that procedur...

In the  Install and Configure HOWTO , we learned how to install and configure a MaxScale Binlog Server.  In this HOWTO, I will present the c...

Updated 2015-04-25 : add the link to the slides of my PLMCE talk and a link to a bug number. MaxScale 1.1.0 is out and includes the new  ...

Dealing with the failure of a MySQL master is not simple.  The most common solution is to promote a slave as the new master but in an enviro...

http://blog.booking.com/evaluating_mysql_parallel_replication_2-slave_group_commit.html Follow the link above to read my latest article on...

One year ago, I blogged about  Evaluation and Online Migration of MySQL 5.6 GTIDs .  At that time, we setup the following test environment w...

http://blog.booking.com/better_parallel_replication_for_mysql.html Follow the link above to read my latest article on the  Booking.com   d...

I just publish a post on the Booking.com blog: http://blog.booking.com/better_crash_safe_replication_for_mysql.html  Spoiler: it uses Binlo...

The other day, I was discussing high availability ( HA ) with other people.  The discussion was going in the direction of, as the applicatio...