Bug #49372 Include the "tomcat-native" packages with our Dashboard installations
Submitted: 2 Dec 2009 21:12 Modified: 26 Apr 2011 19:57
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Server Severity:S3 (Non-critical)
Version:2.1.0.1096 OS:Any
Assigned to: Andy Bang CPU Architecture:Any
Tags: windmill

[2 Dec 2009 21:12] Mark Leith
Description:
Some customers have seen issues with SSL when under large scale. Performance improvements have been seen by switching Tomcat to using the "tomcat-native" library. 

This is a request for us to include and use the tomcat-native library by default. 

How to repeat:
N/A

Suggested fix:
Include the tomcat-native library within our installations.
[20 Sep 2010 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[21 Sep 2010 6:42] Simon Mudd
This bug was opened by support/dev on my behalf.

The request was to allow us to use the tomcat-native libraries to improve performance. On our installation our merlin setup basically does not work with a normal "standard install", and part of the load problems are I believe related to SSL which the tomcat-native packages seem to resolve quite clearly.

So the request was for the upgrades to include this tomcat-native in the standard install so that we don't need to check and ensure that tomcat-native is installed and working. It often takes a while for us to figure out after performing an upgrade why the performance has dropped (there's in internal measuring tools to see this) and this is rather frustrating as it takes up a lot of time to diagnose and often requires my time, MySQL supports time and in the end is an issue which has to be checked after every single upgrade.

MySQL, Sun and now Oracle own "java" so if you can't figure out how to ensure the packages you provide include the native tomcat then I don't know who can...
[19 Jan 2011 23:44] Enterprise Tools JIRA Robot


Attachment: 10553_Re EM-3816 - Include the 'tomcat-native' packages with our Dashboard installations.eml (message/rfc822, text), 2.48 KiB.

[20 Jan 2011 21:33] Enterprise Tools JIRA Robot
Andy Bang writes: 
Final step needed to make all this work:

Author: merlin
Date: 2011-01-20 22:31:40 +0100 (Thu, 20 Jan 2011)
New Revision: 1811

Modified:
   branches/2.3/bitrock/output-mysqlnetwork-linux/apache-tomcat/conf/server.xml
   branches/2.3/bitrock/output-mysqlnetwork-linux64/apache-tomcat/conf/server.xml
   branches/2.3/bitrock/output-mysqlnetwork-osx/apache-tomcat/conf/server.xml
   branches/2.3/bitrock/output-mysqlnetwork-solarisi/apache-tomcat/conf/server.xml
   branches/2.3/bitrock/output-mysqlnetwork-solarisi64/apache-tomcat/conf/server.xml
   branches/2.3/bitrock/output-mysqlnetwork-solariss/apache-tomcat/conf/server.xml
   branches/2.3/bitrock/output-mysqlnetwork-windows/apache-tomcat/conf/server.xml
   branches/2.3/bitrock/output-mysqlnetwork-windows64/apache-tomcat/conf/server.xml
Log:
Add references to sample SSL certificates to server.xml in Tomcat stacks for EM-3816 / Bug #49372 - Include the 'tomcat-native' packages with our Dashboard installations

Modified: branches/2.3/bitrock/output-mysqlnetwork-linux/apache-tomcat/conf/server.xml
===================================================================
--- branches/2.3/bitrock/output-mysqlnetwork-linux/apache-tomcat/conf/server.xml	2011-01-19 23:14:19 UTC (rev 1810)
+++ branches/2.3/bitrock/output-mysqlnetwork-linux/apache-tomcat/conf/server.xml	2011-01-20 21:31:40 UTC (rev 1811)
@@ -101,7 +101,9 @@
                acceptCount="100" scheme="https" secure="true"
                clientAuth="false" sslProtocol="TLS" 
                keystoreFile="conf/myKeystore" 
-               keystorePass="mysqlnetwork"/>
+               keystorePass="mysqlnetwork"
+               SSLCertificateFile="conf/ssl/tomcat.cert.pem"
+               SSLCertificateKeyFile="conf/ssl/tomcat.key.pem"/>
     @@BITROCK_STOP_XML_COMMENT@@
     <!-- MERLIN CHANGE STOP  -->
[31 Jan 2011 18:17] Enterprise Tools JIRA Robot
Andy Bang writes: 
Not working yet -- need to update LD_LIBRARY_PATH as well.
[26 Apr 2011 19:57] John Russell
Added to 2.3.2 changelog.