<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.19190">
<STYLE></STYLE>
</HEAD>
<BODY 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></BODY></HTML>