MySQL Forums
Forum List  »  Replication

MySQL 5.7: Foreign Keys in Replication
Posted by: マサキ ヒロセ
Date: August 03, 2021 01:49AM

I want to know that when I have MySQL Master and a Slave, do tables in the Slave have the same foreign key constraints as in the Master.

I mean when I execute
SHOW CREATE TABLE <table_name>;
in the Slave, Do I see a foreign key constraints like below ?

CONSTRAINT `test_foreign_ibfk_1` FOREIGN KEY (`c1`) REFERENCES `test_master`(`id`)

And If Yes, I also want to know whether or not I can turn foreign key constraints off in the Slave.

Options: ReplyQuote

Written By
MySQL 5.7: Foreign Keys in Replication
August 03, 2021 01:49AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.