<html><head><base href="x-msg://3082/"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Gary,<div><br></div><div>I used to use mysql cluster on my tables for the freeswitch database. When I set it up I started freeswitch which created the tables as MyISAM, then I run an ALTER TABLE X type=ndbcluster on each table this worked for me. I thought you could tune the NDB config file to allow more elements. Did you try raising your Data Size and Index Sizes? There is a nab_size.pl script which can help you work things out I believe.</div><div><br></div><div>I actually ended up moving away from NDB for my FS database as I was suffering strange lock issues and lock errors, NDB seems very limited in the locking mechanism it does and in some case I found the sip_registrations table was actually locked which caused an outage for my clients. I moved to a Innodb Active/Active replication scenario, in doing so I found that the locking issues went away and in fact the SQL queries got faster thanks to indexing. With the InnoDB setup you can still achieve high availability by using Active/Active replication and a virtual address that is monitored using heartbeat.</div><div><br></div><div>Entirely up to you but after the experience I had I would strongly advise against NDB Cluster for your FS Core, initially it was great but as my volume increased I started seeing ODBC lock timeout messages from Freeswitch, as soon as I change the tables to Innodb the lock error messages disappeared.</div><div><br></div><div>Cheers,</div><div><br></div><div>Ash.</div><div><br></div><div><br><div><div>On 22/03/2012, at 6:05 AM, GCHEN00 wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div bgcolor="#ffffff"><div><font size="2" face="Arial">mysql cluster 7.2.4</font></div><div><font size="2" face="Arial">and newest FS</font></div><div><font size="2" face="Arial"></font> </div><div><font size="2" face="Arial">I am trying to use ODBC to connect mysql cluster database.</font></div><div><font size="2" face="Arial">When FS start, it has ERRORs to create the tables channel and interfaces, So I tried to manually create these two tables with schema from non-cluster mysql database.</font></div><div><font size="2" face="Arial">With engine=NDBCLUSTER for the tables, I got this error: "The maximum row size for the used table type, not counting BLOBs, is 14000. You have to change some columns to TEXT or BLOBs"</font></div><div><font size="2" face="Arial"></font> </div><div><font size="2" face="Arial">I can use engine=InnoDB but not NDBCLUSTER.</font></div><div><font size="2" face="Arial"></font> </div><div><font size="2" face="Arial">So I changed fields 'presence_id' and 'presence_data' in channel table from size 4096 to 512 and field 'description' in interfaces table from 4096 to 1024. And it worked.</font></div><div><font size="2" face="Arial"></font> </div><div><font size="2" face="Arial">I am wordering will these table changes cause any problem down the road.</font></div><div><font size="2" face="Arial"></font> </div><div><font size="2" face="Arial">Any other suggestion to solve this problem?</font></div><div><font size="2" face="Arial"></font> </div><div><font size="2" face="Arial">Gary</font></div><div><font size="2" face="Arial"></font> </div><div> </div>_________________________________________________________________________<br>Professional FreeSWITCH Consulting Services:<br><a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a><br><a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a><br><br>FreeSWITCH-powered IP PBX: The CudaTel Communication Server<br><a href="http://www.cudatel.com">http://www.cudatel.com</a><br><br>Official FreeSWITCH Sites<br><a href="http://www.freeswitch.org">http://www.freeswitch.org</a><br><a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a><br><a href="http://www.cluecon.com">http://www.cluecon.com</a><br><br>FreeSWITCH-users mailing list<br><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br><a href="http://www.freeswitch.org">http://www.freeswitch.org</a><br></div></span></blockquote></div><br></div></body></html>