Comments on: The Invisibilities in MySQL 8.0 https://www.percona.com/blog/invisibilities-in-mysql-8-0/ Thu, 03 Aug 2023 17:46:40 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Kenny Gryp https://www.percona.com/blog/invisibilities-in-mysql-8-0/#comment-10974126 Thu, 03 Aug 2023 17:46:40 +0000 https://www.percona.com/blog/?p=89751#comment-10974126 There is also the ability to add the primary key on a replica and have replication work even if the source does not have the primary key.

As described on https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
use REQUIRE_TABLE_PRIMARY_KEY_CHECK = GENERATE as part of a CHANGE REPLICATION SOURCE TO statement.

]]>