# MySQL

Published articles for MySQL.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Group Replication Beyond a Single Cluster: DC-DR with Percona (PS MySQL) Operator

DevFeed: [Group Replication Beyond a Single Cluster: DC-DR with Percona (PS MySQL) Operator](<https://devfeed.tech/articles/group-replication-beyond-a-single-cluster-dc-dr-with-percona-ps-mysql-operator-35041.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/group-replication-beyond-a-single-cluster-dc-dr-with-percona-ps-mysql-operator/>)

Author: Anil Joshi

Published: 2026-09-17T06:43:32Z

Content type: tutorial

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Replication](<https://devfeed.tech/topics/replication.md>), [export](<https://devfeed.tech/topics/export.md>), [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>), [configuration](<https://devfeed.tech/topics/configuration.md>), [Server](<https://devfeed.tech/topics/server.md>), [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [cloud](<https://devfeed.tech/tags/cloud.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [database-trends](<https://devfeed.tech/tags/database-trends.md>), [featured](<https://devfeed.tech/tags/featured.md>), [innodb-clusterset](<https://devfeed.tech/tags/innodb-clusterset.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [kubernetes-operators](<https://devfeed.tech/tags/kubernetes-operators.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-group-replication](<https://devfeed.tech/tags/mysql-group-replication.md>), [mysql-high-availability](<https://devfeed.tech/tags/mysql-high-availability.md>), [mysql-replication](<https://devfeed.tech/tags/mysql-replication.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [operator](<https://devfeed.tech/tags/operator.md>), [percona-kubernetes-operators](<https://devfeed.tech/tags/percona-kubernetes-operators.md>), [percona-operator-for-mysql](<https://devfeed.tech/tags/percona-operator-for-mysql.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [percona-software](<https://devfeed.tech/tags/percona-software.md>), [replication](<https://devfeed.tech/tags/replication.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [yaml](<https://devfeed.tech/tags/yaml.md>)

### AI overview

This tutorial explains how to configure cross-site replication between two Percona Operator for MySQL clusters to create a ClusterSet environment for disaster recovery and switchover between data-center and disaster-recovery members. It covers deploying the clusters, retrieving endpoints and cluster names, transferring credentials, and initializing the DR cluster.

### Source excerpt

A while ago, we discussed the cross-site replication feature of the Percona PXC operator. Recently, a similar cross-site replication feature was introduced in the Percona (PS MySQL) operator v1.2.0, a topology based on Group Replication/InnoDB Cluster. In this blog post, we will explore how to add a DR Cluster to an existing DC Cluster to ... Continued The post Group Replication Beyond a Single Cluster: DC-DR with Percona (PS MySQL) Operator appeared first on Percona.

## Too many GCache Page Files in MySQL Data Directory

DevFeed: [Too many GCache Page Files in MySQL Data Directory](<https://devfeed.tech/articles/too-many-gcache-page-files-in-mysql-data-directory-35043.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/too-many-gcache-page-files-in-mysql-data-directory/>)

Author: Kedar Vaijanapurkar

Published: 2026-09-17T05:29:14Z

Content type: tutorial

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [XtraDB Cluster (PXC)](<https://devfeed.tech/topics/xtradb-cluster-pxc.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Transactions](<https://devfeed.tech/topics/transactions.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [cluster](<https://devfeed.tech/tags/cluster.md>), [database-administration](<https://devfeed.tech/tags/database-administration.md>), [disk-space](<https://devfeed.tech/tags/disk-space.md>), [galera](<https://devfeed.tech/tags/galera.md>), [galera-replication](<https://devfeed.tech/tags/galera-replication.md>), [gcache](<https://devfeed.tech/tags/gcache.md>), [gcache-freeze-purge-at-seqno](<https://devfeed.tech/tags/gcache-freeze-purge-at-seqno.md>), [gcache-keep-pages-count](<https://devfeed.tech/tags/gcache-keep-pages-count.md>), [gcache-page](<https://devfeed.tech/tags/gcache-page.md>), [gcache-page-files](<https://devfeed.tech/tags/gcache-page-files.md>), [gcache-purge](<https://devfeed.tech/tags/gcache-purge.md>), [gcache-troubleshooting](<https://devfeed.tech/tags/gcache-troubleshooting.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [mysql-disk-space](<https://devfeed.tech/tags/mysql-disk-space.md>), [mysql-troubleshooting](<https://devfeed.tech/tags/mysql-troubleshooting.md>), [percona-xtradb-cluster](<https://devfeed.tech/tags/percona-xtradb-cluster.md>), [pxc](<https://devfeed.tech/tags/pxc.md>), [replication](<https://devfeed.tech/tags/replication.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

An investigation into thousands of GCache page files accumulating in a Percona XtraDB Cluster data directory. The article explains how frozen GCache purging caused disk growth, links the behavior to a cluster partition, and describes reproducing it by setting gcache.freeze_purge_at_seqno and generating workload.

### Source excerpt

Learn why PXC accumulates thousands of gcache.page.* files, how frozen GCache purging causes disk growth, and how to safely recover and rejoin using IST. The post Too many GCache Page Files in MySQL Data Directory appeared first on Percona.

## Keycloak 26.7.4 released

DevFeed: [Keycloak 26.7.4 released](<https://devfeed.tech/articles/keycloak-26-7-4-released-31792.md>)

Original publisher: [Read original article](<https://www.keycloak.org/2026/09/keycloak-2674-released>)

Author: Keycloak Team

Published: 2026-09-16T00:00:00Z

Content type: release

Language: en

Sources: [Keycloak Blog](<https://devfeed.tech/sources/keycloak-blog.md>)

Topics: [Keycloak](<https://devfeed.tech/topics/keycloak.md>), [Security](<https://devfeed.tech/topics/security.md>), [Quarkus](<https://devfeed.tech/topics/quarkus.md>), [MariaDB](<https://devfeed.tech/topics/mariadb.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [saml](<https://devfeed.tech/topics/saml.md>)

Tags: [cve](<https://devfeed.tech/tags/cve.md>), [idm](<https://devfeed.tech/tags/idm.md>), [kerberos](<https://devfeed.tech/tags/kerberos.md>), [keycloak](<https://devfeed.tech/tags/keycloak.md>), [keycloak-release](<https://devfeed.tech/tags/keycloak-release.md>), [ldap](<https://devfeed.tech/tags/ldap.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [openid-connect](<https://devfeed.tech/tags/openid-connect.md>), [quarkus](<https://devfeed.tech/tags/quarkus.md>), [release](<https://devfeed.tech/tags/release.md>), [saml](<https://devfeed.tech/tags/saml.md>), [security](<https://devfeed.tech/tags/security.md>), [sso](<https://devfeed.tech/tags/sso.md>)

### AI overview

Keycloak 26.7.4 was released on September 16, 2026. The release includes security fixes for several CVEs, an upgrade to Quarkus 3.33.3.2, and fixes for performance, testing, documentation, administration, and UI issues.

### Source excerpt

To download the release go to Keycloak downloads. Upgrading Before upgrading refer to the migration guide for a complete list of changes. All resolved issues Security fixes #52834 [CVE-2026-90997] Default MySQL/MariaDB row counts make stateless replay gates accept reused artifacts #52835 [CVE-2026-79651] Keycloak Unauthenticated Denial of Service via Unbounded Locale Caching #52836 [CVE-2026-74909] Incomplete fix: percent-encoded semicolon bypasses matrix parameter stripping in PathMatcher #52837 [CVE-2026-19607] Username Takeover Leading to Account Lockout #52838 [CVE-2026-17526] Privilege escalation: the "impersonation" role can impersonate a realm administrator #52839 [CVE-2026-18212] SAML Redirect DEFLATE helpers leak native zlib state Enhancements #52354 Upgrade to Quarkus 3.33.3.2 dist/quarkus Bugs #49635 Performance issue with 26.6.2 dist/quarkus #51102 Flaky test: org.keycloak.testsuite.oauth.AccessTokenTest#accessTokenRequest ci #52015 New links errors for https://quarkus.io/guides docs #52172 Cached `RealmAdapter.isUserManagedAccessAllowed()` returns `isEnabled()` infinispan #52173 `realm_client` is computed into a client's attributes and then persisted on save admin/api #52233 Oracle 19 full client OCI driver crashes on startup since 26.6.0 -- SQLFeatureNotSupportedException on setNetworkTimeout dist/quarkus #52241 Clicking on a sub group in the admin console throws an exception admin/ui #52283 Flaky test SessionRestServiceTest.testGetDevicesSessions testsuite #52430 Flaky test: userprofile.spec.ts fails with timeout on "no-users-found-empty-action" in serial suite testsuite

## Announcing Fedora Linux 45 Beta

DevFeed: [Announcing Fedora Linux 45 Beta](<https://devfeed.tech/articles/announcing-fedora-linux-45-beta-26757.md>)

Original publisher: [Read original article](<https://fedoramagazine.org/announcing-fedora-linux-45-beta/>)

Author: Aoife Moloney

Published: 2026-09-15T14:05:00Z

Content type: release

Language: en

Sources: [Fedora Magazine](<https://devfeed.tech/sources/fedora-magazine.md>)

Topics: [Fedora](<https://devfeed.tech/topics/fedora.md>), [Linux](<https://devfeed.tech/topics/linux.md>), [dnf](<https://devfeed.tech/topics/dnf.md>), [podman](<https://devfeed.tech/topics/podman.md>), [pandas](<https://devfeed.tech/topics/pandas.md>), [Python](<https://devfeed.tech/topics/python.md>), [gcc](<https://devfeed.tech/topics/gcc.md>), [Go Language](<https://devfeed.tech/topics/go-language.md>), [MariaDB](<https://devfeed.tech/topics/mariadb.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Filesystems](<https://devfeed.tech/topics/filesystems.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [dnf](<https://devfeed.tech/tags/dnf.md>), [fedora-project-community](<https://devfeed.tech/tags/fedora-project-community.md>), [filesystems](<https://devfeed.tech/tags/filesystems.md>), [gcc](<https://devfeed.tech/tags/gcc.md>), [go](<https://devfeed.tech/tags/go.md>), [linux](<https://devfeed.tech/tags/linux.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [pandas](<https://devfeed.tech/tags/pandas.md>), [partitioning](<https://devfeed.tech/tags/partitioning.md>), [podman](<https://devfeed.tech/tags/podman.md>), [pre-release](<https://devfeed.tech/tags/pre-release.md>), [python](<https://devfeed.tech/tags/python.md>), [release](<https://devfeed.tech/tags/release.md>), [toolchains](<https://devfeed.tech/tags/toolchains.md>)

### AI overview

Fedora Linux 45 Beta is available for download or upgrade on September 15, 2026. The release includes changes to the kernel console, package signature verification, desktop secret management, software versions, Atomic Desktop image builds, Fedora CoreOS swap support, Anaconda installation flows, and Stratis filesystem partitioning.

### Source excerpt

Fedora Linux 45 Beta is here! On Tuesday, 15 September 2026 you can download or upgrade your systems from your usual spots to start enjoying what F45 has to offer early. How to get the beta release You can download F45 Beta, or our pre-release edition versions, from any of the following places: You can [...]

## Performance improvements in Percona Server 8.4.11-11

DevFeed: [Performance improvements in Percona Server 8.4.11-11](<https://devfeed.tech/articles/performance-improvements-in-percona-server-8-4-11-11-26780.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/performance-improvements-in-percona-server-8-4-11-11/>)

Author: Bogdan Degtyariov

Published: 2026-09-15T11:52:54Z

Content type: article

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [Percona Server for MySQL](<https://devfeed.tech/topics/percona-server-for-mysql.md>), [Percona](<https://devfeed.tech/topics/percona.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Cache](<https://devfeed.tech/topics/cache.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [Database](<https://devfeed.tech/topics/database.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [cache](<https://devfeed.tech/tags/cache.md>), [io](<https://devfeed.tech/tags/io.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [performance](<https://devfeed.tech/tags/performance.md>), [scalability](<https://devfeed.tech/tags/scalability.md>)

### AI overview

This article describes performance and scalability improvements in Percona Server for MySQL 8.4.11-11, focusing on changes to the InnoDB buffer pool and page flushing. It explains how narrowing mutex coverage and using finer-grained latching allows physical reads to proceed more in parallel, particularly for read-heavy, I/O-bound workloads.

### Source excerpt

Focusing on Percona Server 8.4.11-11 My previous post (Performance Progression of Percona Server for MySQL 8.4) did a brief review of the performance changes in Percona Server for MySQL 8.4 released in 2026. I recommend reading it first to better understand the material in this post. Version 8.4.11-11 includes patches that deliver significant improvements in ... Continued The post Performance improvements in Percona Server 8.4.11-11 appeared first on Percona.

## Intelligence is yours. Let's keep it that way.

DevFeed: [Intelligence is yours. Let's keep it that way.](<https://devfeed.tech/articles/intelligence-is-yours-let-s-keep-it-that-way-19892.md>)

Original publisher: [Read original article](<https://www.digitalocean.com/blog/intelligence-is-yours>)

Author: Paddy Srinivasan

Published: 2026-09-14T21:11:13Z

Content type: opinion

Language: en

Sources: [DigitalOcean](<https://devfeed.tech/sources/digitalocean.md>)

Topics: [Open Source](<https://devfeed.tech/topics/open-source.md>), [Software](<https://devfeed.tech/topics/software.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [React](<https://devfeed.tech/topics/react.md>), [GitHub](<https://devfeed.tech/topics/github.md>)

Tags: [agents](<https://devfeed.tech/tags/agents.md>), [competition](<https://devfeed.tech/tags/competition.md>), [github](<https://devfeed.tech/tags/github.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [intellectual-property](<https://devfeed.tech/tags/intellectual-property.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [models](<https://devfeed.tech/tags/models.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [news](<https://devfeed.tech/tags/news.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [opencode](<https://devfeed.tech/tags/opencode.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [react](<https://devfeed.tech/tags/react.md>)

### AI overview

The article argues that founders should retain ownership and control of their companies' intelligence rather than depend on a single intelligence provider. It advocates an Open Intelligence movement built from open-source models, agents, harnesses, data technologies, and infrastructure, drawing comparisons with the adoption of Linux, PostgreSQL, MySQL, Kubernetes, and other open technologies.

### Source excerpt

Intelligence was yours. A founder's intellectual property, business logic, differentiation, their intelligence, was once theirs alone. You built it, you owned it, and no tools/platform vendor stood between you and your customers. This is no longer clear. It is starting to look like it is "theirs." Intelligence can now be manufactured: the models, the agents and the harnesses that drive them, and the compute they run on. Providers who own all these can produce the application, and the differentiation, in every industry. That power runs the risk of becoming increasingly concentrated in a handful of companies. The race for the application layer is not about interfaces or go-to-market; it is a fight over who owns the intelligence layer itself. We have seen this before but we must act before its too late. Linux started behind Unix and Windows and now runs most of the world's servers. PostgreSQL and MySQL started behind Oracle and now underpin most new software. Kubernetes arrived after proprietary orchestrators and made them irrelevant. Each began less capable and won anyway: builders could see inside it, run it anywhere, and never had to ask permission. The same is happening now. Open weight models have repeatedly reached the frontier this past year. Open harnesses like OpenCode have grown to tens of trillions of tokens a day. Hermes reached more than 200,000 GitHub stars in five months, a milestone that took React a decade to achieve. Along with the near total adoption of open source data technologies, this collection of open technologies power an Open Intelligence movement. Open Intelligence restores the order. It returns to founders ownership of what makes their companies theirs. Founders should be free to build without tying their future to a single intelligence provider: their choice of agents, harnesses, data technologies, models, and infrastructure, with open source transparency, control, and competition keeping every layer honest. The stakes go beyond business.

## Linux server performance: Is disk I/O slowing your application?

DevFeed: [Linux server performance: Is disk I/O slowing your application?](<https://devfeed.tech/articles/linux-server-performance-is-disk-i-o-slowing-your-application-20872.md>)

Original publisher: [Read original article](<https://linuxblog.io/linux-server-performance-disk-io-slowing-application/>)

Author: Hayden James

Published: 2026-09-12T16:11:54Z

Content type: tutorial

Language: en

Sources: [Hayden James](<https://devfeed.tech/sources/hayden-james.md>)

Topics: [Linux](<https://devfeed.tech/topics/linux.md>), [IO](<https://devfeed.tech/topics/io.md>), [Server](<https://devfeed.tech/topics/server.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>), [Processes](<https://devfeed.tech/topics/processes.md>), [NVMe](<https://devfeed.tech/topics/nvme.md>)

Tags: [blog](<https://devfeed.tech/tags/blog.md>), [command-line](<https://devfeed.tech/tags/command-line.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [linux](<https://devfeed.tech/tags/linux.md>), [load](<https://devfeed.tech/tags/load.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [nvme](<https://devfeed.tech/tags/nvme.md>), [performance](<https://devfeed.tech/tags/performance.md>), [processes](<https://devfeed.tech/tags/processes.md>), [request](<https://devfeed.tech/tags/request.md>), [server](<https://devfeed.tech/tags/server.md>), [ssd](<https://devfeed.tech/tags/ssd.md>), [storage](<https://devfeed.tech/tags/storage.md>), [sysadmins](<https://devfeed.tech/tags/sysadmins.md>), [terminal](<https://devfeed.tech/tags/terminal.md>)

### AI overview

This tutorial explains how disk I/O bottlenecks can cause high Linux load averages even when CPU usage is low. It shows how to use top, atop, and iotop on a LEMP web server, including per-core I/O wait measurements, to identify storage-related application slowdowns.

### Source excerpt

If your Linux server is bogged down by disk I/O, your first step may often be to use the top command in the terminal to check load averages. Continue reading...

## Introducing Neki

DevFeed: [Introducing Neki](<https://devfeed.tech/articles/introducing-neki-2326.md>)

Original publisher: [Read original article](<https://planetscale.com/blog/introducing-neki>)

Author: Nick Van Wiggeren

Published: 2026-09-10T12:00:00Z

Content type: release

Language: en

Sources: [Blog -- PlanetScale](<https://devfeed.tech/sources/blog-planetscale.md>)

Topics: [Database](<https://devfeed.tech/topics/database.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [neki](<https://devfeed.tech/tags/neki.md>), [platform](<https://devfeed.tech/tags/platform.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [product](<https://devfeed.tech/tags/product.md>), [routing](<https://devfeed.tech/tags/routing.md>), [scale](<https://devfeed.tech/tags/scale.md>), [workflow](<https://devfeed.tech/tags/workflow.md>)

### AI overview

PlanetScale announces Neki in platform preview, a sharded Postgres offering designed to scale a database across multiple machines while retaining Postgres compatibility.

### Source excerpt

Neki, sharded Postgres by PlanetScale, is now available in platform preview.

## GitHub availability report: August 2026

DevFeed: [GitHub availability report: August 2026](<https://devfeed.tech/articles/github-availability-report-august-2026-83.md>)

Original publisher: [Read original article](<https://github.blog/news-insights/company-news/github-availability-report-august-2026/>)

Author: Jakub Oleksy

Published: 2026-09-10T02:05:17Z

Content type: article

Language: en

Sources: [GitHub Engineering](<https://devfeed.tech/sources/github-engineering.md>)

Topics: [GitHub](<https://devfeed.tech/topics/github.md>), [site-reliability-engineering](<https://devfeed.tech/topics/site-reliability-engineering.md>), [migration](<https://devfeed.tech/topics/migration.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [GitHub Actions](<https://devfeed.tech/topics/github-actions.md>)

Tags: [availability](<https://devfeed.tech/tags/availability.md>), [azure](<https://devfeed.tech/tags/azure.md>), [company-news](<https://devfeed.tech/tags/company-news.md>), [database](<https://devfeed.tech/tags/database.md>), [github](<https://devfeed.tech/tags/github.md>), [github-actions](<https://devfeed.tech/tags/github-actions.md>), [github-availability-report](<https://devfeed.tech/tags/github-availability-report.md>), [migration](<https://devfeed.tech/tags/migration.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [news-insights](<https://devfeed.tech/tags/news-insights.md>), [outage](<https://devfeed.tech/tags/outage.md>), [performance](<https://devfeed.tech/tags/performance.md>), [production](<https://devfeed.tech/tags/production.md>)

### AI overview

GitHub reports five August incidents with degraded service performance and describes capacity, resiliency, database, Azure migration, and GitHub Actions improvements.

### Source excerpt

In August, we experienced five incidents that resulted in degraded performance across GitHub services. The post GitHub availability report: August 2026 appeared first on The GitHub Blog.

## PostgreSQL Migrator 1.0 : first stable release

DevFeed: [PostgreSQL Migrator 1.0 : first stable release](<https://devfeed.tech/articles/postgresql-migrator-1-0-first-stable-release-4722.md>)

Original publisher: [Read original article](<https://www.postgresql.org/about/news/postgresql-migrator-10-first-stable-release-3377/>)

Published: 2026-09-10T00:00:00Z

Content type: release

Language: en

Sources: [PostgreSQL news](<https://devfeed.tech/sources/postgresql-news.md>)

Topics: [migration](<https://devfeed.tech/topics/migration.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [releases](<https://devfeed.tech/topics/releases.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>), [ci](<https://devfeed.tech/topics/ci.md>)

Tags: [ci](<https://devfeed.tech/tags/ci.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

PostgreSQL Migrator 1.0 is the first stable release of an open-source tool for migrating Oracle, MySQL, and MariaDB databases to PostgreSQL. It supports full inspection and limited conversion and migration for selected database objects, with compatibility promised across 1.x releases.

### Source excerpt

Paris, 7th september 2026. The Dalibo team is pleased to announce the release of PostgreSQL Migrator 1.0 stable, a free and open-source tool designed to help migrate databases from Oracle and MySQL/MariaDB to PostgreSQL. Key features Easy installation: pure Go binary with zero proprietary dependencies. Fast, offline inspection: Extract the full source catalog once, then iterate on conversion offline. Complexity scoring: Quickly assess and compare the difficulty of migration projects. Interactive web UI: Browse both the original and converted catalogs, search objects, and identify migration blockers. Schema and data conversion: Converts datatype and SQL expression, convert column to boolean. Code analysis and transpilation: Transpiles and analyzes SQL, PL/SQL and routines with the companion transqlate tool. High-performance data copy: Streamed bulk COPY to PostgreSQL (or to files / pipes), with low memory usage and significantly higher throughput than traditional tools in our tests. Hackable & configurable: Reliable JSON catalog data, TOML configuration, and templating for fine-tuning. Supported features PostgreSQL Migrator supports migrating from Oracle Database 11g to 26ai, MySQL 8.4+ and MariaDB 10+ to PostgreSQL 16 up to 19. Version 1.0 has full inspection including jobs, system triggers, etc. However, conversion and migration is limited to role, schema, sequences, table, virtual columns, constraints and indexes. The documentation describes implemented and planned features including views, procedural objects, SQL Server and more. Stability We have built a demanding CI pipeline including end-to-end tests based on Oracle Free container and cypress. This effectively prevents regression and ensure quality. After one year of beta and rc, PostgreSQL Migrator is stable. We'll ensure configuration, CLI and project compatibility for all 1.x releases. License and availability PostgreSQL Migrator is released under the PostgreSQL License. Documentation: https://postgresql-mi

## Loading Parquet data into MySQL with ClickHouse

DevFeed: [Loading Parquet data into MySQL with ClickHouse](<https://devfeed.tech/articles/loading-parquet-data-into-mysql-with-clickhouse-5483.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/parquet-to-mysql-with-clickhouse>)

Author: Mark Needham

Published: 2026-09-10T00:00:00Z

Content type: tutorial

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [parquet](<https://devfeed.tech/topics/parquet.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [parquet](<https://devfeed.tech/tags/parquet.md>), [s3](<https://devfeed.tech/tags/s3.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

A tutorial on using ClickHouse to load Parquet data into MySQL and query MySQL through ClickHouse table functions.

### Source excerpt

Use ClickHouse to load Parquet files into MySQL, explore remote data, and run MySQL queries with table functions and named collections.

## Enabling TLS in PXC without Downtime

DevFeed: [Enabling TLS in PXC without Downtime](<https://devfeed.tech/articles/enabling-tls-in-pxc-without-downtime-14095.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/enabling-tls-in-pxc-without-downtime/>)

Author: Juan Arruti

Published: 2026-09-09T23:32:15Z

Content type: tutorial

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [TLS (Transport Layer Security)](<https://devfeed.tech/topics/tls.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [Security](<https://devfeed.tech/topics/security.md>), [Network](<https://devfeed.tech/topics/network.md>), [openssl](<https://devfeed.tech/topics/openssl.md>)

Tags: [galera](<https://devfeed.tech/tags/galera.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [insight-for-dbas](<https://devfeed.tech/tags/insight-for-dbas.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [percona](<https://devfeed.tech/tags/percona.md>), [pxc](<https://devfeed.tech/tags/pxc.md>), [replication](<https://devfeed.tech/tags/replication.md>), [security](<https://devfeed.tech/tags/security.md>), [ssl](<https://devfeed.tech/tags/ssl.md>), [tls](<https://devfeed.tech/tags/tls.md>), [tls-handshake](<https://devfeed.tech/tags/tls-handshake.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [xtradb-cluster-pxc](<https://devfeed.tech/tags/xtradb-cluster-pxc.md>)

### AI overview

This tutorial explains how to enable TLS for replication traffic in Percona XtraDB Cluster without a full cluster restart. Using Galera's socket.dynamic option, operators can perform two rolling restarts: first allowing encrypted and plaintext connections, then enforcing TLS-only communication.

### Source excerpt

Starting with Percona XtraDB Cluster (PXC) 8.0, replication traffic encryption is enabled by default. That said, it's common to find clusters running without TLS that suddenly need it: a new compliance requirement, an audit finding, a network segment that is no longer considered trusted. PXC has a variable for exactly that case, pxc-encrypt-cluster-traffic, which handles ... Continued The post Enabling TLS in PXC without Downtime appeared first on Percona.

## Troubleshoot AWS Advanced JDBC Wrapper configuration for Aurora Global Database write forwarding

DevFeed: [Troubleshoot AWS Advanced JDBC Wrapper configuration for Aurora Global Database write forwarding](<https://devfeed.tech/articles/troubleshoot-aws-advanced-jdbc-wrapper-configuration-for-aurora-global-database-write-forwarding-4712.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/database/troubleshoot-aws-advanced-jdbc-wrapper-configuration-for-aurora-global-database-write-forwarding/>)

Author: Hema Saminathan

Published: 2026-09-03T16:26:20Z

Content type: tutorial

Language: en

Sources: [AWS Database Blog](<https://devfeed.tech/sources/aws-database-blog.md>)

Topics: [configuration](<https://devfeed.tech/topics/configuration.md>), [Database](<https://devfeed.tech/topics/database.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Latency](<https://devfeed.tech/topics/latency.md>)

Tags: [advanced-300](<https://devfeed.tech/tags/advanced-300.md>), [amazon-aurora](<https://devfeed.tech/tags/amazon-aurora.md>), [aws](<https://devfeed.tech/tags/aws.md>), [drivers](<https://devfeed.tech/tags/drivers.md>), [global](<https://devfeed.tech/tags/global.md>), [latency](<https://devfeed.tech/tags/latency.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>)

### AI overview

A configuration troubleshooting guide for the AWS Advanced JDBC Wrapper with Aurora Global Database write forwarding. It explains Region-specific settings for primary and secondary Regions, including MySQL-specific write-forwarding behavior.

### Source excerpt

Configuring the AWS Advanced JDBC Wrapper for Amazon Aurora Global Database with write forwarding requires Region-specific settings, and misconfiguration causes latency spikes and connection failures. This post walks through the correct dialect, plugins, host patterns, and write forwarding settings for the primary and secondary Regions.

## JDBC batching can still issue one round trip per row unless driver statement rewriting is enabled

DevFeed: [JDBC batching can still issue one round trip per row unless driver statement rewriting is enabled](<https://devfeed.tech/articles/one-round-trip-beats-a-thousand-and-your-batch-api-probably-is-not-batching-39599.md>)

Original publisher: [Read original article](<https://ankit-rana.com/logs/47-batching-one-round-trip-beats-a-thousand/>)

Author: hello@ankit-rana.com

Published: 2026-09-03T00:00:00Z

Content type: tutorial

Language: en

Sources: [Ankit Rana | Mechanical Sympathy](<https://devfeed.tech/sources/ankit-rana-mechanical-sympathy.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [Latency](<https://devfeed.tech/topics/latency.md>), [client](<https://devfeed.tech/topics/client.md>), [Code](<https://devfeed.tech/topics/code.md>)

Tags: [batching](<https://devfeed.tech/tags/batching.md>), [bulk-load](<https://devfeed.tech/tags/bulk-load.md>), [client](<https://devfeed.tech/tags/client.md>), [cost](<https://devfeed.tech/tags/cost.md>), [database](<https://devfeed.tech/tags/database.md>), [database-performance](<https://devfeed.tech/tags/database-performance.md>), [durability](<https://devfeed.tech/tags/durability.md>), [jdbc](<https://devfeed.tech/tags/jdbc.md>), [latency](<https://devfeed.tech/tags/latency.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [server](<https://devfeed.tech/tags/server.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

For small database writes, network round trips and transaction overhead can dominate the actual insert work. The article explains that JDBC batching may accept rows into a client-side batch while still sending separate statements unless driver-side statement rewriting is enabled, and that autocommit adds a transaction and durability barrier per row.

### Source excerpt

For small writes the per-statement overhead dominates the actual work, so throughput is set by round trips rather than by the database. JDBC batching is the usual fix and it silently does nothing on the wire unless the driver is told to rewrite the statements, so addBatch can look correct while still issuing one round trip per row. Autocommit compounds it by turning every row into its own transaction and its own durability barrier, which is the difference between one fsync and a hundred thousand.

## MySQL CDC connector for ClickPipes is now Generally Available

DevFeed: [MySQL CDC connector for ClickPipes is now Generally Available](<https://devfeed.tech/articles/mysql-cdc-connector-for-clickpipes-is-now-generally-available-5437.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/mysql-cdc-connector-for-clickpipes-is-now-generally-available>)

Author: Marta Paes

Published: 2026-09-02T14:03:04Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Infrastructure as code](<https://devfeed.tech/topics/infrastructure-as-code.md>), [Terraform](<https://devfeed.tech/topics/terraform.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [api](<https://devfeed.tech/tags/api.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data](<https://devfeed.tech/tags/data.md>), [infrastructure-as-code](<https://devfeed.tech/tags/infrastructure-as-code.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [observability](<https://devfeed.tech/tags/observability.md>), [release](<https://devfeed.tech/tags/release.md>), [terraform](<https://devfeed.tech/tags/terraform.md>)

### AI overview

ClickHouse announces general availability of its MySQL CDC connector for ClickPipes, which replicates MySQL and MariaDB data into ClickHouse Cloud. The release adds automatic parallel snapshotting, reliability and observability improvements, and configuration through the Cloud API and Terraform.

### Source excerpt

Replicate MySQL and MariaDB data into ClickHouse Cloud with the generally available MySQL CDC connector, featuring faster parallel snapshots, safer production defaults, improved observability, and infrastructure-as-code support.

## OpenID Connect Authentication for MySQL, Now Fully Open Source

DevFeed: [OpenID Connect Authentication for MySQL, Now Fully Open Source](<https://devfeed.tech/articles/openid-connect-authentication-for-mysql-now-fully-open-source-14105.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/oidc-authentication-for-percona-mysql/>)

Author: Michał Jankowski

Published: 2026-09-02T08:56:26Z

Content type: article

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [OpenID connect (OIDC)](<https://devfeed.tech/topics/oidc.md>), [Authentication](<https://devfeed.tech/topics/authentication.md>), [JSON Web Tokens](<https://devfeed.tech/topics/jwt.md>), [OAuth](<https://devfeed.tech/topics/oauth.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [authentication](<https://devfeed.tech/tags/authentication.md>), [jwks](<https://devfeed.tech/tags/jwks.md>), [jwt](<https://devfeed.tech/tags/jwt.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oauth](<https://devfeed.tech/tags/oauth.md>), [oauth-2-0](<https://devfeed.tech/tags/oauth-2-0.md>), [oidc](<https://devfeed.tech/tags/oidc.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [openid-connect](<https://devfeed.tech/tags/openid-connect.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [percona-software](<https://devfeed.tech/tags/percona-software.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

Percona Server for MySQL includes an open-source OpenID Connect authentication plugin for specified 8.4 and 9.7 releases. The article explains how it authenticates users through standards-compliant identity providers and describes capabilities beyond the MySQL Enterprise plugin, including JWKS signing-key synchronization, group-to-role mapping, and proxy-user support.

### Source excerpt

Percona Server for MySQL now ships with a fully open source OpenID Connect (OIDC) authentication plugin, available starting with Percona Server for MySQL 8.4.11-11 and 9.7.2-2 (not yet released as of this writing). It allows a MySQL account to authenticate against any standards-compliant Identity Provider (IdP) instead of relying on a locally stored password, closing ... Continued The post OpenID Connect Authentication for MySQL, Now Fully Open Source appeared first on Percona.

## How INTEGER and INT Produced Different Schemas in Debezium

DevFeed: [How INTEGER and INT Produced Different Schemas in Debezium](<https://devfeed.tech/articles/how-integer-and-int-produced-different-schemas-in-debezium-20086.md>)

Original publisher: [Read original article](<https://lambda.blinkit.com/how-integer-and-int-produced-different-schemas-in-debezium-9c98e8a80aa2?source=rss----42df4a1e8725---4>)

Author: Prathit Malik

Published: 2026-09-02T07:02:02Z

Content type: article

Language: en

Sources: [Grofers](<https://devfeed.tech/sources/grofers.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [migration](<https://devfeed.tech/topics/migration.md>), [Streaming](<https://devfeed.tech/topics/streaming.md>), [Kafka](<https://devfeed.tech/topics/kafka.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Databases](<https://devfeed.tech/topics/databases.md>)

Tags: [big-data](<https://devfeed.tech/tags/big-data.md>), [blinkit](<https://devfeed.tech/tags/blinkit.md>), [change](<https://devfeed.tech/tags/change.md>), [database](<https://devfeed.tech/tags/database.md>), [debezium](<https://devfeed.tech/tags/debezium.md>), [jdbc](<https://devfeed.tech/tags/jdbc.md>), [kafka](<https://devfeed.tech/tags/kafka.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [schema](<https://devfeed.tech/tags/schema.md>), [sql](<https://devfeed.tech/tags/sql.md>), [streaming](<https://devfeed.tech/tags/streaming.md>)

### AI overview

This article investigates a Debezium CDC pipeline failure caused by MySQL INT and INTEGER synonyms being treated as different types. The resulting schema mismatch produced an Integer where a downstream consumer expected a Long, causing a ClassCastException on every batch. It explains how streaming and snapshot schema handling differ and how routine migrations exposed the problem.

### Source excerpt

A Debezium investigation: how MySQL synonyms INT and INTEGER were treated as different types. One of our CDC pipelines started failing with a ClassCastException on every batch. java.lang.ClassCastException: class java.lang.Integer cannot be cast to class java.lang.Long The pipeline was producing an Integer, but the downstream consumer expected a Long. Every run failed in the same way, which pointed us toward a schema mismatch rather than an issue with individual records. Background: how CDC works To see why a mismatch like that can hide for years, it helps to know how CDC actually works. Most companies replicate their transactional database (MySQL, Postgres, something similar) into a separate data lake for analytics, rather than querying the source directly, and Change Data Capture (CDC) is what keeps that copy in sync: it tails the database's transaction log and replays every insert, update, and delete downstream. Debezium is the most widely used open-source CDC tool for MySQL, and it builds a table's schema in one of two ways that are supposed to agree but do not always. Streaming mode: the first time it sees a CREATE TABLE or ALTER TABLE in the binlog, it parses the raw SQL text and writes the result to its own internal Kafka topic, database.history.kafka.topic. Every restart after that rebuilds the in-memory schema by replaying that topic, not by re-reading the binlog. Snapshot mode: reads the table definition fresh through MySQL's JDBC metadata interface, which normalizes types, every time it runs. Schema Registry sits downstream of both: each connector writes whatever schema it built into the registry, but neither connector reads its own schema back from it. Keep that in mind; it matters later. The trigger: a routine migration With that in mind, here's what actually happened to us. Rewind two years: one of our upstream service teams added a few columns to a source table as part of a standard schema change. ALTER TABLE <source_table> ADD COLUMN length double NU

## Announcing native MySQL databases: Bring your MySQL workloads to Appwrite

DevFeed: [Announcing native MySQL databases: Bring your MySQL workloads to Appwrite](<https://devfeed.tech/articles/announcing-native-mysql-databases-bring-your-mysql-workloads-to-appwrite-16435.md>)

Original publisher: [Read original article](<https://appwrite.io/blog/post/announcing-native-mysql-databases>)

Author: Jake Barnby

Published: 2026-09-02T00:00:00Z

Content type: release

Language: en

Sources: [Appwrite Blog](<https://devfeed.tech/sources/appwrite-blog.md>)

Topics: [Appwrite](<https://devfeed.tech/topics/appwrite.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Provisioning](<https://devfeed.tech/topics/provisioning.md>), [Availability](<https://devfeed.tech/topics/availability.md>), [Replication](<https://devfeed.tech/topics/replication.md>), [autoscaling](<https://devfeed.tech/topics/autoscaling.md>), [TLS (Transport Layer Security)](<https://devfeed.tech/topics/tls.md>)

Tags: [announcements](<https://devfeed.tech/tags/announcements.md>), [autoscaling](<https://devfeed.tech/tags/autoscaling.md>), [availability](<https://devfeed.tech/tags/availability.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [provisioning](<https://devfeed.tech/tags/provisioning.md>), [replication](<https://devfeed.tech/tags/replication.md>), [tls](<https://devfeed.tech/tags/tls.md>)

### AI overview

Appwrite announces native managed MySQL databases that can run inside the same project as an application's existing backend. The service supports MySQL 8.4 and 8.0, standard drivers and ORMs, TLS, backups and point-in-time recovery, replicas with automatic failover, database branches, scaling, and connection pooling.

### Source excerpt

Provision a managed MySQL 8.4 instance inside your Appwrite project and keep using the drivers, ORMs, and tools your applications already depend on.

## Native databases vs Appwrite databases: which one should you pick?

DevFeed: [Native databases vs Appwrite databases: which one should you pick?](<https://devfeed.tech/articles/native-databases-vs-appwrite-databases-which-one-should-you-pick-16496.md>)

Original publisher: [Read original article](<https://appwrite.io/blog/post/native-databases-vs-appwrite-databases>)

Author: Atharva Deosthale

Published: 2026-09-01T00:00:00Z

Content type: tutorial

Language: en

Sources: [Appwrite Blog](<https://devfeed.tech/sources/appwrite-blog.md>)

Topics: [Appwrite](<https://devfeed.tech/topics/appwrite.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SDKs](<https://devfeed.tech/topics/sdks.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [backend](<https://devfeed.tech/tags/backend.md>), [comparisons](<https://devfeed.tech/tags/comparisons.md>), [databases](<https://devfeed.tech/tags/databases.md>), [guide](<https://devfeed.tech/tags/guide.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [orm](<https://devfeed.tech/tags/orm.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [realtime](<https://devfeed.tech/tags/realtime.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

This guide compares Appwrite's managed TablesDB, DocumentsDB, and VectorsDB with native PostgreSQL and MySQL databases. It explains the trade-off between Appwrite's SDK-based permissions, realtime events, functions, and other platform features and the direct SQL access available through native database drivers or ORMs.

### Source excerpt

Appwrite offers two kinds of databases. This guide explains how TablesDB, DocumentsDB, and VectorsDB differ from native PostgreSQL and MySQL, and how to choose between them for your project.

## How one connection kills a database

DevFeed: [How one connection kills a database](<https://devfeed.tech/articles/how-one-connection-kills-a-database-2325.md>)

Original publisher: [Read original article](<https://planetscale.com/blog/debugging-live-database-connections>)

Author: Simeon Griggs

Published: 2026-08-31T00:00:00Z

Content type: article

Language: en

Sources: [Blog -- PlanetScale](<https://devfeed.tech/sources/blog-planetscale.md>)

Topics: [debugging](<https://devfeed.tech/topics/debugging.md>), [migration](<https://devfeed.tech/topics/migration.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [vitess](<https://devfeed.tech/topics/vitess.md>)

Tags: [app](<https://devfeed.tech/tags/app.md>), [cli](<https://devfeed.tech/tags/cli.md>), [database](<https://devfeed.tech/tags/database.md>), [debugging](<https://devfeed.tech/tags/debugging.md>), [errors](<https://devfeed.tech/tags/errors.md>), [exception](<https://devfeed.tech/tags/exception.md>), [github](<https://devfeed.tech/tags/github.md>), [management](<https://devfeed.tech/tags/management.md>), [migration](<https://devfeed.tech/tags/migration.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [product](<https://devfeed.tech/tags/product.md>), [transactions](<https://devfeed.tech/tags/transactions.md>), [vitess](<https://devfeed.tech/tags/vitess.md>)

### AI overview

The article explains how an unclosed database transaction can block a migration and queue later queries, causing downtime. It discusses diagnosing live MySQL and Postgres connections and preventing stuck Postgres transactions with a timeout.

### Source excerpt

Unblock stuck connections with live connection management in the PlanetScale CLI and dashboard

## Announcing Appwrite 2.0: a new foundation for your apps

DevFeed: [Announcing Appwrite 2.0: a new foundation for your apps](<https://devfeed.tech/articles/announcing-appwrite-2-0-a-new-foundation-for-your-apps-16405.md>)

Original publisher: [Read original article](<https://appwrite.io/blog/post/announcing-appwrite-2>)

Author: Eldad Fux

Published: 2026-08-31T00:00:00Z

Content type: release

Language: en

Sources: [Appwrite Blog](<https://devfeed.tech/sources/appwrite-blog.md>)

Topics: [Appwrite](<https://devfeed.tech/topics/appwrite.md>), [Databases](<https://devfeed.tech/topics/databases.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [OAuth](<https://devfeed.tech/topics/oauth.md>), [Firewall](<https://devfeed.tech/topics/firewall.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>)

Tags: [feature](<https://devfeed.tech/tags/feature.md>), [firewall](<https://devfeed.tech/tags/firewall.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oauth](<https://devfeed.tech/tags/oauth.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [products](<https://devfeed.tech/tags/products.md>), [release](<https://devfeed.tech/tags/release.md>), [s3](<https://devfeed.tech/tags/s3.md>)

### AI overview

Appwrite 2.0 is a major platform release with a new engine, rebuilt Console, relational, schemaless, and vector data support, native PostgreSQL and MySQL engines, S3-addressable storage, OAuth 2.1 and OpenID Connect support, and organization-level Domains and Firewall.

### Source excerpt

Appwrite 2.0 brings a new engine, a rebuilt Console, five database types, an S3 API, an OAuth 2.1 server, and organization-level Domains and Firewall.

## 【kube-apiserver】选型收束与开放问题：排除树、Kine 与 events 分集群

DevFeed: [【kube-apiserver】选型收束与开放问题：排除树、Kine 与 events 分集群](<https://devfeed.tech/articles/kube-apiserver-kine-events-33972.md>)

Original publisher: [Read original article](<https://quant67.com/post/apiserver/16-selection/16-selection.html>)

Author: Liao Tonglang

Published: 2026-08-28T00:00:00Z

Content type: tutorial

Language: zh

Sources: [土法炼钢 - 系统与基础设施](<https://devfeed.tech/sources/source-4.md>)

Topics: [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [Caching](<https://devfeed.tech/topics/caching.md>), [etcd](<https://devfeed.tech/topics/etcd.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Raft](<https://devfeed.tech/topics/raft.md>)

Tags: [apiserver](<https://devfeed.tech/tags/apiserver.md>), [churn](<https://devfeed.tech/tags/churn.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [errcompacted](<https://devfeed.tech/tags/errcompacted.md>), [etcd](<https://devfeed.tech/tags/etcd.md>), [events](<https://devfeed.tech/tags/events.md>), [exclusion-tree](<https://devfeed.tech/tags/exclusion-tree.md>), [kine](<https://devfeed.tech/tags/kine.md>), [kubernetes](<https://devfeed.tech/tags/kubernetes.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [open-questions](<https://devfeed.tech/tags/open-questions.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [quota](<https://devfeed.tech/tags/quota.md>), [raft](<https://devfeed.tech/tags/raft.md>), [selection](<https://devfeed.tech/tags/selection.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [storage](<https://devfeed.tech/tags/storage.md>), [ttl](<https://devfeed.tech/tags/ttl.md>), [v1-30-3](<https://devfeed.tech/tags/v1-30-3.md>), [watch-cache](<https://devfeed.tech/tags/watch-cache.md>)

### AI overview

This concluding article presents a mechanism-based decision tree for diagnosing Kubernetes control-plane issues across kube-apiserver and etcd layers. It explains Kine's differing Watch semantics when using SQLite, PostgreSQL, or MySQL backends, discusses routing Kubernetes Events to a separate etcd cluster, and identifies open questions around watch-cache SLOs, compaction, linear reads, and Lease fencing.

### Source excerpt

用机制排除树收束何时查 apiserver 轴、何时穿透 etcd 轴、何时两轴联查；回收 etcd/13 写下的 apiserver 停损线；Kine SQL backend 的 Watch 语义差与 Jepsen 覆盖空白；events --etcd-servers-overrides 分集群运维；列出 watch cache SLO 联合模型、线性读期望与 Lease+fencing 全链路三个开放问题；以 ADR 语言关闭系列边界。

## Performance Progression of Percona Server for MySQL 8.4

DevFeed: [Performance Progression of Percona Server for MySQL 8.4](<https://devfeed.tech/articles/performance-progression-of-percona-server-for-mysql-8-4-14110.md>)

Original publisher: [Read original article](<https://www.percona.com/blog/performance-progression-of-percona-server-for-mysql-8-4/>)

Author: Bogdan Degtyariov

Published: 2026-08-27T13:07:20Z

Content type: article

Language: en

Sources: [Blog - Percona](<https://devfeed.tech/sources/blog-percona.md>)

Topics: [MySQL](<https://devfeed.tech/topics/mysql.md>), [benchmarking](<https://devfeed.tech/topics/benchmarking.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>), [Scalability](<https://devfeed.tech/topics/scalability.md>), [configuration](<https://devfeed.tech/topics/configuration.md>), [cpu](<https://devfeed.tech/topics/cpu.md>), [Hardware](<https://devfeed.tech/topics/hardware.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarking](<https://devfeed.tech/tags/benchmarking.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [cpu](<https://devfeed.tech/tags/cpu.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [hardware](<https://devfeed.tech/tags/hardware.md>), [intel](<https://devfeed.tech/tags/intel.md>), [latency](<https://devfeed.tech/tags/latency.md>), [load](<https://devfeed.tech/tags/load.md>), [measurement](<https://devfeed.tech/tags/measurement.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [percona](<https://devfeed.tech/tags/percona.md>), [percona-server-for-mysql](<https://devfeed.tech/tags/percona-server-for-mysql.md>), [performance](<https://devfeed.tech/tags/performance.md>), [processors](<https://devfeed.tech/tags/processors.md>), [run](<https://devfeed.tech/tags/run.md>)

### AI overview

This article investigates read/write performance changes across Percona Server for MySQL 8.4 versions released in 2026. It describes benchmark scope, database and buffer-size combinations, configuration, and CPU-frequency controls, while excluding features, security patches, latency percentiles, and resource-utilization measurements.

### Source excerpt

1. Purpose and scope This performance investigation aims to look into the read/write performance of Percona Server for MySQL 8.4 and how it changed between versions released in 2026: 8.4.8-8 released on 12 March 2026 8.4.10-10 released on 30 June 2026 8.4.11-11 released on 20 August 2026 We want to see if there are improvements ... Continued The post Performance Progression of Percona Server for MySQL 8.4 appeared first on Percona.

## ADD COLUMN is not always free, and the lock queue is what takes you down

DevFeed: [ADD COLUMN is not always free, and the lock queue is what takes you down](<https://devfeed.tech/articles/add-column-is-not-always-free-and-the-lock-queue-is-what-takes-you-down-39595.md>)

Original publisher: [Read original article](<https://ankit-rana.com/logs/43-add-column-is-not-always-free/>)

Author: hello@ankit-rana.com

Published: 2026-08-26T00:00:00Z

Content type: article

Language: en

Sources: [Ankit Rana | Mechanical Sympathy](<https://devfeed.tech/sources/ankit-rana-mechanical-sympathy.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [incident](<https://devfeed.tech/topics/incident.md>), [Query (disambiguation)](<https://devfeed.tech/topics/query.md>), [migration](<https://devfeed.tech/topics/migration.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>)

Tags: [ddl](<https://devfeed.tech/tags/ddl.md>), [incident](<https://devfeed.tech/tags/incident.md>), [locking](<https://devfeed.tech/tags/locking.md>), [migration](<https://devfeed.tech/tags/migration.md>), [migrations](<https://devfeed.tech/tags/migrations.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [query](<https://devfeed.tech/tags/query.md>), [queues](<https://devfeed.tech/tags/queues.md>), [schema-design](<https://devfeed.tech/tags/schema-design.md>), [timeout](<https://devfeed.tech/tags/timeout.md>)

### AI overview

Adding a nullable column can cause an outage even when the schema change itself is nearly instantaneous. In PostgreSQL, ALTER TABLE may wait for a long-running query, and subsequent queries can queue behind the waiting lock request. Setting a short lock_timeout and retrying can prevent the migration from taking down the table.

### Source excerpt

Modern PostgreSQL adds a column with a default as a metadata change, so the table is never rewritten and the migration itself is instant. The outage comes from lock acquisition instead: ALTER TABLE needs an ACCESS EXCLUSIVE lock, and while it waits behind one long-running query, every subsequent query queues behind the waiting ALTER because the lock queue is ordered. Setting lock_timeout to a couple of seconds and retrying converts that from an outage into a no-op.

[Next page](<https://devfeed.tech/tags/mysql.md?cursor=WyIyMDI2LTA4LTI2VDAwOjAwOjAwKzAwOjAwIiwgImMxZTliYWUxLTcxZDYtNDVlNi1hOGZkLTc4ZjY3ZjI0NGQ1ZSJd>)