In a Linux world, whenever your database server crashes or gets terminated, you need to find its cause. There can be several reasons for this. It can be SIGSEGV, which is a crash due to some bug in the backend server, but this is the least likely reason. The most common reason is running out [&]

https://www.percona.com/blog/2019/08/02/out-of-memory-killer-or-savior/

Capital One dominated the headlines this week when they disclosed that they had become the latest hacking victim with a shared responsibility between them and their customers. Does this mean Amazon bears no responsibility in a breach like this? Not entirely (more on that later). Responsibility of the User One major issue is that the [&]

https://www.percona.com/blog/2019/08/01/your-personal-data-just-leaked-and-its-your-fault/

In this post, we will discuss a new feature  the MySQL 8.0.17 installing other plugins. Below is the command line to install the clone plugin: [crayon-5d5c7069d080e386554329/] And how to check if the clone plugin is active: [crayon-5d5c7069d0814897047615/] Note that these steps need to be executed on the Donor (clone_valid_donor_list parameter. As it is a [&]

https://www.percona.com/blog/2019/08/01/mysql-8-0-17-clone-plugin-how-to-create-a-slave-from-scratch/

One of the great features of PostgreSQL is its extendability. My colleague and senior PostgreSQL developer Ibar has blogged about developing an extension with much broader capabilities including callback functionality. But in this blog post, I am trying to address a complete novice user who has never tried but wants to develop a simple function [&]

https://www.percona.com/blog/2019/07/31/postgresql-simple-c-extension-development-for-a-novice-user/

Next up in line for the blog poll series is a question about database management. Last year, we asked you a few questions in a blog poll and we received a great amount of feedback. We wanted to follow up on those some of those same survey questions to see what may have changed over [&]

https://www.percona.com/blog/2019/07/31/blog-poll-whos-responsible-for-securing-the-data-in-your-databases/

There is always a need for profiling tools in databases for admins or developers. While it is easy to understand the point where an SQL is spending more time using [crayon-5d5b15ed42f79136795479-i/] or [crayon-5d5b15ed42f7d687411335-i/] in PostgreSQL, the same would not work for functions. Recently, Jobin has published a blog post where he demonstrated how plprofiler can [&]

https://www.percona.com/blog/2019/07/30/using-plpgsql_check-to-find-compilation-errors-and-profile-functions/

Why do I need Network encryption? In our previous blog post MongoDB Security vs. Five ‘Bad Guys’ theres an overview of five main areas of security functions. Lets say youve enabled #1 and #2 (Authentication, Authorization) and #4 (Storage encryption a.k.a. encryption-at-rest and Auditing) mentioned in the previous blog post. Only authenticated users will be [&]

https://www.percona.com/blog/2019/07/30/network-transport-encryption-for-mongodb/

PostgreSQL is one of the finest object-relational databases, and its architecture is process-based instead of thread-based. While almost all the current database systems utilize threads for parallelism, PostgreSQLs process-based architecture was implemented prior to POSIX threads. PostgreSQL launches a process “postmaster” on startup, and after that spans new process whenever a new client connects to [&]

https://www.percona.com/blog/2019/07/30/parallelism-in-postgresql/

Debian 10 Buster packages have been released into the Percona packaging repositories.  Recent versions of Percona Server for MySQL, Percona XtraDB Cluster, Percona XtraBackup, Percona Server for MongoDB, Percona Toolkit, and the PMM Client can now be automatically installed via the Debian 10 apt command. Global Debian 10 Buster Setup: [crayon-5d3f0cf4ab8cc622524601/] Percona Server 5.7, Percona [&]

https://www.percona.com/blog/2019/07/26/debian-10-buster-packages-available-for-percona-products/

Join Percona Support Engineer Vinicius Grippa as he presents his talk “Enhancing MySQL Security” on Thursday, July 25th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now Security is always a challenge when its comes to data. Moreso, regulations like GDPR add a whole new layer on top of it, with [&]

https://www.percona.com/blog/2019/07/24/upcoming-webinar-enhancing-mysql-security/

Join Percona Support Engineer Vinicius Grippa as he presents his talk “Enhancing MySQL Security” on Thursday, July 25th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now Security is always a challenge when its comes to data. Moreso, regulations like GDPR add a whole new layer on top of it, with [&]

https://www.percona.com/blog/2019/07/24/upcoming-webinar-enhancing-mysql-security/

Join Percona Support Engineer Vinicius Grippa as he presents his talk “Enhancing MySQL Security” on Thursday, July 25th, 2019 at 6:00 AM PDT (UTC-7) / 9:00 AM EDT (UTC-4). Register Now Security is always a challenge when its comes to data. Moreso, regulations like GDPR add a whole new layer on top of it, with [&]

https://www.percona.com/blog/2019/07/24/upcoming-webinar-enhancing-mysql-security/

ERROR 1040&again A pretty common topic in Support tickets is the rather infamous error: ERROR 1040: Too many connections. The issue is pretty self-explanatory: your application/users are trying to create more connections than the server allows, or in other words, the current number of connections exceeds the value of the max_connections variable. This situation on [&]

https://www.percona.com/blog/2019/07/23/connect-to-mysql-after-hitting-error-1040-too-many-connections/

As a Solutions Engineer at Percona, one of my responsibilities is to support our customer-facing roles such as the sales and customer success teams, which affords me the opportunity to speak to many current and new customers who partner with Percona. I often find that many people are interested in Percona Monitoring and Management (PMM) [&]

https://www.percona.com/blog/2019/07/23/pmm-for-mongodb-start-guide/

We are pleased to announce our 4th Beta release of PMM 2! PMM (Percona Monitoring and Management) is a free and open-source platform for managing and monitoring MySQL, MongoDB, and PostgreSQL performance. With this release weve made the following improvements since our last public Beta at the end of May: Query Analytics PostgreSQL  Aggregate [&]

https://www.percona.com/blog/2019/07/22/percona-monitoring-and-management-pmm-2-beta-4-is-now-available/

In my previous blog post, we have seen how the extension pg_qualstats is an extension developed by the POWA Team who have contributed to the very useful extension [crayon-5d3a0c129851e671456198-i/] in PostgreSQL. Lets discuss this approach on Hacker News. 

https://www.percona.com/blog/2019/07/22/automatic-index-recommendations-in-postgresql-using-pg_qualstats-and-hypopg/

Please join Percona’s Senior Support Engineer Charly Batista as he presents “10 Common Mistakes (Java) Developers Make when Writing SQL” on Tuesday, July 23rd, 2019 at 8:00 AM EDT (UTC-4). Register Now Its easy for Java developers (and users of other OO languages) to mix object-oriented thinking and imperative thinking. But when it comes to [&]

https://www.percona.com/blog/2019/07/19/webinar-common-mistakes-java-developers-make-when-writing-sql/

See part one of this series here.  This post is part two of my series Assessing MySQL Performance Amongst AWS Options, taking a look at how current Amazon RDS services – Amazon Aurora and Amazon RDS for MySQL – compare with Percona Server with InnoDB and RocksDB engines on EC2 instances. This time around, I [&]

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

When a MongoDB server crashes you will usually find what is called a stack trace in its log file. But what is it and what purpose does it have? Lets simulate a simple crash so we can dig into it. Crashing a test server In a test setup with a freshly installed MongoDB server, we [&]

https://www.percona.com/blog/2019/07/18/resolving-mongodb-stack-trace/

When a MongoDB server crashes you will usually find what is called a stack trace in its log file. But what is it and what purpose does it have? Lets simulate a simple crash so we can dig into it. Crashing a test server In a test setup with a freshly installed MongoDB server, we [&]

https://www.percona.com/blog/2019/07/18/resolving-mongodb-stack-trace/