Aug
30
2024
--

When Warnings Deceive: The Curious Case of InnoDB’s Row Size Limitation

Mysterious warning Recently, I was involved in an investigation whose goal was to find out the reason for a warning message like this: [crayon-66d3235a263dd269727999/] The message looks clear, isn’t it? Well, the problem was that this particular table had not been changed for years, and so no DDL (ALTER) query was involved here. Moreover, there […]

Aug
27
2024
--

Important Notice: Update Process for Percona Monitoring and Management 2.38 and Earlier

ENV Variables in PMM AMI.jpgWe’ve received numerous reports about issues occurring with Percona Monitoring and Management (PMM) when updating to the latest version (currently 2.42.0), or updating to any version from an old version (2.37.1 and before) using the update button on the UI.  Symptoms PMM won’t show any notifications on the UI about new available versions if: You’ve […]

Aug
26
2024
--

Talking Drupal #464 – Drupal Content Production

Today we are talking about Producing content with Drupal, How Drupal can help content producers, and ways it could be better with guest Jerry Ta. We’ll also cover Stage File Proxy as our module of the week.

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

Topics

  • Brief overview of Urban Institute using Drupal
  • What are the day to day responsibilities of a content producer
  • Layout Builder or Paragraphs
    • What is your opinion
  • You’ve been in content production for almost 2 decades, what was your first website editing tool.
  • How long have you been using Drupal
  • What is your number one wish the Drupal community would solve
  • Drupalcon
    • What value do you look for for a content producer
  • What is the hardest part of using Drupal
  • Starshot reaction
  • Predictions for Drupal in 5 years for content producers

Resources

Guests

Jerry Ta – joshmiller

Hosts

Nic Laflin – nLighteneddevelopment.com nicxvan John Picozzi – epam.com johnpicozzi Josh Miller – joshmiller

MOTW Correspondent

Martin Anderson-Clutz – mandclu.com mandclu

  • Brief description:
    • Have you ever wanted to work on code or configuration changes to your Drupal site in a non-production environment, without having to copy over all the images and other content files? There’s a module for that.
  • Module name/project name:
  • Brief history
    • How old: created in Jan 2011 by netaustin, by recent releases are by Stephen Mustgrave, who listeners will probably recognize from the Needs Review initiative, among his many other Drupal contributions
    • Versions available: 7.x-1.10, 3.0.0-alpha2, and 3.1.0, the last of which works with Drupal 10.3 and 11
  • Maintainership
    • Actively maintained
    • Security coverage
    • Test coverage
    • Documentation – not a lot, but it has been the subject of numerous blog posts over the years
    • Number of open issues: 15 open issues, 2 of which are bugs against the current branch
  • Usage stats:
    • 16,710 sites
  • Module features and usage
    • Once you have Stage File Proxy site up on your non-production site, when the environment gets a request for a content file it doesn’t have like an image, it will query the production site to create a local copy
    • It also has a mode where those requests are served 301 redirects to their location on the production server, so no files are ever copied
    • Once you have the module installed, you can set the origin website URL using the admin UI, using a drush variable-set command, or you can add a line to your settings.php file.
    • Also, if you have simple HTTP authentication set up on the site you want to pull from (for example using the Shield module), you can add URL-encoded versions of the username and password to the origin URL, and the module will still be able to copy down the files.
    • This module was previously covered in this podcast way back in episode #33, but I thought it was worth bring back because it is so useful for working on site locally or across non-production environments
Aug
26
2024
--

Percona Server for MySQL Performance Improvements – August 2024

pt-online-schema-change for Purging Rows and Reclaiming Disk Space in a Single OperationAt Percona, we have always prioritized database performance as a critical factor in selecting database technologies. Recently, we have observed a concerning trend in the community edition of MySQL, where performance appears to be declining across major releases, specifically MySQL versions 5.7, 8.0, and 8.4. If you’re interested in learning more about these observations, we […]

Aug
23
2024
--

Addressing Data Size Differences in MongoDB Replica Set Nodes

MongoDB replication data sizeWhen working with MongoDB replication in environments using the WiredTiger storage engine, you may encounter data size discrepancies between PRIMARY and SECONDARY nodes. When this problem arises, the SECONDARY node uses significantly more disk space than the PRIMARY instance. When this issue first appeared at Percona Support a few years ago, the most notable discussion […]

Aug
20
2024
--

How to Run Percona Toolkit in Kubernetes

How to Run Percona Toolkit in KubernetesPercona Operator for MySQL, based on Percona XtraDB Cluster (PXC), provides configuration to expose the ProxySQL, HAProxy, and the PXC instances themselves so that you can use Percona Toolkit to connect to MySQL from these endpoints externally. However, you can also create Kubernetes pods to run Percona Toolkit operations there instead if you do not […]

Aug
19
2024
--

Why You Should Consider an External Replica for Your Cloud Environment

In current times, there is a high degree of focus on ensuring the availability and recovery of your production data. This can be challenging at times when using DBaaS solutions in the public cloud space, for example, when using AWS Aurora. Relying solely on a single cloud provider for database services can pose significant risks. […]

Aug
15
2024
--

The Making of an Open Source PostgreSQL TDE Extension

Open Source PostgreSQL TDE ExtensionWhen using a tool for a while, one often becomes patriotic towards it. With your investment, such as your work, you’re building up experience and starting to care more about the tool you use. How good it is, how it’s perceived by others. It’s an interesting process. Being strongly involved with PostgreSQL, it was interesting […]

Aug
14
2024
--

Effective Strategies for Recovering MySQL Group Replication From Failures

Group replication is a fault-tolerant/highly available replication topology that ensures if the primary node goes down, one of the other candidates or secondary members takes over so write and read operations can continue without any interruptions. However, there are some scenarios where, due to outages, network partitions, or database crashes, the group membership could be broken, or we end […]

Aug
13
2024
--

Solving pg_upgrade and lc_collate Mismatch Issues in PostgreSQL

pg_upgrade and lc_collate mismatchCharacter collations determine the sort order and classification of characters. When creating a database with initdb, PostgreSQL normally sets the collation based on the operating system’s locale settings, but other special collations, such as “C,” “POSIX,” and “ucs_basic,” are available as alternatives. On Linux systems, updates to glibc can bring changes to collation rules. Normally, […]

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