Page 1 of 1
MySQL NDB Cluster Query
Posted: Mon Apr 23, 2012 7:23 pm
by 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
Re: MySQL NDB Cluster Query
Posted: Tue Apr 24, 2012 9:04 am
by 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.
Re: MySQL NDB Cluster Query
Posted: Sun Apr 29, 2012 8:44 pm
by 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
Re: MySQL NDB Cluster Query
Posted: Mon Apr 30, 2012 9:42 am
by 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.