Is the Database for JIRA Software and JIRA Service Desk the same?

Tayyab Bashir Community Champion Aug 04, 2017

Hi, 

I have JIRA Software (server) installed and its connect with a mysql database "jiradb".

Now I am adding JIRA Service Desk (JSD) on top of JIRA Software, so my question are:
* How is Service Desk handled in the database? 
* Would the tables for JSD be added in the same database "jiradb"? 
* Where is all the data for Service Desk (tickets, and stuff) stored in the database? Does it use the same table to store tickets as Jira Software's tables? 


I just need clarification on how data would be managed in the database for Service Desk with respect to the exisiting database? 

 

1 answer

1 accepted

2 votes
Steven Behnke Community Champion Aug 04, 2017

JIRA Service Desk and JIRA Software are simply the JIRA application with a series of plugins installed.

The plugins use the plugin data store mostly, so they will create additional tables in the typical jira database.

Issues are issues are issues so field data is where it always is.

Tayyab Bashir Community Champion Aug 04, 2017

 

The plugins use the plugin data store mostly, so they will create additional tables in the typical jira database.

Are you talking about the plugins that are installed when Service Desk is installed? 

So all the data of SD will eventually be getting stored in the same database "jiradb" that Software has been using? 

To be pedantic, no.

The data of Service Desk, Software and all your add-ons are kept in the JIRA Core database.  Most Applications and add-ons create tables in there for themselves, as well as storing some data in the Core tables.

Steven Behnke Community Champion Aug 04, 2017

@Tayyab Bashir can you tell us what you're trying to achieve or audit here?

Hi @Steven Behnke

I added JIRA Service Desk on top of JIRA Server recently, and for that purpose I was looking into if the database of both applications would be the same or not. 
And as Nic said, they're both handled in JIRA core's database, so I guess the short answer would be Yes they're the same

What I am trying to achieve or audit.

I want to see if I could take Service Desk's XML data backup separately from JIRA Software's data. 
So in order to take SD's XML backups separately, I figured it would need a separate database? 


But I guess the projects and issues we create are kept in the same tables so it would be difficult to take their backup separately. 

Steven Behnke Community Champion Aug 07, 2017

I'll try to be specific for what its worth.

Service Desk uses "Issues" for it's "Requests". So actual issues, custom field values, attachments, comments, etc are all in the usual places.

Service Desk uses Active Objects (like any other plugin) for configuration settings. This means that "global settings" like the Email Configuration toggle and "project settings" like Request Types configs and Queues configs are all stored in other various tables within jiradb.

Backing up the database, attachments, indexes, plugins, and configurations will entirely back up both JIRA and JIRA Service Desk.

By the way, "Project Import" will not import plugin settings. Active Objects (the plugin datastore) can only be restored via a Full Restore.

That's a very peculiar thing to want to do.  Sounds like a totally broken or insane requirement to me, as the Service Desk data is totally dependent on JIRA Core data.

Think of it this way - if you exported just SD data, you would get items like

  • exceeded SLA
  • a list of request types
  • some portal definitions

But without the project, issue and user data that JIRA holds, it's utterly useless.  Same goes for Software - you'd get a load of useless board data that points at issues, projects and users you don't know anything about.

Tayyab Bashir Community Champion Aug 07, 2017

Thankyou both for your answers. 
Makes quite a lot of sense now and gives the clarification I needed. 


Thanks,
Tayyab

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Mar 09, 2018 in Jira Service Desk

E.L. Fridge's take on education, Jira Service Desk, and creative Jira use cases

...word of mouth, so by 2016, we were working with several other entities on campus to implement Jira Service Desk . The Atlassian motto of “for every team” has really come true for us in this case. We...

970 views 2 14
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you