This year was even more hard than previous years are we received 76 amazing submission ! 76 !!

The Committee had the difficult task to choose only 15 of them.

This is the list of the talks that were accepted:

Get your Percona Live Open Source Database Conference 2018 Super Saver tickets now.

The countdown is on for the annual Percona Live Open Source Database Conference 2018! The conference takes place in Santa Clara, CA from April 23-25, 2018. The theme is Championing Open Source Databases, and the three-day conference will focus on the latest trends, news and best practices in MySQL, MongoDB, PostgreSQL and other open source databases. It includes tracks on time series data, cloud databases, operations, business/case studies and more.

This year’s conference will feature one day of tutorials and …

With MySQL version 5.7.11 and up, Oracle continues to improve MySQL’s security features by adding MySQL Enterprise Transparent Data Encryption (TDE) for InnoDB tables stored in innodb_file_per_table tablespaces. This feature provides at-rest encryption for physical tablespace data files.

MySQL Enterprise TDE uses a two-tier encryption key architecture, consisting of a master encryption key and tablespace keys. When an InnoDB table is encrypted, a tablespace key is encrypted with the master key and the encrypted value of the tablespace key is stored in the tablespace header. When encrypting tablespace data, InnoDB transparently uses the master encryption key …

Working in an operations environment means that you get a lot of questions.  There’s the inevitable troubleshooting tasks that go along with being a DBA.  This is designed to be a quick reference post, much like my more in depth post in 2016 about timeouts. These typical error messages can create confusion and unneeded activities to diagnose.  To aid my own process of elimination and those of others, here are three error messages every DBA should know by heart.

SQLSTATE[HY000] [2002] Connection timed out

Plain and simple: this error means the client cannot connect to the server.

• The calling program is trying to connect to the wrong database server (one that it cannot reach).
• The database server is completely down (you’d get another error if the server and client actually made a connection). …

While investigating alternatives to migrate to Google Cloud SQL, I encountered a lack of support for external masters. However, it’s possible to overcome this limitation by replicating into Google Cloud SQL using Tungsten replicator.

Cloud SQL is Google’s database-as-a-service solution, similar to RDS for Amazon Web Services. You can get a fully managed database in only a few clicks (or API calls). At the time of writing this, the only supported databases are MySQL and Postgres.

Cloud SQL alternatives

Google offers two different options for MySQL deployments.

1st generation instances:

• Only MySQL versions 5.5 and 5.6 can provisioned
• Max memory is limited to 16 Gb
• Max of 250 Gb storage (up to 500 Gb with Silver or higher support package)
• MyISAM and InnoDB
• Asynchronous replication for read replicas

2nd generation instances:

Percona’s Technical Director of Quality Assurance Roel Van de Paar shares his findings on the quality of MySQL 8.0.3 RC.

On 21 September 2017, our upstream friends at Oracle released MySQL 8.0.3 RC as the first MySQL 8.0 Release Candidate.

I tested the MySQL 8.0.3 Release Candidate branch with selected Percona bugfixes applied and built it as debug using the pquery QA framework (freely available here). Percona releases Percona Server for MySQL – an improved fork of the MySQL server – with additional features and bug patches.

Any QA engineer would enjoy seeing the many bugs discovered:

================ [Run: 079328] Sorted unique issue strings (11258 trials executed, …

“We wanted a solution which was backward compatible with our frameworks, as we have used mainly MySQL, which was reliable and nearly 100% data consistent.  If our application were to execute a commit and receive a successful response, we needed a 100% guarantee that we have rows of data in our database — and for more than that one instance.”

There were many options E-CARD explored. “First, we tried MySQL NDB Cluster. That was a very frustrating experience. After that we tried a few other plugins and extensions of MySQL, but they weren’t complete solutions. At the end of this process, we found Galera with MySQL. It responded to our needs nearly 100% of the time.”

Read the full story

Bulgarian National Lottery chooses Galera Cluster

Join Percona’s Chief Evangelist, Colin Charles as he presents 2017 Year in Review for Open Source Database Software on Wednesday, December 13, 2017 at 7:00 am PST / 10:00 am EST (UTC-8).

Register Here

2017 is soon coming to an end, and it’s good to pause and take a look at the past year to see the impact of new software release. Colin will discuss the changes, growth and trends that have affected software producers and enterprises using open source.

Key topics will include:

• How has the software supply chain landscape …

After upgrading some of our slaves to latest 5.7, I have found  what looks like a serious regression introduced in MySQL 5.7.
A couple weeks ago I noticed that the error log file of one of our clusters, where I had implemented my in place transparent compression of binary logs,  was literally flooded by the following error:

[ERROR] Binlog has bad magic number;  It's not a binary log file that can be used by this version of MySQL

In the above setup this is  an harmless error, and it should only happen at server startup, where mysqld opens and reads all available binary log files.  The error is due to the fact that since files are now compressed, mysqld doesn't recognize them as valid - not an issue, as only older files are compressed, and only after …

We have brought further enhancement to MySQL Group Replication 5.7 release by backporting some most requested features to MySQL 5.7.20 release:

• Member weight for automatic primary election on failover
• Disallow writes after leaving the group

And to MySQL 5.7.19 release:

• Transaction savepoint support

Member weight for automatic primary election on failover

The Member weight for automatic primary election on failover feature will allow user to influence primary member election using a integer member weight value.…