Hi. Where can I find the Managed Database Env because I want to use Managed MariaDB.
And what to change to Change to Managed DB?
Hey
Can you elaborate a bit about this?
Yeah. If I want to Change from local Database to Managed Db for Appwrite, What env variables to Change?
For now you can run AppWrite with MariaDB only so if you want to have managed one you'll need to update the following variables
_APP_DB_HOST
- Your managedDB host.
_APP_DB_PORT
- Your managedDB port
_APP_DB_SCHEMA
- Through what scheme, if exporting and importing leave it on appwrite
_APP_DB_USER
- Your managedDB Don't run on root
_APP_DB_PASS
- User passwwod
_APP_DB_ROOT_PASS
- Root password
The quick way would be to dump all the current database data and import it to a remote one
P.S, You can this vars inside either the docker-compse.yml
or the .env
in the path /root/appwrite
or your appwrite location (if you created a custom one)
It is better to edit the values inside the .env
file
Hmm so. So Matej once mentioned that: As of right now, Appwrite only allows you to connect to MariaDB, but we plan to support any database backend, such as MySQL, Postgres or MongoDB.
Gladly, Appwrite API is built in a way that database layer does not make much of a difference, what matters, is the API structure that you consume. It might feel a bit strange for someone with backend experience to see extra layer on top of database that Appwrite uses, but it's there to create consistency no matter what database you will choose in future.
However, if you do want to try managedDB, you need to make changes as mentioned by @Binyamin
However do you want to share about what you are trying to do with your managed DB and then maybe we could try doing it other ways ?
I'm Currently using Appwrite with K8S and Its good.
I don't want to manage database on Local server. Because I need to Take care of Redundancy & HA & Backups etc,.
If I use managed DB I dont need to Care about any of those
That sounds logical
any chance you'll be sharing insights on this? 😁
Can you explain what you mean Mr. Steven?
like how you set up Appwrite on K8s. Are you using Appwrite Functions too?
Recommended threads
- Query Appwrite
Hello, I have a question regarding Queries in Appwrite. If I have a string "YYYY-MM", how can I query the $createdAt column to match this filter?
- Different appwrite IDs are getting expos...
File_URL_FORMAT= https://cloud.appwrite.io/v1/storage/buckets/[BUCKET_ID]/files/[FILE_ID]/preview?project=[PROJECT_ID] I'm trying to access files in my web app...
- Invalid document structure: missing requ...
I just pick up my code that's working a week ago, and now I got this error: ``` code: 400, type: 'document_invalid_structure', response: { message: 'Inv...