MySQL Reviews

My opinion on MySQL is that it is the second most popular database after Oracle, and we are using MySQL for several of our customers. So far, my experience with MySQL is very good for organizations that consider database security and availability as priorities. These features are already available with MySQL. Security is inbuilt with the database, and clusters are also possible using MySQL. Availability and sharding features are present, which is why this is a larger database.

I think its replication capabilities are very good.

MySQL has helped my customers' database management by providing better RTO and RPO. The RPO can be less, RTO can be less, using this replication software. It's an inbuilt feature of the database itself, and you don't have to purchase an additional license for the replication.

Regarding their documentation and interface, there is room for improvement. Documentation is definitely required when running multiple databases on a cluster system. The load balancer, MySQL LB, which is used to connect to the application, lacks clear documentation. When there are multiple application servers connecting to the MySQL cluster and going through the MySQL load balancer, the documentation is not user-friendly. It's there, but only technical persons with deep knowledge of the MySQL database can implement it. Most of the community users or ISVs who use MySQL don't have many technical persons or DBA experts, so they face some challenges for the high availability of connecting high available databases from high available applications. That documentation should be simplified.

When we talk about their performance, I never hear from any of my customers about bugs, problems with stability, or updates.

I would rate the technical support for MySQL as very limited since normally everything is available on the blog post. I have never reached out to the support team or Oracle support team for MySQL-related support, so I cannot comment on this.

Neutral

In my opinion, this is not a pretty expensive tool. It is reasonable because it does not base on different components. Oracle has different components, so if you need security, you have to procure a different license, but here everything is inbuilt and it's not costly.

From their competitors, they could learn from PostgreSQL. Recently there was a discussion where a customer was planning MySQL to PostgreSQL migrations, but finally, they decided to stop moving out from MySQL because of benefits such as sharding features, availability, and clusters. These are not apple-to-apple comparisons between both products. There are some other similar options such as MariaDB, but it's not that popular. Though the base is the same for MySQL and MariaDB, it is not as widely used.

I would assess the value of ACID compliant transactions in MySQL as good, pretty good.

When it comes to spatial extensions, I haven't used spatial extensions for MySQL database, so I cannot comment at this stage.

It's difficult to say how many user transactions MySQL handles for my customers who have applications. I don't have that figure at this stage, but I know big organizations are using MySQL where up to 10 to 20,000 transactions per five to six hours are processed.

The main weaknesses of MySQL depend on the context. For critical workload and financial transactions, customers don't use MySQL; they use Oracle. Talking about our customers, I don't get any complaints that they are facing challenges with MySQL that make them want to move to other databases.

There is no problem with their marketing strategy, as they have been very active for the last two to three years. Initially when Oracle took over this database, there was no dedicated team. Now there is a dedicated team, and they are doing very well with their marketing strategy for MySQL.

Their implementation is very easy.

I believe they have all the features which the segment of customers using this database requires. All the features are available, and MySQL is releasing new features regularly, such as enhancing the security postures. I don't think any new features are required at this stage.

I rate MySQL a nine out of 10, and there is no limit to what they could do to make it even better. Whatever performance or new features you're going to add, somebody else will ask for different features.

MySQL is my primary choice for a transactional database in backend application development. I use this technology in my application development to store user data frequently in a structured form within a relational database management system. I store and manage application data such as user information, orders, payments, inventory, and other business entities. MySQL supports CRUD operations including transactions, indexing, joining, and stored procedures, enabling reliable and efficient data access for Spring Boot and microservices-based applications.

In my projects, particularly in an e-commerce application which is a digital supply chain management system, I use MySQL and integrate my application with a distributed architecture. In one of my projects, we built a microservices-based payment and order management system using Java, Spring Boot, and MySQL. I added the dependency of MySQL so my application interacts with the database through Spring Data JPA. Each microservice, such as order, payment, and inventory, has its own dedicated MySQL database, following the database per service pattern. MySQL handles transactional data including order and payment records and inventory updates, ensuring consistency through ACID transactions. MySQL's reliability, transaction support, and integration with Spring Data JPA made it a key component for our microservices architecture, helping ensure data consistency and strong performance while allowing each microservice to scale independently.

I use MySQL to store the data for my transactions. For payment scenarios or storing order information, I consistently increment and decrement the inventory based on user transactions. We utilize an event-driven architecture that provides loose coupling in the applications and enables high throughput, allowing us to store data easily in the database.

MySQL stands out for its reliability, performance, and the ability to perform strong CRUD operations, making it easy to integrate with Java Spring Boot microservices applications. One of its biggest strengths is ACID compliant transactions, which are essential for maintaining data consistency in applications such as order and payment processing. I also find indexing and query optimization very valuable, while its replication capability, scalability options, and strong community support are major advantages for enterprise applications.

