Thanks Jose, This is the kind of information i was talking about. Someone who has used it in production and has first hand experience
Given your word, let me try TiDB one of these days and i will share to the community. I will not put it up for live production but for trainings and tests 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:13 PM 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 >
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
