Very Slow Fresh Bahmni Install with GCP Cloud SQL

Software Bahmni
,
1

I’m installing a fresh Bahmni Docker (standard-config) setup but using a GCP MySQL instance instead of using default bahmni openmrsdb image. I’m not restoring a backup — just doing the default fresh initialization. The problem is: The installation has been running for 28+ hours and is still initializing the Bahmni/OpenMRS metadata. Has anyone faced this with Cloud SQL? Any ways to speed this up?Looking for advice on:

  1. Recommended DB settings or flags

  2. Whether it’s better to initialize locally, dump, and then restore into Cloud SQL

  3. Any known optimizations for Bahmni Docker when using a remote DB

Thanks for any pointers! @mohant

2

I am guessing you would have started from absolute empty db, so the entire CIEL concepts are being loaded from scratch. We typically advice to keep a snapshot and start from point. But it shouldn’t take 28 hours!! Have you checked whether the db is actually being loaded, and not stuck somewhere in limbo?

3

Thank for your reply.

I tried testing with 4 core CPU and 16 gb ram.

It got initialized but took around 3 hours. Agree with using snapshot of the db.