We are developers working on different types of projects. We use relational databases in some projects and non-relational databases in others. When we use relational databases, we use MySQL. When we use non-relational databases, we use our DynamoDB or MongoDB.
MySQL
JetwareExternal reviews
1,604 reviews
from
and
External reviews are not included in the AWS star rating for the product.
MySQL: Easy and Powerful
What do you like best about the product?
Mysql is an awesome database to learn for beginners. Mysql Database implementation is easy when compared to other databases. There are many plugins and packages to integrate into any code base without much effort.
We can use mysql for small scale projects. I had previously used in many beginner level projects. There are also lot of forums that help to troubleshoot any issues.
We can use mysql for small scale projects. I had previously used in many beginner level projects. There are also lot of forums that help to troubleshoot any issues.
What do you dislike about the product?
Mysql is so powerful but not suitable for large databases. Other than that everything looks fine.
What problems is the product solving and how is that benefiting you?
MySQL helps in efficiently storing, retrieving, and managing data from it with it's powerful queries.It also offers features like indexing and query optimization and caching.
Intense but rewarding
What do you like best about the product?
The possibility of scaling and learning at a good point is related to the great documentation and potential of the MYSQL service. The ability to use php-fpm, Apache with a multi-threaded module and MySQL with good configuration in your indexes from the beginning can take any small or medium-sized company to a good level.
What do you dislike about the product?
The learning curve can be somewhat tedious, but in the end it will be rewarding.
What problems is the product solving and how is that benefiting you?
Being a free service, you can save costs at the start of your business.
Beginners Relational Database
What do you like best about the product?
A very good feature for MYSQL server is that we can use it for desktops. Since it is open source, we will have a good community support for any kind of help. Also it is easy to learn and code.
What do you dislike about the product?
While installing sometimes connecting to local host will throw an error. I struggled a lot to fix that. Also the clustering part is not that much improved compared to other databases. Really slow for large databases.
What problems is the product solving and how is that benefiting you?
I have used MYSQL for study purposes for the first time. It helped in creating tables, inserting values, and much more. After that, I have used MYSQL to create ER diagrams for my new project in the office.
Also daily operation like UPDATE, TRUNCATE, GRANT etc., were done on the work bench itself
Also daily operation like UPDATE, TRUNCATE, GRANT etc., were done on the work bench itself
Provides powerful data querying.
What is our primary use case?
What is most valuable?
- Ease of Use: MySQL is relatively easy to set up, configure, and manage, especially with tools like MySQL Workbench and command-line utilities. Its widespread popularity also means there is ample documentation, tutorials, and community support available for users.
- Open Source and Cost-effective: MySQL is open-source software, which means it is free to use and can be customized according to specific requirements. This makes it a cost-effective choice for startups, small businesses, and projects with budget constraints.
What needs improvement?
Compared to some other database systems, MySQL may have limitations in terms of advanced features and functionalities, especially when it comes to complex data relationships and transactions.
For how long have I used the solution?
I have been using MySQL for two years.
What do I think about the stability of the solution?
In my past two years of MySQL experience, I found no bugs or breakdowns. It works completely fine.
What do I think about the scalability of the solution?
Many cloud providers offers managed mysql service with scalable architecture ,automated backups , monitoring and scaling. Leveraging this can solve the scalability problem.
How was the initial setup?
MySQL is very easy to install and use.
What's my experience with pricing, setup cost, and licensing?
As it is an open source and there is community edition available so if you have small or medium use case it is much cheaper to use.
What other advice do I have?
Below are some thing to consider while working with mysql.
1. Regular maintenance
2. Security consideration
3. Version compatibility
You can try MySQL if you have any use cases of relational databases. It is very easy for somebody to learn to use MySQL for the first time. The solution worked fine for me, with no breakdowns or scalability issues.
Overall, I rate MySQL eight and a half or nine out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Easy to manage, saves time, and provides good documentation
What is our primary use case?
I use the solution for personal use cases like software development, mostly database bug systems.
How has it helped my organization?
I used the tool to build our website. It is used as a database to store information.
What is most valuable?
SKIP LOCKED is a valuable feature. It prevents us from deleting things we put in the database. It's mostly for background jobs in the software development site in MySQL 8. It is a new feature. The solution easily integrates with other tools and systems in our IT environment.
What needs improvement?
The full-text search feature must be improved.
For how long have I used the solution?
I have been using the solution for the past three weeks.
What do I think about the stability of the solution?
I rate the tool’s stability an eight out of ten. We can create a database user schema. It's quite easy to update and remove in case anything happens. Backing up is quite easy. We have security features for the backup.
What do I think about the scalability of the solution?
I’m the only user in my organization.
How are customer service and support?
The product provides good documentation online.
How was the initial setup?
It is easy to deploy the product. I deployed it on my own. The deployment took an hour. We deploy the product using Kamal. It uses Docker. The tool is deployed on the cloud. To deploy the solution, we just have to enter the password in the server and deploy it. It wasn't much of a hassle.
What was our ROI?
The tool is easy to manage and saves us time. It has much less complications.
What's my experience with pricing, setup cost, and licensing?
We're using the community version. The tool is open source.
Which other solutions did I evaluate?
I also use PostgreSQL.
What other advice do I have?
The tool helps us get the job done. It is not very complex. Overall, I rate the product a nine out of ten.
Easy to use, code is easy to write and understand
What is our primary use case?
I don't use MySQL extensively, but I use the code within MySQL for preparing some reports and all that.
What is most valuable?
Code is easy to write and code, it's easy to understand. That's why it's widely used. The queries are very easy to understand and [write the] code. For coding, it's very easy.
What needs improvement?
The user interface could be more user friendly. Mainly because most of the times we see black and white digital lines. Something like Python.
For how long have I used the solution?
I have been using it for three years. I have been using it since 2021.
What do I think about the stability of the solution?
I haven't experienced any bad things.
What do I think about the scalability of the solution?
It is widely adopted in our company. We have around 60% of our total employees using it.
How are customer service and support?
We have an internal support team. We usually connect to them, and they will resolve the issue. We don't need to connect to the MySQL team directly.
How was the initial setup?
The initial setup is not very difficult. It's easy only.
What's my experience with pricing, setup cost, and licensing?
The pricing is not much expensive, it's cheap only.
What other advice do I have?
I would recommend it. For beginners, it is pretty much easier compared to other tools. The queries are very similar and easy to learn in a short span of time.
For beginners, it is very easy to use. It would be something easy to learn. It is a perfect tool for beginners.
Overall, I would rate the solution a seven out of ten.
Easy to use and can be used to store data
What is our primary use case?
MySQL is an open-source relational database management system used to store data.
What is most valuable?
MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability.
What needs improvement?
MySQL could introduce more indexing strategies. There are a couple of strategies where you can index things to be more searchable and visible. We lack that kind of functionality. For example, if your name is indexed correctly with a certain strategy, it can improve the search results faster. The solution’s interface could be improved.
For how long have I used the solution?
I have been using MySQL for my entire career.
What do I think about the stability of the solution?
MySQL is a stable solution.
What do I think about the scalability of the solution?
MySQL is a scalable solution.
How was the initial setup?
The solution’s initial setup is easy.
What's my experience with pricing, setup cost, and licensing?
MySQL is a free and open-source solution.
What other advice do I have?
MySQL is deployed on the cloud in our organization. Big companies like Netflix, Uber, and Facebook use the solution. Since MySQL is an old product, many people might have faced similar issues, posted them online, and got a resolution. MySQL's performance and scalability features have supported our database growth.
New users can follow the documentation to use the solution, as it is straightforward. You need to be very clear about why you want to use the solution. MySQL is a relational database management system that cannot be used as a dynamic database management system.
MySQL is generally faster and more efficient than other relational database management systems. Hence, it is our preferred choice for applications that require high performance.
Overall, I rate the solution a nine out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
The performance is optimal, the speed is very good, and there are no delays in fetching data
What is our primary use case?
We use the tool in projects with customer records in the database. There will be a front-end application to search and find specific data from the tool. In another project, there are product listings, and the front end fetches data from the tool and shows it in a gallery or list view on the web page or mobile application.
How has it helped my organization?
We used MySQL in a project for a nonprofit museum. They have a lot of donors. They have a large repository of customers who give donations. They categorize the customers based on the money they give, such as steward level, platinum level, and diamond level. The client may send out an invite for an event for a certain group of customers, such as the patrons who donate the most. MySQL helped us in that project.
What is most valuable?
The optimized process is valuable. I have seen websites that take ages to load and show the data. Many web applications with lakhs and lakhs of data will take forever to show specific results. The database performance is optimal for the application we developed. The speed is very good. There were no delays in fetching data from the back end and showing it on the front end.
What needs improvement?
At times, the autoscaling does not happen when there is a surge in load. We had to depend on manual scaling. It led to website crashes in the past.
For how long have I used the solution?
We have been using the solution for projects running for the past five years.
What do I think about the scalability of the solution?
Scalability is one area in which we are very cost-sensitive. We always closely monitor the charges to increase the server scale. It will help us use more space in the DB if there is an economical way for us to pick up larger servers. We have more than six lakh end users.
How was the initial setup?
Most of our projects are on the cloud. A very small number are on the client's premises.
What was our ROI?
We are continuing to use the tool because it's been cost-effective. It's producing revenue for us. It's a beneficial solution.
What's my experience with pricing, setup cost, and licensing?
The tool is open source. We choose open-source software mostly. We integrate a very limited number of licensed software.
What other advice do I have?
I have not seen any incident with a security violation or data breach. I have not contacted the technical support team. The infrastructure team contacts the technical support team regarding server-related issues. There is a LAMP stack. The Linux, Apache, MySQL, and PHP combination seems to be working well for enterprises' modern web applications.
Overall, the integration works well. However, initially, we worked with a third-party integration team to fix the APIs, query, and response code. Initially, some technical work will be needed. Once it is done, the integration turns seamless.
Overall, I rate the product an eight out of ten.
Provides good indexing and supports multiple data types, but performance needs to be improved
What is most valuable?
I would use MySQL for a medium project, with around 1,00,000 hundred thousand users, because of the indexing and stored procedures.
What needs improvement?
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.
For how long have I used the solution?
I have been using MySQL for more than ten years.
What do I think about the stability of the solution?
MySQL has good stability.
I rate the solution a six or seven out of ten for stability.
What do I think about the scalability of the solution?
Around 150 users are using the solution daily in our organization.
I rate the solution a six out of ten for scalability.
Which solution did I use previously and why did I switch?
We previously used Oracle. We switched to MySQL because Oracle's license was costly.
How was the initial setup?
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.
What about the implementation team?
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.
What's my experience with pricing, setup cost, and licensing?
MySQL is a cheap solution.
What other advice do I have?
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.
Which deployment model are you using for this solution?
On-premises
Best Open Source Database System
What do you like best about the product?
MySQL is our most used open source tool as a database administrator in all our Smart Cities projects. Whether managing a single instance or a cluster, its performance is exceptional. Relational database management is effortless. As I mentioned in the title, best RDBMS software.
What do you dislike about the product?
Logically, there are payment systems, also managed by Oracle, that have almost infinite configuration and integration options in other systems, but in terms of performance and ease of use, MySQL is unbeatable.
What problems is the product solving and how is that benefiting you?
Relational data storage is the first and last purpose of an RDBMS. Its client-server model is very powerful for integrations with other systems such as Drupal. You can even combine it with others such as SQL Server or Oracle. But within open source, it is the standard. A flexible and easy-to-use sw (in addition to its high performance).
showing 21 - 30