Wed, 27 Mar 2024 14:03:47 +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/using-pam-with-sasl-in-percona-server-for-mongodb/ https://www.percona.com/blog/using-pam-with-sasl-in-percona-server-for-mongodb/#respond Wed, 27 Mar 2024 14:03:47 +0000 https://www.percona.com/blog/?p=95210 Percona Server for MongoDB currently has several external authentication options, such as LDAP with SASL, LDAP, Kerberos, and AWS IAM. What is amazing is that SASL can authenticate with Pluggable Authentication Modules (PAM) too. This means that you still have additional external authentication options to choose from through PAM libraries.For a quick demonstration of PAM […]]]> https://www.percona.com/blog/using-pam-with-sasl-in-percona-server-for-mongodb/feed/ 0 95210 https://www.percona.com/blog/testing-ldap-authentication-and-authorization-on-percona-operator-for-mongodb/ https://www.percona.com/blog/testing-ldap-authentication-and-authorization-on-percona-operator-for-mongodb/#comments Mon, 19 Sep 2022 13:35:44 +0000 https://www.percona.com/blog/?p=82461 As of Percona Operator for MongoDB 1.12.0, the documentation now has instructions on how to configure LDAP Authentication and Authorization. It already contains an example of how to configure the operator if OpenLDAP is your LDAP server. Here is another example of setting it up but using Samba as your LDAP server.To simplify the installation […]]]> https://www.percona.com/blog/testing-ldap-authentication-and-authorization-on-percona-operator-for-mongodb/feed/ 1 82461 https://www.percona.com/blog/using-vault-to-store-the-master-key-for-data-at-rest-encryption-on-percona-server-for-mongodb/ https://www.percona.com/blog/using-vault-to-store-the-master-key-for-data-at-rest-encryption-on-percona-server-for-mongodb/#comments Tue, 21 Apr 2020 12:30:20 +0000 https://www.percona.com/blog/?p=66495 Since the release of Percona Server MongoDB 3.6.13 (PSMDB), you have been able to use Vault to store the encryption keys for data at rest encryption. Here’s how to set it up.First, you need to have a Vault server up and running. My colleague, Jericho, has an article on setting up Vault for Percona Server […]]]> https://www.percona.com/blog/using-vault-to-store-the-master-key-for-data-at-rest-encryption-on-percona-server-for-mongodb/feed/ 3 66495 https://www.percona.com/blog/setting-world-writable-file-permissions-prior-to-preparing-the-backup-can-break-it/ https://www.percona.com/blog/setting-world-writable-file-permissions-prior-to-preparing-the-backup-can-break-it/#comments Mon, 01 Jul 2019 14:50:03 +0000 https://www.percona.com/blog/?p=57909 It’s bad practice to provide world-writable access to critical files in Linux, though we’ve seen time and time again that this is done to conveniently share files with other users, applications, or services. But with Xtrabackup, preparing backups could go wrong if the backup configuration has world-writable file permissions.Say you performed a backup on a […]]]> https://www.percona.com/blog/setting-world-writable-file-permissions-prior-to-preparing-the-backup-can-break-it/feed/ 1 57909 https://www.percona.com/blog/how-to-fix-mysql-replication-after-an-incompatible-ddl-command/ https://www.percona.com/blog/how-to-fix-mysql-replication-after-an-incompatible-ddl-command/#comments Mon, 01 Oct 2018 11:40:37 +0000 https://www.percona.com/blog/?p=52668 MySQL supports replicating to a slave that is one release higher. This allows us to easily upgrade our MySQL setup to a new version, by promoting the slave and pointing the application to it. However, though unsupported, there are times when the MySQL version of slave deployed is one release lower. In this scenario, if […]]]> https://www.percona.com/blog/how-to-fix-mysql-replication-after-an-incompatible-ddl-command/feed/ 4 52668 https://www.percona.com/blog/fixing-er_master_has_purged_required_gtids-when-pointing-a-slave-to-a-different-master/ https://www.percona.com/blog/fixing-er_master_has_purged_required_gtids-when-pointing-a-slave-to-a-different-master/#comments Mon, 02 Jul 2018 11:50:08 +0000 https://www.percona.com/blog/?p=50939 GTID replication has made it convenient to setup and maintain MySQL replication. You need not worry about binary log file and position thanks to GTID and auto-positioning. However, things can go wrong when pointing a slave to a different master. Consider a situation where the new master has executed transactions that haven’t been executed on […]]]> https://www.percona.com/blog/fixing-er_master_has_purged_required_gtids-when-pointing-a-slave-to-a-different-master/feed/ 1 50939 https://www.percona.com/blog/mysql-8-0-innodb_dedicated_server-variable-optimizes-innodb/ https://www.percona.com/blog/mysql-8-0-innodb_dedicated_server-variable-optimizes-innodb/#comments Mon, 26 Mar 2018 20:26:50 +0000 https://www.percona.com/blog/?p=48473 In this post, we’ll look at the MySQL 8.0 innodb_dedicated_server variable.MySQL 8.0 introduces a new variable called innodb_dedicated_server. When enabled, it auto tunes innodb_buffer_pool_size, innodb_log_file_size and innodb_flush_method at startup (if these variables are not explicitly defined in my.cnf).The new MySQL 8.0 variable automatically sizes the following variables based on the RAM size of the system:innodb_buffer_pool_size: […]]]> https://www.percona.com/blog/mysql-8-0-innodb_dedicated_server-variable-optimizes-innodb/feed/ 5 48473 https://www.percona.com/blog/compare-current-and-past-time-series-graphs-in-percona-monitoring-and-management-pmm/ Sat, 13 Jan 2018 00:35:22 +0000 https://www.percona.com/blog/?p=47010 In this short blog post, I will show you how you can compare current and past time series in Percona Monitoring and Management (PMM).Recently, a support customer shared a graph with us that compared query throughput between today and yesterday as a confirmation that optimizing their server variables improved performance.Do you want to compare workload […]]]> 47010 https://www.percona.com/blog/setting-percona-pam-active-directory-external-authentication/ Thu, 13 Jul 2017 19:17:10 +0000 https://www.percona.com/blog/?p=44232 In this blog post, we’ll look at how to set up Percona PAM with Active Directory for external authentication.In my previous article on Percona PAM, I demonstrated how to use Samba as a domain, and how easy it is to create domain users and groups via the samba-tool. Then we configured nss-pam-ldapd and nscd to […]]]> 44232 https://www.percona.com/blog/how-to-setup-and-troubleshoot-percona-pam-with-ldap-for-external-authentication/ https://www.percona.com/blog/how-to-setup-and-troubleshoot-percona-pam-with-ldap-for-external-authentication/#comments Fri, 21 Apr 2017 16:20:39 +0000 https://www.percona.com/blog/?p=42685 In this blog, we’ll look at how to setup and troubleshoot the Percona PAM authentication plugin.We occasionally get requests from our support clients on how to get Percona Server for MySQL to authenticate with an external authentication service via LDAP or Active Directory. However, we normally do not have access to client’s infrastructure to help […]]]> https://www.percona.com/blog/how-to-setup-and-troubleshoot-percona-pam-with-ldap-for-external-authentication/feed/ 2 42685 https://www.percona.com/blog/quickly-troubleshooting-metadata-locks-mysql-5-7/ https://www.percona.com/blog/quickly-troubleshooting-metadata-locks-mysql-5-7/#comments Wed, 28 Dec 2016 19:52:57 +0000 https://www.percona.com/blog/?p=39656 In a previous article, Ovais demonstrated how a DDL can render a table blocked from new queries. In another article, Valerii introduced performance_schema.metadata_locks, which is available in MySQL 5.7 and exposes metadata lock details. Given this information, here’s a quick way to troubleshoot metadata locks by creating a stored procedure that can: Find out which […]]]> https://www.percona.com/blog/quickly-troubleshooting-metadata-locks-mysql-5-7/feed/ 7 39656 https://www.percona.com/blog/generating-test-data-mysql-tables/ https://www.percona.com/blog/generating-test-data-mysql-tables/#comments Mon, 10 Feb 2014 08:00:09 +0000 https://www.percona.com/blog/?p=19581 One of the common tasks requested by our support customers is to optimize slow queries. We normally ask for the table structure(s), the problematic query and sample data to be able to reproduce the problem and resolve it by modifying the query, table structure, or global/session variables. Sometimes, we are given access to the server […]]]> https://www.percona.com/blog/generating-test-data-mysql-tables/feed/ 7 19581 https://www.percona.com/blog/getting-percona-pam-to-work-with-percona-server-its-client-apps/ https://www.percona.com/blog/getting-percona-pam-to-work-with-percona-server-its-client-apps/#comments Wed, 14 Aug 2013 07:46:41 +0000 https://www.percona.com/blog/?p=17354 https://www.percona.com/blog/getting-percona-pam-to-work-with-percona-server-its-client-apps/feed/ 5 17354