ShoreTel Database Replication and Manipulation MAXDBQUERIES!


It’s really not about any VoIP system you have installed all of them, in accordance with the rules, the same architecture, the configuration database. Depending on your system, you may find the database, which began in the complex Access database to an SQL database is full. The database will store information about the current configuration, and often, Call Detail Records that document the activities of the telephone system. The characteristics of the database is consistent across all architecture is not possible to just “read / write” copy of your database!

Some phone systems to distribute the database across multiple servers. ShoreTel, such as distributed database components for distributed application server and voice mail, unified architecture characterize the image in some places in the environment. We need better, since changes in the effect of database systems, a global network of broadband and the demand for the database. First, what changes to the database? Well clear of any configuration changes made to this system. For example, when adding or deleting users clear cause database now! Take the example of the more subtle, however. Consider what happens to the agent in a workgroup, which is located at a remote site, which will be distributed voice mail server. Each agent of change that makes a call to change the database manager. Enter the system and exit the system, changes to the database. How about the challenge offered by the agent on a workgroup?

Any changes are sent to the database. Change the first time on “read / write” database and then replicated to the remote copy of database. ShoreTel process Component Object Model using MS distributed (DCOM) objects to exchange information from the configuration database from one another and write configuration information to the database. User configuration options stored in a database with a personal manager to call the interface. Each service on the server ShoreTel distributed caching a copy of the configuration database. In a distributed server has lost communication with the server at headquarters (read “read / write” database), any changes made do not get distributed servers. If the DVM to reboot without a database associated with the HQ, the service is running but not working. If the network connection is restored, removed and re-cache configuration for each service, such service to be functional.

If there is a global network, we note that the DVM will actually restart your database. Movement between the server and database server DVM headquarters is clearly using broadband, and create additional demand on the database. At ShoreTel is the database MySQL. The question is, how many simultaneous database access (read, edit and write) operations can be MySQL server to work together? What happens if agreement can not be solved? There is a queue and try again? In large systems, say, 700 agents working group on the web site, you have the MySQL database with a request to change the status? If you dig into the server logs you will find MAXDBQUERIES default is 100. It has been our experience, the size of the defense system, is sometimes necessary to call this number back to eliminate burdensome database. These adjustments should be made only on the configuration of DVM, the head office server. You must reboot the server after DVM, to make these changes. You should also note the difference between HEX and decimal!

Tags: , , , ,

Comments are closed.