Stickybit
Blog
Viewing entries tagged with 'ss'
Load balancing PostgreSQL in the Amazon cloud
We've been working on an internal project for quite some time that among other things involves a ReSTful web service backed by a PostgreSQL database.
Our "production" installation is deployed in the Amazon EC2 cloud, with the idea that this gives us maximum flexibility to scale up resource investment dynamically with demand. However, in such a deployment PostgreSQL becomes both a potential bottleneck and SPOF (Single Point of Failure). While at its current phase in development we don't see any indication that we will be reaching a performance ceilings any time soon, this is still a concern for any large-scale roll out.
Even old dogs can still learn about TCP and UDP stacks...
Besides netstat, lsof and tcpdump I've not got a new tool in the collection. Christoffer showed me the ss command the other day while we were trying to understand the load on the DesignSync server.