[asterisk-ha-clustering] Wanted: High-Available and reliable MySQL Back-end for Asterisk

[Watkins, Bradley]

Hi Oli,

What in particular are you looking to test?  I am currently successfully running a 3-node Galera cluster that is the backend storage for an enterprise-level VoIP platform that includes several Asterisk nodes in various roles (ACD, IVR, voicemail).  The Galera nodes are being load-balanced via LVS/ldirectord.  One thing to note, however, is that within each role we have pairs of servers that are running in active/passive.  So the one potential issue with Galera of writing to the same rows and getting deadlocks is not an issue in my environment.  I suspect that if that situation were to arise Asterisk would be less than graceful as is the case with many other applications.

Regards,
- Brad

>
http://www.compuware.com/
The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it.

>From: asterisk-ha-clustering-bounces at lists.digium.com [mailto:asterisk-ha-
>clustering-bounces at lists.digium.com] On Behalf Of Oli Sennhauser
>Sent: Thursday, February 09, 2012 4:13 AM
>To: asterisk-ha-clustering at lists.digium.com
>Subject: [asterisk-ha-clustering] Wanted: High-Available and reliable MySQL Back-
>end for Asterisk
>
>Hello all,
>
>We have seen up to know that MySQL was used in a Master-Master Replication Set-
>up for HA Asterisk back-ends. Master-Master Replication has limited scalability and
>causes some troubles with fail-over and data inconsistencies.
>
>Now we want to test how Asterisk behaves with MySQL synchronous multi-Master
>Replication and Galera (http://codership.com/).
>
>Added benefits with Galera replication is that Asterisk servers can write to any
>MySQL Server in the Cluster and:
>
>* does Synchronous Replication
>* uses InnoDB tables
>* is an active-active real multi-Master topology
>* does automatic membership control
>* is true parallel Replication on row level
>* has no Slave lag
>* does not loose transactions
>* scales reading and writing
>
>Galera Cluster can be used in a LAN or a WAN!
>
>We are a database company and have no clue about Asterisk and VoIP. Thus we are
>looking for somebody who wants to test this set-up together with us.
>
>Please let me know when you are interested so we can figure out the details. Thanks
>for volunteering!
>
>Best regards,
>Oli
>
>--
>
>FromDual - Vendor independent and neutral MySQL consulting.
>
>Oli Sennhauser                    CEO / Senior Consultant
>Phone: +41 44 940 24 82           Mobile: +41 79 830 09 33
>oli.sennhauser at fromdual.com       http://www.fromdual.com
>Skype: fromdual                   Yahoo: fromdual
>
>
>--
>____________________________________________________________________
>_
>-- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
>asterisk-ha-clustering mailing list
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-ha-clustering