MySQL is ideal for storing application data, specifically web application data. Additionally you should use MySQL if you need a relational database which stores data across multiple tables. As MySQL is a relational database, it's a good fit for applications that rely heavily on multi-row transactions
One of the reasons MySQL is the world's most popular open source database is that it provides comprehensive support for every application development need. Within the database, support can be found for stored procedures, triggers, functions, views, cursors, ANSI-standard SQL, and more.
Ease of use. MySQL is a high-performance but relatively simple database system and is much less complex to set up and administer than larger systems. MySQL is fast. Its developers contend that MySQL is about the fastest database system you can get.
