I'd love to get rid of MyISAM. Doing the course of alpha testing it was corrupted once and that never happened with our InnoDB tables. Also, looking at Tokutek as the long term solution for all tables. The jump from InnoDB to Tokutek is straight forward if fulltext is taken out of the mix. I really wish Tokutek biz dev would talk to Amazon about offering the storage engine in RDS. Any who, can you speak to the maintenance profiles of the two? It seems like Sphinx is pretty hands off. Also having many years of Java experience, I feel like Sphinx might be a better bet if I start off running in a memory constrained environment like an EC2 small or medium.
I'd love to get rid of MyISAM. Doing the course of alpha testing it was corrupted once and that never happened with our InnoDB tables. Also, looking at Tokutek as the long term solution for all tables. The jump from InnoDB to Tokutek is straight forward if fulltext is taken out of the mix. I really wish Tokutek biz dev would talk to Amazon about offering the storage engine in RDS. Any who, can you speak to the maintenance profiles of the two? It seems like Sphinx is pretty hands off. Also having many years of Java experience, I feel like Sphinx might be a better bet if I start off running in a memory constrained environment like an EC2 small or medium.