Vicibox MySQL Multi Master Replication

[randy_delgado_03]

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 ...

[mflorell]

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.

[randy_delgado_03]

Thanks matt for the heads up ...

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

[mflorell]

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?

[randy_delgado_03]

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 ...

[mflorell]

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.

[randy_delgado_03]

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?

[mflorell]

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)

[randy_delgado_03]

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

Thanks again ... (^_^)