On Wed, Aug 10, 2011 at 8:20 AM, Saptarshi Purkayastha <[email protected]>wrote:
> I was looking through this discussion and wanted to know how much of a > priority is it for the community to run OpenMRS on Postgres or MSSQL?? Other > than once-in-a-while mails on the dev list?? Is it our core motivation to > have users choose what database they want OpenMRS to work on?? > It is some amount of work (upgrading liquibase is definitely required, > adding database drivers and changing mysql-specific - tinyint to smallint, > longtext etc.). > Ideally, OpenMRS should run with the major databases (e.g., MySQL, Postgres, MSSQL, Oracle). This is both to provide flexibility for implementations and to avoid overly-committing OpenMRS to MySQL's future. > Also among other things, I've yesterday had problems with simultaneous > users (75+) using the system (16GB+ server) and getting out of memory and > having to restart the system every 12-14hrs to release memory. The memory > usage goes on increasing for Tomcat and restarting the server seems like the > simple solution for the time being. I've heard Paul talk about a similar > problem at AMPATH in one of the conf call recordings. Has there been a > workaround at AMPATH or is restarting Tomcat the accepted solution?? I'm > planning to host OpenMRS on Glassfish (with its better monitoring tools and > VisualVM integration) and also write a performance monitoring module that > uses javamelody <http://code.google.com/p/javamelody/>, but any > suggestions in the meantime should be useful... > This might be better asked on the implementers list. Hopefully any lessons can be added here <https://wiki.openmrs.org/x/gxAz>. Cheers, -Burke > --- > Regards, > Saptarshi PURKAYASTHA > > My Tech Blog: http://sunnytalkstech.blogspot.com > You Live by CHOICE, Not by CHANCE > > > > On 27 July 2011 18:18, Ben Wolfe <[email protected]> wrote: > >> I think this was the ticket I was thinking of: >> https://tickets.openmrs.org/browse/TRUNK-1925 >> >> That ticket should be edited to be more general about supporting all >> databases. The removal of the "not exists" from the wizard is just one part >> of that. >> >> The openmrs app does run on everything. And I'm pretty sure the update >> wizard / liquibase changesets run on everything. So a quick fix would be to >> install to mysql, then export the database tables and import those into >> postgresql. >> >> Ben >> >> On Wed, Jul 27, 2011 at 1:44 PM, Suranga Kasthurirathne < >> [email protected]> wrote: >> >>> >>> Hi, >>> >>> >>> Looks like you could do with an Openmrs Id, >>> >>> go to https://wiki.openmrs.org/display/RES/OpenMRS+ID, and create your >>> id, this will let you interact (and yes, create tickets) easily. >>> once you create an id, you can use it to log in, and use JIRA. >>> >>> after signing in, go to >>> https://tickets.openmrs.org/secure/Dashboard.jspa and click on 'create >>> issue' (on the top right of screen). >>> >>> Hope this helps. >>> >>> >>> >>> >>> On Wed, Jul 27, 2011 at 4:04 PM, Sokha RUM <[email protected]> wrote: >>> >>>> I look for the existing ticket, and i found a ticket TRUNK-1922 which is >>>> about the supporting 6 types of database including also PostgreSQL. But >>>> that >>>> ticket is already in status "Fixed". >>>> >>>> One more thing i wanted to create a new ticket, but could not login. I >>>> do >>>> not know if i can use the account for joining community to access to >>>> ticket >>>> of OpenMRS. >>>> >>>> _________________________________________ >>>> >>>> To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to >>>> [email protected] with "SIGNOFF openmrs-devel-l" in the body >>>> (not the subject) of your e-mail. >>>> >>>> [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l] >>>> >>> >>> >>> >>> -- >>> Best Regards, >>> >>> Suranga >>> >>> ------------------------------ >>> Click here to >>> unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from >>> OpenMRS Developers' mailing list >> >> >> > ------------------------------ > Click here to > unsubscribe<[email protected]?body=SIGNOFF%20openmrs-devel-l>from > OpenMRS Developers' mailing list > _________________________________________ To unsubscribe from OpenMRS Developers' mailing list, send an e-mail to [email protected] with "SIGNOFF openmrs-devel-l" in the body (not the subject) of your e-mail. [mailto:[email protected]?body=SIGNOFF%20openmrs-devel-l]
