Introduction

Sometimes the best way to repair data issues and problems within a MySQL database is to restore only some of the tables from a backup. For example, suppose that some data was accidentally deleted from one table due to a software error, then the easiest way to recover the lost data might be to restore only one table from a backup. Previously this kind of partial restore was not supported by MySQL Enterprise Backup (MEB). However, MEB 3.11 introduces support for selective restore from backups created with the --use-tts option (or TTS backups).

TTS backups are backups that are created with the transportable tablespaces feature of InnoDB. These backups consist of InnoDB tables that …

Thank you to all of you who attended my webinar last week about Global Transaction IDs (GTIDs), which were introduced in MySQL 5.6 to make the reconfiguration of replication straightforward. If you missed my webinar, you can still listen to the recording and download the sides (free). We had a lot of questions during the webinar, so let me try to answer them here. Please let me know in the comments if additional clarification is needed.

Q: Does GTID provide any benefit to master-master replication? If yes, how?
Q: Is ACTIVE ACTIVE MASTER MASTER successful in MySQL with GTID? …

In some cases it is not possible to use an index to optimize a JOIN. This may for example happen when you query the Performance Schema. As a result these kind of queries can be very slow; however in MySQL 5.6 and later you can use a trick to improve the performance considerably.

As a working example in this post, I will use the schema_table_statistics view in the sys schema. Since the view involves the schema, I will create a reasonable large number of databases and tables for the test:

shell$ for ((i=0; i<100; i++)); do
>    echo "Database ${i}"
>    mysql -e "CREATE DATABASE db${i}"
>    for ((j=0; j<100; j++)); do
>        mysql -e "CREATE TABLE db${i}.t${j} (id int unsigned NOT NULL auto_increment PRIMARY KEY, val varchar(10) NOT NULL) …

Daniel was tracking down what appeared to be a networking problem….

• server reported 113 (No route to host)
• However, an strace did not reveal the networking stack ever returning that.
• On the other side, IP packets were actually received.
• When confronted with mysteries like this, I get suspicious – mainly of (fellow) programmers.
• I suggested a grep through the source code, which revealed  return -EHOSTUNREACH;
• Mystery solved, which allowed us to find what was actually going on.

Lessons:

1. Don’t just believe or presume the supposed origin of an error.
2. Programmers often take shortcuts that cause grief later. I fully appreciate how the above code came about, but I still think it was wrong. Mapping a “similar” situation onto an existing …

Continuent is delighted to announce an exciting Continuent Tungsten feature addition for MySQL users: replication in real-time from MySQL into Amazon RedShift.  

In this webinar-on-demand we survey Continuent Tungsten capabilities for data warehouse loading, then zero in on practical details of setting up replication from MySQL into RedShift.  We cover:

Introduction to real-time movement

My new book on 3D printing has been published! I must say this work has been a real joy to write. It's the book I wish existed when I first started playing with 3D printers.

Like most people who started with building their own 3D printer from scratch, I struggled to learn the concepts and get a firm foundation for how the machines work and how to work with them. I was dismayed by the lack of documentation and help available from most vendors. Indeed, most tend to say things like "do a Google search" rather than answer your questions directly.

Fortunately, there is a lot of information out there about 3D printing, especially from the RepRap community. Unfortunately, the sheer volume can be overwhelming for most and in some cases the information is either not entirely correct or is too specific for a certain printer to be a solution you can use. Furthermore, it can take hours to sift through the data to find what you need …

In keeping with a MySQL tradition, we will be holding a storage engine vendors meeting to coincide with MySQL Central @ Open World this year.

The day and venue is TBD, but will be in the San Francisco/Bay Area week of 29th September - October 3rd.

For an invitation, please send me an email!

Jothir wrote great blog post, introducing MEB's "Backup to Cloud" feature. And while this blog post is great source of information for Amazon users who consider using MEB it is not so clear how to setup the cloud storage itself for those MEB users who are only considering storing backups in the Cloud. I actually was one of them and decided to share my experience.

OK, so what do you need to start using MEB with Amazon S3 service?

1. Amazon AWS account. You can register it for free at https://portal.aws.amazon.com/gp/aws/developer/registration/index.html
2. A bucket where …

Innodb 5.5 and 5.6 does not support export/import of individual partitions and hence MEB selective backup does not support it

MEB 3.11 supported on MySQL versions 5.5 and 5.6.