dhis2-users team mailing list archive

[Knut Staring <knutst@xxxxxxxxx>]

Agree with the earlier responses, but we really should still try to stamp
out the mysql bugs, since many organizations have large investments around
that platform (and I think we are pretty close). However, users will have
to do more tests themselves before upgrades.

Knut
On 5 Dec 2015 5:49 pm, "Hannan Khan" <hannank@xxxxxxxxx> wrote:

> Hi Rebecca
>
> Theoretically you can use MySQL and the hibernate.properties is as follows:
>
>
> hibernate.dialect = org.hibernate.dialect.MySQLDialect
> hibernate.connection.driver_class = com.mysql.jdbc.Driver
> hibernate.connection.url = jdbc:mysql://localhost/dhis2
> hibernate.connection.username = xxxx
> hibernate.connection.password = xxxx
>
> But I suggest to use Postgres other wise you get plenty of bugs. We use
> MySQL since 2011 and then we converted all our databases to postgres for
> various reasons.
>
> Regards
>
> Hannan Khan
> HISP Bangladesh
>
>
> On Thu, Dec 3, 2015 at 1:08 AM, Smith, Rebecca A. <
> rs3524@xxxxxxxxxxxxxxxxx> wrote:
>
>> Thanks Iuri and Lars! This is very helpful.
>>
>> -----Original Message-----
>> From: Iuri Fanti [mailto:iuri.fanti@xxxxxxxxx]
>> Sent: Wednesday, December 02, 2015 12:24 PM
>> To: Lars Helge Øverland
>> Cc: Smith, Rebecca A.; dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Subject: Re: [Dhis2-users] MySQL for DHIS
>>
>> Hi,
>>
>> we tried to use MySQL, but it didn't work when we had to use OptionsSet
>> values in DataElements for single events without registration. The
>> OptionSet resulted empty, evidently because of some problem fetching data
>> from MySQL.
>>
>> Iuri
>>
>> 2015-12-02 17:14 GMT+01:00 Lars Helge Øverland <larshelge@xxxxxxxxx>:
>> > Hi Rebecca,
>> >
>> > in order to use MySQL there is nothing else you need to do (beyond
>> > changing the database connection config properties like you say).
>> >
>> > Now MySQL is far less tested with DHIS 2 compared to Postgres so you
>> > are more likely to come across bugs and upgrade issues on MySQL.
>> >
>> > There is also a fair chance that we will create Postgres-only features
>> > at some point in the future (as an example, using features from the
>> > PostGIS spatial data extension).
>> >
>> > So MySQL works, but Postgres would be preferred.
>> >
>> >
>> > best regards,
>> >
>> > Lars
>> >
>> >
>> >
>> > On Wed, Dec 2, 2015 at 4:29 PM, Smith, Rebecca A.
>> > <rs3524@xxxxxxxxxxxxxxxxx>
>> > wrote:
>> >>
>> >> Hi all,
>> >>
>> >>
>> >>
>> >> We have a partner who would strongly prefer to use MySQL instead of
>> >> Postgres as the DHIS 2.21 database. The DHIS documentation notes that
>> >> MySQL can be used but doesn’t give much detail beyond the connection
>> strings.
>> >>
>> >>
>> >>
>> >> Does anyone in this group have experience with using MySQL for DHIS?
>> >> Has it been reliable? Do you have to do any manual configuration that
>> >> you wouldn’t do with Postgres?
>> >>
>> >>
>> >>
>> >> Thanks,
>> >>
>> >> Becky
>> >>
>> >>
>> >>
>> >>
>> >>
>> >> Becky Smith
>> >>
>> >> Development-Operations Specialist
>> >>
>> >> ICAP at Columbia University
>> >>
>> >> Tel: 212.304.7115
>> >>
>> >> Email: rs3524@xxxxxxxxxxxxxxxxx
>> >>
>> >>
>> >>
>> >>
>> >> _______________________________________________
>> >> Mailing list: https://launchpad.net/~dhis2-users
>> >> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> >> Unsubscribe : https://launchpad.net/~dhis2-users
>> >> More help   : https://help.launchpad.net/ListHelp
>> >>
>> >
>> >
>> >
>> > --
>> > Lars Helge Øverland
>> > Lead developer, DHIS 2
>> > University of Oslo
>> > Skype: larshelgeoverland
>> > http://www.dhis2.org
>> >
>> >
>> > _______________________________________________
>> > Mailing list: https://launchpad.net/~dhis2-users
>> > Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> > Unsubscribe : https://launchpad.net/~dhis2-users
>> > More help   : https://help.launchpad.net/ListHelp
>> >
>>
>>
>>
>> --
>> "The best argument against democracy is a five-minute conversation with
>> the average voter." - Winston Churchill
>> @-`-,--
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>