I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures.
MySQL offers reliability, performance, and cross-platform compatibility, making it a preferred choice for backend applications. Its open-source nature and cost-effectiveness, coupled with strong community support, enhance its appeal for developers.


| Author info | Rating | Review Summary |
|---|---|---|
| Programmer at Ministry of Interior | 3.5 | I would recommend MySQL for medium projects of around 100,000 users due to its indexing and stored procedures. However, it lacks performance for enterprise-level applications and falls short in security compared to DB2. We switched from Oracle due to licensing costs. |

I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures.
MySQL's performance needs to be improved for enterprise-level applications compared to Oracle and Postgres. That's the only drawback I found in MySQL. When the table storage is full, the solution's performance becomes slow. The solution's security needs improvement as DB2 is more secure than MySQL.
I have been using MySQL for more than ten years.
MySQL has good stability.
I rate the solution a six or seven out of ten for stability.
Around 150 users are using the solution daily in our organization.
I rate the solution a six out of ten for scalability.
We previously used Oracle. We switched to MySQL because Oracle's license was costly.
It's really easy to set up MySQL. On a scale from one to ten, where one is difficult and ten is easy, I rate the solution's initial setup an eight out of ten.
We implemented the solution in our organization through a consultant. It took a few hours to set up everything. Around one to two people were needed to deploy the solution.
MySQL is a cheap solution.
When you compare Oracle and DB2 with SQL Server and MySQL, all these come under RDBMS (Relational Database Management System). Since the licensing for Oracle and DB2 is costly, people will go for either MySQL or Postgres. People go for MySQL because it is better than Postgres in indexing and supports multiple data types compared to Postgres.
Just one person is needed to maintain MySQL. We didn't face any challenges using MySQL because of many open communities. If you have MySQL's commercial license, you will get good support. I would recommend MySQL to users who are going for medium enterprise applications.
Overall, I rate the solution a seven out of ten.
| Product | Mindshare (%) |
|---|---|
| MySQL | 12.7% |
| PostgreSQL | 11.5% |
| Firebird SQL | 10.0% |
| Other | 65.8% |
| Company Size | Count |
|---|---|
| Small Business | 58 |
| Midsize Enterprise | 26 |
| Large Enterprise | 48 |
| Company Size | Count |
|---|---|
| Small Business | 416 |
| Midsize Enterprise | 179 |
| Large Enterprise | 322 |
MySQL, known for its ease of use, is ideal for transactional databases, data management, and analytics. Its support for CRUD operations and ACID compliance ensures data consistency. Features like indexing optimize large queries, while replication boosts scalability. Despite its strengths, users express concerns about performance and scalability under large loads, along with the desire for improved clustering, backup capabilities, and modern tool integration. Enhancing the interface and expanding documentation can elevate the user experience.
What are the main features of MySQL?MySQL finds its place in web and ERP systems, supporting applications in e-commerce, financial services, education, and business intelligence. Its integration with microservices and cloud platforms enables efficient data management, making it suitable for customer management and transactional records in dynamic industries.
Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.