The goal of this blog post is to explain the various types of transaction isolation levels available in MySQL. After reading the blog, you will be able to explain dirty reads, non-repeatable reads, and the concept of phantom rows as well. What is the Isolation Level in MySQL? Isolation (I) is one of the properties [&]

https://www.percona.com/blog/2021/02/11/various-types-of-innodb-transaction-isolation-levels-explained-using-terminal/

I have a local Percona Monitoring and Management (PMM) instance at home, which I use to look after my local databases. With the release of PMM 2.14 and its support for monitoring of external “serverless” stuff, I decided to check if I can get some insights into my local networking. I have a TP-Link TL-SG108PE [&]

https://www.percona.com/blog/2021/02/09/monitoring-a-tp-link-switch-with-percona-monitoring-and-management/

A few weeks ago I sat down and talked about tuning MongoDB memory settings with Mike Grayson, one of our MongoDB Database Engineers here at Percona. If you have not seen the video I would recommend it.  Since then I have heard from people in the community about other topics they would like to see.  [&]

https://www.percona.com/blog/2021/02/09/mongodb-sharding-replication-101-the-communitys-questions-answered/

Running Database-as-a-Service (DBaaS) in the cloud is the norm for users today. It provides a ready-to-use database instance for users in a few seconds, which can be easily scaled and usually comes with a pay-as-you-go model. We at Percona see that more and more cloud vendors or enterprises either want to or are already running [&]

https://www.percona.com/blog/2021/02/08/dbaas-on-kubernetes-under-the-hood/

About two years ago I wrote about installing Percona Monitoring and Management (PMM) on Linode using StackScripts. This is a great way to automate the process,  and now you can do even better by deploying Percona Monitoring and Management from Linode Marketplace. The process can now be done in even fewer clicks! Click on “Deploy [&]

https://www.percona.com/blog/2021/02/08/installing-percona-monitoring-and-management-v2-on-linode/

Join Brian Walters and Brandon Fleisher for an interactive discussion around new service and software offerings coming from Percona. Oracle has decided that MySQL 5.6 will reach its end of life in February 2021. This means there will be no more updates and, more importantly, no more security fixes for discovered vulnerabilities. Yikes! Did you [&]

https://www.percona.com/blog/2021/02/05/webinar-february-24-whats-old-is-new-whats-coming-is-here-percona-offerings-for-mysql-5-6-and-dbaas-in-pmm/

If you have not heard, this weekend is FOSDEM.  FOSDEM this year is virtual (and open to all), and it looks like it is going to be an absolutely stellar lineup of open source content.  The details:  February 6-7th, 2021, with over 600 speakers, over 700 sessions, and 113 tracks!  So much to see.   [&]

https://www.percona.com/blog/2021/02/05/fosdem-is-this-weekend-matt-yonkovits-must-see-sessions/

Hi and thanks to all who attended my webinar on Tuesday, January 26th titled Using PMM to Identify & Troubleshoot Problematic MySQL Queries! Like we do after all our webinars, we compile the list of questions that were answered verbally and also those that were posed yet remained unanswered since we ran out of time [&]

https://www.percona.com/blog/2021/02/03/qa-on-webinar-using-pmm-to-identify-and-troubleshoot-problematic-mysql-queries/

Something new and exciting this year for Percona Live ONLINE is the inclusion of “Community Rooms”.  Every year we struggle with fitting in as many sessions as we can into Percona Live.  As the largest open-source database conference, we want to be inclusive of as many different projects and database technologies as possible.  We recognize [&]

https://www.percona.com/blog/2021/02/03/introducing-percona-live-community-rooms/

After MongoDB switched to SSPL I wrote part one of this article, titled “Why MongoDB’s SSPL is Bad For You”. At the time it was a MongoDB phenomenon, though over the last 2+ years more companies (typically VC-funded unicorns or public companies) changed licenses to SSPL or similar. This culminated in Elastic changing their license [&]

https://www.percona.com/blog/2021/02/02/why-sspl-is-bad-for-you-part-2/

