JIRA Embedded (Evaluation) Database

Dustin Wright

Hello all!  Please bear with me as I'm very new to JIRA.  While in school to become a programmer, my mentor suggested I apply what I'm learning in a project this summer.  He also suggested making this as close to real-world work experience as we can by adding JIRA to our project.  My questions:

Research indicates I can run the JIRA server on my own Linux box for $10 a year.  For our single project, can the embedded database be used?   Only two users and this one project will be tracked in it.  I'd think this would qualify as "evaluation" would you agree?

I'm not opposed to adding MySQL to the Linux box.  I'm sure this is all good stuff I'll need to know on the job.  If the embedded database is sufficient, that's much simpler.  Please advise.

Thank you for helping me understand what I need to do to get this going.

Earl McCutcheon

Hi Dustin,

You can defiantly use the embedded database if you're just playing around with the setup to try things out BUT if you are planning on keeping anything persistent, I would recommend using MySQL as you noted or another DB from the supported platform list. 

The embedded H2 DB is an in memory database, so the main thing to consider is that the data can be lost or irrecoverably corrupted if you encounter an error or shut down abruptly, and as the database is stored in memory it is using more memory to store that data which in effect gives you a higher potential for a memory related error, which is why the database type is not supported for anything other than evaluations, so you should only use this for an evaluation where the data is not critical, or needed to be maintained in any way.

Regards,
Earl