I think the right pattern here is edge sharding of user data. Cloudflare makes this pretty easy with D1/Hyperdrive.