# Percona master-master + slave setup

**URL:** <https://forums.percona.com/t/percona-master-master-slave-setup/6494>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [August 5, 2018, 10:28pm UTC](https://forums.percona.com/t/percona-master-master-slave-setup/6494 "2018-08-05T22:28:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![flash05](https://avatars.discourse-cdn.com/v4/letter/f/54ee81/32.png) [@flash05](https://forums.percona.com/u/flash05)\
**Post date:** [August 5, 2018, 10:28pm UTC](https://forums.percona.com/t/percona-master-master-slave-setup/6494/1 "2018-08-05T22:28:21Z")

</div>

Hi,

I’m new to Percona cluster and was able to successfuly setup a lab using this guide: [url][Redirecting](https://www.percona.com/doc/percona-xtradb-cluster/LATEST/install/index.html%5B/url%5D)

Now, I’m not sure if this makes sense, is it possible to integrate a slave to this master-master setup or just simply add another master and do all the reads there?

I’m unable to find a guide and only master-slave except this: [url][https://www.percona.com/doc/percona-xtrabackup/LATEST/howtos/setting\_up\_replication.html[/url]](https://www.percona.com/doc/percona-xtrabackup/LATEST/howtos/setting_up_replication.html%5B/url%5D) and couple of others.

Thanks.

---

<div class="post-metadata">

**Author:** ![Barrett](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/barrett/32/15734_2.png) [@Barrett](https://forums.percona.com/u/Barrett)\
**Post date:** [August 6, 2018, 6:56am UTC](https://forums.percona.com/t/percona-master-master-slave-setup/6494/2 "2018-08-06T06:56:17Z")

</div>

Hi flash05,

To answer your question, it is possible to set up asynchronous replication from PXC to a read-only replica.

Please check out [this post](https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/49277-it-s-it-possible-to-using-xtradb-cluster-as-a-slave)for more details on setting this up properly.

---

<div class="post-metadata">

**Author:** ![flash05](https://avatars.discourse-cdn.com/v4/letter/f/54ee81/32.png) [@flash05](https://forums.percona.com/u/flash05)\
**Post date:** [August 6, 2018, 7:16am UTC](https://forums.percona.com/t/percona-master-master-slave-setup/6494/3 "2018-08-06T07:16:17Z")

</div>

> [@Barrett;52006](#):
>
> Hi flash05,
> 
> To answer your question, it is possible to set up asynchronous replication from PXC to a read-only replica.
> 
> Please check out [this post](https://www.percona.com/forums/questions-discussions/percona-xtradb-cluster/49277-it-s-it-possible-to-using-xtradb-cluster-as-a-slave)for more details on setting this up properly.

Hi Barret. Thanks for the input and yes I’ve seen that as well and on said “But actually - why to bother with async replication at all here? Why not use all in same PXC cluster, and just designate one node as writer/master if needed?” so it is possible however im not sure if this makes sense and just assign one as slave. By any chance there is a use-case of this setup?

---

<div class="post-metadata">

**Author:** ![Barrett](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/barrett/32/15734_2.png) [@Barrett](https://forums.percona.com/u/Barrett)\
**Post date:** [August 6, 2018, 10:44am UTC](https://forums.percona.com/t/percona-master-master-slave-setup/6494/4 "2018-08-06T10:44:13Z")

</div>

As a new PXC user, a less complicated setup makes more sense and will meet the majority of requirements.

Have you seen [this Solution Brief](https://www.percona.com/resources/solution-brief/always-online-critical-website-percona-xtradb-cluster)?

We recommend a 3-node cluster with 1 asynchronous slave as a best-practice. The asynchronous slave can be used for disaster recovery or for read-splitting for reads that are tolerant of a minor delay.

---

<div class="post-metadata">

**Author:** ![flash05](https://avatars.discourse-cdn.com/v4/letter/f/54ee81/32.png) [@flash05](https://forums.percona.com/u/flash05)\
**Post date:** [August 6, 2018, 8:55pm UTC](https://forums.percona.com/t/percona-master-master-slave-setup/6494/5 "2018-08-06T20:55:03Z")

</div>

Thanks again for your response. I guess we’ll just have to use this 3-node setup to simplify things and not add more variables to the equation. 🙂
