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.
Subject
Views
Written By
Posted
MySQL 5.7: Foreign Keys in Replication
999
August 03, 2021 01:49AM
490
August 03, 2021 10:24AM
513
August 03, 2021 11:12PM
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.