As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how using the new dual passwords feature can reduce the overall DBA workload and streamline the management process. I’ve also covered how the new password failure tracking features can enable the locking of an account with too many failed password [&]

https://www.percona.com/blog/mysql-8-random-password-generator/

Dont miss the great overview of PostgreSQL 14 that Umair Shahid recently put together, PostgreSQL 14 – Performance, Security, Usability, and Observability! Range data types have been in Postgresql for some time now, however, as of PostgreSQL 14, we have seen the introduction of multi-range data types.  Before we cover that, lets cover the basics [&]

https://www.percona.com/blog/using-the-multirange-data-type-in-postgresql-14/

There are plenty of ways to run ProxySQL in Kubernetes (K8S). For example, we can deploy sidecar containers on the application pods, or run a dedicated ProxySQL service with its own pods. We are going to discuss the latter approach, which is more likely to be used when dealing with a large number of application [&]

https://www.percona.com/blog/getting-started-with-proxysql-in-kubernetes/

In this short blog post, we are going to review how to avoid using credentials in the Percona Monitoring and Management (PMM) client command line when adding new exporters. We will use an example with the MySQL exporter, but it is extensible to others (PostgreSQL, MongoDB, etc.). In the online documentation we can see the [&]

https://www.percona.com/blog/how-to-hide-credentials-from-percona-monitoring-and-management-client-commands/

As we’ve communicated in our blog post in May, the TokuDB Storage Engine has been marked as “deprecated” in Percona Server for MySQL 8.0. It will be removed in a future version (Percona Server for MySQL 8.0.28, expected to ship in Q1 2022). With the release of Percona Server for MySQL 8.0.26, the storage engine will [&]

https://www.percona.com/blog/tokudb-storage-engine-will-be-disabled-by-default-in-percona-server-for-mysql-8-0-26/

As part of my ongoing focus on MySQL 8 user and password management, I’ve covered how the new dual passwords feature can reduce the overall DBA workload and streamline the management process (see MySQL 8: Dual Passwords). This wasn’t the only change to user/password management in MySQL 8; one of the more security-focused changes was [&]

https://www.percona.com/blog/mysql-8-account-locking/

As previously mentioned here on the blog, PostgreSQL 14 was just released. Need a primer? Umair Shahid recently put together a great overview, PostgreSQL 14 – Performance, Security, Usability, and Observability. I recently did a deep-dive into using JSON from within PostgreSQL in a two blog post series titled Storing and using JSON within PostgreSQL, [&]

https://www.percona.com/blog/using-new-json-syntax-in-postgresql-14-update/

As a DBA, it is important to monitor a database to help us troubleshoot or to understand the health of an instance. Percona Monitoring and Management (PMM v2) is open-source and does a great job in monitoring the databases like MongoDB, MySQL, PostgreSQL, etc. In this blog post, we will see how to configure a [&]

https://www.percona.com/blog/configuring-a-mongodb-sharded-cluster-with-pmm2-part-2/

It is a common use case to synchronize data in two tables inside MySQL servers. This blog post describes one specific case: how to synchronize data between two different tables on the same MySQL server. This could be useful, for example, if you test DML query performance and do not want to affect production data. [&]

https://www.percona.com/blog/synchronize-tables-on-the-same-server-with-pt-table-sync/

Complete the 2021 Open Source Data Management Software Survey to share your knowledge and experience, and help inform the open source database community. In 2020 we ran our second Open Source Data Management Software Survey. This resulted in some interesting data on the state of the open source database market.  Some key statistics: 41% of [&]

https://www.percona.com/blog/2021-open-source-data-management-software-survey

Peter Zaitsev, known to all as Perconas founder and CEO, asked me to pen a few reminisces as I retire.  How do I sum up 22 years in the MySQL world?  How do I even begin?  I best start with gratitude. Ive had the amazing privilege of being on the inside of the leadership teams [&]

https://www.percona.com/blog/lessons-from-peter-zaitsev/

Percona serves several communities including MySQL, PostgreSQL, and MongoDB.  The Percona Community Team is committed to promoting content and technical advice on open source database technologies and needs. Hence, we organize monthly MeetUps as a series of regular 1-hour live streaming every Wednesday at 11 am EST/ 5:00 pm CEST/8:30 pm IST with Matt Yonkovit, [&]

https://www.percona.com/blog/join-community-meetups-for-mysql-postgresql-mongodb-or-pmm/

Today saw the launch of PostgreSQL14. For me, the important area to focus on is what the community has done to improve performance for heavy transactional workloads and additional support for distributed data. The amount of data that enterprises have to process continues to grow exponentially. Being able to scale up and out to support [&]

https://www.percona.com/blog/postgresql-14-performance-security-usability-and-observability/

Here at Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help you manage any issues that arise in any of the databases that we support. And, in true open source form, report back on any issues or bugs [&]

https://www.percona.com/blog/percona-monthly-bug-report-september-2021/

As Technical Product Manager, I get a lot of user feedback, both positive and negative. In recent months many people have complained about the Home dashboard. It went something like this: “Hey, the Home page is useless! We have several hundred services monitored by a single Percona Monitoring and Management (PMM), so this list of [&]

https://www.percona.com/blog/new-experimental-environment-dashboards-for-percona-monitoring-and-management/

In a previous post, A Horizontal Scalability Mindset for MySQL, I discussed the concerns around growing individual MySQL instances too large and some basic strategies: Optimizing/minimizing size with proper data types Removing unused/duplicate indexes Keeping your Primary Keys small Pruning data Finally, if those methods have been exhausted, I touched on horizontal sharding as the [&]

https://www.percona.com/blog/horizontal-scaling-in-mysql-sharding-followup/

It’s been a while since Percona started to develop its own software products, but collecting reviews is a new experience for us. We started this activity about a year ago, and the results we got are stunning. Your reviews said more about us than we ever could imagine. From everyone at Percona, we’d like to [&]

https://www.percona.com/blog/percona-software-recognized-with-product-awards/

As a Technical Account Manager at Percona, I get to work with many of our largest clients. While the industry verticals vary, one main core challenge generally remains the same  what do I do with all this data? Dealing with massive data sets in MySQL isn’t a new challenge, but the best approach still [&]

https://www.percona.com/blog/horizontal-scalability-for-mysql/

The future of technology adoption belongs to developers. The future of application deployment belongs in the cloud. The future of databases belongs to open source. That’s essentially the summary of Percona’s innovation strategy and that’s the reason I decided to join Percona  I believe the company can provide me with the perfect platform for [&]

https://www.percona.com/blog/percona-and-postgresql-better-together/

Its release roundup time again here at Percona! Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. [&]

https://www.percona.com/blog/release-roundup-september-27-2021/