Buy Percona SupportEmergency? Get 24/7 Help Now!

Percona XtraDB Cluster 5.7.14-26.17 GA is now available

Latest MySQL Performance Blog posts - September 29, 2016 - 7:05am

This Percona XtraDB Cluster 5.7.14-26.17 GA release is dedicated to the memory of Federico Goncalvez, our colleague with Percona’s Uruguayan team until his tragic death on September 6, 2016.

Fede, we miss you.

Percona announces the first general availability (GA) release in the Percona XtraDB Cluster 5.7 series on September 29, 2016. Binaries are available from the downloads area or our software repositories.

The full release notes are available here.

Percona XtraDB Cluster 5.7.14-26.17 GA is based on the following:

For information about the changes and new features introduced in Percona Server 5.7, see Changed in Percona Server 5.7.

Percona XtraDB Cluster 5.7.14-26.17 GA New Features

This is a list of the most important features introduced in Percona XtraDB Cluster 5.7 compared to version 5.6:

  • PXC Strict Mode saves your workload from experimental and unsupported features.
  • Support for monitoring Galera Library instruments and other wsrep instruments as part of Performance Schema.
  • Support for encrypted tablespaces in Multi-Master Topology, which enables Percona XtraDB Cluster to wire encrypted tablespace to new booting node.
  • Compatibility with ProxySQL, including a quick configuration script.
  • Support for monitoring Percona XtraDB Cluster nodes using Percona Monitoring and Management
  • More stable and robust operation with MySQL and Percona Server version 5.7.14, as well as Galera 3.17 compatibility. Includes all upstream bug fixes, improved logging and more.
  • Simplified packaging for Percona XtraDB Cluster to a single package that installs everything it needs, including the Galera library.
  • Support for latest Percona XtraBackup with enhanced security checks.
Bug Fixes
  • Fixed crash when a local transaction (such as EXPLAIN or SHOW) is interrupted by a replicated transaction with higher priority (like ALTER that changes table structure and can thus affect the result of the local transaction).
  • Fixed DONOR node getting stuck in Joined state after successful SST.
  • Fixed error message when altering non-existent table with pxc-strict-mode enabled.
  • Fixed path to the directory in percona-xtradb-cluster-shared.conf.
  • Fixed setting of seqno in grastate.dat to -1 on clean shutdown.
  • Fixed failure of asynchronous TOI actions (like DROP) for non-primary nodes.
  • Fixed replacing of my.cnf during upgrade from 5.6 to 5.7.
Security Fixes
  • CVE-2016-6662
  • CVE-2016-6663
  • CVE-2016-6664

For more information, see this blog post.

Other Improvements
  • Added support of defaults-group-suffix for SST scripts.

Help us improve our software quality by reporting any bugs you encounter using our bug tracking system. As always, thanks for your continued support of Percona!

7 Fresh Bugs in MySQL 8.0

Latest MySQL Performance Blog posts - September 28, 2016 - 11:19am

This blog post will look at seven bugs in MySQL 8.0.

Friday afternoon is always ideal for a quick look at the early quality of MySQL 8.0! Last Friday, I did just that.

If you haven’t heard the news yet, MySQL 8.0 DMR is available for download on!

Tools to the ready: pquery2, updated 8.0 compatible scripts in Percona-qa and some advanced regex to wade through the many cores generated by the test run. For those of you who know and use, this should mean a lot!

[09:41:50] [21492] ====== TRIAL #39308 ======

In other words, almost 40K trials and 21.5K core dumps (or other significant issues) detected! This run had been churning away on a server for a number of days. On to the bug logging fun!

After reducing test cases, and filtering duplicates, we have the following seven bugs logged in upstream;

  • Bug #83120 virtual void Field::store_timestamp(const timeval*): Assertion ‘false’ failed.
  • Bug #83118 handle_fatal_signal (sig=11) in replace_user_table
  • Bug #83117 Assertion MDL_checker::is_read_locked(m_thd, *object)’ failed.
  • Bug #83115 Assertion ‘maybe_null’ failed. handle_fatal_signal in tem_func_concat::val_str
  • Bug #83114 Assertion `strlen(db_name) <= (64*3) && strlen(table_name) <= (64*3)’ failed.
  • Bug #83113 SIGKILL myself on DROP TABLE
  • Bug #83112 handle_fatal_signal (sig=11) in sp_get_flags_for_command

My first impressions?

MySQL 8.0 DMR is a reasonably solid release for a first iteration.

It seems our friends at upstream are on an excellent path to making MySQL 8.0 another rock-solid release. Chapeau!

Percona Live Europe featured talk with John De Goes — MongoDB Analytics & Dashboards

Latest MySQL Performance Blog posts - September 28, 2016 - 8:46am

Welcome to another Percona Live Europe featured talk with Percona Live Europe 2016: Amsterdam speakers! In this series of blogs, we’ll highlight some of the speakers that will be at this year’s conference. We’ll also discuss the technologies and outlooks of the speakers themselves. Make sure to read to the end to get a special Percona Live Europe registration bonus!

