I was recently faced with a real issue about completely exhausting the disk space on MySQL. This was a serious issue because of the continuous outages of the service, as the customer had to constantly restart the server and wait for the next outage. What was happening? In this article, Im going to explain it [&]

https://www.percona.com/blog/2019/07/17/mysql-disk-space-exhaustion-for-implicit-temporary-tables/

With such a wide range of options available for running MySQL based servers in Amazon cloud environments, how do you choose? Theres no doubt its a challenge. In this two-part series of blog posts, well try to draw a fair and informative comparison based on well-established benchmark scenarios – at scale. In part one we [&]

https://www.percona.com/blog/2019/07/17/assessing-mysql-performance-amongst-aws-options-part-one/

Please join Percona’s Service Delivery Manager Rodrigo Trindade as he presents “Troubleshooting Java Connections to MySQL” on Thursday, July 18th, 2019 at 10:00 AM PDT (UTC-7). Register Now This talk will explain the steps needed to make a connection from Java to MySQL work and highlight potential issues you might encounter. It will cover all [&]

https://www.percona.com/blog/2019/07/17/webinar-how-to-connect-a-mysql-database-with-java/

We are glad to announce the 1.1.0 release of the Percona Kubernetes Operator for Percona Server for MongoDB. The Operator simplifies the deployment and management of the Percona Server for MongoDB in Kubernetes-based environments. It extends the Kubernetes API with a new custom resource for deploying, configuring and managing the application through the whole life [&]

https://www.percona.com/blog/2019/07/16/percona-kubernetes-operator-for-mongodb-1-1-0-is-now-available/

proposed by PostgreSQL contributor Alvaro Herrera. BRIN stands for “Block Range INdex”. A block range is a group of pages adjacent to each other, where summary information about all those pages is stored in Index.  For example, Datatypes like integers  dates where sort order is linear  can be stored as min and max [&]

https://www.percona.com/blog/2019/07/16/brin-index-for-postgresql-dont-forget-the-benefits/

We are pleased to announce the launch of Percona Open Source Advance (POSA). POSA is a consulting-led migration solution which assesses your existing proprietary database architecture and helps you migrate to the most suitable free open source software available. Open source software migrations are increasingly mandated as strategic initiatives for companies but often require expert [&]

https://www.percona.com/blog/2019/07/16/avoid-vendor-lock-in-by-embracing-open-source/

We are glad to announce the 1.1.0 release of the  Percona Kubernetes Operator for Percona XtraDB Cluster. The Percona Kubernetes Operator for Percona XtraDB Cluster automates the lifecycle and provides a consistent Percona XtraDB Cluster instance. The Operator can be used to create a Percona XtraDB Cluster, or scale an existing Cluster, and contains the [&]

https://www.percona.com/blog/2019/07/16/percona-kubernetes-operator-for-percona-xtradb-cluster-1-1-0/

The Percona Live Open Source Database Conference, Europe 2019 will have a one week extension of the call for papers.  Our new close date will be Monday July 22, 2019.  Any and all topics related to open source database technologies are invited. This years conference takes a new approach, organizing tracks along these key business [&]

https://www.percona.com/blog/2019/07/16/percona-live-europe-2019-conference-updates/

Recently I had a customer where every single query was running in a transaction, as well as even the simplest selects. Unfortunately, this is not unique and many connectors like Java love to do that. In their case, the Java connector changed autocommit=off for the connection itself at the beginning, and as these were permanent [&]

https://www.percona.com/blog/2019/07/15/mysql-the-impact-of-transactions-on-query-throughput/

Most any commercially mature DBMS provides the following five ways to secure the data you keep inside it: Authentication of user connections (== Identity) Authorization (== DB command permissions) (a.k.a. Role-based access control) Network Encryption (a.k.a. Transport encryption) Storage Encryption (a.k.a. Encryption-at-rest) Auditing (MongoDB Enterprise or Percona Server for MongoDB only) MongoDB is no exception. [&]

https://www.percona.com/blog/2019/07/12/mongodb-security-vs-five-bad-guys/

Most any commercially mature DBMS provides the following five ways to secure the data you keep inside it: Authentication of user connections (== Identity) Authorization (== DB command permissions) (a.k.a. Role-based access control) Network Encryption (a.k.a. Transport encryption) Storage Encryption (a.k.a. Encryption-at-rest) Auditing (MongoDB Enterprise or Percona Server for MongoDB only) MongoDB is no exception. [&]

https://www.percona.com/blog/2019/07/12/mongodb-security-vs-five-bad-guys/

Docker Security Considerations – PART I Why Docker Security Matters It is a fact that Docker has found widespread use during the past years, mostly because it is very easy to use as well as fast and easy to deploy when compared with a full-blown virtual machine. More and more servers are being operated as [&]

https://www.percona.com/blog/2019/07/11/docker-security-considerations-part-i/

Percona is glad to announce the release of Percona XtraBackup 2.4.15 on July 10, 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/07/10/percona-xtrabackup-2-4-15-is-now-available/

WAL retention is a very important topic for PostgreSQL database management. But very often we come across DBAs getting into surprise situations such as: 1. Several TBs of WALs piled up in archive destination 2. WALs filling up pg_wal/pg_xlog directory due to failing archive 3. Necessary WALs are no longer preserved External backup projects for [&]

https://www.percona.com/blog/2019/07/10/wal-retention-and-clean-up-pg_archivecleanup/

Please join Percona Consultant Doug Duncan as he presents his talk “Building Kubernetes Operator for Percona Server for MongoDB” on Wednesday, July 10th, 2019 at 10:00 AM PDT (UTC-7). Register Now Doug will discuss the basic knowledge needed to understand the complications of running MongoDB inside of a containerized environment and then to go over [&]

https://www.percona.com/blog/2019/07/08/upcoming-webinar-7-10-learn-how-to-run-mongodb-inside-of-a-containerized-environment/

During our work in support, we see this again and again: I try to connect to MySQL and am getting a 1045 error, and most times it comes accompanied with &but I am sure my user and password are OK.  So we decided it was worth showing other reasons this error may occur. MySQL 1045 [&]

https://www.percona.com/blog/2019/07/05/fixing-a-mysql-1045-error/

A time ago we wrote about how personalized roles may help you to give specific permissions when it is needed. This time we want to discuss how a custom role, combined with a MongoDB View, can hide sensitive information from the client. Hiding Fields in MongoDB Suppose you have a collection that needs to be [&]

https://www.percona.com/blog/2019/07/05/hiding-fields-in-mongodb-views-custom-roles/

Mistakes can happen. If only we could go back in time to the very second before that mistake was made. Act 1: The Disaster Plain text version for those who cannot run the asciicast above: [crayon-5d2088edb0e81422304874/] Act 2: Time travel with a Snapshot restore + Oplog replay Plain text version for those who cannot run [&]

https://www.percona.com/blog/2019/07/05/mongodb-disaster-snapshot-restore-and-point-in-time-replay/

Last year, we asked you a few questions in a blog poll and we received a great amount of feedback. This year, we wanted to follow up on those same survey questions to see what may have changed over the last 12 months. So with that in mind, were hoping you can take a minute [&]

https://www.percona.com/blog/2019/07/03/blog-poll-what-keeps-you-up-at-night/

I think it is often confusing to compare upstream MySQL and Percona Server for MySQL, and some helpful information can be found in the introductory notes. But what does that really mean for an ordinary DBA, especially if none of the known big extra features are important in a particular use case? In this article, [&]

https://www.percona.com/blog/2019/07/03/percona-server-for-mysql-highlights-binlog_space_limit/