Perhaps sharding data by geographical location could be one path - e.g. deploy one server in the US and another in Europe, each with its own database.

The whole concept of edge computing - deploying app servers closer to your users for minimal network latency - seems to go hand in hand with using an embedded database like SQLite. (I haven't tried it in production yet, but looking forward to.)