dhis2-users team mailing list archive

[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 <https://www.dhis2.org>