Hello, open source community!   We need your help.  We want to make sure you are getting what you need from Percona software, so we have built a series of quick surveys  of six or fewer questions  each asking if you are using our software and if you would recommend it to others.  They [&]

https://www.percona.com/blog/2021/02/02/percona-software-feedback-help-us-help-you/

Recently, I wrote an overview about what you need to know about PostgreSQL security. For this post, I want to write about PostgreSQL authentication. It is divided into three categories: 1. PostgreSQL Internal Authentication, 2. OS-based Authentication, and 3. External Server-Based Authentication.  In most cases, PostgreSQL is configured to be used with internal authentication, so [&]

https://www.percona.com/blog/2021/02/01/postgresql-database-security-authentication/

Its release roundup time here at Percona! Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights and critical information, as well as links to the full release notes and direct links to the software or service itself to download. Todays post [&]

https://www.percona.com/blog/2021/02/01/push-metrics-for-percona-monitoring-and-management-percona-distribution-for-mongodb-4-4-3-release-roundup-february-1-2021/

In Percona Monitoring and Management 2.12.0 (PMM), we replaced Prometheus with VictoriaMetrics. Metrics data can now be ‘pushed’ to the server as well as being ‘pulled’ by the server. This is useful if you want to keep open ports to a minimum or your monitored system is in an environment that favors “inside>out” communication (like [&]

https://www.percona.com/blog/2021/01/29/percona-monitoring-and-management-2-14-moving-to-a-push-model-for-victoriametrics/

Dont miss out! Join Peter Zaitsev, Percona CEO, as he discusses DBaaS and Kubernetes. DBaaS is the fastest-growing way to deploy databases. It is fast and convenient yet it is typically done using proprietary software and tightly coupled to the cloud vendor. Percona believes Kubernetes finally enables a fully Open Source DBaaS Solution capable of [&]

https://www.percona.com/blog/2021/01/29/webinar-february-10-kubernetes-the-path-to-open-source-dbaas/

Some time ago, I required a specific version of PostgreSQL. After searching on all the repositories, I was unable to find that specific version. It seems that the PostgreSQL community removes the old package when a new minor version comes. For example, if you need the 12.2 version but the 12.3 version is out, its [&]

https://www.percona.com/blog/2021/01/28/how-to-create-postgresql-custom-builds-and-debian-packages/

There are several ways to deploy ProxySQL between your applications and the database servers. A common approach is to have a floating virtual IP (VIP) managed by keepalived as the application endpoint. The proxies have to be strategically provisioned to improve the resiliency of the solution (different hardware, network segments, etc,). When we consider cloud [&]

https://www.percona.com/blog/2021/01/28/load-balancing-proxysql-in-aws/

Percona XtraBackup 8.0.23 enables the lock-ddl option by default to ensure any DDL events do not corrupt the backups. Any DML events continue to occur, and only DDL events are blocked. A DDL lock protects the definition of tables and views. With the “lock-ddl” option disabled, Percona XtraBackup allows backups while concurrent DDL events continue [&]

https://www.percona.com/blog/2021/01/27/percona-xtrabackup-8-enables-lock-ddl-by-default/

Percona Live ONLINE will be held virtually from May 12-13, 2021 and we’re excited to announce the call for papers for the conference is now open! TL;DR The conference will be held online from May 12-13, 2021 Call for papers open now The deadline for submissions is February 28, 2021 Seeking submissions for lightning talks, [&]

https://www.percona.com/blog/2021/01/27/percona-live-online-2021-call-for-papers/

I want to present a tool for running a specific version of open source databases in a single instance, replication setups, and Kubernetes. AnyDbVer deploys MySQL/MariaDB/MongoDB/PostgreSQL for testing and experiments. It Could Be Started By& Docker (or Podman) or dbdeployer (MySQL-Sandbox successor) could also start a specific database version, but such installations are significantly different [&]

https://www.percona.com/blog/2021/01/27/deploying-any-version-of-leading-open-source-databases-for-tests-and-experiments/