vicidial.org

Good Day Everyone,

Has anyone successfully setup multi master replication in mysql on vicibox database?

Currently i'm planning a load balance/fail over on vicibox database ...

Any thoughts, reference, and suggestion would be highly appreciated.

Thank you ...

We do not recommend Master <-> Master MySQL replication, there are a lot of issues with this that can cause data loss and inconsistency.

We recommend instead using Master -> Slave(s) with heartbeat failover to make one of the slaves a master in the event of an unrecoverable failure.

Thanks matt for the heads up ...

how about MySQL Proxy? have you tried working with it as well for load balancing purposes?

Database load balancing with a real-time application like ViciDial really doesn't work well. ViciDial does a large number of update/insert/delete queries with a large number of very fast selects, with query queueing integrity. This kind of application does not work well with distributed querying platforms.

How many agents are you looking to build a system for?

Thanks for the info matt. Good thing i asked first before implementing ...

*How many agents are you looking to build a system for?
- About 75 - 120 expandable matt. Thats why im preparing for the worst case scenario and familiarizing with the possibilities of loadbalance / failover ...

You can go over 300 agents with a single MySQL server with 4 x quad-core CPUs and 64GB RAM with 4 x SAS 15k drives and a hardware RAID 10. And of course several telco servers and a few web servers. We have built several clusters like this for our larger clients.

With RAM drives, more RAM and more CPUs you could go even higher.

Got it matt. But if you are to ask, what hardware specs will you prefer for 120 stations with 50/50 inbound and outbound having 2:1 agent ratio for outbound?

DB/WEB/TELEPHONY <= Separated?

Or it can go all in one with higher specs?

Whats your preference?

For 120 seats you do not want to do an all-in-on server. For the DB server I would recommend a 2 x quad-core CPU system with 16GB RAM and 15k SAS or SCSI drives with a hardware-caching RAID controller set in RAID 10. Then you would need one web server(single quad-core CPU and 4GB RAM) and 3-5 telco servers(depending on your lines-to-agent ratio, same specs as web server)

Thanks again matt, this info really gives me a glimpes on what i need to deploy on that volume of agents.

Thanks again ... (^_^)