One feature that made a significant difference for me is the indexing feature of MySQL. In our order and payment management system, certain APIs support filtering, sorting, and pagination on large data sets. As the amount of data grows, some queries become slower because they have to scan large portions of the table. We analyze the execution plan using explain and added indexes on frequently searched columns such as order ID, customer ID, payment status, and created date. MySQL's combination of transaction support, indexing, reliable query execution, and seamless integration with Spring Boot and Hibernate helps me build scalable and high-performance reliable backend services.

Another important feature is ACID compliant transactions. During payment processing, multiple database operations such as updating payment status records, recording transaction details, and creating audit records need to either all succeed or all fail together, which is critical for maintaining the integrity of financial data.

Replication is one of the best features in MySQL for Spring Boot or microservices. I can segregate the read operations so that the application does not overload the system, as I have separated write and read databases. I distribute the read transactions, allowing the application to run smoothly while write operations are done on the primary database. This effectively scales the application for high throughputs since both operations are managed independently without overloading a single database. I would also highlight MySQL's replication support for improving scalability, reliability, and availability, along with a strong community, excellent documentation, and a well-established ecosystem that simplifies application development, troubleshooting, and maintenance in production.

MySQL has a positive impact on my organization by providing a reliable and high-performance database for my business-critical applications in the order and payment management components. It ensures transaction consistency through ACID compliance, which is essential for maintaining data integrity. By optimizing SQL queries and adding indexing on frequently accessed columns, I significantly improve API response times for search, filtering, and reporting operations. MySQL contributes to improved system reliability, faster application performance, and higher developer productivity, creating a positive impact on my organization that employees appreciate.

MySQL is a reliable and mature relational database, but there are a few areas where it could be improved. One area is horizontal scalability. While MySQL supports scaling for applications, handling write-heavy workloads often requires additional solutions such as sharding, which adds complexity. Another area where it could improve is in native support for advanced analytics and large-scale distributed processing, which may require specialized databases. Changing the database schema on large tables can also be challenging and may require careful planning to minimize downtime. Performance tuning is powerful, but identifying and optimizing slow queries often requires manual analysis and experience. Having more built-in performance insights and automated optimization recommendations would be helpful for administrators.

In terms of documentation and security, I think MySQL could be improved in those areas. While the official documentation is comprehensive, it can sometimes be difficult for beginners to navigate, especially for advanced topics such as application partitioning and query optimization. More practical examples and architecture-focused guides would be beneficial. On the integration side, MySQL already works well with frameworks such as Spring Boot and Hibernate, but enhancing support for modern cloud-native deployments, Kubernetes, and automated observability would simplify operations. MySQL is a mature and dependable database, and I hope to see improvements primarily around administration, better operational tooling, and a smoother developer experience rather than fundamental database capabilities.

I have been working in my current field for five years.

I observed API response times for search, filtering, and pagination improved by roughly 30 to 40% in my testing and production monitoring after optimizing many queries using MySQL and applying indexing on the join columns. Although I do not have formal organization-wide KPIs specifically for MySQL, I also reduced the number of slow query incidents, and developers now spend less time troubleshooting database and performance issues.

One piece of advice for others looking into using MySQL is to design their schema carefully, use proper indexing, monitor query performance, and follow database best practices from the start. MySQL is a reliable and mature database that works very well for transactional applications and integrates seamlessly with modern frameworks such as Spring Boot.

MySQL is popular for its consistency, specifically based on ACID compliance. Overall, it consistently meets my needs for reliability, performance, and scalability. It is easy to integrate and well-supported by the community, making it an excellent choice for enterprise applications. I would definitely recommend it to organizations building transactional and microservices-based systems. I would rate my overall experience with MySQL as an eight out of ten.

I used MySQL mostly for college projects. I have used Postgres, but for the use case that I utilized it for, I do not think it was interchangeable with MySQL. To be frank, I do not really know the nuances.

The best features with MySQL are the fact that it is open source and a relational database. The best part about using MySQL was that it was open source, so it was pretty easy to understand and get materials to learn.

MySQL has good documentation and online support. It is pretty good in terms of integrations, continuous integrations with different tools, and customization options.

MySQL was not scaled up, so I did not use the replication capabilities. I do not think MySQL's data security features were at an industrial level for my project, so I did not make use of them. I was mostly using indexes.

I would advise people thinking about using MySQL to look up if the indexing mechanism is useful for their needs and then accordingly select the right database, and also consider if relational databases make sense for their use case. MySQL uses B-trees, so indexing could not be relevant to some use cases.

