...
Database | Description |
eltex_ems | contains data on domain structure, object tree, EMS users, EMS configuration data etc. The database is created/updated when eltex-ems-db package is installed. |
eltex_alert | contains EMS and device event logs. The database is created/updated when eltex-ems-db package is installed. |
wireless | contains SSID configuration. The database is created/updated when eltex-ems-db package is installed. |
eltex_auth_service | the database used by eltex-auth-service package to store data on Admin Panel, Portal Constructor and NBI users. The database is created/updated during eltex-auth-service-db package installation. |
radius | contains data on Wi-Fi users, their usernames, customization and accounting. The database is created/updated during freeradius-eltex-db package installation. |
ELTEX_PORTAL | contains data on virtual portals used in the project. The database is created/updated during eltex-portal-mysql package installation. |
payments | contains data on Wi-Fi users' payments for using paid tariffs. The database is created/updated during eltex-portal-mysql package installation. |
eltex_doors | contains JWT tokens generated by eltex-doors service. |
Service management
Operation | Command | Response | ||||
Status check |
|
| ||||
Service start |
|
| ||||
Service stop |
|
| ||||
Service restart |
|
|
Configuration
MySQL configuration is done via /etc/mysql/my.cnf (default file installed with mysql-server package) and /etc/mysql/conf.d/eltex-ems.cnf (the file installed with eltex-ems-db package and containing additional information which is important for the management system work) configuration files.
The number of connections
Depending on the estimated number of access points, the maximum number of AP connections should be specified via max_connections parameter. The parameter is specified in /etc/mysql/mysql.conf.d/mysql.cnf by default, but commented out. Uncomment it and enter the required number, for example, like this:
...
The number can be selected from Calculating the number of database connections depending on server load (last row).
Memory size
MyISAM is used in eltex_alert database and syslog. InnoDB is used in all other databases, including radius.radacct high-load table.
After the database is installed, configure buffer size for MyISAM and InnoDB services (/etc/mysql/conf.d/eltex-ems.cnf parameters key_buffer_size and innodb_buffer_pool_size, respectively).Configuration recommendations:
...
Additional database user accounts
Collecting rsyslog
To collect logs from DHCP and RADIUS servers, rsyslog user account should be created in the database.
Commands:
...
where HOST is an address of RADIUS or DHCP server in management network. For each server, a separate entry should be created.
Checking replication ststus in GUI EMS
For EMS server to be able to check replication state, additional user accounts are required. They can be created via the MySQL console:
commands:
...
where HOST is an address of EMS server in VRRP network. For each server, a separate entry should be created.
Database connection number calculation depending on server load
up to 50 AP | from 50 to 200 AP | from 200 to 500 AP | from 500 to 4 thousand AP | ||
The number of SoftWLC service connections |
| ||||
nbi (total) | 16 | 38 | 78 | 156 | |
The number of service connections per DB | radius | 4 | 12 | 24 | 48 |
ems | 4 | 10 | 22 | 48 | |
wireless | 4 | 10 | 22 | 48 | |
logs | 2 | 4 | 6 | 8 | |
eltex_auth_service | 2 | 2 | 4 | 4 | |
| |||||
ems (total) | 20 | 40 | 92 | 186 | |
The number of service connections per DB | event | 4 | 8 | 16 | 32 |
tree | 4 | 8 | 20 | 40 | |
syslog | 2 | 4 | 4 | 4 | |
radius | 4 | 8 | 20 | 40 | |
wireless | 3 | 6 | 14 | 30 | |
| |||||
PCRF (total) | 6 | 12 | 24 | 48 | |
The number of service connections per DB | radius | 2 | 4 | 8 | 16 |
sql.ems | 2 | 4 | 8 | 16 | |
sql.wireless | 2 | 4 | 8 | 16 | |
radius | 5 | 10 | 15 | 32 | |
eltex-auth | 2 | 2 | 2 | 5 | |
eltex-portal | 10 | 10 | 15 | 32 | |
eltex-portal-constructor | 10 | 10 | 10 | 10 | |
rsyslog-mysql | 2 | 4 | 6 | 10 | |
replication | 2 | 2 | 2 | 2 | |
reserve | 8 | 8 | 8 | 8 | |
| |||||
| 78 | 130 | 234 | 449 |
mysql server operation analysis using MySQLTuner
MySQLTuner is a perl script that analyses MySQL statistics and provides recommendations on MySQL server configuration optimization.
...