Mon, 20 May 2024 13:08:17 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://www.percona.com/blog/wp-content/uploads/2023/02/cropped-percona-favicon-32x32.png 32 32 76301791 https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/ https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/#respond Mon, 20 May 2024 13:06:30 +0000 https://www.percona.com/blog/?p=96350 If you were to ask me the question, “Would it be possible to set up a replicate filter within the Percona XtraDB Cluster?” my immediate response would be to question you right back. Why would you even want the cluster nodes to have different data when you’re using a synchronous replication cluster? That’s because, instinctively, […]]]> https://www.percona.com/blog/can-we-set-up-a-replicate-filter-within-the-percona-xtradb-cluster/feed/ 0 96350 https://www.percona.com/blog/choosing-the-right-database-comparing-mariadb-vs-mysql-postgresql-and-mongodb/ https://www.percona.com/blog/choosing-the-right-database-comparing-mariadb-vs-mysql-postgresql-and-mongodb/#respond Thu, 16 May 2024 12:46:12 +0000 https://www.percona.com/blog/?p=96342 Selecting the appropriate database technology for your needs is crucial for ensuring compatibility with existing applications and infrastructure, optimizing application performance, and reducing costs. With so many different choices available, it can be difficult to make such a decision!This blog post provides a head-to-head comparison of MariaDB vs. PostgreSQL, MongoDB, and MySQL, highlighting their similarities […]]]> https://www.percona.com/blog/choosing-the-right-database-comparing-mariadb-vs-mysql-postgresql-and-mongodb/feed/ 0 96342 https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/ https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/#respond Mon, 13 May 2024 13:19:30 +0000 https://www.percona.com/blog/?p=96293 Table modifications are a routine task for database administrators. The blog post Using Percona Toolkit to Alter Database Tables Online: A Controlled Approach provides insights into the process of altering tables online in a controlled manner, ensuring uninterrupted access for application users and preventing application downtime. We will focus here on utilizing the powerful “pt-online-schema-change” […]]]> https://www.percona.com/blog/seamless-table-modifications-leveraging-pt-online-schema-change-for-online-alterations/feed/ 0 96293 https://www.percona.com/blog/mysql-database-security-best-practices/ https://www.percona.com/blog/mysql-database-security-best-practices/#respond Thu, 09 May 2024 13:02:54 +0000 https://www.percona.com/blog/?p=96285 Have you ever read a news story about a major company experiencing a data breach that exposed millions of customer records? These breaches can be devastating, causing significant financial losses, reputational damage, and even legal repercussions. Unfortunately, MySQL databases, one of the most popular relational database management systems, is at the heart of many critical […]]]> https://www.percona.com/blog/mysql-database-security-best-practices/feed/ 0 96285 https://www.percona.com/blog/mysql-8-4-first-peek/ https://www.percona.com/blog/mysql-8-4-first-peek/#respond Wed, 01 May 2024 13:13:29 +0000 https://www.percona.com/blog/?p=96106 MySQL 8.4 has now been officially released, and this is a quick review of what is in the release notes. This is momentous as it is designated a Long-Term Support (LTS) release. Various 8.0 releases introduced material changes that impacted speed and stability, causing hair-pulling and swearing among those affected. Please note this is a […]]]> https://www.percona.com/blog/mysql-8-4-first-peek/feed/ 0 96106 https://www.percona.com/blog/why-mariadb-is-better-than-mysql/ https://www.percona.com/blog/why-mariadb-is-better-than-mysql/#respond Tue, 23 Apr 2024 15:36:53 +0000 https://www.percona.com/blog/?p=95980 Apples or oranges?Tea or coffee?Books or eBooks?Each of these comparisons has very similar features and serves many of the same purposes, but in the end, they are different choices people make. Do you know what else belongs on this list?MariaDB or MySQL?It’s time we discuss the age-old debate of MariaDB versus MySQL and see if […]]]> https://www.percona.com/blog/why-mariadb-is-better-than-mysql/feed/ 0 95980 https://www.percona.com/blog/did-mydumper-like-triggers/ https://www.percona.com/blog/did-mydumper-like-triggers/#respond Fri, 19 Apr 2024 13:46:56 +0000 https://www.percona.com/blog/?p=95924 Yes, but now it likes them more, and here is why.IntroUsing the LIKE clause to filter triggers or views from a specific table is common. However, it can play a trick on you, especially if you don’t get to see the output (i.e., in a non-interactive session). Let’s take a look at a simple example […]]]> https://www.percona.com/blog/did-mydumper-like-triggers/feed/ 0 95924 https://www.percona.com/blog/ultimate-guide-to-improving-database-performance/ https://www.percona.com/blog/ultimate-guide-to-improving-database-performance/#respond Thu, 18 Apr 2024 13:25:39 +0000 https://www.percona.com/blog/?p=95915 Welcome to the ultimate guide on how to boost your database performance! We’ve designed it to help you understand and improve the performance of your databases, regardless of your level of experience as a DBA or whether you manage databases for a small or large company.We’ll cover a number of very important topics, such as […]]]> https://www.percona.com/blog/ultimate-guide-to-improving-database-performance/feed/ 0 95915 https://www.percona.com/blog/a-guide-to-better-understanding-mysql-charset-levels/ https://www.percona.com/blog/a-guide-to-better-understanding-mysql-charset-levels/#respond Tue, 16 Apr 2024 13:24:05 +0000 https://www.percona.com/blog/?p=95701 We usually receive and see some questions regarding the charset levels in MySQL, especially after the deprecation of utf8mb3 and the new default uf8mb4. If you understand how the charset works on MySQL but have some questions regarding this change, please check out Migrating to utf8mb4: Things to Consider by Sveta Smirnova.Some of the questions […]]]> https://www.percona.com/blog/a-guide-to-better-understanding-mysql-charset-levels/feed/ 0 95701 https://www.percona.com/blog/why-select-count-from-table-is-sometimes-very-slow-in-mysql-or-mariadb/ https://www.percona.com/blog/why-select-count-from-table-is-sometimes-very-slow-in-mysql-or-mariadb/#comments Mon, 15 Apr 2024 13:02:26 +0000 https://www.percona.com/blog/?p=95505 If you have enough experience with MySQL, it is very possible that you stumbled upon an unusually slow SELECT COUNT(*) FROM TABLE; query execution, at least occasionally.Recently, I had a chance to investigate some of these cases closer, and it stunned me what huge differences there can be depending on the circumstance given the very […]]]> https://www.percona.com/blog/why-select-count-from-table-is-sometimes-very-slow-in-mysql-or-mariadb/feed/ 1 95505 https://www.percona.com/blog/partially-rolling-back-a-transaction-in-mysql-or-postgresql/ https://www.percona.com/blog/partially-rolling-back-a-transaction-in-mysql-or-postgresql/#respond Fri, 12 Apr 2024 13:36:18 +0000 https://www.percona.com/blog/?p=95737 This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to write an article on rolling back transactions to a particular point. I selected this topic because I found many people are not aware of this feature in databases.DescriptionEvery ACID-compliant RDBMS follows the “All or None” […]]]> https://www.percona.com/blog/partially-rolling-back-a-transaction-in-mysql-or-postgresql/feed/ 0 95737 https://www.percona.com/blog/how-to-replicate-and-rename-a-database-in-mariadb/ https://www.percona.com/blog/how-to-replicate-and-rename-a-database-in-mariadb/#comments Thu, 11 Apr 2024 13:14:12 +0000 https://www.percona.com/blog/?p=95734 MySQL/MariaDB replication filter is an important feature when we need to replicate only certain databases or tables. Having this configuration option change dynamically is really convenient, but in this article, we’ll note that some replication filters are not dynamic, and you should be aware of that.The use case here is to replicate one database from […]]]> https://www.percona.com/blog/how-to-replicate-and-rename-a-database-in-mariadb/feed/ 1 95734 https://www.percona.com/blog/percona-monitoring-and-management-setup-on-kubernetes-with-nginx-ingress-for-external-databases/ https://www.percona.com/blog/percona-monitoring-and-management-setup-on-kubernetes-with-nginx-ingress-for-external-databases/#respond Wed, 10 Apr 2024 12:49:04 +0000 https://www.percona.com/blog/?p=95637 It’s a common scenario to have a Percona Monitoring and Management (PMM) server running on Kubernetes and also desire to monitor databases that are running outside the Kubernetes cluster. The Ingress NGINX Controller is one of the most popular choices for managing the inbound traffic to K8s. It acts as a reverse proxy and load […]]]> https://www.percona.com/blog/percona-monitoring-and-management-setup-on-kubernetes-with-nginx-ingress-for-external-databases/feed/ 0 95637 https://www.percona.com/blog/ask-me-anything-about-mysql-5-7-to-8-0-post-eol/ https://www.percona.com/blog/ask-me-anything-about-mysql-5-7-to-8-0-post-eol/#respond Tue, 09 Apr 2024 16:02:36 +0000 https://www.percona.com/blog/?p=95688 We met with Vinicius Grippa, a Senior Support Engineer at Percona. He is also active in the open source community and was recognized as a MySQL Rock Star in 2023.In the previous interview with Vinicius, we discussed the upcoming End of Life (EOL) for MySQL 5.7. Now that MySQL 5.7 has reached EOL, MySQL 8 […]]]> https://www.percona.com/blog/ask-me-anything-about-mysql-5-7-to-8-0-post-eol/feed/ 0 95688 https://www.percona.com/blog/mysql-101-how-to-find-and-tune-a-slow-sql-query/ https://www.percona.com/blog/mysql-101-how-to-find-and-tune-a-slow-sql-query/#respond Wed, 03 Apr 2024 12:02:51 +0000 https://www.percona.com/blog/?p=69394 This blog was originally published in June 2020 and was updated in April 2024.One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket.  While this can be caused by a multitude of factors, it is more often than not caused by a bad or slow MySQL […]]]> https://www.percona.com/blog/mysql-101-how-to-find-and-tune-a-slow-sql-query/feed/ 0 69394 https://www.percona.com/blog/duplicate-redundant-and-invisible-indexes/ https://www.percona.com/blog/duplicate-redundant-and-invisible-indexes/#respond Tue, 02 Apr 2024 13:55:28 +0000 https://www.percona.com/blog/?p=84444 This blog was originally published in January 2023 and was updated in April 2024.MySQL index is a data structure used to optimize the performance of database queries at the expense of additional writes and storage space to keep the index data structure up to date. It is used to quickly locate data without having to […]]]> https://www.percona.com/blog/duplicate-redundant-and-invisible-indexes/feed/ 0 84444 https://www.percona.com/blog/deep-dive-into-mysqls-performance-schema/ https://www.percona.com/blog/deep-dive-into-mysqls-performance-schema/#comments Tue, 02 Apr 2024 11:23:21 +0000 https://www.percona.com/blog/?p=84466 This blog was originally published in January 2023 and was updated in April 2024.Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. We started looking into the stats of the performance schema. While working, the customer raised two interesting questions: how […]]]> https://www.percona.com/blog/deep-dive-into-mysqls-performance-schema/feed/ 1 84466 https://www.percona.com/blog/mysql-key-performance-indicators https://www.percona.com/blog/mysql-key-performance-indicators#respond Tue, 02 Apr 2024 09:00:29 +0000 https://www.percona.com/blog/?p=88829 This blog was originally published in June of 2023 and updated in April of 2024.As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for […]]]> https://www.percona.com/blog/mysql-key-performance-indicators/feed/ 0 88829 https://www.percona.com/blog/caching_sha2_password-support-for-proxysql-is-finally-available/ https://www.percona.com/blog/caching_sha2_password-support-for-proxysql-is-finally-available/#respond Mon, 01 Apr 2024 17:11:40 +0000 https://www.percona.com/blog/?p=95205 ProxySQL recently released version 2.6.0, and going through the release notes, I focused on the following:Added support for caching_sha2_password!This is great news for the community! The caching_sha2_password authentication method for frontend connections is now available. This has been a long-awaited feature …Why?Because in MySQL 8, caching_sha2_password has been the default authentication method. Starting from MySQL […]]]> https://www.percona.com/blog/caching_sha2_password-support-for-proxysql-is-finally-available/feed/ 0 95205 https://www.percona.com/blog/easily-validate-configuration-settings-in-mysql-8/ https://www.percona.com/blog/easily-validate-configuration-settings-in-mysql-8/#comments Mon, 01 Apr 2024 11:54:23 +0000 https://www.percona.com/blog/?p=75088 This blog was published in April of 2021 and updated in April of 2024.In past versions of MySQL, there was often an ‘upgrade dance’ that had to be performed in starting up a newly upgraded MySQL instance with the previous version configuration file. In some cases a few deprecated options might no longer be supported […]]]> https://www.percona.com/blog/easily-validate-configuration-settings-in-mysql-8/feed/ 1 75088