Percona is glad to announce the release of Percona XtraBackup 8.0.6 on May 9, 2019. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. [&]

https://www.percona.com/blog/2019/05/09/percona-xtrabackup-8-0-6-is-now-available/

In my previous post Running MySQL/Percona Server in Kubernetes with a Custom Config Ive looked at how to set up MySQL in Kubernetes to utilize system resources fully. Today I want to measure if there is any performance overhead of running MySQL in Kubernetes, and show what challenges I faced trying to measure it. I [&]

https://www.percona.com/blog/2019/05/09/measuring-mysql-performance-kubernetes/

Its not essential to understand how MySQL® and Percona Server for MySQL build indexes. However, if you have an understanding of the processing, it could help when you want to reserve an appropriate amount of space for data inserts. From MySQL 5.7, developers changed the way they built secondary indexes for InnoDB, applying a bottom-up [&]

https://www.percona.com/blog/2019/05/08/mysql-innodb-sorted-index-builds/

ProxySQL 2.0.3, released by ProxySQL, is now available for download in the Percona Repository along with an updated version of Perconas proxysql-admin tool. ProxySQL is a high-performance proxy, currently for MySQL,  and database servers in the MySQL ecosystem (like Percona Server for MySQL and MariaDB). It acts as an intermediary for client requests seeking resources from the [&]

https://www.percona.com/blog/2019/05/07/proxysql-2-0-3-and-updated-proxysql-admin-tool/

Percona announces the release of Percona Server for MySQL 8.0.15-6 on May 7, 2019 (downloads are available here and from the Percona Software Repositories). This release is based on MySQL 8.0.14 and 8.0.15. It includes all bug fixes in these releases. Percona Server for MySQL 8.0.15-6 is now the current GA release in the 8.0 series. All of Percona’s software [&]

https://www.percona.com/blog/2019/05/07/percona-server-for-mysql-8-0-15-6-is-now-available/

Less than one month left until Percona Live. This time the Committee work was a bit unusual. Instead of having one big committee for the whole conference we had a few mini-committees, each responsible for a track. Each independent mini-committee, in turn, had a leader who was responsible for the whole process. I led the [&]

https://www.percona.com/blog/2019/05/07/mariadb-track-at-percona-live/

We are pleased to announce the launch of PMM 2.0.0-alpha2, Perconas second Alpha release of our long-awaited PMM 2 project! In this release, youll find support for MongoDB Metrics and Query Analytics  watch for sharp edges as we expect to find a lot of bugs!  Weve also expanded our existing support of MySQL from our [&]

https://www.percona.com/blog/2019/05/03/percona-monitoring-and-management-pmm-2-0-0-alpha2-is-now-available/

Percona announces the release of Percona Server for MongoDB 3.6.12-3.2 on May 3, 2019. Download the latest version from the Percona website or the Percona software repositories. Percona Server for MongoDB is an enhanced, open source, and highly-scalable database that is a fully-compatible, drop-in replacement for MongoDB 3.6 Community Edition. It supports MongoDB 3.6 protocols and drivers. Percona [&]

https://www.percona.com/blog/2019/05/03/percona-server-for-mongodb-3-6-12-3-2-is-now-available/

When users experience memory usage issues with any software, including MySQL®, their first response is to think that its a symptom of a memory leak. As this story will show, this is not always the case. This story is about a bug. All Percona Support customers are eligible for bug fixes, but their options vary. [&]

https://www.percona.com/blog/2019/05/02/mysql-memory-management-memory-allocators-and-operating-system/

Percona is glad to announce the release of Percona XtraBackup 2.4.14 on May 1, 2019. You can download it from our download site and apt and yum repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. [&]

https://www.percona.com/blog/2019/05/01/percona-xtrabackup-2-4-14-is-now-available/

