Regarding Jira Cloud MySQL access

[Bernardo Leigh]

Currently we have jira configured into a linux box and connected to a mysql server.  We mainly use jira through the front end, but occasionally access the mysql DB directly.  If we transition to JIRA Cloud will we still have access to query the DB via mysql command line tool?

[Nic Brough -Adaptavist- · Accepted solution]

No, you will not have any database access.

(Even if you did, mysql wouldn't work - it's not running on MySQL)

[Robert Massaioli _Atlassian_]

Correct: Atlassian Cloud uses PostgreSQL.

[Bernardo Leigh]

Thank you. I had just found an article on the pros and cons, and found the answer.  I guess moving to the cloud we would have to rely on finding the proper add-on to accomplish some of the tasks that we have configured through bash scripts, etc...

[Nic Brough -Adaptavist-]

You'd have to run them remotely, you don't get any access to the servers at all.  Add-ons are your best bet, as they run within the applications.  You can write your own as well, for Cloud - it might be neater for you than finding another server and extracting information to be reprocessed.  Both your external stuff and "Connect" add-ons would be relying on the REST interface to read (and write!) the JIRA data.

[Robert Massaioli _Atlassian_]

Or you could write your own add-ons: http://connect.atlassian.com/

It's pretty easy to do and we have an active community to help you write add-ons.