I agree with Francis on this, Using a tested database engine will save us for tomorrow since there may not be a need to fix errors resulting from the database engine. We have found issues of different errors with different users as a result of database misconfiguration so, switching to a different database engine may limit your support in case of any issues.
Regards Ibrahim On Wed, Feb 17, 2021 at 4:40 PM Francis Guchie <francisguc...@gmail.com> wrote: > 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 > -- *Ibrahim Kimbugwe* *Product Manager* Guchietech International Ug Office: *+*256 700252896 Mobile: +256 772842076 website: www.guchietech.com <http://www.btechforex.com>
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
