mysql clustering

[Op3r]

An interesting post came up

I was wondering if mysql clustering is quite ok for vicidial.

Any one tried this?

[mflorell]

All I have done is Master/Slave and it worked out OK, nothing like the whole 5-server Mysql cluster thing that you can now do in MySQL 5. I would assume that it would also work OK since it is just MySQL and version 5 works just fine with VICIDIAL.

[AlexR]

I've tried this setup with VICIDIAL in small testing environment, but I would not dare to go to production with a MySQL Cluster, since it is a Memory based cluster...


From the MySQL Cluster FAQ

n MySQL-5.0, Cluster is in-memory only. This means that all table data (including indexes) is stored in RAM. Therefore, if your data takes up 1GB of space and you want to replicate it once in the cluster, you need 2GB of memory to do so (1 GB per replica).

And since vicidial_list & call_log/vicidial_agent_log tables grow rather fast, I would not advice to go this direction. (yet)


Thank you,


Alejandro

[peacy]

As of MySQL 5.1 you can have the data on disk also.

But if you really want replication + load balancing you have to have at least 4 nodes just for the MySQL cluster.

[Op3r]

I am thinking about this for a long time.

Basically I saw someone using ultramonkey on some of their mysql setups although not connected to VICIDIAL.

He explained to me that by clustering the mysql databases and having a load balancing server all you need is like 4 pundits (p4 ht with 4gb of ram and 70gb hard drive) doing the clustering. and you will just connect to it thru the load balancing server. This is great for like 100+ seats set ups or even for those who want to have 0 downtime. (heck even avaya or mosaic have downtimes)

Ill explain my thoughts more after I talk again to that guy.

any more ideas about this? because this can really help us for the stability and scalability of our open source astguiclient.

and yeah I heard someone is using ultramonkey to auto load balance asterisk too.

[ramindia]

Hi


iam working on same project
not for vicidial

centralise Database for the whole company

Looking in to HA and RAID Level, any success i will post results here


ram