What you need to know about SQLite
joyofrails.com
joyofrails.com
There's not just vertical scaling vs horizontal-with-replication. There's also horizontal-with-sharding, where each additional machine remains (more) independent.
The exact semantics regarding how "lively" and "safe" each domain type must be almost certainly varies type to type.
I think a lot of developers come into this thinking one big SQLite database. And for many cases that is the most correct path. But you can do a database per domain type or service, and customize the replication and performance considerations at this smaller grain. You can still do ETL magic on the other side to build composite views of everything for reporting purposes. SQLite is amazing at this kind of thing. It can really help decompose a monster problem if you're willing to throw away dogma and focus on the actual problem on hand.