Questions tagged [semi-sync-replication]

Semisynchronous Replication : MySQL's Proprietary Mechanism for Replication

Filter by
Sorted by
Tagged with
0
votes
0answers
27 views

MariaDB Semi-Sync Slave connection lost during inserting of rows into Master

I have been using MariaDB (10.3) Semi-Sync [Master/Slave] Replication. As a part of testsystem, I am inserting 6000 rows into Master database and approximately it is processing 1000 rows/second. ...
0
votes
0answers
111 views

mysql unable to start with semi sync parameter

Im using mysql 5.7 and it has 2 slaves with GTID. I tried to enable semi-sync and I have done with set global variable in mysql prompt. It was running fine. Then I did a restart, after that mysql ...
3
votes
3answers
498 views

High disk IO with MySQL master-master replication

We've been evaluating an active-passive master-master replication setup for our MySQL database, running on version 8.0. While diagnosing some general slowness issues, we were surprised to see very ...
1
vote
1answer
44 views

Accessing Oracle DB from SQL Server DB

I am looking for the best and simplest way for accessing an Oracle db from an SQL Server db. Both are on separate physical servers. I am looking for a one-way access in read-only mode. SQL Server ...
1
vote
1answer
601 views

MySQL Semi-synchronous replication with Multi-Master

Is it possible to use semi-synchronous replication with a Multi-Master setup? I've tried to follow this guide to setup a semi-synchronous replication for a master-slave setup: https://avdeo.com/2015/...
1
vote
1answer
890 views

MySQL Database replication for high availability

configuration: 1 balancer 2 Azure machines(4 gb ram, 2 cores), with MySQL master-master replication enabled. X users connecting to the balancer to sync data. test: i've tested the MySQL replication ...
2
votes
1answer
310 views

Syncing updates to master in master/slave setup [semi-sync replication]

Background info I have two MySQL 5.5 servers set up in a Master/Slave configuration with Semi-synchronous replication. The database is being used for a high-profile WordPress site. Problem It ...
3
votes
1answer
199 views

Question about MySQL Semisynchronous Replication

I was researching about MySQL Semisynchronous Replication, my understanding about the workflow is the follow: Master Receive a successful transaction from a client session. Master write it to his ...
1
vote
2answers
310 views

Breaking Semisynchronous Replication in MySQL 5.5

I've set up Semisynchronous Replication between two MySQL 5.5 servers running on Windows 7. My application is running and updating the database of the master server and same is being updated in the ...
5
votes
1answer
1k views

Installing and enabling both master and slave semisynchronous plugins on same server

I want to run a semisynchronous replication setup, and for simplicity I'd like to not have to INSTALL and UNINSTALL plugins when a slave is promoted to a master. So I'm wondering if I'll experience ...