Scaling Rails and Postgres to millions of users at Microsoft

Postgres can be scaled vertically like Stackoverflow did. With cache on edge for popular reads if you absolutely must (but you most likely dont).<p>No need to microservice or sync read replicas even (unless you are making a game). No load balancers. Just up the RAM and CPU up to TB levels for heavy real world apps (99% of you wont ever run into this issue)<p>Seriously its so create scalable backend services with postgrest, rpc, triggers, v8, even queues now all in Postgres. You dont even need cloud. Even a mildly RAM&#x27;d VPS will do for most apps.<p>got rid of redis, kubernetes, rabbitmq, bunch of SaaS tools. I just do everything on Postgres and scale vertically.<p>One server. No serverless. No microservice or load handlers. It&#x27;s sooo easy.

I ran into some scaling challenges with Postgres a few years ago and had to dive into the docs.<p>While I was mostly living out of the &quot;High Availability, Load Balancing, and Replication&quot; chapter, I couldn&#x27;t help but poke around and found the docs to be excellent in general. Highly recommend checking them out.<p><a href="https:&#x2F;&#x2F;www.postgresql.org&#x2F;docs&#x2F;16&#x2F;index.html" rel="nofollow">https:&#x2F;&#x2F;www.postgresql.org&#x2F;docs&#x2F;16&#x2F;index.html</a>

15 years ago I worked on a couple of really high profile rails sites. We had millions of users with Rails and a single mysql instance (+memcached and nginx). Back then ruby was a bit slower than it is today but I’m certain some of the challenges you face at that scale are things people still do today…<p>1. try to make most things static-ish reads and cache generic stuff, e.g. most things became non-user specific HTML that got cached as SSI via nginx or memcached<p>2. move dynamic content to services to load after static-ish main content, e.g. comments, likes, etc. would be loaded via JSON after the page load<p>3. Move write operations to microservices, i.e. creating new content and changes to DB become mostly deferrable background operations<p>I guess the strategy was to do as much serving of content without dipping into ruby layer except for write or infrequent reads that would update cache.

Please check this excellent book by former Microsoft and Groupon engineer on scaling Rails and Postgres:<p>[1] High Performance PostgreSQL for Rails Reliable, Scalable, Maintainable Database Applications by Andrew Atkinson:<p><a href="https:&#x2F;&#x2F;pragprog.com&#x2F;titles&#x2F;aapsql&#x2F;high-performance-postgresql-for-rails&#x2F;" rel="nofollow">https:&#x2F;&#x2F;pragprog.com&#x2F;titles&#x2F;aapsql&#x2F;high-performance-postgres...</a>

What a small world. Earlier today I got tagged in a PR [1] where Andrew became the maintainer of a Ruby gem related to database migrations. Good to know he is involved in multiple projects in this space.<p>[1] <a href="https:&#x2F;&#x2F;github.com&#x2F;lfittl&#x2F;activerecord-clean-db-structure&#x2F;issues&#x2F;33">https:&#x2F;&#x2F;github.com&#x2F;lfittl&#x2F;activerecord-clean-db-structure&#x2F;is...</a>

Postgres can scale to millions of users, but Rails definitely can&#x27;t. Unless you&#x27;re prepared to spend a ton of money.

My experience scaling up Rails (mostly in size of codebase NOT in size of traffic) really made me love typesafe languages.<p>IDE smartness (auto complete, refactoring), compile error instead of runtime, clear APIs...<p>Kotlin is a pretty nice &quot;Type-safe Ruby&quot; to me nowadays.

This desperately needs the Walmart treatment of JET.com’s teams past acquisition :)

What&#x27;s Rails and Postgres? Do they mean ASP.NET and MS SQL Server?

I don&#x27;t understand why you wouldn&#x27;t just use Elixir&#x2F;Phoenix if you need to scale?

Scaling a non-scalabe by default framework that should have been few services written in a performance first language at a billion+ USD company.<p>I am not sure why are we boliling the oceans for the sake of a language like Ruby and a framework like Rails. I love those to death but Amazons approach is much better (or it used to be): you can&#x27;t make a service for 10.000+ users in anything else than: C++, Java (probably Rust as well nowadays).<p>For millions of users the CPU cost difference probably justifies the rewrite cost.