func (s *TestSuite) TestFailMoveBelow(c *C) {
clearTestMaintenance()
_, _ = inst.ExecInstance(&slave2Key, `set global binlog_format:='ROW'`)
_, err := inst.MoveBelow(&slave1Key, &slave2Key)
_, _ = inst.ExecInstance(&slave2Key, `set global binlog_format:='STATEMENT'`)
c.Assert(err, Not(IsNil))
}
// The test also assumes one backend MySQL server.
func (s *TestSuite) SetUpSuite(c *C) {
config.Config.MySQLTopologyUser = "******"
config.Config.MySQLTopologyPassword = "******"
config.Config.MySQLOrchestratorHost = "127.0.0.1"
config.Config.MySQLOrchestratorPort = 5622
config.Config.MySQLOrchestratorDatabase = "orchestrator"
config.Config.MySQLOrchestratorUser = "******"
config.Config.MySQLOrchestratorPassword = "******"
config.Config.DiscoverByShowSlaveHosts = true
_, _ = db.ExecOrchestrator("delete from database_instance where hostname = ? and port = ?", masterKey.Hostname, masterKey.Port)
_, _ = db.ExecOrchestrator("delete from database_instance where hostname = ? and port = ?", slave1Key.Hostname, slave1Key.Port)
_, _ = db.ExecOrchestrator("delete from database_instance where hostname = ? and port = ?", slave2Key.Hostname, slave2Key.Port)
_, _ = db.ExecOrchestrator("delete from database_instance where hostname = ? and port = ?", slave3Key.Hostname, slave3Key.Port)
inst.ExecInstance(&masterKey, "drop database if exists orchestrator_test")
inst.ExecInstance(&masterKey, "create database orchestrator_test")
inst.ExecInstance(&masterKey, `create table orchestrator_test.test_table(
name varchar(128) charset ascii not null primary key,
value varchar(128) charset ascii not null
)`)
rand.Seed(time.Now().UTC().UnixNano())
}
func (s *TestSuite) TestMoveBelowAndBackComplex(c *C) {
clearTestMaintenance()
// become child
slave1, _ := inst.MoveBelow(&slave1Key, &slave2Key)
c.Assert(slave1.MasterKey.Equals(&slave2Key), Equals, true)
c.Assert(slave1.SlaveRunning(), Equals, true)
// Now let's have fun. Stop slave2 (which is now parent of slave1), execute queries on master,
// move s1 back under master, start all, verify queries.
_, err := inst.StopSlave(&slave2Key)
c.Assert(err, IsNil)
randValue := rand.Int()
_, err = inst.ExecInstance(&masterKey, `replace into orchestrator_test.test_table (name, value) values ('TestMoveBelowAndBackComplex', ?)`, randValue)
c.Assert(err, IsNil)
master, err := inst.ReadTopologyInstance(&masterKey)
c.Assert(err, IsNil)
// And back; keep topology intact
slave1, err = inst.MoveUp(&slave1Key)
c.Assert(err, IsNil)
_, err = inst.MasterPosWait(&slave1Key, &master.SelfBinlogCoordinates)
c.Assert(err, IsNil)
slave2, err := inst.ReadTopologyInstance(&slave2Key)
c.Assert(err, IsNil)
_, err = inst.MasterPosWait(&slave2Key, &master.SelfBinlogCoordinates)
c.Assert(err, IsNil)
// Now check for value!
var value1, value2 int
inst.ScanInstanceRow(&slave1Key, `select value from orchestrator_test.test_table where name='TestMoveBelowAndBackComplex'`, &value1)
inst.ScanInstanceRow(&slave2Key, `select value from orchestrator_test.test_table where name='TestMoveBelowAndBackComplex'`, &value2)
c.Assert(inst.InstancesAreSiblings(slave1, slave2), Equals, true)
c.Assert(value1, Equals, randValue)
c.Assert(value2, Equals, randValue)
}