Easy to use and open source with almost endless community support
What do you like best about the product?
With Endless online community support and easy of use its a global standard and built in to many web applications. The cost is essentially free and if your purpose is for something like an internal intranet or portal page its perfect. I use it every day for our internal holiday and CRM system as well as for business reporting and it just chugs along with little attention needed.
What do you dislike about the product?
Not as robust and business critical as something like MSSQL but also a hell of a lot cheaper and I still run my companies business analytics and internal intranet pages 24/7 on it with no issues
What problems is the product solving and how is that benefiting you?
It offers a cheap alternative for not critical business database needs
Solid RDBMS for web-scale applications
What do you like best about the product?
I value the InnoDB storage engine for its support for ACID-compliant transactions and its efficient handling of read-heavy operations. The native replication capabilities provide a standard method for scaling out reads and implementing high-availability architectures. The ecosystem includes functional tools like MySQL Workbench, which assists directly with data modeling, server administration, and SQL development. Its cross-platform compatibility ensures a consistent database environment across various operating systems. Finally, the extensive technical documentation and large community make it possible to find solutions to most technical issues.
What do you dislike about the product?
Achieving high performances requires a significant investment in configuration tuning
What problems is the product solving and how is that benefiting you?
Over the years, MySQL has been a foundational component of our technology stack, consistently solving the core challenge of reliable data management as our business has grown. In the beginning, it provided a stable, no-cost entry point for a relational database, allowing our initial application to launch on a proven and secure platform.
As our operations expanded, the problem shifted from simple data storage to managing performance at scale. The primary benefit we've realized is architectural flexibility over the long term. Instead of facing a costly and disruptive migration to a new system, we used MySQL's own features to evolve. By implementing master-slave replication, we were able to offload read-intensive analytics and reporting tasks that were beginning to slow down our main application. This has allowed us to scale our services efficiently, ensuring system responsiveness and stability without needing to re-engineer our entire data layer. In essence, MySQL has provided a continuous and scalable path, supporting our technical requirements year after year.
Analysis of customer purchasing patterns and user actions has been effectively facilitated
What is our primary use case?
The primary use case for me is mainly to identify patterns. I am part of a data science team, and our job is to interpret user actions, such as when customers place orders on platforms like Amazon or eBay. We analyze patterns such as how many products are being quickly purchased, what additional items customers are buying, and where demand is surging.
What is most valuable?
Both
MSSQL and Oracle are versatile tools in their own ways. If we compare
MSSQL and Oracle, MSSQL is very handy for accessing data through SQL Server Management Studio. It allows programming, writing stored procedures, creating views, constraints, and triggers easily. There is some parity between SQL Server and Oracle, but Oracle is tightly coupled to its applications.
PostgreSQL is better for handling JSON files and database migrations.
What needs improvement?
Oracle could improve on scalability. Currently, to meet scalability requirements, utilizing cloud computing is necessary, which is costly. Especially as
PostgreSQL, an open source solution, is gaining popularity in the market.
For how long have I used the solution?
I started using these solutions since 2008 and continue to use them as part of my work domain.
What do I think about the stability of the solution?
MySQL solution is overall stable. I did not see any challenges.
What do I think about the scalability of the solution?
Scalability is a concern. While both solutions are good regarding scalability, open sources like PostgreSQL are competing well. Meeting scalability requirements through cloud computing is an expensive affair.
How are customer service and support?
Regarding
MySQL and Oracle support, I hardly use it much.
How would you rate customer service and support?
What's my experience with pricing, setup cost, and licensing?
I am not involved in purchasing the tools. Someone buys them for me, and I work on them. I hardly care about the cost.
What other advice do I have?
For MySQL, I hardly used it, but I can rate MSSQL and Oracle. I rate both nine out of ten. They are robust enough, though JSON handling could be improved. Meeting JSON handling needs would reduce the reliance on NoSQL solutions. I rate the overall solution a nine out of ten.
I worked with MySQL since more than 5 years
What do you like best about the product?
It's easy to use and integrate, and also to work with it
What do you dislike about the product?
Sometimes is harder to make complex reports with data from DB
What problems is the product solving and how is that benefiting you?
Store related data in relevant places and connect them when needed
Good and human friendly query type
What do you like best about the product?
The things which i like the most the user friendly interface and user friendly query language. Easy Integration
What do you dislike about the product?
The think which i don't like in mysql is the mysql workbench
What problems is the product solving and how is that benefiting you?
Easy query type which would realy beneficial for long query and stable data injection.
Most Popular Relational Database Solution Businesses
What do you like best about the product?
The minimal UI with all the function doc
Easy to use & convenient
What do you dislike about the product?
Sometimes my queries won't auto-save - or query recovery issue
What problems is the product solving and how is that benefiting you?
Scapaing the data in a meaningful format.
Making database entries is very simple and seamless.
Native encryption ensures secure data management with a simple deployment
What is our primary use case?
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.
What is most valuable?
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.
What needs improvement?
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.
For how long have I used the solution?
I have been using it for around ten years.
What do I think about the stability of the solution?
We face certain integration issues, especially when we integrate the database with security solutions like IBM QRadar, which affects database performance.
How are customer service and support?
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.
How would you rate customer service and support?
Which solution did I use previously and why did I switch?
We are working with Oracle, and we also use a file database called GT.M.
How was the initial setup?
It is a pretty simple deployment process that can take around two to three hours.
What about the implementation team?
We have a dedicated database administration team responsible for implementation. We have around five to ten people in the team.
What was our ROI?
We estimate the ROI to be around 40%.
What other advice do I have?
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.
Which deployment model are you using for this solution?
On-premises
MySQL database review
What do you like best about the product?
MySQL is a tool used to manage databases and servers. While it's not a database itself, it's widely used for organizing and handling data within databases. It's popular because it helps with efficiently managing and organizing data, making it a great tool for this purpose.
What do you dislike about the product?
Sometimes the website got 503 DB error so we need to repair the DB but it is improving day by day.
What problems is the product solving and how is that benefiting you?
It is helpful for managing databases and servers, providing significant assistance.
Most Popular DB Software
What do you like best about the product?
I've been using MySQL since my graduation. It's very easy to use and navigate. I can also easily import big excel files here.
What do you dislike about the product?
When going for big data analysis, MySQL gives problem. Additionally, it's challenging to find issues in previous queries when I wanted to make some corrections.
What problems is the product solving and how is that benefiting you?
I am preparing to become a Data Analyst and I use MySQL and Excel both, and MySQL has made running queries easier.
Working with sql
What do you like best about the product?
MySql is really helpful for saving/retreiving data to/from rational database
What do you dislike about the product?
MySql is greatly helpful to integrate in our application for database management.
What problems is the product solving and how is that benefiting you?
It is much easy to learn mysql queries and run those queries to perform operations
