I learned the semi hard way on PoC system where the Mysql index corrupted.
I was lucky and could simply redeploy my application, but I have never used Mysql since.
I was lucky and could simply redeploy my application, but I have never used Mysql since.
With Postgres, you can just drop the binary table data files in, restart the database and pg rebuilds the indexes and relationships.
From a quick google, it now looks like MySQL is now more robust in this regard.