Questions tagged [multi-master]
Multi-master refers to a configuration in which more than one node in a cluster is a full read/write member. It takes many forms - synchronous MM network clustering, async MM replication, shared-storage MM clustering, and more.
84 questions
0
votes
0
answers
44
views
How do I convert master-slave to multimaster database replication in MySQL?
Currently, I have one master and two slaves in my setup. How can I convert it so that I have three masters instead? I need all three nodes to be writable and to update each other accordingly.
Most of ...
0
votes
1
answer
115
views
Alternative to multi-master replication between local and cloud db when writes are infrequent and only 1 db at a time
Background:
I have a closed-source app on my laptop that saves its data in a local SQLite database. I'm working on creating a mobile app for myself that would replicate the functionality of the ...
0
votes
1
answer
16
views
MySQL replication status not reporting mysqld.cnf parameters
I am running a multi master replication from 3 master servers to 1 slave. Each of the masters has 2 DBs but I am replicating just 1 of the DBs.
Server version: 8.0.35-0ubuntu0.20.04.1 (Ubuntu)
...
0
votes
1
answer
616
views
do_table or ignore_table alternatives on MariaDB Galera Multi-Master
As far as I can see, there are no do_table or ignore_table configs in MariaDB Galera multi-master (master-master) to skip or ignore specific tables. And there are only binlog_do_db and ...
0
votes
1
answer
194
views
Geo-distributed DBaaS with MySQL compatible DB with multi-master?
There are a few NewSQL engines exist, most of them Postgres-compatible, but there are MariaDB Xpand and others, MySQL-based. Plus Galera-based clusters.
My question - is there production ready DBaaS ...
2
votes
0
answers
1k
views
MySQL multi-master group replication on kubernetes
We are trying to setup MySQL multi-master group replication (GR) on kubernetes Group replication configuring instances.
GR is starting on one pod after all the configurations. However the second node ...
2
votes
2
answers
800
views
How do you update one side of a MySQL master-master replication setup?
I have a master-master (circular) replication configured between two MySQL servers, call them West and East. There is also a web app that interfaces with each DB, also on its own West and East server,...
1
vote
1
answer
569
views
Proxysql setup for Percona PXC Multimaster cluster
I have a clean Ubuntu lab setup for PXC Cluster and Proxysql (each a separate VM)and i'm seeing this issue (error below).
Is there a specific installation that needs to be followed for PXC cluster? I ...
0
votes
2
answers
2k
views
MySQL Error 1062 after reboot node in multi master replication
I setup 2 MySQL Community Server (8.0.20) with a replication master to master. Today one of the nodes went down, and when it went up, the replication failed. I tried to just ignore a registry with SET ...
0
votes
1
answer
41
views
DR For MySQL multi master nodes
I’ve planned to build MySQL master-master replication and need DR for this setup. I was thinking for replication from any of the node as a slave.
Please help, which option is best and how to switch ...
0
votes
0
answers
1k
views
How to implement master-master replication in PostgreSQL?
I am working on a project which requires my database client to scale horizontally for higher availability but it is required to use RDBMS for our solution. Therefore, we want to implement master-...
1
vote
1
answer
127
views
MySQL replication not finished on next site call
I have 3 MySQL8.0 instances. Two of them are slaves. Each site call I‘m reading the slave till the first write Request is made. Afterwards Only the Master is used during the request. Now, if I write ...
0
votes
1
answer
174
views
How to use a MySQL database both remotely and locally
I cannot find the best solution for my problem.
I made a C++ application which runs on a Kiosk under Ubuntu that needs to store and retrieve data from a MySQL database and these same data need to be ...
7
votes
2
answers
4k
views
Multi-Master Multi-Region MySQL Cluster
I am hosting an application (a game) in multiple regions around the globe. Performance is critical to this application since it's a game, and therefore I need to host a database instance in each of ...
0
votes
0
answers
613
views
mariabackup slave info and multi-master replication
I have several master databases using mariadb 10.3 and replicate then all to one replica using multi-master replication. All is working fine.
I want to backup that replica server, so i can restore it ...
0
votes
1
answer
617
views
galera cluster how to run an ALTER without using RSU/TOI
I need to run an alter statement but would like to prevent locking/stall the cluster. The Galera docs advised using:
SET wsrep_OSU_method='RSU';
Then Run the ALTER statement, once finich:
SET ...
1
vote
1
answer
619
views
Galera Arbitrator system requirements compared with the actual Galera MariaDB node requirements
Right now our setup is CloudFlare > 1x HAProxy (Dallas,TX), 3x App servers (Dallas,TX), 3x MariaDB nodes in a Galera multi-master cluster (Dallas,TX).
The App servers auto-scale horizontally to handle ...
0
votes
1
answer
651
views
MySQL Replication ignore few columns
I have setup MySQL replication, is there a way to skip replicating one column or multiple columns from few tables?
0
votes
1
answer
284
views
Is there an option to prioritize a table while replication conflict occurs?
I have a master slave configuration for my production stage environment. Sometimes I need to write to some tables of my stage server i.e slave server. In that case conflicts occurs as content from ...
1
vote
1
answer
761
views
Statement Based Replication still giving duplicate Entry Error
New to the replication. I am configuring multi-master replication. I did the following steps:
made one slave.
configured two masters to it.
Now i am performing following scenario:
disconnect both ...
0
votes
1
answer
678
views
Why does my Group Replication plugin fail in MySQL 5.7.24?
I've been using the group_replication plugin with MySQL without issues before 5.7.24. With this version, the server starts up without the plugin because of failure.
I confirmed it manually (see steps ...
0
votes
1
answer
575
views
Mysql Slave Claims to be Running but New Records Not Appearing and No Delay
I've created a new mysql master and a slave. My master is also a slave of another running instance. The replication between those two works fine so I don't believe my issue is there.
I created a dump ...
2
votes
1
answer
912
views
galera wsrep_cluster_address value
I am trying to deploy galera multimaster replication but faced some problems, google does not solve it it seems, but I see some people had the same problems in the past.
Say, I have 3 servers
192....
0
votes
1
answer
1k
views
1236 On Slave After Master Master Failure
I have a master (master 1) that replicates to another master (master 2), which then replicates to its slave.
So master 2 had an issue with the binary logs:
Relay log read failure: Could not parse ...
0
votes
1
answer
881
views
Mariadb Galera cluster empty set
I am playing around with a MariaDB Galera Master Master Cluster and I have some issues which I do not understand.
[mysqld]
bind-address=0.0.0.0
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/...
1
vote
1
answer
538
views
MongoDB how to achieve asynchronous geo-replication
I have read a lot of background about MongoDB replication and sharding. None of the default solutions that I know can actually do what I'm trying to achieve.
Current situation
We have a time ...
2
votes
1
answer
784
views
Mysql database replication with geo-distributed servers
I am just a developer, who doesn't have deep knowledge in DBA. So need experts suggestions in this.
I have two offline databases in two cities, I want to make a synchronization between two databases ...
0
votes
0
answers
6k
views
Internal MariaDB error code: 1927 ('Connection was killed')
Edit: filed a bug report at https://jira.mariadb.org/browse/MDEV-14493
Mariadb nodes freeze occasionally with the following error in the logs, any clues?
(drupal app, db freezes on clearing ...
0
votes
1
answer
71
views
Mysql replication, allow inserts while database is disconnected
I've tried getting information on this elsewhere but can't really find what I'm looking for. I'm making a system to handle sales, etc for a company that has different branches. They want to have the ...
0
votes
1
answer
1k
views
Galera Cluster Setup - Primary and Secondary Site Scenario
I'm very new to Galera Cluster and is exploring a potential setup with reasonable resiliency to node failure and network failure. Looking at the very bottom part of this documentation, the Weighted ...
1
vote
0
answers
134
views
Replicate Specific Tables with fully qualified statements removed
Currently we have a replication system that is a master to slave, which that slave is also a master. We are replicating our web server to our stats server so we can report on users traffic as well. We'...
2
votes
1
answer
734
views
Avoiding infinite loop in a master-master replication
As an exercise, I am implementing a master-master replication in PostgreSQL, using triggers (requirement of the task). Basically there are 2 databases with tables that have almost exactly the same ...
0
votes
1
answer
614
views
Install galera cluster without remove existing mariadb
I have to setup Galera cluster in one of my production servers.
OS: Ubuntu 14.04
Existing mysql: maridb 10.1
While installing this cluster, its asking to remove the existing mariadb-server-10.1
How ...
5
votes
2
answers
5k
views
MySQL - Master to master replication without downtime in Live production
I want to setup 2 node master-master replication. Im aware of the point of failiures in this replication. Its a huge database around 1.5TB.
Heavy OLTP is going on. But its mandatory to implement right ...
0
votes
2
answers
1k
views
What to do in times of data inconsistency in Master-Master Replication in MySQL?
I am building an architechture consisting MySQL Master-Master replication with HAProxy in its front. For HAProxy i am using round_robin algorithm to distribute loads between two masters. My question ...
-1
votes
1
answer
579
views
How to get user Insert statistics in MySQL
I'm trying to get statistics on the write load on my MySQL servers.
Something like what show global status like "Com_%"; gives me.
but, here comes the catch - we're using Master-Master replication.
...
1
vote
1
answer
757
views
MariaDB Galera Multi-Master Performance
I am playing around with a MariaDB Galera Multi Master Cluster and I have some performance issues which I do not understand.
I have 2 virtual test machines with Ubuntu 16.04 and MariaDB 10.1 ...
1
vote
1
answer
86
views
runtime replication
We have a master-master replication setup with 3 databases being replicated between both masters; 'database a', 'database b', 'database c'. Replication is row-based.
'database c' had an issue and we ...
4
votes
2
answers
2k
views
Is group replication available in Mysql community?
Group replication for Mysql server seems to be a great functionnality.
It is available from version 5.7.17 of MySql Enterprise and Cluster CGE edition.
But is it available for Mysql community ? and ...
0
votes
1
answer
60
views
Multi Master Replication With One Slave
I'm in the middle of my little project here and i had some problem here, this is the detail of it.
I have 4 server, 3 server using for getting data from my sensor module and 1 is using for storing ...
2
votes
2
answers
988
views
MySql Multi Master Active Active Mutli Write
I am establishing Multi Master Replication [All mater can write to their database], Initially I started with two server. After establishing connection and sync data on both servers. There are some ...
0
votes
1
answer
658
views
How could duplicate entry on unique key happen if only one master is active?
Say, I we have master-master replication with only one master active at a time.
We have users table:
create table users (
id int auto_increment,
email varchar(255),
primary key id(id),
unique ...
3
votes
1
answer
1k
views
How to convert MySQL master-slave to master-master
I've searched around, but can't find the exact details to point me in the proper direction. I currently have 2 MySQL instances under 5.5.41 running as a master-slave setup. I followed these ...
1
vote
1
answer
684
views
Setting up Master-Master Replication in MySQL on a live system
I've just recently taken on the task of looking after our mySQL databases, and have been given the task of setting master-master replication. We have a live server which has a mySQL database which is ...
2
votes
1
answer
967
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
2
answers
329
views
Chained MySQL replication from Master->Master replicated pair
This is a pictorial view of what I have:
Master 1<----->Master 2
| |
| |
V V
Slave 1 Slave 2
The masters are never written ...
3
votes
1
answer
787
views
How to migrate from a MySQL master-slave setup to a master-master setup without downtime
We have an existing master-slave MySQL replication setup where we would like to promote the second slave to a master in order to achieve a master-master setup with no or only minimal downtime.
Is it ...
1
vote
1
answer
2k
views
Will auto_increment always grow in master-master setup?
Let's suppose I have mysql master-master replication setup with only one server active at a time (i.e. all writes going to one server), and
I have ability to manually switch to another master.
Next, ...
4
votes
1
answer
13k
views
How to verify galera is synced
I have been using mysql master:master replication and was always able to check the status of replication using this command:
mysql > show slave status\G
I was able to see this in the show slave ...
0
votes
1
answer
100
views
Multi master single slave replication mysql
I have a scenario in which there are two masters master 1 and master 2 and i want to add slave to master 2 , so when i update in master 1 it will replicate for master 2 so how do i get slave of master ...