I researched that over 80% of migration problems can be solved with Apache
SeaTunnel (https://seatunnel.apache.org/) itself, as a sister project. We
could build around it for more Fineract-specific needs.

On Thu, Nov 12, 2026 at 11:34 AM Aman Mittal <[email protected]>
wrote:

> Also looking for Apache SeaTunnel if it can replace the need.
>
> On Thu, Nov 12, 2026 at 10:27 AM Aman Mittal <[email protected]>
> wrote:
>
>> 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