Sat, 17 Feb 2024 00:35:37 +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/syscalls-analysis-in-mysql-when-using-innodb_flush_method-and-innodb_use_fdatasync/ https://www.percona.com/blog/syscalls-analysis-in-mysql-when-using-innodb_flush_method-and-innodb_use_fdatasync/#respond Thu, 18 Jan 2024 15:08:43 +0000 https://www.percona.com/blog/?p=93503 In this blog post, we will discuss how to validate at the operating system level the effects of changing the innodb_flush_method to variations other than the default (particularly for O_DIRECT which is most commonly used) and the use of innodb_use_fdatasync.IntroductionFirst, let’s define what the innodb_flush_method parameter does. It dictates how InnoDB manages the flushing of data […]]]> https://www.percona.com/blog/syscalls-analysis-in-mysql-when-using-innodb_flush_method-and-innodb_use_fdatasync/feed/ 0 93503 https://www.percona.com/blog/securing-mongodb-top-five-security-concerns/ https://www.percona.com/blog/securing-mongodb-top-five-security-concerns/#respond Tue, 01 Aug 2023 16:08:40 +0000 https://www.percona.com/blog/?p=70498 https://www.percona.com/blog/securing-mongodb-top-five-security-concerns/feed/ 0 70498 https://www.percona.com/blog/mongodb-version-requirements-for-percona-backup-for-mongodb/ https://www.percona.com/blog/mongodb-version-requirements-for-percona-backup-for-mongodb/#respond Mon, 10 Jul 2023 13:35:43 +0000 https://www.percona.com/blog/?p=89349 Percona Backup for MongoDB (PBM) is a backup utility developed by Percona to address the needs of customers and users who prefer open source tools over proprietary software like MongoDB Enterprise and Ops Manager. PBM offers comprehensive support and ensures cluster-wide consistent backups for MongoDB without additional costs.MongoDB supported versionsWhile physical backups and restores are […]]]> https://www.percona.com/blog/mongodb-version-requirements-for-percona-backup-for-mongodb/feed/ 0 89349 https://www.percona.com/blog/chatgpt-vs-mysql-dba-challenge/ https://www.percona.com/blog/chatgpt-vs-mysql-dba-challenge/#comments Tue, 02 May 2023 12:40:39 +0000 https://www.percona.com/blog/?p=87482 Given the increasing popularity of ChatGPT in solving questions of humankind, I decided to take a better look at the current state of AI. At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. As the question comes from time to time, is my profession […]]]> https://www.percona.com/blog/chatgpt-vs-mysql-dba-challenge/feed/ 2 87482 https://www.percona.com/blog/mongodb-best-practices https://www.percona.com/blog/mongodb-best-practices#respond Mon, 17 Apr 2023 17:00:21 +0000 https://www.percona.com/blog/?p=66058 In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. The main objective of this post is to share my experience over the past years tuning […]]]> https://www.percona.com/blog/mongodb-best-practices/feed/ 0 66058 https://www.percona.com/blog/mysql-8-0-dynamic-redo-log-sizing/ https://www.percona.com/blog/mysql-8-0-dynamic-redo-log-sizing/#comments Wed, 10 Aug 2022 12:07:40 +0000 https://www.percona.com/blog/?p=82095 This blog post will discuss the newest feature available in MySQL 8.0.30: dynamic redo log sizing. After the InnoDB buffer pool size, we can say that having a proper size for the redo logs is crucial for MySQL performance. There are numerous blog posts about how to calculate a good redo log size. One of […]]]> https://www.percona.com/blog/mysql-8-0-dynamic-redo-log-sizing/feed/ 3 82095 https://www.percona.com/blog/backup-restore-performance-conclusion-mysqldump-vs-mysql-shell-utilities-vs-mydumper-vs-mysqlpump-vs-xtrabackup/ https://www.percona.com/blog/backup-restore-performance-conclusion-mysqldump-vs-mysql-shell-utilities-vs-mydumper-vs-mysqlpump-vs-xtrabackup/#comments Mon, 28 Feb 2022 13:53:56 +0000 https://www.percona.com/blog/?p=80233 A little bit ago, I released a blog post comparing the backup performance of different MySQL tools such as mysqldump, the MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. You can find the first analysis here:Backup Performance Comparison: mysqldump vs. MySQL Shell Utilities vs. mydumper vs. mysqlpump vs. XtraBackupHowever, we know the backups […]]]> https://www.percona.com/blog/backup-restore-performance-conclusion-mysqldump-vs-mysql-shell-utilities-vs-mydumper-vs-mysqlpump-vs-xtrabackup/feed/ 11 80233 https://www.percona.com/blog/dump-performance-comparison-mysqldump-vs-mysql-shell-utilities-vs-mydumper/ https://www.percona.com/blog/dump-performance-comparison-mysqldump-vs-mysql-shell-utilities-vs-mydumper/#comments Mon, 27 Dec 2021 13:30:13 +0000 https://www.percona.com/blog/?p=78255 In this blog post, we will compare the performance of performing a backup from a MySQL database using mysqldump, MySQL Shell feature called Instance Dump, mysqlpump, mydumper, and Percona XtraBackup. All these available options are open source and free to use for the entire community.To start, let’s see the results of the test.Benchmark ResultsThe benchmark […]]]> https://www.percona.com/blog/dump-performance-comparison-mysqldump-vs-mysql-shell-utilities-vs-mydumper/feed/ 13 78255 https://www.percona.com/blog/mongodb-message-cannot-add-session-into-the-cache-toomanylogicalsessions/ https://www.percona.com/blog/mongodb-message-cannot-add-session-into-the-cache-toomanylogicalsessions/#comments Thu, 03 Jun 2021 14:29:24 +0000 https://www.percona.com/blog/?p=76116 This week, I had an interesting case whereas one of our customers was facing the issue: [crayon-664c85cbc44b6484261161/] Studying this issue and discussing it with my colleagues I had to chance to explore in detail how the logical sessions in MongoDB are handled. First, a brief explanation of how the entire process workers and what is […]]]> https://www.percona.com/blog/mongodb-message-cannot-add-session-into-the-cache-toomanylogicalsessions/feed/ 4 76116 https://www.percona.com/blog/compiling-percona-xtrabackup-for-arm/ https://www.percona.com/blog/compiling-percona-xtrabackup-for-arm/#comments Wed, 28 Apr 2021 19:34:26 +0000 https://www.percona.com/blog/?p=75770 This blog post will show how to compile the Percona XtraBackup (PXB) tool for ARM. For this, we are going to use an AWS EC2 ARM instance with Ubuntu 20.04(Focal Fossa).The motivation for this was born in my interest in the new generation of ARM processors and if this is a viable option for the […]]]> https://www.percona.com/blog/compiling-percona-xtrabackup-for-arm/feed/ 1 75770 https://www.percona.com/blog/enabling-jemalloc-on-percona-server-for-mysql-5-7-and-8-0-series/ https://www.percona.com/blog/enabling-jemalloc-on-percona-server-for-mysql-5-7-and-8-0-series/#comments Wed, 02 Dec 2020 14:55:43 +0000 https://www.percona.com/blog/?p=72848 The benefits of jemalloc versus glibc memory allocator for use with MySQL have been widely discussed. With jemalloc (along with Transparent Huge Pages disabled) there is less memory fragmentation, and thus more efficient resource management of the server memory. For MySQL 5.6, installing jemalloc is enough to enable it when starting the MySQL process. However, for […]]]> https://www.percona.com/blog/enabling-jemalloc-on-percona-server-for-mysql-5-7-and-8-0-series/feed/ 3 72848 https://www.percona.com/blog/analyzing-mysql-with-strace/ Tue, 30 Jun 2020 16:31:07 +0000 https://www.percona.com/blog/?p=69412 In this blog post, we will briefly explore the OS tool strace. It is not widely used due to its performance impacts, and we don’t recommend using it in production. Still, it is amazing at helping you understand some things that happen in MySQL, where the OS is involved, and as a last case resource […]]]> 69412 https://www.percona.com/blog/enable-ldap-on-percona-monitoring-and-management-pmm/ Wed, 08 Jan 2020 15:47:27 +0000 https://www.percona.com/blog/?p=63707 Percona Monitoring and Management (PMM) has been on the road for a while now, and it brings exciting new features and improvements. For those who are not familiar with the tool, PMM allows deep insight into the performance of applications and databases. The most crucial highlight: it is 100% open-source. Also, the source code is present […]]]> 63707 https://www.percona.com/blog/mysql-8-0-17-clone-plugin-how-to-create-a-slave-from-scratch/ https://www.percona.com/blog/mysql-8-0-17-clone-plugin-how-to-create-a-slave-from-scratch/#comments Thu, 01 Aug 2019 15:24:35 +0000 https://www.percona.com/blog/?p=59651 In this post, we will discuss a new feature – the MySQL 8.0.17 clone plugin. Here I will demonstrate how easy it is to use to create the “classic” replication, building the standby replica from scratch.The clone plugin permits cloning data locally or from a remote MySQL server instance. The cloned data is a physical […]]]> https://www.percona.com/blog/mysql-8-0-17-clone-plugin-how-to-create-a-slave-from-scratch/feed/ 8 59651 https://www.percona.com/blog/live-mysql-slave-rebuild-with-percona-toolkit/ https://www.percona.com/blog/live-mysql-slave-rebuild-with-percona-toolkit/#comments Wed, 13 Mar 2019 11:58:07 +0000 https://www.percona.com/blog/?p=55560 Recently, we had an edge case where a MySQL slave went out-of-sync but it couldn’t be rebuilt from scratch. The slave was acting as a master server to some applications and it had data was being written to it. It was a design error, and this is not recommended, but it happened. So how do you […]]]> https://www.percona.com/blog/live-mysql-slave-rebuild-with-percona-toolkit/feed/ 3 55560 https://www.percona.com/blog/enhancing-mysql-security/ Tue, 05 Mar 2019 21:57:39 +0000 https://www.percona.com/blog/?p=55729 Join Percona Support Engineer, Vinicius Grippa, as he presents his talk Enhancing MySQL Security on Thursday, March 7th, 2019 at 7:00 AM PST (UTC-8) / 10:00 AM EST (UTC-5).View the RecordingSecurity is always a challenge when it comes to data. What’s more, regulations like GDPR add a whole new layer on top of it, with […]]]> 55729 https://www.percona.com/blog/replicating-mysql-8-0-mysql-5-7/ https://www.percona.com/blog/replicating-mysql-8-0-mysql-5-7/#comments Tue, 07 Aug 2018 13:01:50 +0000 https://www.percona.com/blog/?p=51580 In this blog post, we’ll discuss how to set a replication from MySQL 8.0 to MySQL 5.7. There are some situations that having this configuration might help. For example, in the case of a MySQL upgrade, it can be useful to have a master that is using a newer version of MySQL to an older version […]]]> https://www.percona.com/blog/replicating-mysql-8-0-mysql-5-7/feed/ 7 51580 https://www.percona.com/blog/safely-purging-binary-logs-from-master/ Wed, 28 Mar 2018 16:36:54 +0000 https://www.percona.com/blog/?p=48044 In this blog post, we’ll discuss some of the options available when purging binary logs. We’ll look at how to safely purge them when you have slaves in your topology and want to avoid deleting any binary log that still needs to be applied.Safely Purging Binary Logs From MasterWe generally want to ensure that, before […]]]> 48044