lefred's blog


There Are 10 Types of People in the World....

Howto make MySQL point-in-time recovery faster ?

Before explaining how you can improve the speed for performing point-in-time recovery, let’s recall what is Point-In-Time Recovery and how it’s usually performed. Point-in-Time Recovery, PTR Point-In-Time recovery is a technique of restoring your data until a certain point (usually until an event that you would like that has never happened). For example, a user did a mistake and you … Read More


Migration from MySQL Master-Slave pair to MySQL InnoDB Cluster: howto

MySQL InnoDB Cluster (or only Group Replication) becomes more and more popular. This solution doesn’t attract only experts anymore. On social medias, forums and other discussions, people are asking me what it the best way to migrate a running environment using traditional asynchronous replication [Master -> Slave(s)] to InnoDB Cluster.


MySQL Shell: eye candy for a future release !

  Today I presented MySQL InnoDB Cluster at the Helsinki MySQL User Group. To demonstrate how easy it’s to deploy a cluster with MySQL Shell and used the prompt that will be part of a future release just because it’s beautiful. If you also want to see how it looks like, just check the video below: There were several MongoDB … Read More


MySQL Group Replication and logical backup

Taking a logical backup of a member of a Group Replication Cluster is not something very easy. Currently (5.7.17, 5.7.18 or 8.0.0) if you want to use mysqldump to take a logical backup of your dataset, you need to lock all the tables on the member you are taking the dump. Indeed, a single transaction can’t be used as savepoints … Read More


OpenWorld 2017 Call for Papers Closing Soon!

Time is running out to submit a talk for OpenWorld 2017 that will table place on October 1–5, 2017 in San Francisco, CA.  If you are looking for inspiration on what talk to submit, we encourage you to submit a case study.  We would love to hear how you are using MySQL as part of your data platform, and your … Read More


recent

Last Tweets Last Tweets

Locations of visitors to this page
categories