Personal blog of Yzmir Ramirez

We’re excited to announce that both Percona Server for MySQL and Percona XtraBackup now support the ARM64 architecture on Red Hat Enterprise Linux (RHEL) 8/9 and Oracle Linux (OL) 8/9. The packages with the aarch64.rpm extension can be found on Percona Software Downloads. The aarch64.rpm file extension indicates that the RPM package is specifically built for the ARM64 architecture and intended […]

After having been in long-term support (LTS) for the past two years, Debian 9 (“Stretch”) has now reached End of Life (EOL) on 2022-06-30.

We generally align our OS platform end-of-life dates with the upstream platform vendor. We publish the platform end-of-life dates in advance on our website on the Percona Release Lifecycle Overview page.

When an OS platform has reached End of Life, we stop providing new packages, binary builds, hotfixes, or bug fixes for Percona software. Still, we will continue providing downloads of the existing packages.

Per our policies, we are announcing that this EOL has gone into effect for Percona software on Debian Linux 9 on 2022-07-01.

Each operating system vendor has different supported migration or upgrade paths to their next major release. Please contact us if you need assistance migrating your database to a different supported OS platform – we will be happy to assist you!

As you are probably aware, Red Hat Enterprise Linux 6 (RHEL 6 or EL 6 in short) officially reached “End of Life” (EOL) on 2020-11-30 and is now in the so-called Extended Life Phase, which basically means that Red Hat will no longer provide bug fixes or security fixes.

Even though EL 6 and its compatible derivatives like CentOS 6 had reached EOL some time ago already, we continued providing binary builds for selected MySQL-related products for this platform.

However, this became increasingly difficult, as the MySQL code base continued to evolve and now depends on tools and functionality that are no longer provided by the operating system out of the box. This meant we already had to perform several modifications in order to prepare binary builds for this platform, e.g. installing custom compiler versions or newer versions of various system libraries.

As of MySQL 8.0.26, Oracle announced that they deprecated the TLSv1 and TLSv1.1 connection protocols and plan to remove these in a future MySQL version in favor of the more secure TLSv1.2 and TLSv1.3 protocols. TLSv1.3 requires that both the MySQL server and the client application be compiled with OpenSSL 1.1.1 or higher. This version of OpenSSL is not available in binary package format on EL 6 anymore, and manually rebuilding it turned out to be a “yak shaving exercise” due to the countless dependencies.

Our build & release team was able to update the build environments on all of our supported platforms (EL 7, EL 8, supported Debian and Ubuntu versions) for this new requirement. However, we have not been successful in getting all the required components and their dependencies to build on EL 6, as it would have required rebuilding quite a significant amount of core OS packages and libraries to achieve this.

Moreover, switching to this new OpenSSL version would have also required us to include some additional shared libraries in our packages to satisfy the runtime dependencies, adding more complexity and potential security issues.

In general, we believe that running a production system on an OS that is no longer actively supported by a vendor is not a recommended best practice from a security perspective, and we do not want to encourage such practices.

Because of these reasons and to simplify our build/release and QA processes, we decided to drop support for EL 6 for all products now. Percona Server for MySQL 8.0.27 was the last version for which we built binaries for EL 6 against the previous version of OpenSSL.

Going forward, the following products will no longer be built and released on this platform:

• Percona Server for MySQL 5.7 and 8.0
• Percona XtraDB Cluster 5.7
• Percona XtraBackup 2.4 and 8.0
• Percona Toolkit 3.2

This includes stopping both building RPM packages for EL 6 and providing binary tarballs that are linked against glibc 2.12.

Note that this OS platform was also the last one on which we still provided 32-bit binaries.

Most of the Enterprise Linux distributions have stopped providing 32-bit versions of their operating systems quite some time ago already. As an example, Red Hat Enterprise Linux 7 (released in June 2014) was the first release to no longer support installing directly on 32-bit Intel/AMD hardware (i686/x86). Already back in 2018, we had taken the decision that we will no longer be offering 32-bit binaries on new platforms or new major releases of our software.

Given today’s database workloads, we also think that 32-bit systems are simply not adequate anymore, and we already stopped building newer versions of our software for this architecture.

The demand for 32-bit downloads has also been declining steadily. A recent analysis of our download statistics revealed that only 2.3% of our total binary downloads are referring to i386 binaries. Looking at IP addresses, these downloads originated from 0.4% of the total range of addresses.

This change affects the following products:

• Percona Server for MySQL 5.7
• Percona XtraDB Cluster 5.7
• Percona XtraBackup 2.4
• Percona Toolkit

We’ve updated the Percona Release Lifecycle Overview web page accordingly to reflect this change. Previously released binaries for these platforms and architectures will of course remain accessible from our repositories.

If you’re still running EL 6 or a 32-bit database or OS, we strongly recommend upgrading to a more modern platform. Our Percona Services team would be happy to help you with that!

The countdown for the annual Percona Live Data Performance Conference and Expo in Europe continues with today’s announcement of our keynote speakers!

