Change Is Inevitable
  • Home
  • MySQL
    • MySQL-Articles
    • AWS RDS
    • Percona Xtradb Cluster
    • MariaDB
    • Galera Cluster
    • ProxySQL
    • MySQL-Scripts
    • MySQL tools
    • MySQL Resources
  • Tools
    • MySQL Advisor
    • MySQL Random Data Generator
    • Postgresql Random Data Generator
    • Clean Prompt
  • General
    • binary-to-decimal
    • Fermat’s Theorem
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright
    • MySQL Podcast (Youtube)
    • MySQL Podcast (Spotify)
Recent Posts
  • MySQL INSTANT DDL breaks EXCHANGE PARTITION
  • How to setup and use Percona Binlog Server (PBS)
  • MySQL Major Version Upgrade Checklist – how to
  • InnoDB Flushing is simple – explained
  • MySQL Tools for Performance Tuning and Test Data Generation
Recent Comments
  • Kedar on MySQL INSTANT DDL breaks EXCHANGE PARTITION
  • Jean-François Gagné on MySQL INSTANT DDL breaks EXCHANGE PARTITION
  • Reggie on A Unique Foreign Key issue in MySQL 8.4
  • Kedar on How to fix write latency in MySQL 8.4 Upgrade
  • Kedar on How to fix write latency in MySQL 8.4 Upgrade
Home » MySQL upgrade
Change Is Inevitable

Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects

  • Home
  • MySQL
    • MySQL-Articles
    • AWS RDS
    • Percona Xtradb Cluster
    • MariaDB
    • Galera Cluster
    • ProxySQL
    • MySQL-Scripts
    • MySQL tools
    • MySQL Resources
  • Tools
    • MySQL Advisor
    • MySQL Random Data Generator
    • Postgresql Random Data Generator
    • Clean Prompt
  • General
    • binary-to-decimal
    • Fermat’s Theorem
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright
    • MySQL Podcast (Youtube)
    • MySQL Podcast (Spotify)

Browsing Tag

MySQL upgrade

3 posts
MySQL Major Version Upgrade Checklist
  • MySQL
  • MySQL Upgrade
  • No comments

MySQL Major Version Upgrade Checklist – how to

  • Kedar
  • July 16, 2026
This article provides MySQL Major Version Upgrade Checklist along with video, one may follow to ease the upgarde task.
View Post
  • MySQL
  • Technical
  • 4 comments

How to fix write latency in MySQL 8.4 Upgrade

  • Kedar
  • April 4, 2026
During any MySQL major version upgrade, especially when moving from 8.0 to 8.4, it’s not just about compatibility checks. Subtle default changes can directly impact MySQL performance tuning, and if…
View Post
mysql8.4-foreign-keys
  • MySQL
  • MySQL Upgrade
  • 5 comments

A Unique Foreign Key issue in MySQL 8.4

  • Kedar
  • April 24, 2025
Recently, a friend reached out to me for help after encountering an error while restoring a MySQL dump during an upgrade from MySQL 8.0 to 8.4. The error read: At…
View Post
MySQL Podcast (Youtube)
RSS feed: MySQL Podcast (Spotify) MySQL Podcast (Spotify)
  • MySQL Major Version Upgrade Checklist (Zero Downtime Strategy)
    Upgrading MySQL major versions in production is never just a version bump - it’s a carefully planned process involving compatibility checks, replication strategy, testing, and controlled cut-over.In this episode, we walk through a practical MySQL Major Version Upgrade Checklist based on real-world DBA workflows. We are covering MySQL replication as base setup for upgrade. It […]
Search:
... ...
  • MySQL INSTANT DDL breaks EXCHANGE PARTITION
  • How to setup and use Percona Binlog Server (PBS)
  • MySQL Major Version Upgrade Checklist – how to
  • InnoDB Flushing is simple – explained
  • MySQL Tools for Performance Tuning and Test Data Generation

5 responses to “A Unique Foreign Key issue in MySQL 8.4”

  1. Reggie Avatar
    Reggie
    August 16, 2026

    Thanks for sharing this and reporting the bug.
    Equally fascinating is that the errors I receive, when trying to synchronise model with database, are against an FK that doesn’t exist, in the model or when inspecting the table information.

    Reply
  2. Rajaganesh G Avatar
    Rajaganesh G
    April 30, 2025

    Nice topic and clarified the doubt on foreign key.constraint issue. Good topic to go through once.

    Reply
    1. Kedar Avatar
      Kedar
      September 13, 2025

      Thanks Rajaganesh.

      Reply
  3. Anil Darnal Avatar
    Anil Darnal
    April 25, 2025

    thank you!

    Reply
    1. Kedar Avatar
      Kedar
      September 13, 2025

      Hey!!!!!! Hope you got chance to read 🙂

      Reply
Change Is Inevitable
Designed & Developed by Code Supply Co.