Hello Frans, Have you simply tried to update your Fineract version to the latest stable 1.4 release? As of the Fineract 1.2 release, there's full support for MySQL 2.7. You could also then upgrade your community-app instance separately to the latest upstream version.
If you can't do that on your own, we can assist in providing a war file that you could deploy. The Mifos X release you are on currently is built on an earlier version of Fineract; the latest Mifos X release coming out will be built on the forthcoming Fineract 1.5 release. Ed On Wed, Feb 17, 2021 at 11:12 AM Jose Alberto Hernandez Maldonado < jose.hernan...@fintecheando.mx> wrote: > Hello guys! > > We understand the fear for this kind of changes, but we've used this > database in production environment for a couple of entities in LA, with the > two Fineract versions, Mifos X and CN > > The second reason of this suggestion is related to the performance that > TiDB can to have (even in a cluster) better than MySQL > > Thanks and best regards > Alberto > > El 17/02/2021 12:45 PM kimbugwe ibrahim <kimbra.ibra...@gmail.com> > escribió: > > > 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 > > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users > -- *Ed Cable* President/CEO, Mifos Initiative edca...@mifos.org | Skype: edcable | Mobile: +1.484.477.8649 *Collectively Creating a World of 3 Billion Maries | *http://mifos.org <http://facebook.com/mifos> <http://www.twitter.com/mifos>
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