This three-day conference focuses on the latest trends, news and best practices in the MySQL, NoSQL and data in the cloud markets, while looking forward to what’s on the long-term horizon within the global data performance industry. Attendees will get briefed on the hottest topics, learn about building and maintaining high-performing deployments and hear from technical experts. Whether you are new to data performance or a senior DBA with years of experience, there are tracks for you. With 84 breakout sessions, 8 tutorial sessions and 6 keynotes there will be no lack of great content presented by top industry professionals. You’ll return home equipped with new tools and ideas to make your business run better.

The Percona Live Europe 2015 keynote speakers and topics include:

• MC Brown, VMware Continuent, “Tungsten Replicator, More Open Than Ever!”: This talk will explain why a heterogeneous data replication solution is necessary to effectively move data between both databases and datacenters.

• Kristian Köhntopp, Syseleven GmbH, “The Virtues of Boring Technology”:
  This talk will rely on experiences at Booking.com to highlight why “boring” technology makes sense for organizations that are busy managing growth.

• Geir Hoydalsvik, Oracle, “MySQL 5.7: 20 years in the making!”: MySQL 5.7 is on its way to GA. This talk covers major developments including JSON, Optimizer Hints, Query Rewrite, Optimizer Cost Model, GIS, InnoDB, Group Replication, Fabric, Performance Schema, Sys Schema, Workbench and much more!

• Mark Callaghan, Facebook, “MySQL and MongoDB for web-scale data management”:
  This talk will ignore debates over legacy vs. new, NoSQL/NewSQL vs. SQL or relational vs. document data models. I want a solution for sharded replica sets that is efficient, performant and manageable. I have a wish list for features. How close will MySQL and MongoDB get to making this easier in the next few years?

• Peter Zaitsev, Percona, “Percona: Your Partner in Optimizing Data Performance”: This talk will focus on the growth of open source products in the enterprise and the importance of using the right open source tools and technology for each job rather than being locked into a proprietary solution. Learn how Percona is a true open source partner that helps you optimize your data performance to better run your business.

• Keynote Panel featuring Jim Doherty, Percona (Moderator); Kenny Gorman, Rackspace; Mark Callaghan, Facebook; Ian Meyers, Amazon Web Services; and Peter Zaitsev, Percona, “The Next Disruptive Technology: What Comes After the Cloud and Big Data?”: With the Cloud and Big Data transitioning from “next big things” to broadly deployed operational technologies we think it’s a good time to look a few years out and speculate about what may prove to be the next big technology disruption. So what’s next?

Fun Featured Events!

• Monday, September 21, SportPesa, Africa’s #1 sports betting platform, is hosting the Opening Party at the Delirium Café, following the day’s tutorial sessions, to kick off the conference and features giveaways, games, top prizes and beer!
• Tuesday, September 22, Percona Live Diamond Sponsor booking.com will host the Community Dinner at the company’s headquarters in historic Rembrandt Square. After the day’s breakout sessions, attendees will be picked up outside the venue and taken to the dinner by canal boats! Space is limited so attendees should sign up as soon as possible.
• Wednesday, September 23, the closing reception will be held in the Mövenpick Hotel exhibit hall.

So don’t forget, register for the conference and sign up for the community dinner before space is gone!

See you in Amsterdam!

The post Percona Live Keynote Speakers and Topics! appeared first on MySQL Performance Blog.

I’ll be presenting a webinar next Wednesday, January 23 at 10 a.m. (Pacific Time), about issues application developers should think about for scaling out read-query traffic using multiple MySQL instances in a replication pair.

Specifically, about the care we have to take because replication is asynchronous.  This means the slave  may not have current data at all times, so an application must choose to query the slave or the master dynamically.  As much as possible, we’d like to automate this choice so that application developers can be the most productive.

Please join me for this webinar by registering here: http://www.percona.com/webinars/readwrite-splitting-mysql-and-php

The post Webinar on Read/Write Splitting with PHP appeared first on MySQL Performance Blog.

2012 is near… and so is the next FOSDEM edition !

This year again, MySQL will be represented by its Community.

If you want to discuss with friend’s of MySQL it’s the place to be in February !

Like every year, FOSDEM takes place the first week-end of February in Brussels.

The MySQL and Friends devroom is Room H.1309 (150 seats). We (the MySQL Community) will have the room on Sunday 5th February 2012, all day.

We are organizing a MySQL & Friends dinner on Saturday night, more to come later on this.

If you want to propose a talk (you are in fact invited to propose one !), the deadline is December 26th.
Like we did on past editions, as soon as the talks are submitted, we will ask everyone to vote on the talks via Twitter or email.

Propose your talk now() here.

Thank you and see you soon in Brussels to talk MySQL and/or have a nice Belgian Beer

