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" <[email protected]> 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. < > [email protected]> wrote: > >> Thanks Iuri and Lars! This is very helpful. >> >> -----Original Message----- >> From: Iuri Fanti [mailto:[email protected]] >> Sent: Wednesday, December 02, 2015 12:24 PM >> To: Lars Helge Øverland >> Cc: Smith, Rebecca A.; [email protected] >> 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 <[email protected]>: >> > 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. >> > <[email protected]> >> > 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: [email protected] >> >> >> >> >> >> >> >> >> >> _______________________________________________ >> >> Mailing list: https://launchpad.net/~dhis2-users >> >> Post to : [email protected] >> >> 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 : [email protected] >> > 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 : [email protected] >> Unsubscribe : https://launchpad.net/~dhis2-users >> More help : https://help.launchpad.net/ListHelp >> > > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-users > Post to : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > >
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
