[MDEV-4833] SWITCH MASTER TO Created: 2013-08-01  Updated: 2015-06-12

Status: Open
Project: MariaDB Server
Component/s: Replication
Fix Version/s: None

Type: Task Priority: Major
Reporter: VAROQUI Stephane Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

We could use muti source replication to create a domains between all slaves and the master, we use that domain to send every write transactions to the master. The master execute the query and send the result to the slave via a replicated temporary table, and send an acknowledge simple inserting into a replicate acknowledge system table, the slave put the query on hold waiting for the acknowledge event, on such event forward the temporary table to the client. Having this in place we allow load balancing to all nodes and can implement a SWITCH MASTER command. That solution is losing read consistency but anyway most user of the replication do accept this since a long time. Election of a new master would take place using Corosync cluster engine plugin.



 Comments   
Comment by Daniel Black [ 2015-06-12 ]

with the implementation of GTIDs and MASTER_GTID_WAIT is there anything left to be done in this feature request?

Generated at Thu Feb 08 06:59:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.