Originally Posted by mohtasham1983
I have developed a few web based applications interacting with MySQL. They were mostly small and didn't require much design and I could do everything on a piece of paper.
However, I'm going to develop a new application with a relatively complex database schema. I'm pretty sure a piece of paper cannot help me with this application anymore.
I was wondering if there's any cool software that can be a replacement for paper when thinking and designing about database architecture?
Thanks in advance.
I don't know of any, but I've been down that road before. The best thing I can suggest, is to keep a VERY close eye on things, specifically the transactions that are going on. You can do things like splitting up tables on different spindles, or optimizing the queries.
I've seen things scale up well, until a certain point, then have problems. Plateauing is the term, and it's hard to see coming, and harder to fix. I know Oracle has some good tools, but all the MySQL stuff I've done has been relatively small.