Hello Experts,
It’s my first time with the Percona db and I need to prepare a technical plan to deploy Percona db cluster on multi-AZ in AWS including the following:
- How much time I will need to deploy it.
- How I can perform a load/performance test for it considering the following:
- 3 nodes = X read transactions/s and Y write transactions/s
- 5 nodes = X read transactions/s and Y write transactions/s
Appreciate your support.
BR,
Haytham
1 Like
Hello @Haytham,
The amount of time you need to deploy depends on how familiar you are with everything. I teach a PXC training class every couple weeks so it would probably take me about 10-20m to setup a 3-node multi-az cluster. The “multi-az” aspect is irreverent regarding time. You simply launch node 1 in az 1, then launch node 2 in az 2, etc. Ideally, create a private network shared between each VPC in each AZ for easier networking.
The de-facto standard is to use sysbench for testing/load-performance. Plenty of articles on the web demonstrating this.
Be sure to integrate proxysql into your build to handle load balancing and high-availability aspects of your cluster.
2 Likes
Thanks for your reply.
Is there a document or something can I refer back to it to see the full architecture ?
Thanks
1 Like
I don’t have any documents. That would be something we would create for you as a client as part of an Architecture and Design engagement with our consultants. Here’s something I found, though: Best Practices for Percona XtraDB Cluster on AWS - Percona Database Performance Blog
2 Likes