7 votes

Multi-Datacenter design for SQL Server

At this point, I guess SQL Server with an AlwaysOn cluster will satisfy HA, but what about read/write? I think this SQL Server 2012 whitepaper will be a good read for you at this point to get a ...
James Anderson's user avatar
5 votes
Accepted

How to verify galera is synced

If wsrep_local_state_comment, wsrep_ready, and wsrep_connected show the correct values, then that particular node is good. There's no Seconds_Behind_Master equivalent, because Galera is synchronous ...
Michael - sqlbot's user avatar
4 votes
Accepted

How to migrate from a MySQL master-slave setup to a master-master setup without downtime

On a basic level, yes. Just set up the current Master like you would any normal slave database. However, there are some things to consider first. Is the second slave set to READ-ONLY, as you want to ...
IGGt's user avatar
  • 2,086
4 votes
Accepted

Multi-Master Multi-Region MySQL Cluster

You probably want a cluster such as MySQL InnoDB Cluster (from Oracle) or MariaDB Galera Cluster or Percona XtraDB Cluster in each region for high availability. You can write to any of the nodes in ...
dbdemon's user avatar
  • 6,301
3 votes
Accepted

How do you update one side of a MySQL master-master replication setup?

At my company we run MySQL with circular replication. We do not stop replication during a deploy of either the app or schema changes. We must restart MySQL Server during upgrades or some configuration ...
Bill Karwin's user avatar
  • 14.3k
3 votes

Many-to-One replication / Transactional Replication

I see at least two options: if you don't need near-real-time replication, but just once a day (or maybe every hour) is enough for you, and the amount of data is small, you can quite simply create a ...
jcaron's user avatar
  • 552
3 votes
Accepted

Will auto_increment always grow in master-master setup?

Auto Increment ID is "replicating" to the slaves. Otherwise it would be hell of a job to promote a slave to a new master if the status of auto increment needs to synced. So to answer your question it ...
Károly Nagy's user avatar
  • 3,000
2 votes
Accepted

Is group replication available in Mysql community?

Based on the MySQL Developer manual: https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html It appears that so long as you're on the appropriate version you'll have access to ...
Josh Bonello's user avatar
2 votes
Accepted

MySQL - Master to master replication without downtime in Live production

I am glad you were able to mysqldump 1.5TB database. You are sure patient. Now for the reality check. You will some downtime for reboots and pausing. No need to mysqldump anymore. STEP 01 Did you ...
RolandoMySQLDBA's user avatar
2 votes
Accepted

Mysql Slave Claims to be Running but New Records Not Appearing and No Delay

When running an intermediary replication that is also a master, log-slave-updates needs to be enabled to ensure that the upstream master, replicates to the downstream slave.
danblack's user avatar
  • 7,699
2 votes
Accepted

Mysql multi-master active-active replication : replication doesn't happen for all slaves

Looking at you config, it seems you are missing log-slave-updates in your my.cnf files. You will need to add this in to both masters my.cnf files and restart them. This tells the slave database to ...
IGGt's user avatar
  • 2,086
1 vote

Geo-distributed DBaaS with MySQL compatible DB with multi-master?

(The Title and the Text talk about different things.) What would you be bringing to the table that AWS (or other Cloud) does not already provide? Please define "geo-distributed". Meanwhile, ...
Rick James's user avatar
  • 77.6k
1 vote
Accepted

MySQL Error 1062 after reboot node in multi master replication

You should use pt-table-checksum to see the differences between the source and the replica. If the differences are many, importing data again from the source could be the fastest solution. Otherwise, ...
Federico Razzoli's user avatar
1 vote
Accepted

Is there an option to prioritize a table while replication conflict occurs?

No. The Master and the Slave should always (aside from a minor delay) have identical data. If they don't, you need to investigate and fix it. Else, things could get worse and worse. Percona Tools ...
Rick James's user avatar
  • 77.6k
1 vote

galera wsrep_cluster_address value

wsrep_cluster_address is a comma-separated list in quotation marks, with all the nodes e.g.: wsrep_cluster_address="gcomm://192.168.0.1,192.168.0.2,192.168.0.3" For more info see the ...
Mandrappa's user avatar
1 vote
Accepted

