Back
Syntax
Study
Editor
Mode:
HTML
CSS
JavaScript
PHP
Reset
Run »
HTML / CSS / JS
-- On the replica to promote: STOP REPLICA; RESET REPLICA ALL; -- remove connection to old primary -- Verify all GTIDs applied SHOW VARIABLES LIKE "gtid_executed"; -- Reconfigure application connection strings to point to new primary -- Point remaining replicas to new primary: CHANGE REPLICATION SOURCE TO SOURCE_HOST="new_primary", SOURCE_AUTO_POSITION=1; START REPLICA;
Result
Open