Is there any way to make JIRA read-only from database(mysql) end.
Know how to do it by changing permission scheme from JIRA administration. But, looking for a way to achieve this through database side.
Not really. The way you'd do it is actually to just take the changes you've made in the UI, work out how they are held in the database and change it via SQL (while JIRA is offline). It's quicker to do it in the UI mostly.
You'll need a cron that can stop JIRA, run some SQL against your database, and then restart JIRA. And you will need to be very careful with the SQL - it will need to read the current settings and store them somewhere so it can put them back when it's done (remember that your admins can easily change the permissions in th UI and you need to preserve what they're doing) This makes me question what you're trying to do. If you genuinely need to lock JIRA out for a while for a good reason, then it's probably going to be far more simple to just stop it.
My scenario is like we have two JIRA instances. One(JIRA1) go live and one(JIRA2) backing the Live instance. If our Live instance(JIRA1) down for some reason we would like to point to backup JIRA(JIRA2) which should be in read only mode with all the latest data of Live(JIRA1). Where users can only view all issues until LiveJIRA (JIRA1) is up. Hope this briefs my concern :).
The problem though is that just takes care of Project data. If you've got plugins installed they might have different permissions ways. Also JIRA interacts with the database (in a write fashion) when folks are just logging in or viewing things... There are also crons etc. Just things to be aware off...
Yes, and for JIRA to even start up, it has to have *write* access to the database. In this case, I'm not sure you care too much about it, as I assume that the aim is just to stop updates until the production server is back up (because otherwise people might update it and then complain about data loss), and when production is back, you're going to throw away the disaster recovery system and rebuild it from production again.
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG