def _set_group_master_replication(group, server_id, update_only=False):
"""Set the master for the given group and also reset the
replication with the other group masters. Any change of master
for a group will be initiated through this method. The method also
takes care of resetting the master and the slaves that are registered
with this group to connect with the new master.
The idea is that operations like switchover, failover, promote all are
finally master changing operations. Hence the right place to handle
these operations is at the place where the master is being changed.
The following operations need to be done
- Stop the slave on the old master
- Stop the slaves replicating from the old master
- Start the slave on the new master
- Start the slaves with the new master
:param group: The group whose master needs to be changed.
:param server_id: The server id of the server that is becoming the master.
:param update_only: Only update the state store and skip provisioning.
"""
# Set the new master if update-only is true.
if update_only:
group.master = server_id
return
try:
# Otherwise, stop the slave running on the current master
if group.master_group_id is not None and group.master is not None:
_group_replication.stop_group_slave(
group.master_group_id, group.group_id, False
)
# Stop the Groups replicating from the current group.
_group_replication.stop_group_slaves(group.group_id)
except (_errors.GroupError, _errors.DatabaseError) as error:
_LOGGER.error(
"Error accessing groups related to (%s): %s.", group.group_id,
error
)
# Set the new master
group.master = server_id
try:
# If the master is not None setup the master and the slaves.
if group.master is not None:
# Start the slave groups for this group.
_group_replication.start_group_slaves(group.group_id)
if group.master_group_id is not None:
# Start the slave on this group
_group_replication.setup_group_replication(
group.master_group_id, group.group_id
)
except (_errors.GroupError, _errors.DatabaseError) as error:
_LOGGER.error(
"Error accessing groups related to (%s): %s.", group.group_id,
error
)
def _set_group_master_replication(group, server_id, update_only=False):
"""Set the master for the given group and also reset the
replication with the other group masters. Any change of master
for a group will be initiated through this method. The method also
takes care of resetting the master and the slaves that are registered
with this group to connect with the new master.
The idea is that operations like switchover, failover, promote all are
finally master changing operations. Hence the right place to handle
these operations is at the place where the master is being changed.
The following operations need to be done
- Stop the slave on the old master
- Stop the slaves replicating from the old master
- Start the slave on the new master
- Start the slaves with the new master
:param group: The group whose master needs to be changed.
:param server_id: The server id of the server that is becoming the master.
:param update_only: Only update the state store and skip provisioning.
"""
# Set the new master if update-only is true.
if update_only:
group.master = server_id
return
try:
# Otherwise, stop the slave running on the current master
if group.master_group_id is not None and group.master is not None:
_group_replication.stop_group_slave(group.master_group_id,
group.group_id, False)
# Stop the Groups replicating from the current group.
_group_replication.stop_group_slaves(group.group_id)
except (_errors.GroupError, _errors.DatabaseError) as error:
_LOGGER.error("Error accessing groups related to (%s): %s.",
group.group_id, error)
# Set the new master
group.master = server_id
try:
# If the master is not None setup the master and the slaves.
if group.master is not None:
# Start the slave groups for this group.
_group_replication.start_group_slaves(group.group_id)
if group.master_group_id is not None:
# Start the slave on this group
_group_replication.setup_group_replication(
group.master_group_id, group.group_id)
except (_errors.GroupError, _errors.DatabaseError) as error:
_LOGGER.error("Error accessing groups related to (%s): %s.",
group.group_id, error)
def test_sync_readonly_servers(self):
status = self.proxy.group.lookup_servers("GROUPID3")
for info in self.check_xmlrpc_iter(status):
if info['status'] == MySQLServer.SECONDARY:
slave_uuid = info['server_uuid']
slave_server = fetch_test_server(slave_uuid)
slave_server.connect()
_group_replication.setup_group_replication("GROUPID2", "GROUPID3")
_replication.synchronize_with_read_only(slave_server,
self.shard_server, 3, 5)
_group_replication.stop_group_slave("GROUPID2", "GROUPID3", True)
try:
rows = self.shard_server.exec_stmt("SELECT NAME FROM db1.t1",
{"fetch": True})
except _errors.DatabaseError:
raise Exception("Enable Shard failed to enable shard.")
self.assertEqual(len(rows), 15)
def _stop_shard_group_replication(shard_id, clear_ref):
"""Stop the replication between the master group and the shard group.
:param shard_id: The ID of the shard, whose group needs to
be atopped as a slave.
:param clear_ref: Indicates whether removing the shard should result
in the shard group losing all its slave group references.
"""
#Fetch the Range sharding specification. When we start implementing
#heterogenous sharding schemes, we need to find out the type of
#sharding scheme and we should use that to find out the sharding
#implementation.
_, shard, _, shard_mapping_defn = \
verify_and_fetch_shard(shard_id)
#Stop the replication between the shard group and the global group. Also
#based on the clear_ref flag decide if you want to clear the references
#associated with the group.
_group_replication.stop_group_slave(shard_mapping_defn[2], shard.group_id,
clear_ref)
def _stop_shard_group_replication(shard_id, clear_ref):
"""Stop the replication between the master group and the shard group.
:param shard_id: The ID of the shard, whose group needs to
be atopped as a slave.
:param clear_ref: Indicates whether removing the shard should result
in the shard group losing all its slave group references.
"""
#Fetch the Range sharding specification. When we start implementing
#heterogenous sharding schemes, we need to find out the type of
#sharding scheme and we should use that to find out the sharding
#implementation.
_, shard, _, shard_mapping_defn = \
verify_and_fetch_shard(shard_id)
#Stop the replication between the shard group and the global group. Also
#based on the clear_ref flag decide if you want to clear the references
#associated with the group.
_group_replication.stop_group_slave(shard_mapping_defn[2], shard.group_id,
clear_ref)
def test_sync_readonly_servers(self):
status = self.proxy.group.lookup_servers("GROUPID3")
self.assertEqual(status[0], True)
self.assertEqual(status[1], "")
obtained_server_list = status[2]
for idx in range(0, 2):
if obtained_server_list[idx]["status"] == MySQLServer.SECONDARY:
slave_uuid = obtained_server_list[idx]["server_uuid"]
slave_server = MySQLServer.fetch(slave_uuid)
slave_server.connect()
_group_replication.setup_group_replication("GROUPID2", "GROUPID3")
_replication.synchronize_with_read_only(
slave_server, self.shard_server, 3, 5
)
_group_replication.stop_group_slave("GROUPID2", "GROUPID3", True)
try:
rows = self.shard_server.exec_stmt(
"SELECT NAME FROM db1.t1",
{"fetch" : True})
except _errors.DatabaseError:
raise Exception("Enable Shard failed to enable shard.")
self.assertEqual(len(rows), 15)