Table of Contents | ||||
---|---|---|---|---|
|
...
For additional information on verifying pre-requisites refer this article.
- The three servers should be on the same network and able to communicate with each other. Refer QMetry Deployment Document for the requirements.
- All the servers should have support of these commands: unzip, wget, curl and vim.
- Internet access should be enabled on all 3 servers to install using docker.
- Ensure Proxy Servers are not blocking downloads from the Internet.
- Docker installation requires root user access. To install using a non-root user, follow the steps specified here before starting the install on both QMetry and Report servers.
- QMetry and Report Servers should be able to communicate over 80/443 and Database Server 3306/DB Ports. Ports 8080 and 33061 should be enabled/open on Reports Server to allow connections from QMetry application server.
- Docker is installed under /var/lib/ directory. We recommend allocating enough space here to ensure QMetry has enough space to save your data.
- Data of QMetry attachments added is saved under : /var/lib/docker/volumes/qmetry_attachment/_data
- Get the following files from QMetry Support: QMetryApp.zip, Spark_Report_Install.zip, License and docker credentials required for installation.
- Post installation, QMetry Application and Report tool both should be configured either on https or http.
- Following Ports should be open on respective servers:
...
- Login to AWS Management Console and open the Amazon RDS console.
- RDS > Databases > Actions > Stop RDS Service.
- Go to Configurations tab > Parameter Group.
- Search and then add / edit the following parameters.
Parameters | Values |
---|---|
lower_case_table_names | 1 |
max_allowed_packet | 536870912 |
character_set_server | utf8mb4 |
collation_server | utf8mb4_unicode_ci |
innodb_thread_concurrency | 10 |
query_cache_limit | 1073741824 |
table_definition_cache | 2000 |
group_concat_max_len | 1536000 |
innodb_autoinc_lock_mode | 2 |
tx_isolation | REPEATABLE-READ |
sql_mode | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
binlog_error_action | ABORT_SERVER |
binlog_format | ROW |
binlog_group_commit_sync_delay | 0 |
binlog_group_commit_sync_no_delay_count | 0 |
binlog_gtid_simple_recovery | 1 |
binlog_max_flush_queue_time | 0 |
binlog_order_commits | 1 |
binlog_row_image | FULL |
binlog_rows_query_log_events | 0 |
binlog_stmt_cache_size | 32768 |
max_binlog_stmt_cache_size | 18446744073709547520 |
log_bin_trust_function_creators | 1 |
log_bin_use_v1_row_events | 0 |
- RDS > Databases > Actions > Start RDS Service.
- Connect to the RDS DB, and execute the below query - which ensures whenever RDS restarts, mysql bin logs are not deleted - which is essential for dependable reports data sync.
- call mysql.rds_set_configuration('binlog retention hours', 24);
...
Once the script finishes executing it will prompt to enter the following parameters
Options | Details | Example |
---|---|---|
Enter Mysql Database Host IP / DNS Name (Qmetry) | QMetry DB Host Public IP/DNS | 10.10.11.100 |
Enter Mysql Database Port (Qmetry) | QMetry App MySQL DB Port. Enter 3306, unless QMetry DB port is different | 3306 |
Enter Mysql Database Schema (Qmetry) | QMetry App DB schema name. Enter : qmetry | qmetry |
Enter Mysql Database Username (Qmetry) | QMetry App DB username. Enter : root | root |
Enter Mysql Database Password (Qmetry) | QMetry App DB password. If it is unchanged from default, enter : qmetry | qmetry |
Enter Mysql Database Host IP / DNS Name (Reports) | Enter the static docker IP : 10.5.0.7 as the IP address of QMetry Reports server | 10.5.0.7 |
Enter Mysql Database Port (Reports) | Enter the port where reports DB is running. Enter : 3306 | 3306 |
Enter Mysql Database Schema (Reports) | Enter the database schema name of QMetry Reports DB - | qtmanalytics |
Enter Mysql Database Username (Reports) | Enter username of QMetry Reports DB | root |
Enter Mysql Database Password (Reports) | Enter password of QMetry Reports DB - qmetryreports@!Nf0# | qmetryreports@!Nf0# |
Enter Port To Start SyncJob (Reports) | Reports Sync Job runs from this port : 8080 | 8080 |
Do you want to Run Force Sync Now ? (y/n) | Enter y to sync all the QMetry data to Reports DB with the current script. Always enter y at the time of fresh reports install | Type : y |
Enter Memory to allocate in GB(s) to Spark | Entered memory would be used by the sync job while running a full sync of data. Enter 3/4th of total memory available on server. For example, if memory on server is 24 GB, enter 18 | 18 |
...
After waiting for about a minute, command docker ps should return the following :
Step 4 - Restart Reports Services
...