ec2 instance types for ProxySQL

[Debian Dba]

Hello all,

     I've a plain vanilla Percona MySQL Master-Slave setup with concurrent connections which usually are between 300-500. As we would be using ProxySQL in this setup as our choice of Load Balancer, what other factors should I take into account in deciding the right AWS EC2 instance type for ProxySQL? Are there any specific category within AWS instance types that I should focus on?

Thanks in advance

Deb

[René Cannaò]

Similarly to MySQL , the number of connections alone is not sufficient to estimate the load that they will generate, neither what hardware (or EC2 instance) is required.

For example, a very busy workload with just 10 connections can create more load than an application using 5000 connections idle most of the time.

That said, as a general guidance, keep in mind that ProxySQL is CPU and network intensive: disk usage is not relevant, and memory footprint is generally low (unless it has to handle hundreds of thousands of connections, or query cache is enabled).

For this reason, you should generally use compute optimized EC2 instances.

Thanks

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Debian Dba]

Thanks Rene. I'll keep this in mind.

To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.