Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Basic: Apache for caching and HTTP/2

EDV April 19, 2021

So I setup my Jira and got pretty bad performance, the sites are loading very slow. Now two problems were detected: "modern http protocols" and "embedded database".

So I see the procedure is discribed in the help sites, but I just dont know how to even use the commands. I have Jira running on a Windows Server 2016. I see that its running on a Tomcat Webserver.

So where do I type in those commands like

a2enmod proxy_http headers; a2dismod proxy_http2

 

Thx for the help!

2 answers

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 19, 2021

I think you have run into a common misunderstanding here, and although I suspect you're searching for and finding the right docs, the incorrect context makes it all seem like nonsense or inapplicable.

So, you're actually looking at four different products and services here:

  • h2 is a database that is providing the data storage for your Jira
  • Tomcat is an application server (proper/explanatory name is "Apache Tomcat" or even "The Apache Foundation's Tomcat") - it is not a web server, it is a web-application server
  • Jira is a web-application that uses a database (h2) to store data, runs on Tomcat, and throws up pages for users to interact with their data.
  • Apache is a web-server (proper/explanatory name is "The Apache Foundation's Apache"), unlike Tomcat

So, you've mentioned three problems:

  • speed (reported by humans)
  • modern http protocols (reported by Jira)
  • embedded database (reported by Jira)

The second and third can feed into the first, so let's get them fixed first.

The embedded database is simple - stop using h2 and swap to one of the supported databases (postgres, mysql, oracle or ms-sql).  h2 is a file and memory based database which can run into performance issues quite quickly as it grows.  More importantly, it can (and will) fail catastrophically.  It should only be used for throwaway systems (development and testing), never one that you actually want to keep real data in.  You should migrate as soon as possible.

The http protocols are a bit more complex to explain.  There's a whole load of protocols that computers use to talk to each other, and some of them are insecure.  Plain http is totally insecure and shouldn't be used for anything other than reading public information, but there are some https protocols that are no longer secure.  Your Jira is using one of them.

This is where protocols get a bit more complex - we do not know how you have implemented it.  By default a Jira install uses http, but it's not actually the Jira (or database) that does https, and you should always use https for Jira access.  You can do it in the Tomcat, or you can stick your Tomcat behind a proxy that does the https for you, and that's where the Apache web-server kicks in.

The a2en/a2dis commands you've mentioned are for the Apache web-server, not Tomcat.

So, two actions

1.  Let us know how you are doing https (if at all!  If it is https, is it just Tomcat, or have you got a proxy of some form?)

2.  Migrate to a supported database

EDV April 26, 2021

Sorry for the delayed answer. I now moved the database to MSSQL and got it back running. Now I dont get any issues anymore and performance is fine.

Thx for the help!

0 votes
Gonchik Tsymzhitov
Community Champion
April 19, 2021

Looks like you forget to put info


Protocols
h2 h2c http/1.1

https://httpd.apache.org/docs/2.4/howto/http2.html

 

Also, in that situation I do recommend to look into database setup and JVM configuration. 

EDV April 19, 2021

Ok i understand that info is missing somewhere. But how and where exactly do I have to put it in?

Sorry but that leaves more questions to me than answers. :(

Suggest an answer

Log in or Sign up to answer