MySQL

It is well suited to being a primary database for software that requires a constant link and access. If you require large amounts of data, then MySQL is for you.

MySQL is great for getting an application up and running quickly at no cost. Applications at-scale may find MySQL lacking, however, as millions of rows will degrade performance, so migrating to another system such as MSSQL before getting too large is recommended. Stored procedures are also a pain point as implementing them is not flexible.

If you need a reliable, performant database that can be setup extremely quickly and won't need to service applications for HUGE amounts of data, MySQL is perfect. It's free and open-source, and there are many tutorials online to setup in minutes. Most people who have worked with databases are familiar with MySQL, and probably have spent time using it since it is so popular.

MySQL is an excellent starting point for most application development that requires a full features database. When used in conjunction with standard database frameworks, it can be easily swapped in and out as needs change. It's fast enough to handle relatively large data sets with many millions of rows. As with any application development, however, it's not a silver bullet. There are scenarios where it is more appropriate to use NoSQL or caching databases instead.

Most of our use cases are for fairly small data sets that don't change a lot. MySQL really shines for us in these scenarios. But we have also used it to handle large data sets that are growing each day. When data sets get large there are many things you can do to handle them in MySQL but it isn't necessarily purpose built for those types of implementations - but it can work.

One of the best things about MySQL is that you do not have to worry about the cost! MySQL will work well for use cases across any type of business - small start-up to mammoth enterprise. Covers most use cases for database manipulation. It is just extremely easy to use too!

MySQL is very well-suited to read-intensive database applications. It is very fast. It is also a great enterprise database for new DBAs because it is easy to obtain and installs on a variety of systems and platforms. Although I have not directly experienced problems, MySQL developers report that transactions aren't handled efficiently and that its trigger functionality is lacking sophistication. The biggest problem I've seen with it is how difficult it is to maintain stored procedures. That is a very common complaint and not isolated to my applications.

Pretty good but not sure about performance scaling.

Great for free standing quick DB standup for Pilot Testing and PoC

Easy to integrate the data for monitoring real user interaction, pulling from other log monitoring tools and saving to MySQL is easy and efficient. Storing and rendering geographic information is not as easy as should have been.

It’s well suited for storing catalog data and less suited to store time series data.

For MySQL
Pros:

• Gives you the ability to host several databases on one server.
• Uses tables to store data.
• It has primary and foreign key constraints.
• Uses indexes to sort data and speed up performance, and supports both desktop and web applications.

Cons: If there is unstructured data, it's very hard to create a table.

It offers significant cost savings compared to other database management systems, as it is open sourced. MySQL is known to be the most secure database management system used in applications like Wordpress, Drupal, etc.

MySQL is not very efficient when it comes to using it for a larger database, as the request may be terribly slow or sometimes incomplete. Also its functionality seems to be dependent on add-ons a lot.

MySQL allows a user to select from a range of storage engines that enable you to change the functionality of the tool and handle data from different table types. The system is incredibly reliable and doesn’t hog resources. MySQL has an easy to use interface, and various commands such as batch commands that enables a user to process enormous amounts of data.

The new MySQL is great for areas where one requires concurrent database connections from users. It is fast and easy to manipulate.
MySQL cannot be used to store data inside applications that are run on android mobile. Instead they have to use TinyDB or any other alternative in order to not lag the application.

Even though My SQL does have it's cons, it also is the easiest software to use for data organisation and analytics.

Easy to implement and join dynamic queries. It provides a feature to create and retrieve data through different tables with the help of subqueries. Easy to handle a large amount of data with the help of multiple indexes.

If we have complex or dependency data we always prefer to use MySQL as it provides an RDBMS feature. If we have a larger amount of data it does not give a better performance.

MySQL is fantastic for those who just want to dip their toes in the water, as well as those Olympic style swimmers who are much more advanced. It is extremely flexible and there is a ton of support out there due to its increased popularity as a BI tool. I would definitely recommend using another BI tool that could integrate several MySQL databases together to avoid any lag times with reporting.

MySQL is a great teaching tool for database foundations of relational databases and SQL. MySQL is also suited for small to small/medium companies. Once a company gets to the medium to large range the needs for some functionality may not be met by MySQL and a bundled database suite may be more appropriate. I use it as a teaching and learning tool for database classes.

It works great for a small to large size business. Implementation has some lofty up front costs, but if you require a better system, the advantages outweigh the disadvantages. It’s nice because it also supports emerging technologies and has nice bolt ons to help tailor your digital infrastructure.

MySQL is great for research projects, startups, non profits etc... Basically MySQL is great for any one or any company that is budget minded. MySQL is also very good for products that are high read / low write scenarios especially when using the InnoDB engine.

I really like using this program. When I want to look up a vendor or an analyst it makes my job a breeze. By running directly into the platform, entering in a little bit of information and BOOM a list is able to be pulled up. I really like how user friendly everything is and how responsive customer services is when you have a question.

It is well suited to education environments where access to the attendance and billing is required over the Internet. Our student population was around 256 so if you are managing data for tens of thousands of individuals MySQL may not scale up to the much larger information store required for that student population data set.

When you're building a small website or a blog (with Wordpress, for example) it will suit just fine. As a developer, it's pretty easy to keep a version of MySQL running and manage it for many sorts of applications.