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

Reply via email to