Specifications

Call Detail Record Reports
C – 4 ShoreTel, Inc.
MySQL Database
CDR records are maintained and queried through MySQL database. The maximum
MySQL database size is 64 terabytes (TB) with database tables restricted to a maximum
size of 2 TB.
The data in the MySQL files can be viewed using a new Web-Based Reporting feature
from ShoreWare Director (see “Reports” on page 17-2 for more information).
Alternatively, the user can use common database command utilities via a command line
interface to dump and restore files.
MySQL was introduced to ShoreWare in version 7.0. Previous versions of ShoreWare
stored CDR records using Microsoft Joint Engine Technology (JET) database
management. After ShoreWare version 7.0 is installed, call detail records are stored in
the MySQL database. Systems upgraded from a prior release maintains the previous
database stored in the Microsoft format.
When a CDR report is generated on an upgraded system, only the MySQL database will
be tapped to generate the report. Data in the older Microsoft database is ignored until it
has been converted to the MySQL format. This process is described in “Importing
Access Database Files into MySQL Format” on page C-8.
CDR reports are generated from Director, as described in “Reports” on page 17-2.
MySQL database service can be monitored or restarted from Director by selecting
Maintenance -> Services in the menu panel, then selecting MySQL in the table on the
Services page.
Compatibility and Pre-Configuration Requirements
Disk Space Requirements
Storing call detail records for 50,000 workgroup calls requires a 1.5 GB MySQL
database. Implementing a database of this size typically requires 4.0 GB of disk space.
This includes disk space for the main database (1.5 GB), the archive database (1.5 GB),
and temporary space required to generate reports (1.0 GB).
Although the main and archive databases are typically stored on the same server,
MySQL permits the storage of the databases on different servers.
Compatibility with Utility Programs
ShoreWare should be run on a dedicated server. Other programs that access MySQL
databases may not be compatible with ShoreWare, resulting in installation and data
integrity issues. Before installing ShoreWare on any server, remove all pre-existing
MySQL programs and databases.
Virus Checkers: MySQL database files must be excluded from all virus checker utilities
running on the server. Failure to exclude the database will crash the MySQL service.
Disk or Backup utilities: MySQL database files must be excluded from all disk or
backup utilities running on the server. Failure to exclude the database will crash the
MySQL service.
To restart the database after a crash, access the MySQL Service panel from ShoreWare
Director by selecting Maintenance -> Services in the menu panel, then selecting MySQL
in the table on the Services page.