MySQL 5.7 or MariDB 10.6 or MySQL 8

[Carlos Fau <ca...@altscore.ai>]

Hello,

My name is Charly Fau, I'm joining the community because we are using
Fineract as our banking core.

I was struggling on running the server from scratch, mainly related to the
correct (or preferred) version of the database to use.

We are deploying inside the GCE, so we want to use the managed SQL service
provided by the platform. Due to that, we have the options of MySQL 5.7 or
MySQL 8.0.

What SQL do you recommend to use?
Which version is not recommend to use? (and should not used)

Charly

Re: MySQL 5.7 or MariDB 10.6 or MySQL 8

[Aleksandar Vidakovic <ch...@monkeysintown.com>]

... when you do local development (aka "./gradlew bootRun") then MariaDB
10.8 is nice to work with (have MariaDB running with a little
docker-compose.yml file).

On Mon, Dec 5, 2022 at 4:39 PM Kigred Developer <ki...@gmail.com>
wrote:

> It depends on the version of Fineract you are using.
> Versions <= 1.5 require MySql 5.7
> Versions >= 1.6 require MySql 8 or MariaDB 10.6+
>
> On Mon, 5 Dec 2022, 18:02 Carlos Fau, <ca...@altscore.ai> wrote:
>
>> Hello,
>>
>> My name is Charly Fau, I'm joining the community because we are using
>> Fineract as our banking core.
>>
>> I was struggling on running the server from scratch, mainly related to
>> the correct (or preferred) version of the database to use.
>>
>> We are deploying inside the GCE, so we want to use the managed SQL
>> service provided by the platform. Due to that, we have the options of MySQL
>> 5.7 or MySQL 8.0.
>>
>> What SQL do you recommend to use?
>> Which version is not recommend to use? (and should not used)
>>
>> Charly
>>
>>

Re: MySQL 5.7 or MariDB 10.6 or MySQL 8

[Kigred Developer <ki...@gmail.com>]

It depends on the version of Fineract you are using.
Versions <= 1.5 require MySql 5.7
Versions >= 1.6 require MySql 8 or MariaDB 10.6+

On Mon, 5 Dec 2022, 18:02 Carlos Fau, <ca...@altscore.ai> wrote:

> Hello,
>
> My name is Charly Fau, I'm joining the community because we are using
> Fineract as our banking core.
>
> I was struggling on running the server from scratch, mainly related to the
> correct (or preferred) version of the database to use.
>
> We are deploying inside the GCE, so we want to use the managed SQL service
> provided by the platform. Due to that, we have the options of MySQL 5.7 or
> MySQL 8.0.
>
> What SQL do you recommend to use?
> Which version is not recommend to use? (and should not used)
>
> Charly
>
>

Re: MySQL 5.7 or MariDB 10.6 or MySQL 8

[James Dailey <ja...@gmail.com>]

Carlos -  could you let us know how it’s going? Still deploying?

We are trying to encourage everyone to be on a more recent release.

Any feedback and suggestions are welcome.  Would be ideal to get content or
write ups to help explain the process.

Thanks


On Mon, Dec 5, 2022 at 8:01 PM VICTOR MANUEL ROMERO RODRIGUEZ <
victor.romero@fintecheando.mx> wrote:

> By the way this PR also added Cloud SQL support and it was merged :)
>
> https://github.com/apache/fineract/pull/1373
>
>
>
> El lun, 5 dic 2022 a las 16:40, VICTOR MANUEL ROMERO RODRIGUEZ (<
> victor.romero@fintecheando.mx>) escribió:
>
>> Hello Carlos,
>>
>> MySQL 8.0, by the way you can check this PR
>> https://github.com/apache/fineract/pull/1373 (now obsolete) but we have
>> Fineract up and running in a fully managed GCP environment.
>>
>> Regards
>>
>> Victor
>>
>> El lun, 5 dic 2022 a las 9:02, Carlos Fau (<ca...@altscore.ai>)
>> escribió:
>>
>>> Hello,
>>>
>>> My name is Charly Fau, I'm joining the community because we are using
>>> Fineract as our banking core.
>>>
>>> I was struggling on running the server from scratch, mainly related to
>>> the correct (or preferred) version of the database to use.
>>>
>>> We are deploying inside the GCE, so we want to use the managed SQL
>>> service provided by the platform. Due to that, we have the options of MySQL
>>> 5.7 or MySQL 8.0.
>>>
>>> What SQL do you recommend to use?
>>> Which version is not recommend to use? (and should not used)
>>>
>>> Charly
>>>
>>> --
Sent from Gmail Mobile

Re: MySQL 5.7 or MariDB 10.6 or MySQL 8

[VICTOR MANUEL ROMERO RODRIGUEZ <vi...@fintecheando.mx>]

By the way this PR also added Cloud SQL support and it was merged :)

https://github.com/apache/fineract/pull/1373



El lun, 5 dic 2022 a las 16:40, VICTOR MANUEL ROMERO RODRIGUEZ (<
victor.romero@fintecheando.mx>) escribió:

> Hello Carlos,
>
> MySQL 8.0, by the way you can check this PR
> https://github.com/apache/fineract/pull/1373 (now obsolete) but we have
> Fineract up and running in a fully managed GCP environment.
>
> Regards
>
> Victor
>
> El lun, 5 dic 2022 a las 9:02, Carlos Fau (<ca...@altscore.ai>)
> escribió:
>
>> Hello,
>>
>> My name is Charly Fau, I'm joining the community because we are using
>> Fineract as our banking core.
>>
>> I was struggling on running the server from scratch, mainly related to
>> the correct (or preferred) version of the database to use.
>>
>> We are deploying inside the GCE, so we want to use the managed SQL
>> service provided by the platform. Due to that, we have the options of MySQL
>> 5.7 or MySQL 8.0.
>>
>> What SQL do you recommend to use?
>> Which version is not recommend to use? (and should not used)
>>
>> Charly
>>
>>

Re: MySQL 5.7 or MariDB 10.6 or MySQL 8

[VICTOR MANUEL ROMERO RODRIGUEZ <vi...@fintecheando.mx>]

Hello Carlos,

MySQL 8.0, by the way you can check this PR
https://github.com/apache/fineract/pull/1373 (now obsolete) but we have
Fineract up and running in a fully managed GCP environment.

Regards

Victor

El lun, 5 dic 2022 a las 9:02, Carlos Fau (<ca...@altscore.ai>)
escribió:

> Hello,
>
> My name is Charly Fau, I'm joining the community because we are using
> Fineract as our banking core.
>
> I was struggling on running the server from scratch, mainly related to the
> correct (or preferred) version of the database to use.
>
> We are deploying inside the GCE, so we want to use the managed SQL service
> provided by the platform. Due to that, we have the options of MySQL 5.7 or
> MySQL 8.0.
>
> What SQL do you recommend to use?
> Which version is not recommend to use? (and should not used)
>
> Charly
>
>