That's great info, thanks. I really didn't feel like managing and DBA are my strengths at all, that's why I pressed for RDS. So far it's been good. We run reporting stuff and searching etc off a read replica. Putting fulltext into a separate table is a clever move. Will keep that in mind when it comes to refactor. Actually, I won't, as I just handed in notice :p
That's great info, thanks. I really didn't feel like managing and DBA are my strengths at all, that's why I pressed for RDS. So far it's been good. We run reporting stuff and searching etc off a read replica. Putting fulltext into a separate table is a clever move. Will keep that in mind when it comes to refactor. Actually, I won't, as I just handed in notice :p