# Poor man's MM replication? (Not really, but sort of...)

**URL:** <https://forums.percona.com/t/poor-mans-mm-replication-not-really-but-sort-of/24539>\
**Category:** MySQL & MariaDB\
**Tags:** mysql, percona\
**Created:** [August 18, 2023, 7:14pm UTC](https://forums.percona.com/t/poor-mans-mm-replication-not-really-but-sort-of/24539 "2023-08-18T19:14:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![joshlawrence](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joshlawrence/32/12342_2.png) [@joshlawrence](https://forums.percona.com/u/joshlawrence)\
**Post date:** [August 18, 2023, 7:14pm UTC](https://forums.percona.com/t/poor-mans-mm-replication-not-really-but-sort-of/24539/1 "2023-08-18T19:14:05Z")

</div>

hello everyone!

first, I have read that multi-source replication is not available in percona/mysql 8, but what I’m needing kinda fits in that category…

I’ve got 2 production servers that serve completely different (large-ish) datasets. each primary server has a replica. I have a need to combine most (?) of the data from both primary servers into one server for some reporting project. my initial thought was to do a daily dump/load from each replica to the reporting server, but the data sets are large enough that it will take too much time. since one mysql 8 server cannot be the replica of 2 primaries, are there any solutions that come to mind? at this point, I’m open to any ideas whatsoever, including “what you’re asking for is dumb, what you _should_ try is $this\_idea.”

thank you!

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [August 18, 2023, 7:59pm UTC](https://forums.percona.com/t/poor-mans-mm-replication-not-really-but-sort-of/24539/2 "2023-08-18T19:59:03Z")

</div>

> [@joshlawrence](#):
>
> I have read that multi-source replication is not available in percona/mysql 8

Where did you read that? That is completely false. You can absolutely configure db1\<-\>db2 replication and you can configure fan-in as well, where a single replica has several sources.

> [@joshlawrence](#):
>
> since one mysql 8 server cannot be the replica of 2 primaries

You can absolutely do this.  
[https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source.html](https://dev.mysql.com/doc/refman/8.0/en/replication-multi-source.html)

The very first sentence from the official manual reads:

> MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in parallel.

So where ever you read that it doesn’t work/not available, you should send them that link. 🙂

For your stuff, you can configure 2 replica channels, one for source A and one for source B. The tables/databases should not overlap. If you have a database.table “foobar.mytable” in source A, you can’t have that same table in source B otherwise there would be insane conflicts.

---

<div class="post-metadata">

**Author:** ![joshlawrence](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/joshlawrence/32/12342_2.png) [@joshlawrence](https://forums.percona.com/u/joshlawrence)\
**Post date:** [August 18, 2023, 8:03pm UTC](https://forums.percona.com/t/poor-mans-mm-replication-not-really-but-sort-of/24539/3 "2023-08-18T20:03:07Z")

</div>

hey @matthewb

> [@matthewb](#):
>
> So where ever you read that it doesn’t work/not available, you should send them that link.

oh that’s fantastic!!! even though I have a little egg on my face for getting my details wrong, I learned something new today! thank you so much 🙂