Skip to content

Instantly share code, notes, and snippets.

View masv's full-sized avatar

Martin Svangren masv

  • Göteborg, Sweden
View GitHub Profile

Keybase proof

I hereby claim:

  • I am masv on github.
  • I am msvangren (https://keybase.io/msvangren) on keybase.
  • I have a public key ASC2E5TcwFxX41-KRMoAHw7zL1xUUf0J8-0X_WWCtDCSmgo

To claim this, I am signing this object:

@masv
masv / 0_test.sh
Last active August 16, 2017 16:43
Problems while promoting a MySQL master with Orchestrator
orchestrator -c topology -i db1
# I would expect to be able to make db1 and db2 co-master, but this fails
# with error 1776 (can not set binlog pos when auto-positioning is active)
orchestrator -c make-co-master -i db2 -d db1
# Promoting db2 with graceful master takeover works, but requires some cleanup
orchestrator -c graceful-master-takeover -i db1
orchestrator -c topology -i db1
orchestrator -c set-writeable -i db2
@masv
masv / error_1776.log
Last active August 11, 2017 15:04
Error 1776 on make-co-master
ubuntu@orc:~$ orchestrator -c make-co-master -i db3 -d db2
2017-08-11 14:59:57 DEBUG Connected to orchestrator backend: orc_server_user:?@tcp(127.0.0.1:3306)/orchestrator?timeout=1s
2017-08-11 14:59:57 DEBUG Orchestrator pool SetMaxOpenConns: 128
2017-08-11 14:59:57 DEBUG Initializing orchestrator
2017-08-11 14:59:57 INFO Connecting to backend: maxConnections: 128, maxIdleConns: 32
2017-08-11 14:59:57 DEBUG Will check whether db3:3306's master (db2:3306) can become its co-master
2017-08-11 14:59:57 INFO Will make db3:3306 co-master of db2:3306
2017-08-11 14:59:57 INFO auditType:begin-maintenance instance:db3:3306 cluster:db2:3306 message:maintenanceToken: 35, owner: ubuntu, reason: make co-master of db2:3306
2017-08-11 14:59:57 INFO auditType:begin-maintenance instance:db2:3306 cluster:db2:3306 message:maintenanceToken: 36, owner: ubuntu, reason: db3:3306 turns into co-master of this
2017-08-11 14:59:57 DEBUG Got credentials from a replica. will now apply