Hi All, We have long voted on and accepted FSIP-9. Since the community suggested and the majority agreed, provided that "Proper migration steps were considered for Postgres," I want to revive discussions on the next steps.
https://cwiki.apache.org/confluence/spaces/FINERACT/pages/406622736/FSIP-9+Standardize+on+PostgreSQL I think we can brainstorm ideas for the migration steps. One of the suggestion it received was that we can use pgloader. However, many companies or vendors are concerned that their data volume may be large based on their organizational size. I suggest we create a dedicated plugin or perhaps a shared plugin that exists outside of Fineract Core. What the plugin will do: (It will parallelly sync and monitor the migration in real time 1:1 with MariaDB or MySQL). Then the vendors can implement and sync to PostgreSQL via CDC or other available methods. When the data keeps syncing to PostgreSQL. Vendors can validate and test schema changes live without incurring downtime. HARD Requirement: Plugin dependency should be ASF compliant (Category A dependencies) I think this idea is worth exploring. Regards Aman
