Jun
28
2024
--

Why Are Queries with Many IN Values More Expensive After Upgrading to MySQL 8.x?

IN Values More Expensive After Upgrading to MySQL 8Some of our Percona Support customers report performance degradation after a major MySQL upgrade, and there can be many different reasons for this. These days, the most common major upgrade is from MySQL 5.7 (which recently reached EOL) to 8.0, and I am going to emphasize one important case that affects many database instances. Range […]

Jun
27
2024
--

Adding TLS to LDAP Authentication in Percona Operator for MongoDB

TLS to LDAP Authentication in Percona Operator for MongoDBAs per K8SPSMDB-732, TLS is now supported with LDAP authentication on Percona Operator for MongoDB 1.16.0 and above. This feature has been documented here as well. I’ve written a previous article on using LDAP authentication and authorization without TLS, so let me provide the instructions here on incorporating TLS with LDAP. First, you need to […]

Jun
26
2024
--

MySQL Performance Monitoring: Best Practices

MySQL Performance MonitoringIs your MySQL database running at its best? While MySQL is known for its reliability and ease of use, ensuring top-notch performance is crucial. One way to do that is through performance monitoring, an essential practice for identifying bottlenecks, maintaining optimal speed, and guaranteeing a seamless user experience. Effective monitoring not only helps in detecting […]

Jun
25
2024
--

MySQL Replication: How To Deal With the ‘Got Fatal Error 1236’ or MY-013114 Error

MySQL Got Fatal Error 1236Replication has been the core functionality, allowing high availability in MySQL for decades already. However, you may still encounter replication errors that keep you awake at night. One of the most common and challenging to deal with starts with: “Got fatal error 1236 from source when reading data from binary log“. This blog post is […]

Jun
25
2024
--

Exploring the is_template Flag: Simplifying PostgreSQL Template Databases

PostgreSQL is a powerful and versatile relational database management system that provides many features for managing and manipulating databases. One such feature is the is_template flag, which can be used to create and manage template databases. In this blog post, we will explore what the is_template flag is, why it is useful, and how to […]

Jun
24
2024
--

Understanding Basic Flow Control Activity in MySQL Group Replication: Part One

Understanding Basic Flow Control Activity in MySQL Group ReplicationFlow control is not a new term, and we have already heard it a lot of times in Percona XtraDB Cluster/Galera-based environments.  In very simple terms, it means the cluster node can’t keep up with the cluster write pace. The write rate is too high, or the nodes are oversaturated. Flow control helps avoid excessive […]

Jun
24
2024
--

Talking Drupal #456 – DDEV Grows Up

Today we are talking about DDEV, The DDEV Community, and It’s Future Sustainability with guest Randy Fay and Andrew Berry. We’ll also cover DDEV Drupal Contrib as our module of the week.

For show notes visit: www.talkingDrupal.com/456

Topics

  • What is DDEV
  • In March you posted the DDEV Project Plan for 2024, what is the contributor training initiative
  • DDEV has grown rapidly over the past few years, what do you attribute that to
  • You seem to be the face of DDEV, who else is involved
  • How is DDEV funded
  • What happens when you retire
  • Does the DDEV Foundation have employees
  • What is DDEV coded in
  • What is your favorite feature of DDEV
  • What is next
  • How can people get involved

Resources

Guests

Andrew Berry – deviantintegral

Hosts

Nic Laflin – nLighteneddevelopment.com nicxvan John Picozzi – epam.com johnpicozzi Randy Fay – rfay

MOTW Correspondent

Martin Anderson-Clutz – mandclu.com mandclu

  • Brief description:
    • Have you ever wanted a local DDEV environment optimized for working on a Drupal contrib project? There’s a DDEV add-on for that.
  • Module name/project name:
  • Brief history
    • How old: created in Apr 2023 by Moshe Weitzman, a Drupal core maintainer, and according to his resume the first American to contribute to Drupal
    • Versions available: 1.0.0-rc8
  • Maintainership
    • Actively maintained
    • Test coverage
    • Documentation – Lengthy README
    • Number of open issues: 2 open issues, 1 of which is a bug
  • Module features and usage
    • The add-on adds two ddev commands to help during setup:
    • ddev poser creates a temporary composer.contrib.json, adding drupal/core-recommended as a dev dependency. It also runs composer install and yarn install so that all dependencies are available
    • The additional ddev symlink-project command adds symlinks from your project files to an expected path within the custom modules directory of the installed version of Drupal
    • Once it’s set up, you can easily run tests locally exactly the way they will be run in GitlabCI. It’s also even easier to apply any of the automatic fixes that are available, for example by running ddev phpcbf or ddev eslint with the –fix flag
    • You can also commit the generated .ddev directory inside your project, to make it easy for other contributors to use the same tools
    • I will note that after running ddev poser I got errors trying to use composer to add any other projects to the local environment, for example to use admin toolbar for manual testing
    • That said, this is another great example of how the set of Drupal developer tools is always improving, and also illustrates to the power of DDEV’s add-ons
Jun
24
2024
--

Upgrading to the New Etcd Version From 3.3 for Patroni

Upgrading to the New Etcd Version From 3.3 for PatroniWe have been promoting and using Patroni as the best high availability framework for PostgreSQL, and Etcd was the preferred/recommended DCS for the Patroni cluster. Both Patroni and Etcd have been part of PostgreSQL distribution from Percona for years now. But one area where we were stuck was the Etcd version, and we continued to […]

Jun
19
2024
--

eu-stack Support and Other Improvements in pt-pmp of Percona Toolkit

Improvements in pt-pmp of Percona Toolkitpt-pmp is a profiler tool that creates and summarizes full stack traces of processes on Linux. It was inspired by http://poormansprofiler.org and helped Percona Support resolve many performance issues. In this blog post, I will present an improved pt-pmp that can collect stack traces with minimal impact on the production environment. TLDR; Starting from Percona Toolkit […]

Jun
19
2024
--

Troubleshooting Common MySQL Performance Issues

MySQL databases serve as the foundation of countless applications, powering everything from simple blogs to massive enterprise platforms. But as these applications evolve and user bases expand, MySQL performance issues tend to pop up and ensuring smooth database performance becomes crucial. Fast queries mean happy users, while sluggish performance can lead to frustration and lost […]

Powered by WordPress | Theme: Aeros 2.0 by TheBuckmaker.com