Is it possible to start the Strapi API on a read-only DB? It appears that when starting Strapi API, it attempts to update strapi_core_store_settings table and since the DB is read-only, the startup fails.
Here is our scenario:
We have a primary Maria DB that our Strapi admin panel connects to for content editing. This primary Maria DB has a secondary DB as a read-only replica located in another region. This secondary DB is to help with performance since the front-end site is also in that same region (and meet redundancy requirements).
We are trying to start up the Strapi API and connect to the secondary DB read-only replica but are not sure how to do this. Are we missing a certain configuration setting? We have serveAdminPanel set to false on the secondary Strapi API server (thinking this might solve this, but didn’t).
If possible this allows our front-end site (also located in that secondary region) to hit its Strapi API which would connect to its read-only DB (where that DB gets near real-time updates via DB replication from the primary DB). Our front-end site requests are all read requests (no other creates, updates, or deletes).
We researched all the documentation but no luck. Any advice is much appreciated.
Thanks in advance.