I did not use any ACID compliant transactions with MySQL.

From my experience, MySQL was pretty stable.

I know MySQL has been used in industries by a lot of companies, which means that it is scalable. That is the extent of my knowledge. It should be good because MySQL has been used by industries. I know Facebook uses it.

I would rate the documentation and online support a 10 out of 10.

Positive

I do not deal with Oracle products anymore. That was just a one-time thing that I had for college.

Unfortunately, I do not deal with AWS, Google products, or Azure products because they are usually paid.

MySQL is a very useful database which is used by a lot of companies, so it should be really good. I mostly dealt with MySQL in the last 12 months. My experience with MySQL overall was pretty good. I would rate this review a 10 out of 10.

In my current role as a software developer, we are using MySQL in one of our old projects and in the new project as well, specifically for storing the device data from energy meters that send voltage, current, and other related information.

Basically, in our project, we have some APIs that our device calls. Once the data is received by the API server, we put it in BullMQ, and from BullMQ, we have set up the consumer that consumes the data and puts it in MySQL. Over MySQL, we built a dashboard to show the energy trend, users, and load averages both device-wise and in groups based on averages. We have created an analytics dashboard for the energy meters using MySQL.

In my work, we use materialized views by running a cron job over the server, utilizing it in two ways: one is from the application server that inserts data into another table for analysis, and the second is for making materialized views where we aggregate data such as daily averages for devices and groups of devices. Inside those views, we store group-wise metrics such as average current, average voltage, peak load, and average kilowatt usage per hour. We also present these views on our dashboard, providing users the flexibility to select devices and create views for real-time rendering.

We use Tata Communications as our cloud provider for this hybrid cloud deployment.

We have used MySQL from the start, as we had experience with it, and it is straightforward to set up and easy to manage with fewer people.

One of the best features MySQL offers is the materialized view that I use. Additionally, as it acts as a transactional database, its transactional properties are useful, although they are not much of a concern in our use case since we focus on device data.

The main feature we utilize in MySQL is the view, and I can say that it is the most valuable feature for our needs.

My organization has experienced positive impacts from MySQL, as it provides exceptional capabilities.

MySQL can be improved. While I do not see any significant improvements needed for MySQL in my use cases, I would consider it if any arise in the future.

I have been using MySQL in the industry for two and a half years, and I used it for approximately three years during my college time.

MySQL is stable.

MySQL's scalability is currently adequate, as we have increased operations from ten thousand to twelve thousand devices, and it is working fine for us, but we will monitor for any future issues.

We have not needed to reach out for MySQL's customer support, as the community provides solutions for any issues we face.

I have evaluated other options such as PostgreSQL, as it is better for analytics queries, but its primary and secondary index concept makes updates slower compared to MySQL, which leads us to use MySQL.

The initial setup for MySQL is straightforward and easy to manage with fewer people.

I have seen a return on investment with MySQL, as it allows us to manage with fewer employees, focusing on business logic rather than database management.

My experience with pricing, setup cost, and licensing for MySQL has been good.

I rate MySQL a nine out of ten. I choose nine out of ten because while there should always be room for improvement, I do not see any necessary adjustments in my use case since it is working fine.

I advise others considering MySQL to start with it if they have small teams and are undecided about which database to use. It is easy to set up and allows you to focus on your business logic initially without going for more complicated databases.

MySQL meets our expectations for our use case so far. We will see what the future holds. My overall rating for MySQL is nine out of ten.

We are using two or three types of databases in our organization, such as Oracle and MySQL. We usually use the MySQL database for the business applications that we develop in-house.

The most valuable feature is the on-premises data encryption facilities. By default, we can provide encryption, and this feature in MySQL is why we prefer it over other databases. The native encryption in MySQL encourages us to use this database model more frequently compared to Oracle and other databases. 

With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment. It perfectly supports our ROI, and we have no issues with its functionality.

The data masking functionality should be improved as well as the native encryption functionality in the MySQL database. It could be more beneficial if MySQL can enhance its data masking functionality in the same way it has improved data encryption.

I have been using it for around ten years.

We face certain integration issues, especially when we integrate the database with security solutions like IBM QRadar, which affects database performance.

We have a local vendor available here in Pakistan, who provides service. As far as the principal is concerned, we do not directly communicate with them. We have a vendor here, so we have no issues and usually receive timely responses. I would rate customer service nine out of ten.

Positive

We are working with Oracle, and we also use a file database called GT.M.

It is a pretty simple deployment process that can take around two to three hours.

We have a dedicated database administration team responsible for implementation. We have around five to ten people in the team.