1236 On Slave After Master Master Failure

I'll bet sync_binlog was turned off. With it off, the binlog entries just before the crash may not have been flushed to the binlog file, even though they have been sent to the Slave. Sending ...
Rick James's user avatar
  • 77.6k
1 vote
Accepted

MongoDB how to achieve asynchronous geo-replication

To do oneway replication from multiple "Local MongoDB" sources to one "Centralized MongoDB" realtime is possible with mongo-connector product. Just start one mongo-connector per every Local MongoDB. ...
JJussi's user avatar
  • 5,703
1 vote

Avoiding infinite loop in a master-master replication

This isn't easy, rolling your own is a bad idea. That said, there are a few ways to do this, disable the triggers and rules (like with Bucardo) Streaming log replication like with Postgres-BDR. BDR ...
Evan Carroll's user avatar
  • 62.7k
1 vote

Install galera cluster without remove existing mariadb

If you installed MariaDB 10.1, you don't need to remove anything because MariaDB Server and MariaDB Galera Server packages have been combined and Galera packages and their dependencies get installed ...
HamoonDBA's user avatar
  • 617
1 vote

MySQL - Master to master replication without downtime in Live production

As I'm not able to comment yet I need to write a new answer. I would like to add to the 6 steps of @RolandoMySQLDBA that the CHANGE MASTER TO command did not work for me. As the last command of STEP ...
dirkaholic's user avatar
1 vote

What to do in times of data inconsistency in Master-Master Replication in MySQL?

Master-Master, with both being written to, has so many perils that I regularly recommend against it. Since all writes need to be performed on both servers, there is no performance benefit from ...
Rick James's user avatar
  • 77.6k
1 vote

What to do in times of data inconsistency in Master-Master Replication in MySQL?

First point is that you should only write to one Master at a time, with the other set as the 'backup' option in HAPROXY. This will prevent you from writing to an out of date master (unless there is a ...
IGGt's user avatar
  • 2,086
1 vote

MariaDB Galera Multi-Master Performance

I don't know about your application/workload but generally, you should try with: wsrep_slave_threads=N (Do not use a value for wsrep_slave_threads that is higher than the average given by the ...
Ashraf Sharif's user avatar
1 vote

Is group replication available in Mysql community?

I ask the official support for the MySQL Group Replication, they told me that we can use the MySQL Group Replication in Community Edition even for the commercial product. But they advise to use the ...
Xin Meng's user avatar
  • 111
1 vote

How could duplicate entry on unique key happen if only one master is active?

Do not see the problem. When somebody enters the email address a second time then this happens. Nothing to do with replication. This is what the unique key is used for. If this error would break the ...
Marco's user avatar
  • 3,700
1 vote

How to convert MySQL master-slave to master-master

Master-Master has a lot of problems if you are writing to both. It is better to write to only one of them until you need to failover. Setting up Dual-Master is simply setting up both servers as being ...
Rick James's user avatar
  • 77.6k
1 vote

Chained MySQL replication from Master->Master replicated pair

Since you have binlog/replicate filtering, this is probably what happened: USE non_replicated_db; CREATE TABLE replicated_db.table_name ...; The filtering works on the USE, not on the db ...
Rick James's user avatar
  • 77.6k
1 vote
Accepted

Chained MySQL replication from Master->Master replicated pair

To answer my own question, the "fix" is to change binlog_format to STATEMENT. It was previously MIXED. Not entirely sure of the reason behind this - MySQL should be intelligent when using MIXED mode ...
phil-lavin's user avatar
1 vote

Multi master single slave replication mysql

I am assuming you already have Master1 and Master2 acting as Slaves of each other? The slave will be replicating from only one of the Masters. It will get data from the other Master via that one. ...
Rick James's user avatar
  • 77.6k
1 vote

Single Slave with Multiple Masters. Does this pattern exist in MongoDB?

I don't think so Single Slave with Multipe Master Possible. As per MongoDB BOL Here Master-slave replication preceded replica sets and made it possible to have a large number of non-master (i.e. slave)...
Md Haidar Ali Khan's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible