CODEWITHSUNDEEP
mysqlloadscaling
dave
dave

Reputation: 7867

MySQL - How well will it scale with multiple concurrent remote connections each throwing 100's of writes per second?

I'm running a small server with MySQL installed that will have 10 to 20 clients remotely connected to it (direct connection) flooding it with data. The data could be coming in at 200-300 writes per second. Possibly more/less.

I'm wondering how well MySQL can handle this. The 'server' is an off the shelf computer. Nothing special/enterprise.

I don't know whether I should write a small async server that will sit between MySQL and the clients to buffer the data. Every 1000 rows or so, it can dump the data into MySQL.

Is this necessary? Or can MySQL handle this load?

Upvotes: 0

Views: 164

Answers (1)

Barend
Barend

Reputation: 17419

Facebook makes extensive use of MySQL at commit rates higher than yours, so it's certainly possible. I don't know the exact commit rate at which it stops being easy.

Upvotes: 1

Related Questions