CakePHP Database - MyISAM, InnoDB, or Postgresql
I've always just used MyISAM for all of my projects, but I am looking for
a seasoned opinion before I start this next one.
I'm about to start a project that will be dealing with hundreds of
thousands of rows across many tables. (Several tables may even have
millions of rows as the years go on). The project will primarily need
fast-read access because it is a Web App, but fast-write obviously doesn't
hurt. It needs to be very scalable.
The project will also be dealing with sensitive and important information,
meaning it needs to be reliable. MySQL seems to be notorious for ignoring
validation.
The project is going to be using CakePHP as a framework, and I'm fairly
sure it supports MySQL and Postgresql equally, but if anyone can disagree
with me on that please let me know.
I was tempted to go with InnoDB, but I've heard it has terrible
performance. Postgresql seems to be the most reliable, but also is not as
fast as MyISAM.
If I were able to upgrade the server's version of MySQL to 5.5, would
InnoDB be a safer bet than Postgres? Or is MyISAM still a better fit for
most needs and more scaleable than the others?
No comments:
Post a Comment