[Freeswitch-users] Using mysql cluster as core db

[Tristan Mahé]

Hi Gary,

You can always hack and recompile your mysql cluster src with larger row 
support ( beware it's not an easy hack ).

I don't know the presence stuff in FS, but if it's storing xml msgs 
received from UA's, you may store truncated stuff using your modified 
scheme and this will break functionnality, same for the 'description' 
field, it's been too long I didn't take a look at FS src to answer 
precisely...

Regards,

Gled.

Le 21/03/2012 20:05, GCHEN00 a écrit :
> mysql cluster 7.2.4
> and newest FS
> I am trying to use ODBC to connect mysql cluster database.
> 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.
> 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"
> I can use engine=InnoDB but not NDBCLUSTER.
> 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.
> I am wordering will these table changes cause any problem down the road.
> Any other suggestion to solve this problem?
> Gary
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> 
> 
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://wiki.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org


-- 
Tristan Mahé
B&C
08.25.59.50.59

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20120321/18a80bb1/attachment.html