We estimate the ROI to be around 40%.

With respect to BAM, database activity monitoring, when we integrate BAM solutions, we face certain integration challenges. These are mainly compatibility issues, like when IBM Guardian is integrated with MySQL for database monitoring. Despite these challenges, the availability of support from IBM helps us to overcome them. 

The product is highly recommended for its compatibility with other platforms like dot net framework. It easily integrates with in-house development functionalities and provides excellent relational database functionality. 

Overall, I give it an eight out of ten.

Positive

Right now, I don't work very effectively with the tool. I am more like an architect currently, so I don't have to go deep into MySQL. In my company, we don't use Azure yet. Teamcenter PLM software is set up using Oracle or MySQL. We need to install Oracle or MySQL.

I used the tool for technical things for ten to twelve years. Right now, I have lost touch with how to use it.

The product is cost-effective, less expensive, and much faster, considering the way my company structures the data and the solution handled. The only thing is that if there are 10,000,000 or 20,000,000 records, it will slow down a bit. If the data is less, the performance is good. Once the data keeps on increasing, such as if we work with five terabytes of data and go up to nine terabytes of data, MySQL finds it difficult to handle the data. Huge amounts of data can only be managed by Oracle.

The performance issues in the product can be considered as an area where improvements are required.

I have experience with MySQL.

It is a stable solution. Stability-wise, I rate the solution a nine out of ten. Once the data increases, the tool will face some issues.

Scalability-wise, the product works very well. I rate the solution's scalability an eight out of ten.

My company usually deals with big companies having a minimum of around 2,000 people.

I have not contacted the product's support team since everything is available on the internet.

I used Dropbox when it was initially introduced. I had put so many documents into Dropbox, but I stopped using it. It has been a long time since I have used the product. I had used the product when it was launched, and the tool was giving two GB or three GB for free.

The product's initial setup phase is very easy. I rate the initial setup phase a nine to ten out of ten.

My company uses MySQL's corporate licenses.

In terms of our organization's data management strategy, especially if I talk about PLM software, which is about data management and can be regarded as the core data management of the products that we make. When we are designing something, specifically a new product, it is a critical area, especially considering that I am in the energy sector. In the energy sector, when we are building huge turbines and other things, the data might have intellectual property aspects attached to it. Even within the company, one region cannot see other regions to the extent to which the product offers security. In my company, we use PDM and PLM from Teamcenter effectively.

MySQL is not a tool my company uses in production. When we create some small demos, we use MySQL. For production, we would use only Oracle because it is the most stable tool in the market.

When we install Teamcenter, we don't need to touch the database. We just need to make some references to figure out this is the database, and it automatically creates everything. The basic thing about PDM and PLM systems is that the user should never touch the database because people may corrupt the data model or do anything that will have a very bad impact on the system. Database modifications only have to be made to the PLM system. We are not supposed to interact with the database directly.

The tool is very lightweight, less expensive, and sometimes it is free. It is a very usable tool that is preferred by a lot of people. Only for production use, I may ask people not to use it.

Integration of MySQL is like how we don't directly integrate PLM with Oracle. We have to use PLM's APIs to talk to the database. As a part of the best practices, we should not directly integrate anything with the PLM database. Feature-wise, the integration capabilities of the product are easy to use. It is like any other tool where if there is a table, there is a property. If you want to map a property using any middleware, then we can easily do that.

I recommend the product to others. For medium-sized companies, MySQL is one of the best solutions. Medium-sized companies can choose not to go for Oracle, which is very expensive.

In terms of the value or benefits derived by our company from the use of the product, I would say that it is not very expensive and provides performance along with scalability. The product can cater to the needs of customers ranging from 2,00,000 to 6,00,000 to 10,00,000 records. Even 20,00,000 records are fine, but after that, users may get into trouble. It is the best tool for mid-sized companies with a reasonable amount of data.

I rate the tool an eight out of ten.

I use MySQL as a metadata database to store information about our product and transactions from other platforms. We extract and store these transactions daily.

I find MySQL's relational data storage format very useful for data management. Our structure is well-defined and easy for end users and business stakeholders to read. I appreciate the tool's simplicity and ability to integrate with our backend tools.

Performance optimization techniques in MySQL are foundational and very useful. Many big database tools are based on their techniques. We use basic optimization methods like indexes and constraints, which should be set up early when designing the database schema. These optimizations are important for us and work well with MySQL.

As for areas that could be improved, the tool is often used as a local database on laptops. But now, we're moving to cloud-based solutions that are more scalable and highly available. I think the tool should offer a cloud database option. This would let users keep a local copy of data if needed, but also have their data available across different regions through a cloud account. 

