Running C5 on AWS RDS - PageSearchIndex
Permalink
We have a C5 based application running on AWS in a load balanced cluster using a multi availabilty zone Amazon Relational Data Service [RDS] form of MySQL.
RDS likes all tables to be INNODB as it then is able to offer point in time rollback
In C5 the PageSearchIndex table is MyISAM with a full text index -- can't do this INNODB
Amazon at this time doesn't assure point in time rollback if any MyISAM table is present.
This particular application does not use page search very much but does use user search.
Will we break anything by removing the index from PageSearchIndex and converting to INNODB? Slow is fine
Grateful for any comment.
PS
If anyone wants any tips on how to cluster C5 on AWS then feel welome to let us know. Cool setup and quite simple in long run
RDS likes all tables to be INNODB as it then is able to offer point in time rollback
In C5 the PageSearchIndex table is MyISAM with a full text index -- can't do this INNODB
Amazon at this time doesn't assure point in time rollback if any MyISAM table is present.
This particular application does not use page search very much but does use user search.
Will we break anything by removing the index from PageSearchIndex and converting to INNODB? Slow is fine
Grateful for any comment.
PS
If anyone wants any tips on how to cluster C5 on AWS then feel welome to let us know. Cool setup and quite simple in long run
http://www.concrete5.org/documentation/how-tos/developers/install-c...