QueueMetrics - Advanced Configuration Manual

Loway

Revision History
Revision $Revision: 1.2 $$Date: 2010/04/26 09:04:39 $L

Table of Contents

1. Acknowledgements
2. ViciDial integration
2.1. Prerequisites
2.2. Changes to QueueMetrics database
2.3. Changes to ViciDial
2.4. Changes to QueueMetrics
3. Serving QueueMetrics through Apache
3.1. Prerequisites
3.2. Installing mod_jk
3.3. Configuration of Apache and mod_jk
3.4. Virtual host configuration
3.5. Creating Virtualhosts in Tomcat
3.6. Troubleshooting
4. Serving QueueMetrics over Apache/SSL
4.1. Prerequisites
4.2. Configure the Name-Based SSL Virtual Hosts
4.3. Install the Apache HTTP Server and Its SSL/TLS Module
4.4. Configure the global Apache Settings
4.5. Configure the global SSL/TLS Settings
4.6. Create DNS records
4.7. Create the Application Directories
4.8. Install the CRT, CSR, and KEY files
4.9. Configure the Virtual Hosts
4.10. Verify the Configuration
4.11. Setup the service for automated startup
4.12. Troubleshooting
4.13. Summary of Log Files used by Apache
4.14. Notes
5. Installing QM as a ROOT webapp
5.1. Prerequisites
5.2. Changes to Tomcat
5.3. Changes to QueueMetrics
6. Enabling GZIP compression in Tomcat
6.1. Prerequisites
6.2. Changes to Tomcat
6.3. Changes to QueueMetrics
6.4. For further reading
7. Database connection pooling
7.1. Prerequisites
7.2. Changes to the MySQL server
7.3. Changes to QueueMetrics
7.4. Changes to Tomcat
8. Monitoring and fixing "slow queries" in MySQL
8.1. Prerequisites
8.2. Changes to MySQL server
8.3. Changes to QueueMetrics
9. Moving the queue_log table to InnoDB
9.1. Prerequisites
9.2. Changes to MySQL
9.3. Changes to QueueMetrics
10. Using Master-master database replication for strong high-availability
10.1. Prerequisites
10.2. Changes to MySQL
10.3. Changes to QueueMetrics

1. Acknowledgements

We would like to thank the following people for their precious contributions:

  • Matt Florell from the ViciDial Group, USA <mattf@vicidial.com>
  • Matthew J. Roth of InterMedia Marketing, USA
  • Jens von Bulow of Xantech, South Africa