8 Key points while building MySQL based Application

MySQL a open source database which is readily available with all major web hosting as well as cheep web hosting Services. A quality of application can be build on MySQL database with those famous 3P’s – Php, Python, Perl Also MySQL is available for Windows, Mac as well as Linux in Binary and library form. You can customize MySQL source code & get it compiled for your application.

Here are 8 key points that you have to keep in mind before building MySQL based application

• When designing MSQL-based applications, you should decide which engine to use for storing your data. If you don’t think about it during the design phase, you will likely face complications later in the process
• MyISAM merge table – rather then always logging all data to same table adjust the application to log to a that contains the name or number of the month in its name
• You can use MySQL’s built-in Replication to clone your existing table and use the clone table to perform reporting or resource intensive query
• When you deal with any sort of order processing, transactions are a requirement using transaction-safe table types InnoDB or BDB, these unfortunate “data surprises” can be avoided.
• If you’re running a high-traffic web service that has a real-time quote feed and thousands of users, a query should never have to wait, so the row-level locking provided by InnoDB tables is the way to go.
• MySQL’s query cache can often be a big help in situations in which an application issues the same query over and over with the same parameters.
• If you ever need to distribute a CD-ROM- or DVD-ROM-based application that uses MySQL data files, consider using Compressed MyISAM tables.
• Several techniques are available to convert one table type to another , ALTER TABLE, DUMP and ReIMPORT, CREATE and SELECT each with advantages and disadvantages

Above Points are not full list but its some of most important points that need to consider before actually starting building application

Wordpress A popular Blogging tool is also based on MySQL database with Php as application scripting