As PostgreSQL based applications scale, the need to implement connection pooling can become apparent sooner than you might expect. Since, PostgreSQL to date has no built-in connection pool handler, in this post Ill explore some of the options for implementing connection pooling. In doing so, well take a look at some of the implications for application [&]

The post Scaling PostgreSQL with PgBouncer: You May Need a Connection Pooler Sooner Than You Expect appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/27/scaling-postgresql-with-pgbouncer-you-may-need-a-connection-pooler-sooner-than-you-expect/

Please join Percona’s Chief Evangelist Colin Charles on Thursday, June 28th, 2018, as he presents Securing Database Servers From External attacks at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   A critical piece of your infrastructure is the database tier, yet people don’t pay enough attention to it judging by how [&]

The post Webinar 6/28: Securing Database Servers From External Attacks appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/27/webinar-6-28-securing-database-servers-from-external-attacks/

In this blog post, we will walk through PMM-Query Analytics for MongoDB. We will see how to analyze MongoDB query performance; review the initial parameters that we need to check; and find out how to compare MongoDB query performance with and without indexes with the help of EXPLAIN plan. The Percona Monitoring and Management QAN (PMM-QAN) dashboard [&]

The post MongoDB Explain  Using PMM-QAN for MongoDB Query Analytics appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/26/mongodb-explain-using-pmm-qan-for-mongodb-query-analytics/

Please join Percona’s Principal Support Escalation Specialist Sveta Smirnova as she presents Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance on Wednesday, June 27th at 11:00 AM PDT (UTC-7) / 2:00 PM EDT (UTC-4). Register Now   During the MySQL Troubleshooting webinar series, I covered many monitoring and logging tools such as: General, slow, [&]

The post Webinar 6/27: MySQL Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/26/webinar-6-27-mysql-troubleshooting-best-practices/

Kubernetes, and its most popular distribution OpenShift, receives a lot of interest as a container orchestration platform. However, databases remain a foreign entity, primarily because of their stateful nature, since container orchestration systems prefer stateless applications. That said, there has been good progress in support for StatefulSet applications and persistent storage, to the extent that it [&]

The post Running Percona XtraDB Cluster in Kubernetes/OpenShift appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/25/running-percona-xtradb-cluster-kubernetes-openshift/

MongoDB 4.0 is just around the corner and with rc0 we can get a good idea of what we can expect in the GA version. MongoDB 4.0 will allow transactions to run in a replica set and, in a future release, the MongoDB transaction will be cluster-wide. This is a really big change! Multi-statement transactions are [&]

The post MongoDB Transactions: Your Very First Transaction with MongoDB 4.0 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/25/mongodb-transactions-your-very-first-transaction-with-mongodb-4-0/

Please join Percona’s Chief Evangelist, Colin Charles on Tuesday, June 26th, 2018, as he presents MariaDB Server 10.3 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Register Now   MariaDB Server 10.3 is out. It has some interesting features around system versioned tables, Oracle compatibility, column compression, an integrated SPIDER engine, as well [&]

The post Webinar Tues 6/26: MariaDB Server 10.3 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/25/webinar-tues-6-26-mariadb-server-10-3/

Percona announces the GA release of Percona XtraBackup 2.4.12 on June 22, 2018. 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. Offered free [&]

The post Percona XtraBackup 2.4.12 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/25/percona-xtrabackup-2-4-12-is-now-available/

Join Percona Chief Evangelist Colin Charles as he covers happenings, gives pointers and provides musings on the open source database community. This is a short working week for me due to a family emergency. It caused me to skip speaking at DataOps.Barcelona and miss hanging out with the awesome of speakers and attendees. This is the [&]

The post This Week in Data with Colin Charles 43: Polyglots, Security and DataOps.Barcelona appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/22/this-week-in-data-with-colin-charles-43/

In this blog post, we will talk a bit about the product MongoDB Compass. This new tool has 3 main versions, these being: Community, Enterprise and Enterprise Read Only. MongoDB Compass Community is free, but a bit limited. It allows you to connect to your MongoDB Database to run queries, check queries execution plans, manage indexes, and create, [&]

The post Finding the Right Direction: MongoDB Compass  Community Version appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/22/finding-the-right-direction-mongodb-compass-community-version/

Why do I spend time blogging about security frameworks? Because, although there are some resources available on the Web, none apply to Percona XtraDB Cluster (PXC) directly. Actually, I rarely encounter a MySQL setup where SELinux is enforced and never when Percona XtraDB Cluster (PXC) or another Galera replication implementation is used. As well see, [&]