The product's stability is high. 

I rate the tool's scalability as about six out of ten. It's moderate since it's a relational database, so scalability depends on the data volume we can store. We use MySQL mainly for structured data in its final state. About 1800 people use MySQL in our organization. Around 1200 use it daily, and about 600 developers use it for local databases or small project tasks.

MySQL has been in the market for a long time, and its community keeps growing. As developers, we've gotten full support from them since we started using it. This includes help from their support team and software team and assistance with any technical issues we encounter.

Positive

I'd rate the initial setup as nine out of ten for ease, with ten being the easiest. It's very simple for beginners to set up because the documentation is thorough, and each step is well explained. The deployment usually takes minutes to hours, depending on the data volume we're putting into the database. It typically doesn't take longer than a day.

MySQL has had a moderate impact on our cost efficiency so far. We mainly use it for local development in our internal environments. For production, we use other cloud solutions. However, MySQL's impact on our operational productivity is significant. It's very reliable for all the solutions we're building.

I rate the solution's pricing as four out of ten, where one is cheap, and ten is expensive. For our basic needs, it's quite affordable. However, the cost increases when we need to scale up or require high availability. Our developer team of about 600 people uses MySQL without much issue. The pricing becomes more of a concern on the business side, as we have more end users and need constant database availability and scaling. In those cases, the solution gets a bit more expensive, even though it provides good value for the business.

I rate the overall solution a nine out of ten. 

MySQL was open-source at the beginning until Oracle acquired it in 2010. I started working with MySQL because I was an Oracle expert, having worked for Oracle for eight years. That's why I added MySQL to my skills as an administrator. MySQL is a powerful database engine that is easy to install, manage, and work with. It's ideal for fast application deployment and is cost-effective as well.

MySQL is for metadata and data. My organization has used it to store data about hardware servers and their configurations, including network and storage configurations. MySQL is an RDBMS engine, so it can be used for any business application.

MySQL has a straightforward installation process, is lightweight, and easy to manage. Compared to its competitors, it is more accessible and user-friendly. While competitors like Oracle are known for their extensive features, they are often more complex to install, configure, and maintain, requiring experts to manage them, which can be costly. MySQL, now owned by Oracle, may not have the same feature set as Oracle's flagship database, but it is simple to install, manage, and cost-effective. MySQL is a viable option that can be enhanced with additional features, making it reliable for small to medium-scale applications and capable of effectively handling substantial amounts of data.

MySQL is now in a real application cluster. In terms of high availability, MySQL can be configured for active-active or as a real application cluster.

I have been using MySQL for ten years.

When MySQL is involved in the metadata, it never gets down. It's very stable.

It's secure. MySQL supports large databases that can contain nearly fifty million records. It also supports up to sixty-four indexes per table.

They provide 24/7 support. It provides faster resolution and identification.

Positive

It is very easy to install and takes an hour to complete.

I rate the initial setup a ten out of ten, where one is difficult and ten is easy.

It is open-source and supported by Oracle.

Oracle occupies it, so Oracle added more security features, such as password system improvements, host-based verification, and encryption, to the MySQL engine. It's developed and managed by a big company, and they keep adding new features.

I recommend another solution for large data, like billions of records. However, MySQL is a good option for data up to about fifty million records.

Overall, I rate the solution an eight out of ten.

We use MySQL in multiple projects for storing, task management apps, and dating apps.

MySQL is the best option for the Laravel PHP framework. It supports multiple model systems, and it's very easy to call MySQL compared to other languages like MongoDB. I prefer MySQL for the Laravel PHP framework.

The solution's security features depend on where we host our server and database. We have some preventive measures to reduce attacks. We have taken authentication and only allow a particular IP address.

In MySQL, we need to define every table beforehand.

I have been using MySQL for four to five years.

In MySQL, we need to define every table beforehand. However, we don't need to do so in MongoDB. We can add a new row or column in MongoDB anytime, making it much easier. If you purchase MongoDB's plan, it supports many security features, and you don't need to check about security. They will handle everything.

The solution’s initial setup is very easy. For the first time, the solution's implementation will take some time. However, you can use it multiple times after you configure it.

MySQL is a cheap solution.

Maintaining the database is a task. We take a weekly backup for each database so that we can upload it to the server if anything happens to the data. We created a cron job so that the data can be taken and then uploaded to a specific space so that we can go back to the particular big data whenever we want. I prefer MongoDB for scalability because it's much easier to maintain MongoDB.

Just one person is enough to maintain the solution. The solution has good documentation available on Google.

Overall, I rate the solution six and a half out of ten.