请问一下mysql主从复制，对于高并发写入好像没什么效果？

Question

mysql主从复制，对于高并发写入好像没什么效果

Answer 1

Form formPreview = new Form();public Leaf(string name) : base(name) { }public override void Add(Component c){Console.WriteLine("Cannot add to a leaf");}public override void Remove(Component c){Console.WriteLine("Cannot remove to a leaf");}public override void Display(int depth){Console.WriteLine(new string('-',depth)+name);}}

Answer 2

mysql的双主或主从都是通过binlog的传输来对数据的一致性进行保障。换句话说就是A写入了，其实A会把binlog发给B，B也会同时写入。如果你是不希望同时写入，那你只能寄望于共享存储。两台机共用一个存储设备，当A坏了B马上接管A的工作。因为A和B都是使用同一个存储设备，所以不存在同步的问题。

Answer 3

1. 自身mysql故障（如主的mysql服务停后）2. 无法ping通网关3. 产生以上任何一个问题，均应该移除本机的虚拟IP(停止keepalived实例即可)

Answer 4

Form formPreview = new Form();public Leaf(string name) : base(name) { }public override void Add(Component c){Console.WriteLine("Cannot add to a leaf");}public override void Remove(Component c){Console.WriteLine("Cannot remove to a leaf");}public override void Display(int depth){Console.WriteLine(new string('-',depth)+name);}}