Hello Ed,
No i did not yet try that. I will give it a try and let you know the
outcome.
Thanks and regards, Frans
On 18-2-2021 09:03, Ed Cable wrote:
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
<mailto: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
<mailto: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 <mailto: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
<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
<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/
<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 <mailto: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
<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 <mailto: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
<mailto:Mifos-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/mifos-users
<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
<mailto:mifos-develo...@lists.sourceforge.net>
Unsubscribe or change settings at:
https://lists.sourceforge.net/lists/listinfo/mifos-developer
<https://lists.sourceforge.net/lists/listinfo/mifos-developer>
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
<mailto:Mifos-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/mifos-users
<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
<mailto:Mifos-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/mifos-users
<https://lists.sourceforge.net/lists/listinfo/mifos-users>
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
<mailto:Mifos-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/mifos-users
<https://lists.sourceforge.net/lists/listinfo/mifos-users>
--
*Ed Cable*
President/CEO, Mifos Initiative
edca...@mifos.org <mailto:edca...@mifos.org> | Skype: edcable |
Mobile: +1.484.477.8649
*Collectively Creating a World of 3 Billion Maries | *http://mifos.org
<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
Met vriendelijke groet,
Frans Jacobs
------------------------------------------------------------------
- 0485 - 800469
- 06 - 11195653
------------------------------------------------------------------
_______________________________________________
Mifos-users mailing list
Mifos-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/mifos-users
