MySQL NDB Cluster Query

[santosltd]

Hi Team,

We are currently in the process of setting up and migrating our MySQL instance DB's from Nagios over to an NDB Cluster.

During the process of converting the DB and importing it, it hangs at importing on the long_output varchar (8192) structure/content.

I was wondering whether you guys would recommend changing the varchar to either text/blob.

Thanks
Hani

[scottwilkerson]

I would say TEXT would be closest.

From http://dev.mysql.com/doc/refman/5.5/en/blob.html

In most respects, you can regard a BLOB column as a VARBINARY column that can be as large as you like. Similarly, you can regard a TEXT column as a VARCHAR column. BLOB and TEXT differ from VARBINARY and VARCHAR in the following ways:

For indexes on BLOB and TEXT columns, you must specify an index prefix length. For CHAR and VARCHAR, a prefix length is optional. See Section 8.3.4, “Column Indexes”.

BLOB and TEXT columns cannot have DEFAULT values.

[santosltd]

Thanks Scott, we converted it over to TEXT.

Do you guys have any plans to support NagiosXI in an NDB Clustered environment?

Cheers
Hani

[mguthrie]

Not at this time. Items like this fall more under the "server administration" category, so users are welcome to set up their environments with this on their own if they'd like, but we would only be able to offer minimal support for that scenario since we haven't documented or tested that kind of a setup.