We need to migrate our initial installation that is located in our on-premise server into another machine suitable to manage Jira as production
Can you please:
suggest me a suitable hardware configuration ?
Explain how to migrate the data into a server database (eg. mysql) ?
Suggest me a best practice to perform backup/restore ?
+1 for Alexey's link of Migrating JIRA applications to another server
but I would also like to add some other documentation to address your other questions:
Could you please tell us what version of Jira you are using now, and what version you want to upgrade to? Depending on the versions there might be additional steps needed to make sure you can upgrade all your data properly.
MySQL drivers can sometimes be source of some debugging so I'd definitely recommend a free an flexible solution, the most common I've seen and the one I use every time is PostgreSQL, it's also portable so definitely the best option in my opinion if your company does not have a preference :)
Hope this helps!
MariaDB is explicitly not supported for Jira. You can find this detail in the Supported Platforms documentation.
You can use MySQL if you prefer, but I would tend to agree with Micky's comment in regards to database drivers. The problem tends to be that Atlassian installations can not currently bundle the mysql database driver when you do installations/upgrades for MySQL due to licensing concerns. However we don't have this same problem with other supported database types.
You are welcome to use MySQL, but I would recommend updating your mysql jdbc driver when you upgrade Jira each time.
In general, I tend to recommend that Jira installations use a supported version of Postgresql.
Use a well supported and well-known one. We tend to find most people run Production on RedHat because you can get support for it, and then CentOS for dev/test.
Nothing wrong with using CentOS for production though, and we regularly run into Ubuntu and Debian based Atlassian systems. I know of a couple of Arch and Gentoo systems in use as well.
...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...
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