Sysbench has long been established as the de facto standard when it comes to benchmarking MySQL performance. Percona relies on it daily, and even Oracle uses it when blogging about new features in MySQL 8. Sysbench comes with several pre-defined benchmarking tests. These tests are written in an easy-to-understand scripting language called Lua. Some of [&]

https://www.percona.com/blog/2019/04/25/creating-custom-sysbench-scripts/

We are pleased to announce the launch of PMM 2.0.0-alpha1, Perconas first Alpha release of our long-awaited PMM 2 project! We focused exclusively on MySQL support in our first Alpha (because we wanted to show progress sooner rather than later), and youll find updated MySQL dashboards along with enhancements to Query Analytics. Weve also added [&]

https://www.percona.com/blog/2019/04/24/percona-monitoring-and-management-pmm-2-0-0-alpha1-is-now-available/

Following on the heels of our PostgreSQL Tuples Statistics Dashboard, heres another blog post describing how you can gain additional visibility of PostgreSQL queries using PMM. We take a look at using an extension called pg_stat_statements. This allows us to collect information about the various queries running in your PostgreSQL instance. Well describe how to [&]

https://www.percona.com/blog/2019/04/23/adding-postgresql-queries-overview-dashboards-to-the-pmm-plugin/

Percona will no longer be offering the free services of Query Analyzer and MySQL Configuration Generator hosted at tools.percona.com.  We made this decision based on observed low usage numbers, outdated technology, and lack of support for MySQL 5.7+, MongoDB, and PostgreSQL. Although there isn’t a like-for-like replacement available, you might wish to consider the following [&]

https://www.percona.com/blog/2019/04/22/end-of-life-query-analyzer-and-mysql-configuration-generator/

Python 2 reaches EOL on 2020-01-01 and one of its commonly used third-party packages is MySQL-python. If you have not yet migrated away from both of these, since MySQL-python does not support Python 3, then you may have come across some issues if you are using more recent versions of MySQL and are enforcing a [&]

https://www.percona.com/blog/2019/04/18/mysql-python-adding-caching_sha2_password-tlsv1-2-support/

Percona announces the release of Percona Server for MongoDB 4.0.9-4 on April 17, 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 4.0 Community Edition. It supports MongoDB 4.0 protocols and drivers. Percona Server [&]

https://www.percona.com/blog/2019/04/17/percona-server-for-mongodb-4-0-9-4-is-now-available/

PostgreSQL has a very unique way to review the code submitted by developers. Most open source software uses Github pull requests to accommodate users code. PostgreSQL has a Github page but doesnt  manage pull requests using Github. Many years ago, PostgreSQL introduced CommitFest to manage its patches, where postgres opens for a three to four [&]

https://www.percona.com/blog/2019/04/17/postgresql-commitfest-2019-03-ends/

There’s just one week to go before the first of this year’s Percona University events in South America. We’re really pleased with the lineup for all three events. We’re also incredibly happy with the response that we have had from the community. While we realize that a free event is… well… free… you are still [&]

https://www.percona.com/blog/2019/04/16/percona-universities-in-south-america-next-week/

Many of our regular attendees already know that the Percona Live Open Source Database Conference is not all about Percona software or, indeed, all about Percona. However, with moving to a new city—Austin, TX— we have realized that its something we ought to shout out loud and clear. Our conference really is technology agnostic! As [&]

https://www.percona.com/blog/2019/04/15/a-truly-open-source-database-conference/

When you need to upgrade your PostgreSQL databases, there are a number of options available to you. In this post well take a look at how you can upgrade PostgreSQL versions using pg_upgrade, a built-in tool that allows in-place upgrade of your software. Using pg_upgrade allows you, potentially, to minimize your downtime, an essential consideration [&]

https://www.percona.com/blog/2019/04/12/fast-upgrade-of-legacy-postgresql-with-minimum-downtime-using-pg_upgrade/

Percona is proud to be credited in several categories within the annual Database Trends & Application’s (DBTA) Readers’ Choice Awards. Voting is now open, and the categories cover long-standing technologies, as well as newer innovations. Unlike other award programs that rely on the publications’ own evaluation, the DBTA Readers Choice Awards are chosen exclusively by you – [&]

https://www.percona.com/blog/2019/04/12/percona-dbta-readers-choice-awards-2019/

In this blog, I will provide answers to the Q & A for the MySQL 8.0 Architecture and Enhancement webinar. First, I want to thank everybody for attending my April 9, 2019, webinar. The recording and slides are available the slides and a recording here.  

https://www.percona.com/blog/2019/04/11/mysql-8-0-architecture-and-enhancement-webinar-q-a/

In my previous

https://www.percona.com/blog/2019/04/10/how-to-add-more-nodes-to-an-existing-proxysql-cluster/

Native streaming replication in PostgreSQL works only between servers running the same major version. We discussed about logical replication in our previous blog post. In that post, we saw how logical replication could help us set up migration between two different PostgreSQL versions. However, logical replication works only for the currently supported versions of PostgreSQL, [&]

https://www.percona.com/blog/2019/04/09/continuous-replication-from-legacy-postgresql-version-using-slony/

Please join Percona’s Product Manager, Michael Coburn, as he presents his talk Extending and Customizing Percona Monitoring and Management on April 10th, 2019 at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now Do you already run stock PMM in your environment and want to learn how you extend the PMM platform? If [&]

https://www.percona.com/blog/2019/04/09/customizing-percona-monitoring-management/

Please join Perconas Bug Analyst, Lalit Choudhary as he presents his talk MySQL 8.0 Architecture and Enhancement on Tuesday, April 9th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now The release of MySQL 8.0 offers much more to users compared to previous releases. There are major changes in architecture as [&]

https://www.percona.com/blog/2019/04/08/mysql-8-architecture-enhancement/

While the PMM Engineering team is working on the polish for release of PMM 2, I wanted to share with you some of the dashboard improvements were making around PostgreSQL, specifically how you can plot Tuple Statistics using PMM. PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL®, MongoDB®, and PostgreSQL performance. [&]

https://www.percona.com/blog/2019/04/08/adding-postgresql-tuple-statistics-dashboard-to-the-pmm-plugin/

PostgreSQL is a powerful open source relational database management system. It extends the SQL language with additional features. A DBMS is not only defined by its performance and out of the box features, but also its ability to support bespoke/additional user-specific functionality. Some of these functionalities may be in the form of database constructs or [&]

https://www.percona.com/blog/2019/04/05/writing-postgresql-extensions-is-fun-c-language/

When you need to upgrade PostgreSQL, there are a variety of approaches that you can use. To avoid application downtime, then not all of the options to upgrade postgres are suitable. When avoiding downtime is essential, then you might consider using replication as a means of upgrade, and depending on your scenario, you can choose [&]

https://www.percona.com/blog/2019/04/04/replication-between-postgresql-versions-using-logical-replication/

As we continue the development of our Percona Operators to simplify database deployment in Kubernetes (Percona Server for MongoDB Operator 0.3.0 and Percona XtraDB Cluster Operator 0.3.0), one very popular question I get is: how does deployment in Kubernetes affect MySQL performance? Is there a big performance penalty? So I plan to look at how [&]

https://www.percona.com/blog/2019/04/03/running-mysql-percona-server-in-kubernetes-with-a-custom-config/