Back
Is there any reason you cant use a managed MySQL DB with Appwrite?
So quick context I would like to host a selfhosted Appwrite instance and I personally prefer to use managed DBs when able and really like to keep my DBs on dedicated boxes away from my apps/workers. I mainly operate stuff in GCP and a bit in Digital Ocean, neither have a managed DB for MariaDB but do have managed DBs for MySQL. I also know that MariaDB is supposed to be compatible with MySQL but I have never used MariaDB yet myself so I do not know much about it compared to MySQL or Postgres.
So with that my main question are:
- Looking through
registers.phpit looks like there is support to use a MySQL adapter but currently the configs are hardcoded to always use the MariaDB one. Since Appwrite uses Utopia is there any technical reason we can not select the MySQL adapter or is this mainly because the Appwrite team is only testing against MariaDB atm and can not guarantee the stability of using MySQL? - Are there any services that offer managed MariaDBs that anyone would suggest I look into?
TL;DR
Developers are inquiring about using a managed MySQL DB with Appwrite instead of the default MariaDB. They are wondering if the current limitation in Appwrite that only supports MariaDB is due to technical reasons or testing constraints. They are also seeking recommendations for services offering managed MariaDB.