NDB Cluster storage engine and FULLTEXT sql indexes

Hey all,

First of all great CMS!

Second, I got a question about MODx NDB Cluster engine support.
Currently as an experiment we are using an open source cms (in this case MODx) for our applications support center,
the thing is this support center needs a high avaiability for our customers so we are going to implement it on a MySql cluster.

Now the problem is that you use a FULLTEXT sql indexes search, FULLTEXT sql indexes on the other hand is only supported in a MyIsam database.

My question now is, where do you use the FULLTEXT sql indexes mainly for and what impact (what features will be missing) would it have on MODx to
disable it.

Thank you for the answers in advanced.

Grz,
Stefan

Quote from: svzanden at Mar 15, 2007, 08:10 AM

Hey all,

First of all great CMS!

Second, I got a question about MODx NDB Cluster engine support.
Currently as an experiment we are using an open source cms (in this case MODx) for our applications support center,
the thing is this support center needs a high avaiability for our customers so we are going to implement it on a MySql cluster.

Now the problem is that you use a FULLTEXT sql indexes search, FULLTEXT sql indexes on the other hand is only supported in a MyIsam database.

My question now is, where do you use the FULLTEXT sql indexes mainly for and what impact (what features will be missing) would it have on MODx to
disable it.

Thank you for the answers in advanced.

Grz,
Stefan

Stefan:

To my knowledge, the fulltext index on the site_content table is used only by a few search components (FlexSearchForm, AjaxSearch) and possibly by the search in the manager, but otherwise, I do not believe it will have much impact. You could easily provide your own search query that does not require the index.

Note that in the future, likely at 1.0 release, this will no longer be the case, as we will be unveiling some more flexible and advanced search indexing techniques that will not be dependent on the database engine in any way. This will be important to achieve database platform independence and better search capabilities in the framework.