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,612 reviews
from
and
External reviews are not included in the AWS star rating for the product.
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 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.
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).
Enables a wide range of features and benefits, including high performance, scalability and security
What is our primary use case?
We use it to meet the requirements of our customers while optimizing performance and reliability within the constraints provided.
How has it helped my organization?
The performance and scalability of our project have been influenced positively by MySQL. From what I've observed, performance has been satisfactory, and I haven't received any complaints from teams that have implemented it.
What is most valuable?
While MySQL offers strong basic functionality.
What needs improvement?
MySQL lacks a feature akin to Oracle's Real Application Clusters, which ensures continuous database availability within the same data center or nearby data centers. Without this capability, MySQL's suitability for mission-critical applications is diminished. Until MySQL incorporates a similar feature at the application level, its appeal for high availability remains limited. Historically, we've relied on external security measures for data protection, such as encryption. However, when encryption methodologies are employed within MySQL, there may be a slight performance degradation due to the computational overhead associated with processing large volumes of data in the database.
For how long have I used the solution?
I have been working with it for twelve years.
What do I think about the stability of the solution?
Stability is crucial, and it's influenced not just by the inherent features of the database system, but also by how the application team writes queries. If queries are poorly written or not optimized, it can affect stability significantly. While logging can help, improper usage, such as logging entire tables instead of specific fields, can also impact stability. Therefore, ensuring stability requires a holistic approach that considers both the database infrastructure and how the application interacts with it.
What do I think about the scalability of the solution?
Scalability is not as straightforward with MySQL compared to Oracle. I would rate it seven out of ten. Our clientele typically includes small, medium, and enterprise-level businesses.
How was the initial setup?
The initial setup was straightforward. I would rate it nine out of ten.
What about the implementation team?
For the MySQL installation, it's crucial to have a broader understanding of the solution we're implementing. Sometimes, we may need to address OS-level issues, especially when dealing with OS-level addressing like OSFlow. In such cases, thorough testing at the voice level is essential to ensure a smooth installation process. Implementing MySQL in a single-node setup may uncover additional challenges that need to be addressed.
Typically, our focus is on implementing the product rather than the database or operating system level. While I oversee infrastructure aspects, the implementation process is heavily influenced by the specific application being deployed. From setting up voice-level deployment and alerting to handling licensing and the database infrastructure, this entire process usually takes four to six weeks, depending on the complexity of the functionality. Once we complete the initial deployment, subsequent enrollments become more streamlined, and the application is handed over for production use. Any further adjustments or configurations are managed separately.
What's my experience with pricing, setup cost, and licensing?
The pricing falls within the moderate range. I would rate it four out of ten.
What other advice do I have?
Rather than recommending specific servers or operating systems, decisions are driven by how the application behaves and what functionalities it requires. This approach streamlines the process as pre-tested systems are already available, reducing the time and investment required for testing. Overall, I would rate it eight out of ten.
Simplest and best database management tool
What do you like best about the product?
Mysql is ideal for both small and large application, provides all the database solution related to a business and easy to use.
What do you dislike about the product?
Not really a good choice for applications that require advanced analytics or complex data warehousingit, it lacks a strong memory-focused search engine.
What problems is the product solving and how is that benefiting you?
It's Simple and easy structure querying language to perform all the task in less time.
Best for Database Management
What do you like best about the product?
It helps me maintan the complex database with eas and its feture to extract the data is very usefull and i am loving it
What do you dislike about the product?
As such there is nothing to dislike because there can be store large relational database
What problems is the product solving and how is that benefiting you?
It is solved my biggest problem to manage the the complex database and simplyfying to understand the data and can extract usefull information
MySQL Review
What do you like best about the product?
It is an open source relational database management system that is widely used for building scalable and reliable web based application. It is free to use and also known for its fast performance and efficiency making it suitable for a wide range of application from small scale projects to large scale projects. The my sql community is large and active providing a wealth of knowledge tutorials and support through forum and other online platform. It is compatible with various operating system making it flexible for deployment.It is easy to install and integrate with system.It has large number of user base and also have good documentation.It has good customer support.
What do you dislike about the product?
In comparison to some enterprise level database mysql might have fewer advance features especially in areas of analytics and complex business intelligence. It support multiple storage engine certain advance feature may specific to particular engine and not all engines are equally suitable for every cases. It have some limitation when it comes to global transactiom across multiple databases especially in distributedand highly complex transaction scenarios.
What problems is the product solving and how is that benefiting you?
It addresses the need for a robust and efficient database system storing managing and retrieving data in a structured manner. It support scalable database architecture allwoing applications to handle increasing data load and user concurrency as they grow. It provide us a cost effective option for business and developers looking for a reliable and powerful database without the licensing fees associated with commercial alternative. It has a straight forward and user friendly interface making it accessible for developers, administrator and other users. It is also compatible with various programming languages make it versatile and easily integrable. It solves the problem of storing complex data into database by its relational properties using row and column concept.
showing 21 - 30