Page 1 of 1
VICIDIAL with mySQl Cluster
Posted:
Tue Mar 13, 2018 5:26 amby vishalsngh
Hi
We are planning to setup a VICIDIAL (web + dialer) with separate MYSQL Cluster(using mysql cluster app). Just wanted to know if any one has already attempted it? Any help/tips will bemost welcome!
Thx
Re: VICIDIAL with mySQl Cluster
Posted:
Tue Mar 13, 2018 6:02 amby mflorell
It won't work. Clustered MySQL is based on InnoDB-based engines, which are transaction-based and will not work with VICIdial. You can do a Master-Slave MySQL setup though, just make sure you only use the MyISAM family of storage engine options. And just for clarification, we don't actually recommend MySQL anymore, we prefer MariaDB.
Re: VICIDIAL with mySQl Cluster
Posted:
Tue Mar 13, 2018 6:44 amby vishalsngh
Ok. So does Mariadb Galera cluster a tested solution?
Also, in the conv Master slave mode, if the master fails, how wld the vicidial know which is teh new master?
Re: VICIDIAL with mySQl Cluster
Posted:
Tue Mar 13, 2018 7:36 amby mflorell
No, the Mariadb Galera cluster is not tested with VICIdial since it is based as an Innodb-engine solution. Although they apparently now have experimental support for MyISAM, we have not tested that at all.
Re: VICIDIAL with mySQl Cluster
Posted:
Fri Apr 13, 2018 8:08 amby buns
Hi,
I'm working on a Maria DB Galera Cluster for one of customers - 450 seats. I'm working with an Mysql/MariaDB ex employee on this project. We experienced a lots of bug at the beginning but now it is very stable. There's still place for improvement. I'll keep you up to date.
Re: VICIDIAL with mySQl Cluster
Posted:
Fri Nov 19, 2021 9:00 amby dinurajd
buns wrote:Hi,
I'm working on a Maria DB Galera Cluster for one of customers - 450 seats. I'm working with an Mysql/MariaDB ex employee on this project. We experienced a lots of bug at the beginning but now it is very stable. There's still place for improvement. I'll keep you up to date.
Any update on the mysql galera cluster