As the load increases because of more users or traffic you should optimize
the way the database is used. Unfortunately because of different patterns of
usage between installations is not possible to apply one optimization with
the same cost.

Bellow are guidelines to improve the database usage for different
situations:

1. Separate the radius database from the main database. radius database can
be physically installed on different machine than the main database.

2. Separate the cdrtool database from the main database. cdrtool database
can be physically installed on different machine than the main database.

3. Separate the SIP location database from the main openser database. To do
this, dump openser database without data and copy it to location database
(on the same machine). Setup openser, ngnpro and cdrtool to use the new
location database.

4. Separate the sip trace database from the main database. To do this, dump
openser database without data and copy it to siptrace database (on the same
machine). Setup openser, ngnpro and cdrtool to use the new siptrace
database.

5. Having separate databases for sip location and traces, skip replicating
them as they contain volatile data. Add to the mysql server:

binlog-ignore-db=siptrace
binlog-ignore-db=location