Dear All,

IMHO, i would not encourage anyone to use a database other than what has
been recommended on the forums for a number of reasons

   1.  Being able to restore from a mySQL database dump into TiDB is not
   the only reason you should rely on
   2. Throughout the source code, there are table-joins, mySQL
   keywords used and a combination of sql scripts that could result into errors

A simple example is
https://stackoverflow.com/questions/26246413/how-many-max-join-table-at-mysql-and-how-to-count-it#:~:text=MySQL%20has%20a%20limit%20of%2061%20tables%20in%20a%20join.
Where it is mentioned that MySQL has a limit of 61 tables that can be
called in a join sql Script
Another example is MySQL 5.7 came with a new condition only_full_group_by
which installs as a default.   read this ===>
https://issues.apache.org/jira/browse/FINERACT-1054

 In My view,  unless a good number of users have used that particular
database engine, i would encourage all of us to stick to the tested
database engines (tested in real life Production)


My Kind Regards

Francis Guchie Kirago
*Skype:* francisguchie
*Telegram: *232 79 19 44 07
*Whatsapp: *232 79 19 44 07
*LINKEDIN:* https://www.linkedin.com/in/francis-guchie-kirago-a4379617/
twitter: @FrancisGuchie









On Wed, Feb 17, 2021 at 7:24 AM Frans Jacobs <fr...@worldtracks.com> wrote:

> Thanks you for the quick response Alberto. I am going to study this.
>
> You mentioned dump from version 5.7.. but I need to dump from version 5.6.
> Do yo happen to know if that is possible as well?
>
> regards, Frans
>
>
> On 17-2-2021 01:10, Jose Alberto Hernandez Maldonado wrote:
>
> Hello All!
>
> One option without too much effort is to use TiDB (Titan Database
> https://docs.pingcap.com/tidb/stable). It is NewSQL database, high
> performance and can be used with containers.
>
> The advantage on this, the TiDB connector is based in MySQL and you can
> create a MySQL dump from version 5.7 and restore it in TiDB without
> problem.
>
> Talking about Finercat code, as we said the TiDB connector is based in
> MySQL, so no code changes need it.
>
> Thanks and best regards
> Alberto
>
> El 16/02/2021 3:49 PM Frans Jacobs <fr...@worldtracks.com> escribió:
>
>
> Hello all,
>
> I recently received a message from AWS that they will force me ( and
> everybody else running mifos on AWS ) to upgrade the MySQL to version
> 5.7 or 8 before august 2021.
>
> Did anyone else receive this message from AWS?
>
> I think this will affect many other users of Mifos on AWS as well so it
> will have to be fixed.
>
> Any help or advice on how to approach this is much appreciated..
>
> Regards, Frans ( running mifos v. 18.03 )
>
>
>
>
> _______________________________________________
> Mifos-users mailing list
> Mifos-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/mifos-users
>
> Met vriendelijke groet,
> Frans Jacobs
>
> ------------------------------------------------------------------
> - 0485 - 800469
> - 06 - 11195653
> ------------------------------------------------------------------
>
> Mifos-developer mailing list
> mifos-develo...@lists.sourceforge.net
> Unsubscribe or change settings at:
> https://lists.sourceforge.net/lists/listinfo/mifos-developer
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users

Reply via email to