Hello, we have a database structure running master-master with 5 nodes(xtradb cluster) percona mysql 8.0.29 version. The distribution of these nodes is as follows (3 node on side1)-(2 node on side2). What I want to do is to set up a slave server connected to one of the 3 nodes on side1 and report from there. Is such a plot possible? if possible how can i do it? Looking forward to your support and feedback. Respects.
Yes, you can do this using normal async replication. Pick any of the 3 nodes on side 2 and use that as the source for your replica. Be sure to configure using GTID so that you can failover the replica to any of the 3 sources.
Architectural speaking, why do you need an async replica when you have 4 synchronous replicas already available? Assuming you send all writes in your 5-node PXC to a single node, the other 4 are available as readers.
Thanks @matthewb ,We are a company within the scope of pci-dss, my purpose in doing this was to ensure that it does not appear in the Audit’log and that no user other than db admin is visible on the database during the audit. I have read and applied many documents, but unfortunately I could not perform the process. If there is a document you can refer to, I would be very grateful.
The audit log might contain evidence that a new replica has connected. Isn’t the purpose of an audit to show what is happening and document who has access?
You’re right, but I wanted to try such a method since I don’t want to have a select authorized user on the database other than dba on the pci side. maybe i set it up architecture wrong.
thanks your feedback