The first Percona Live Conferences in San Francisco and New York were such wonderful successes that we have been inspired to take it across the ocean into the UK. We are therefore proud to announce that our next Percona Live Conference will be held London October 24-25, 2011 . Registration is now open and we are offering an early-bird registration for eager attendees who appreciate a discount. Register here: http://www.eventbrite.com/event/1909670877/eorg/

Additionally, the Percona Live team is ready to accept submissions of talks and/or tutorials from individuals who wish to speak at this two day event. Please go here: http://www.percona.com/live/london-2011/call-for-speakers/ to submit your talks.

Whether you are a speaker or an attendee, there are a number of sponsorship opportunities available. Please contact Percona’s sales team for further information.

Percona is pleased to extend a belated welcome to Alexey Kopytov. He actually joined us back in November, 2010, but we somehow overlooked blogging then about his switch from Oracle to Percona. Alexey has over six years of work deep in MySQL source code as part of MySQL AB, then Sun, and later Oracle. His first MySQL job was as part of the original High Performance group within the MySQL Support Team, working under Peter and Vadim. Alexey was the original implementer and maintainer of Sysbench, the tool we use everyday for our performance benchmarks. Now Alexey will focus on Percona Server and Percona XtraBackup, you may have seen his name in our recent Release Notes.

Alexey, a big welcome!

It’s finally here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona’s enhancements to the MySQL 5.5.8 server. Here are some highlights:

• Performance and scalability improvements throughout the server and storage engine
• Optimizations for flash storage such as SSD, Virident, and FusionIO
• Optimizations for cloud computing
• The HandlerSocket plugin for NoSQL access
• There’s an Amazon OS repository, as well as Yum and Apt repositories
• Improvements to replication, partitioning, stored procedures
• More diagnostics and tunability
• More pluggability, including pluggable authentication

In addition to building on MySQL 5.5, here are the changes we’ve made from previous Percona Server releases:

New Features

• InnoDB adaptive hash function searches can now be spread across multiple partitions (see Multiple Adaptive Hash Search Partitions. Bug fixed: #688866. (Yasufumi Kinoshita)
• Information from SHOW INNODB STATUS was made available in new status variables in InnoDB Show Status. Bug fixed:#698797.

Variable Changes

• New variable innodb_adaptive_flushing_method was added.
• New variable innodb_use_global_flush_log_at_trx_commit was added. Bug fixed: #635399. (Yasufumi Kinoshita)
• New variable log_warnings_silence replaced old variable suppress_log_warning_1592. Bug fixed: #692413. (Oleg Tsarev)
• Old variable innodb_adaptive_checkpoint was deleted. Bug fixed: #689450. (Yasufumi Kinoshita)
• Old variable innodb_flush_log_at_trx_commit_session was deleted. Bug fixed: #635399. (Yasufumi Kinoshita)
• Old variable use_global_long_query_time was deleted. (Oleg Tsarev) Bug fixed: #692415.
• Old variable variable innodb_ibuf_accel_rate was renamed to innodb_ibuf_merge_rate. Bug fixed: #695906 (Yasufumi Kinoshita)
• Old variable variable innodb_ibuf_active_contract was renamed to innodb_ibuf_active_merge. Bug fixed: #695906 (Yasufumi Kinoshita)
• Old variable enable_query_response_time_stats was renamed to query_response_time_stats. (Oleg Tsarev)
• Existing variable log_slow_verbosity had two new values added:profiling and profiling_use_getrusage. (Oleg Tsarev)
• Existing variables profiling_server and profiling_use_getrusage were merged into the Slow Query Log page. (Oleg Tsarev)

Other Changes

• Additional information was added to the LOG section of the SHOW STATUS command. Bug fixed: #693269. (Yasufumi Kinoshita)
• The SHOW PATCHES command was removed. (Vadim Tkachenko)
• The INFORMATION_SCHEMA table XTRADB_ENHANCEMENTS was removed. (Yasufumi Kinoshita)
• Several fields in the INFORMATION_SCHEMA table INNODB_INDEX_STATS were renamed. Bug fixed: #691777. (Yasufumi Kinoshita)
• The XtraDB version was set to 20.0. (Aleksandr Kuzminsky)
• Many InnoDB compilation warnings were fixed. Bug fixed:#695273. (Yasufumi Kinoshita)
• An Amazon OS repository was created. Bug fixed: #691996. (Aleksandr Kuzminsky)

For more information, please see the following links:

• Downloads – binary distributions and Percona Software Repositories
• Installation instructions
• Consulting, support, training, and custom development
• Release notes
• Documentation
• Developer discussion group

Percona was working closely with Virident on evaluating tachIOn as solution for MySQL, and as result you can find whitepaper “Scaling MySQL Deployments Efficiently Using Virident tachIOn Drives”, available from Virident website. It was done as part of our consulting practice, but all results and numbers are certified by Percona. I personally really enjoyed performance and stability provided by tachIOn card, and you actually saw bunch of benchmarks results published on our blog which proves it.
Virident tachIOn will be on the list of our recommendations for customers looking to improve performance or building high-performance solution based on MySQL.