Its release roundup time here at Percona! We publish quite a few updates to our software and services every week, so we wanted to make it a little easier for you to keep track of our latest releases. So, starting today we will publish release roundups comprising all the details and information you need on [&]

https://www.percona.com/blog/2019/11/04/updated-pmm-and-percona-server-for-mongodb-mysql-utility-user-feature-in-percona-server-for-mysql-release-roundup-nov-4-2019/

Some say that the best password is the one you don’t have to remember. Thats possible with MySQL, thanks to the Authentication from MariaDB 10.4 document). As already mentioned this is not news, and even when one installs MySQL using the .deb packages maintained by the Debian team, the root user is created so it [&]

https://www.percona.com/blog/2019/11/01/use-mysql-without-a-password/

One of the great things about Percona, and a Percona Support contract, is that we not only guarantee application performance but we also provide bug fixes for covered software—and not just advice on how to use it. This is most likely missing from most customer’s in-house support, as it requires a team with code knowledge [&]

https://www.percona.com/blog/2019/10/31/how-percona-support-handles-software-bugs/

Recently we published a blog about a very simple application failover using libpq features which could be the simplest of all automatic application connection routing.  In this blog post, we are discussing how a proxy server using HAProxy can be used for connection routing which is a well-known technique with very wide deployment. There are [&]

https://www.percona.com/blog/2019/10/31/postgresql-application-connection-failover-using-haproxy-with-xinetd/

In MySQL 8.0.18 there is a new feature called how it works under the hood. The high-level basics are the following: if there is a join, it will create an in-memory hash table based on one of the tables and will read the other table row by row, calculate a hash, and do a lookup [&]

https://www.percona.com/blog/2019/10/30/understanding-hash-joins-in-mysql-8/

The nights are lengthening and the spookiest day of the year is nearly upon us, Halloween! In the spirit of the holiday, we asked our team to share their scariest tales of database dread, blood-curdling BIOS failures, and dastardly data destruction, and some of the responses are downright chilling. Grab some candy and check out [&]

https://www.percona.com/blog/2019/10/30/spooktacularly-scary-database-stories/

PostgreSQL is a widely-used Open Source database and has been the DBMS of the year for the past 2 years in

https://www.percona.com/blog/2019/10/29/monitoring-postgresql-databases-using-percona-monitoring-management/

From time to time you may have experienced that MySQL was not able to find the best execution plan for a query. You felt the query should have been faster. You felt that something didnt work, but you didnt realize exactly what. Maybe some of you did tests and discovered there was a better execution [&]

https://www.percona.com/blog/2019/10/29/column-histograms-on-percona-server-and-mysql-8-0/

In MySQL 8.0.18 there is a new feature called new iterator executor for each step. That topic itself deserves its own blog post on how the new iterator executor works, and I will write a post about that as well. But if you cannot wait and you would like to read up, here are some [&]

https://www.percona.com/blog/2019/10/28/using-explain-analyze-in-mysql-8/

Hi everyone! This is one of the most requested subjects to our support team and Id like to share the steps as a tutorial blog post. Today, we will set up internal authentication using x.509 certificates as well as enabling TSL/SSL. If using authentication in MongoDB, there are two ways to configure intra-cluster authentication: Using [&]

https://www.percona.com/blog/2019/10/28/setting-up-mongodb-with-member-x509-auth-and-ssl-easy-rsa/

Every fall I enjoy traveling to key events to meet Perconas customers and software users. Аfter meetup in Ryazan on November 5th sponsored by HighLoad++ in Moscow along with six other Percona experts.  My talks will be: BpfTrace  Finally a Full-Fledged Replacement for Dtrace in Linux Query Analysis for MySQL, PostgreSQL, MongoDB Sessions by [&]

https://www.percona.com/blog/2019/10/24/percona-roadshow-fall-2019-conferences-in-russia-and-uk-in-november/

ProxySQL 2.0.7, released by MariaDB). It acts as an intermediary for client requests seeking resources from the database. Ren'e Canna`o created ProxySQL for DBAs as a means of solving complex replication topology issues. This release includesPSQLADM-204: Add support of MariaDB 10.4 Improvements PSQLADM-157: In some cases, the proxysql-status script used the cat command to display a [&]

https://www.percona.com/blog/2019/10/23/proxysql-2-0-7-and-proxysql-admin-tool-now-available/

When you build replication in PostgreSQL using Streaming replication, you cannot perform writes to a standby node; only reads. This way, you could offload reads or reporting queries to standby servers and send writes to master. Additionally, starting from PostgreSQL 10, [crayon-5db3b93fd4b60727483714-i/]  and [crayon-5db3b93fd4b68905029434-i/] clients could probe the connection for a master and allow connections [&]

https://www.percona.com/blog/2019/10/23/seamless-application-failover-using-libpq-features-in-postgresql/

MySQL Workbench is a great multi-purpose GUI tool for MySQL, which I think is not marketed enough by the MySQL team and is not appreciated enough by the community for what it can do. MySQL Workbench Licensing MySQL Workbench is similar to MySQL Server and is an Open-Core product. There is Community Edition which has [&]

https://www.percona.com/blog/2019/10/23/mysql-workbench-review/

In this article, we will take a look at how to run Percona Monitoring and Management (PMM) Server in a container without root privileges. Some of the concerns companies have about using Docker relate to the security risks that exist due to the requirement for root privileges in order to run the service and therefore [&]

https://www.percona.com/blog/2019/10/22/pmm-server-podman-running-a-container-without-root-privileges/

This blog post will help you configure a 3-node Percona XtraDB Cluster using a binary tarball on your local machine. Configuration files are auto-generated with mostly default configurations except for port/IP address details. The tool has the handy script to create configuration files and start multiple Percona XtraDB Cluster nodes on the fly, helping you [&]

https://www.percona.com/blog/2019/10/15/how-to-start-a-3-node-percona-xtradb-cluster-with-the-binary-tarball-package/

How can you ensure you are properly managing and optimizing the performance of your database environment? Join Percona’s Product Manager Michael Coburn as he presents “Whats New in Percona Monitoring and Management 2?” and walks you through practical demonstration. This will be taking place on Wednesday, October 16, 2019, at 11:00 AM EDT. Register Now [&]

https://www.percona.com/blog/2019/10/14/webinar-10-16-whats-new-in-percona-monitoring-and-management-2/

PostgreSQL 12 can be considered revolutionary considering the performance boost we observe with partitioning enhancements, planner improvements, several SQL features, Indexing improvements, etc. You may see some of such features discussed in future blog posts. But, let me start this blog with something interesting. You might have already seen some news that there is no [&]

https://www.percona.com/blog/2019/10/11/how-to-set-up-streaming-replication-in-postgresql-12/

Percona announces the release of Percona Server for MongoDB 3.6.14-3.4 on October 10, 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/10/10/percona-server-for-mongodb-3-6-14-3-4-available/

Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring your database performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL®, MariaDB®, MongoDB®, and PostgreSQL® servers to ensure that your data works as efficiently as possible. In this release, [&]

https://www.percona.com/blog/2019/10/09/percona-monitoring-and-management-pmm-2-0-1-is-now-available/