In this Percona Live Europe featured talk, we’ll meet John De Goes, CTO at SlamData Inc. His talk will be on MongoDB Analytics & Dashboards. SlamData is an open source analytics and reporting solution designed specifically for MongoDB. SlamData lets anyone build live analytics, charts, and dashboards on any type of data inside MongoDB. Because SlamData runs all queries inside the database, reports are always up to date and can scale to the largest MongoDB deployments.

I had a chance to speak with John and learn a bit more about analytics for businesses:

Percona: Give me a brief history of yourself: how you got into database development, where you work, what you love about it.

John: I work as the CTO at SlamData, where we build open source software that helps companies understand complex data stored in modern databases.

I love my job. We’re solving a huge pain point for businesses, and we get to do that through open source. The technical challenges we’ve had to overcome (and have yet to overcome!) can be really difficult, but that’s what makes it so fun.

Percona: Your talk is called “MongoDB Analytics & Dashboards.” What are some of the more important data sets in MongoDB for people to monitor, and how does SlamData work to provide easy analysis of those data?

John: We use MongoDB to build data hubs, which pull together lots of different types of data into a single database. SlamData’s really useful for that case because you can explore many complex kinds of data, no matter how nested or irregular, then refine the data and build beautiful interactive reports and dashboards that can be used by non-technical people.

Developers also use MongoDB to build web and mobile applications, which tend to collect a lot of data about the product and the users. Normal analytics tools don’t work with MongoDB, because the data model is too complex. But we built SlamData to handle complex data, we make it very easy to do product and user analytics on top MongoDB databases.

Percona: Why are data dashboards important for businesses? How can businesses use the data to improve processes or realize revenues?

John: Analytics serve one of two major roles in today’s businesses. Firstly, tech companies use analytics to build product features. For example, if you built a marketing application for businesses, then your customers probably want their own analytics dashboard that’s embedded into the product. If you built your application on a modern database like MongoDB, then SlamData makes it very easy for developers to add these beautiful, interactive and secure dashboards into their applications.

Secondly, all kinds of companies store user profile, user event and product data inside databases. Businesses can use this information to better understand their customer makeup, what users are doing, how they are using internal or external applications, and how one data set relates to another. These insights help businesses improve business processes, such as allocating marketing spend or directing product development resources. This is the classic use case for Business Intelligence (BI) and reporting software, and SlamData really shines here, because you can just get to work on any kind of data, no matter how much or little structure it might have.

Percona: What is changing in how businesses use data that keeps you awake at night? What tools or features are you looking might you be thinking about to address these issues?

John: Businesses are moving away from traditional data warehousing. They don’t want to spend millions of dollars a year licensing a big clunky piece of technology that never has all the data, and which is always out of date. They want agile solutions that they can point to any source of data, no matter where it is, and no matter what structure it has, and begin answering the questions they have.

This is the single biggest shift in how companies want to consume analytics. The other two important ones are the democratization of analytics, which is a fancy way of saying business users want to do more and bottleneck less on IT, and the increasing use of web and mobile analytics solutions.

SlamData is built web- and mobile-first, and the core technology relies a lot on pushing computation down into data sources to minimize the need to involve IT. But nonetheless, it’s a new paradigm, and building this sort of technology that addresses the need for analytics agility is not easy. It’s taken us two and a half years to get this far, and we’re still barely halfway in.

Percona: What are you looking forward to the most at Percona Live Europe this year?

John: I’m from the USA, so I’m interested in seeing what tools and processes professionals in Europe are using to manage data requirements. I’ll be comparing notes. It’s going to be a blast!

You can read more about John and his thoughts on MongoDB analytics at his twitter handle.

Want to find out more about John, SlamData, and analytics? Register for Percona Live Europe 2016, and come see his talk MongoDB Analytics & Dashboards.

Use the code FeaturedTalk and receive €25 off the current registration price!

Percona Live Europe 2016: Amsterdam is the premier event for the diverse and active open source database community. The conferences have a technical focus with an emphasis on the core topics of MySQL, MongoDB, and other open source databases. Percona live tackles subjects such as analytics, architecture and design, security, operations, scalability and performance. It also provides in-depth discussions for your high-availability, IoT, cloud, big data and other changing business needs. This conference is an opportunity to network with peers and technology professionals by bringing together accomplished DBA’s, system architects and developers from around the world to share their knowledge and experience. All of these people help you learn how to tackle your open source database challenges in a whole new way.

This conference has something for everyone!

Percona Live Europe 2016: Amsterdam is October 3-5 at the Mövenpick Hotel Amsterdam City Centre.

Amsterdam eWeek

Percona Live Europe 2016 is part of Amsterdam eWeek. Amsterdam eWeek provides a platform for national and international companies that focus on online marketing, media and technology and for business managers and entrepreneurs who use them, whether it comes to retail, healthcare, finance, game industry or media. Check it out!

General Inquiries

For general inquiries, please send us your question and someone will contact you.