The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

What is the maximum number of master servers in a multi-source replication?

Hello Friends,

Recently I deployed a multi-source replication scheme with over 100 master servers against a single slave. I had no problem with the setup despite, according to the documentation (https://mariadb.com/kb/en/mariadb/multi-source-replication/) the maximum number of nodes was 64.

I was wondering whether this limit was expanded in recent releases, but I could not find any further mention to it in the release notes.

However, I am having some spurious replication issues. For example, there are missing rows in the slave database. These missing rows come from random master servers. I would like to confirm with you that the limit of 64 servers was in fact expanded in version 10.1.22 (or prior) of MariaDB, running on a 64-bit Centos, so I can discard this as a possible cause for the problem we are experiencing.

I appreciate very much your time and help with this issue.

Best,

Carlos

Answer Answered by Ian Gilfillan in this comment.

I checked the code and the initial allocation size for the array storing connections is 64, but it's automatically extended when needed, so there is no upper limit. I have now updated the documentation to reflect that.

When it comes to your replication problems, please file a bug report that describes your setup and the problem you are seeing so that we can try to help solve that!

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.