Hi Steve, Yes, multithreaded replication is a good enough reason to move to 5.7.
The issues I had faced are following :- - As you had pointed out, some migration scripts like "ALTER TABLE `m_appuser` ADD `last_time_password_updated` DATE NOT NULL ,ADD INDEX ( `last_time_password_updated` ) ;" had failed. It tries to insert '0000-00-00' as default for some reason. Adding a reasonable default value fixes this and corresponding scripts where failure gets cascaded gets fixed as well. - Some native queries (I don't remember which) complained about the ONLY FULL GROUP BY mode which can be fixed by adding the group by clauses to select. Takes a bit of time to go through all the occurrences of group by in codebase to cross check. - Not sure of current 5.7.x version but at that time, it had a non-configurable default of max join limit of 55 and the loan entity had become a bit unwieldy in my fork and simply making a lot of related entities as lazy fetched had further regression and it took me a while to stabilize this. Regards, Avik. On Wed, Jan 17, 2018 at 11:28 PM, Ed Cable <[email protected]> wrote: > Graham, > > I'm including your email to the fineract dev list as well. Can you please > subscribe to that mailing list by simply sending a blank email to > [email protected]? > > Thanks, > > Ed > > Please see Graham's response below > ------------------ > > On Wed, Jan 17, 2018 at 9:27 AM, Ebenezer Graham <[email protected] > > > wrote: > > > I am Graham and I up vote this suggestion. I would like to help migrate > > platform to MySQL 5.7. My team used 5.7 when we were setting up the > > platform for our company and the main issue was with the values in the > > SQL_mode system variable. > > > > The ONLY_FULL_GROUP_BY value prevented some values from being displayed > on > > the web platform > > > > On Jan 17, 2018 5:11 PM, "Ed Cable" <[email protected]> wrote: > > > >> +1 from my side as well. > >> > >> Avik (or others) who might have already completed the upgrade on their > >> own builds of Fineract, could you shine light on any issues you > experienced > >> during the upgrade and anything additional beyond what Steven has > already > >> done you had to do for the upgrade? > >> > >> Ed > >> > >> On Wed, Jan 17, 2018 at 9:04 AM, Myrle Krantz <[email protected]> wrote: > >> > >>> I would be a +1 on this suggestion, but maybe on a branch to be > >>> integrated > >>> after the upcoming release so that it can get a full cycle of testing > >>> before it’s released. What do others think? > >>> > >>> Best Regards, > >>> Myrle > >>> > >>> On Wed 17. Jan 2018 at 15:48 Steve Conrad <[email protected]> wrote: > >>> > >>> > To the Mifos and Fineract dev communities - > >>> > > >>> > My name is Steve Conrad, and I have recently begun volunteering with > >>> the > >>> > Mifos/Fineract community and really appreciate the great work that > you > >>> all > >>> > are doing. > >>> > > >>> > I wanted to propose a new project to migrate the Fineract platform to > >>> MySQL > >>> > 5.7. There are several features in MySQL 5.7 that would benefit the > >>> project > >>> > - performance, embedded JSON objects in the schema, multithreaded > >>> > replication, among others. > >>> > > >>> > When I installed Fineract locally, I used MySQL 5.7. I had to change > a > >>> few > >>> > of the database migration scripts. I have obviously not gone through > >>> all of > >>> > the use cases, but so far am running with no issues. > >>> > > >>> > Does anyone know of any reasons why we could not move to MySQL 5.7? > >>> > Obviously there would be a large testing task, but it may be a > >>> worthwhile > >>> > investment to keep the Fineract platform current. > >>> > > >>> > Thanks, > >>> > Steve > >>> > > >>> > >> > >> > >> > >> -- > >> *Ed Cable* > >> President/CEO, Mifos Initiative > >> [email protected] | Skype: edcable | Mobile: +1.484.477.8649 > >> <(484)%20477-8649> > >> > >> *Collectively Creating a World of 3 Billion Maries | *http://mifos.org > >> <http://facebook.com/mifos> <http://www.twitter.com/mifos> > >> > >> > >> ------------------------------------------------------------ > >> ------------------ > >> Check out the vibrant tech community on one of the world's most > >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot > >> Mifos-developer mailing list > >> [email protected] > >> Unsubscribe or change settings at: > >> https://lists.sourceforge.net/lists/listinfo/mifos-developer > >> > > > > ------------------------------------------------------------ > > ------------------ > > Check out the vibrant tech community on one of the world's most > > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > > Mifos-developer mailing list > > [email protected] > > Unsubscribe or change settings at: > > https://lists.sourceforge.net/lists/listinfo/mifos-developer > > > > > > -- > *Ed Cable* > President/CEO, Mifos Initiative > [email protected] | 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> >
