All of the Appwrite containers were designed to be stateless and easy to scale with replication, scaling the under the hood database is as easy as connecting it to a managed cloud solution.
We're trying to update these old posts as we speak... hopefully we'll get to this soon :') Keep an eye out!