In this research,  I wanted to see what kind of performance improvements could be gained by using a ClickHouse data source rather than PostgreSQL. Assuming that I would see performance advantages with using ClickHouse, would those advantages be retained if I access ClickHouse from within postgres using a foreign data wrapper (FDW)? The FDW in [&]

https://www.percona.com/blog/2019/05/01/benchmark-clickhouse-database-and-clickhousedb_fdw/

Please join, Percona’s Product Manager, Michael Coburn as he presents his talk Speaking the same language as Developers and DBAs. Watch the Recorded Webinar In this talk, well go over some of the high-level monitoring concepts that PMM enables for you, the CEO, to leverage in order to speak the same language as your technical [&]

https://www.percona.com/blog/2019/05/01/watch-webinar-speaking-the-same-language-as-developers-and-dbas/

Last week, Oracle reported on the list of MySQL Community Contributors for 2019 and were proud to say that five serving Perconians made it to the list of 19 people recognized as such. Entries are nominated by the MySQL community and their nominations are assessed against six criteria by a volunteer committee of community mavens. [&]

https://www.percona.com/blog/2019/05/01/mysql-community-contributor-awards-2019/

Join Percona CEO Peter Zaitsev and PingCAP Senior Product and Community Manager Morgan Tocker as they present How to horizontally scale MySQL with TiDB while avoiding sharding issues on Wednesday, May 1st, 2019, at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now In this joint webinar, PingCAP will provide an introduction and overview [&]

https://www.percona.com/blog/2019/04/30/scale-mysql-tidb-avoid-sharding/

We have successfully used ZFS for MySQL® backups and MongoDB® is no different. Normally, backups will be taken from a hidden secondary, either with [crayon-5ccab62701f1c890846171-i/] , WT hot backup or filesystem snapshots. In the case of the latter, instead of LVM2, we will use ZFS and discuss potential other benefits. Preparation for initial snapshot Before taking [&]

https://www.percona.com/blog/2019/04/29/zfs-for-mongodb-backups/

Please join Percona’s Senior Support Engineer Vinodh Krishnaswamy as he presents Deep Dive In the Config Database (Shardings). Watch the Recorded Webinar In MongoDB, we know the Sharded Cluster can migrate chunks across the Shards and also route a query. But where is this information stored, and how is it used by MongoDB to maintain [&]

https://www.percona.com/blog/2019/04/29/webinar-config-database-shardings/

There are three different ways ProxySQL can direct traffic between your application and the backend MySQL services. Locally, on the MySQL servers. Between the MySQL servers and the application. Colocated on the application servers themselves. Without going through too much detail – each has its own limitations. In the first form, the application needs to [&]

https://www.percona.com/blog/2019/04/26/load-balanced-proxysql-in-google-cloud/

Please join Percona’s PostgreSQL Support Technical Lead, Avinash Vallarapu and Senior Support Engineers, Fernando Laudares, Jobin Augustine and Nickolay Ihalainen as they demonstrate the methods to upgrade a legacy version of PostgreSQL to a newer version using built-in as well as open source tools. Watch the Recorded Webinar To start, this webinar opens with a [&]

https://www.percona.com/blog/2019/04/26/upgrading-migrating-legacy-postgresql/

This year we’re having a different concept for Percona Live conferences, which started at Percona Live Europe 2018 last fall. This is an approach practiced by many other organizations by having separate track for MySQL®, MongoDB®, MariaDB®, or PostgreSQL and more. Having many tracks in this big Open Source Database Conference meant that one track [&]

https://www.percona.com/blog/2019/04/26/mysql-track-at-percona-live-2019/

Please join Percona’s Principal Support Engineer Sveta Smirnova as she presents Billion Goods in Few Categories: How Histograms Save a Life? Watch the Recorded Webinar We store data with the intention to use it: search, retrieve, group, sort, etc. To perform these actions effectively, MySQL storage engines index data and communicate statistics with the Optimizer [&]

https://www.percona.com/blog/2019/04/25/webinar-histograms-save-life/