Redundant database

From VoIPmonitor.org
Revision as of 14:37, 1 July 2014 by Festr (talk | contribs) (Created page with "Since sniffer 10 the voipmonitor has feature which mirrors data from some remote sniffer database to another database. It replicates all partitions from certain date increasin...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Since sniffer 10 the voipmonitor has feature which mirrors data from some remote sniffer database to another database. It replicates all partitions from certain date increasingly syncing data to secondary database. You can have unlimited number of slave databases just for offloading or for backup purpose. Here is example of the configuration which will initiate full backup from 2014-06-10 from mysql server on 192.168.0.1 to localhost database creating the whole schema.

[general]
sqldriver = mysql
mysqlcompress = yes
mysqlhost = 127.0.0.1
mysqldb = voipmonitor
cdr_partition = yes
mysqltable = cdr
mysqlusername = root
mysqlpassword = neupk,2
database_backup_from_date = 2014-06-10
database_backup_from_mysqlhost = 192.168.0.1
database_backup_from_mysqldb = voipmonitor
database_backup_from_mysqlusername = root
database_backup_from_mysqlpassword = pass
database_backup_pause = 3
database_backup_insert_threads = 3
cleandatabase = 70
cdr_sipport = yes
cdr_rtpport = yes