The post Lock Down: Enforcing SELinux with Percona XtraDB Cluster appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/21/enforcing-selinux-with-percona-xtradb-cluster/

Percona announces the release of Percona Server for MongoDB 3.4.15-2.13 on June 20, 2018. Download the latest version from the Percona web site 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.4 Community Edition. It supports MongoDB 3.4 protocols and drivers. [&]

The post Percona Server for MongoDB 3.4.15-2.13 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/20/percona-server-for-mongodb-3-4-15-2-13-is-now-available/

Percona announces the release of Percona XtraDB Cluster 5.6.40-26.25 (PXC) on June 20, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.40-26.25 is now the current release, based on the following: Percona Server for MySQL 5.6.40 Galera/Codership WSREP API Release 5.6.39 Galera Replication library 3.23 All Percona software [&]

The post Percona XtraDB Cluster 5.6.40-26.25 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/20/percona-xtradb-cluster-5-6-40-26-25-is-now-available/

Percona announces the release of Percona XtraDB Cluster 5.6.40-26.25 (PXC) on June 20, 2018. Binaries are available from the downloads section or our software repositories. Percona XtraDB Cluster 5.6.40-26.25 is now the current release, based on the following: Percona Server for MySQL 5.6.40 Galera/Codership WSREP API Release 5.6.39 Galera Replication library 3.23 All Percona software [&]

The post Percona XtraDB Cluster 5.6.40-26.25 Is Now Available appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/20/percona-xtradb-cluster-5-6-40-26-25-is-now-available/

Serverless is a new buzzword in the database industry. Even though it gets tossed around often, there is some confusion about what it really means and how it really works. Serverless architectures rely on third-party Backend as a Service (BaaS) services. They can also include custom code that is run in managed, ephemeral containers on [&]

The post Is Serverless Just a New Word for Cloud Based? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/20/is-serverless-just-a-new-word-for-cloud-based/

Serverless is a new buzzword in the database industry. Even though it gets tossed around often, there is some confusion about what it really means and how it really works. Serverless architectures rely on third-party Backend as a Service (BaaS) services. They can also include custom code that is run in managed, ephemeral containers on [&]

The post Is Serverless Just a New Word for Cloud Based? appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/20/is-serverless-just-a-new-word-for-cloud-based/

Please join Percona’s MySQL Database Administrator, Brad Mickel as he presents How to Analyze and Tune MySQL Queries for Better Performance on Thursday, June 21st, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now   Query performance is essential in making any application successful. In order to finely tune your queries [&]

The post Webinar Thu 6/21: How to Analyze and Tune MySQL Queries for Better Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/20/webinar-thu-6-21-how-to-analyze-and-tune-mysql-queries-for-better-performance/

Please join Percona’s MySQL Database Administrator, Brad Mickel as he presents How to Analyze and Tune MySQL Queries for Better Performance on Thursday, June 21st, 2018, at 10:00 AM PDT (UTC-7) / 1:00 PM EDT (UTC-4). Register Now   Query performance is essential in making any application successful. In order to finely tune your queries [&]

The post Webinar Thu 6/21: How to Analyze and Tune MySQL Queries for Better Performance appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/20/webinar-thu-6-21-how-to-analyze-and-tune-mysql-queries-for-better-performance/

Since MySQL 5.7.5, we have been able to resize dynamically the InnoDB Buffer Pool. This new feature also introduced a new variable — innodb_buffer_pool_chunk_size — which defines the chunk size by which the buffer pool is enlarged or reduced. This variable is not dynamic and if it is incorrectly configured, could lead to undesired situations. [&]

The post Chunk Change: InnoDB Buffer Pool Resizing appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/19/chunk-change-innodb-buffer-pool-resizing/

Including setting up Percona XtraDB Cluster with ProxySQL and PMM Please join Percona’s Architect, Tibi K"or"ocz as he presents Percona XtraDB Cluster 5.7 Tutorial Part 2 on Wednesday, June 20th, 2018, at 7:00 am PDT (UTC-7) / 10:00 am EDT (UTC-4). Register Now   Never used Percona XtraDB Cluster before? This is the webinar for [&]

The post Webinar Weds 20/6: Percona XtraDB Cluster 5.7 Tutorial Part 2 appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/06/19/webinar-weds-20-6-percona-xtradb-cluster-5-7-tutorial-part-2/