Sign in Agent Mode
Categories
Your Saved List Become a Channel Partner Sell in AWS Marketplace Amazon Web Services Home Help

MySQL

Jetware

Reviews from AWS customer

4 AWS reviews

External reviews

1,607 reviews
from and

External reviews are not included in the AWS star rating for the product.


4-star reviews ( Show all reviews )

    Anand Viswanath

The performance is optimal, the speed is very good, and there are no delays in fetching data

  • March 21, 2024
  • Review provided by PeerSpot

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.


    Antonio H.

Best Open Source Database System

  • March 15, 2024
  • Review provided by G2

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).


    Ravi Upadhyayula

Enables a wide range of features and benefits, including high performance, scalability and security

  • March 11, 2024
  • Review provided by PeerSpot

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.


    Dheeraj P.

Simplest and best database management tool

  • March 10, 2024
  • Review provided by G2

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.


    Ketan A.

Best for Database Management

  • January 17, 2024
  • Review provided by G2

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


    Computer Software

MySQL Review

  • January 16, 2024
  • Review provided by G2

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.


    Mark P.

Go-to SQL database solution

  • January 09, 2024
  • Review provided by G2

What do you like best about the product?
MySQL can be installed on multiple platforms with installaers and pakages to make installation very easy. It has nearly all of the features you'd expect of a SQL complaint database, with a few "platform specific" extras as well. I've been using mysql for more than 10 years in different scenarios, most of the time seamlessly integrating into the system I'm building. The community support is very good, and if you want it there's paid support too, tough I've never tried it.
What do you dislike about the product?
With all tools like this you have to be aware that ease of use comes at a cost of security. It's harder to implement a the security and reliability features that you might need as it is not set up out of the box.
What problems is the product solving and how is that benefiting you?
MySQL is a fast and reliable way to set up a database to serve an application.


    Ismail Yushaw

A tool that offers an easy setup phase along with exceptional stability

  • November 29, 2023
  • Review provided by PeerSpot

What is our primary use case?

I started to use MySQL at some point when I had some issues that I couldn't get around. I normally use the tool in professional opportunities and when I require support from MySQL.

Cacti is a tool for monitoring devices on a network in graphical terms, for which it uses MySQL or MariaDB. I mostly deploy Cacti with MySQL or MariaDB. Somewhere down the line, I started to have some issues with the permissions in MySQL, including its areas like superuser privileges and similar stuff, which took me a while to figure out. I think the tool is fine for me now.

What is most valuable?

The most valuable feature of the solution stems from the fact that it helps me to get my work done. I am more interested in getting my work done than any feature it comes with since, as long as it gets my work done, it can actually help me achieve my objectives.

What needs improvement?

Nowadays, I use phpMyAdmin or MySQL WorkBench to manage MySQL. I would have been in a position to comment on what requires improvement if I had spoken about the tool three years ago. There are no improvements needed in the UI of the solution since many tools in the market help the user get the job done. MySQL WorkBench belongs to Oracle.

The performance, stability, and security are areas with shortcomings in MySQL, where improvements are required.

It would be a great improvement if the product could be made affordable enough for me to be able to access support from MYSQL, especially when I deal with mission-critical applications.

For how long have I used the solution?

I have been using MySQL since 2014.

What do I think about the stability of the solution?

It is a very stable solution. I deployed the product six years ago, and it still works fine.

What do I think about the scalability of the solution?

I won't be able to comment on the product's scalability since I haven't deployed it in a cluster environment.

Our company has over a thousand devices, including switches and a couple of other devices, which report to MySQL for management purposes. In general, MySQL is a very robust tool.

Which solution did I use previously and why did I switch?

Somewhere down the line, I got introduced to MariaDB as well. Nowadays, I use MariaDB rather than MySQL most of the time.

How was the initial setup?

The product's initial setup phase is easy since I use package management software. I mostly take care of the deployment phase with the help of Docker and other tools. If you decide to use the default deployment settings provided by MySQL, then it is a straightforward process to deploy it.

A lot of things have changed since I have deployed the solution. The solution is like a new product nowadays since you just need an application to deploy it presently. The other area where you need to take care of the solution is knowing how to secure it very well so that it becomes less vulnerable and prevents people from taking advantage of the solution.

Mostly, I go to the MySQL website to download the binaries, and I just deploy them on a Windows machine or another system, which is just a straightforward process. The product's installation phase is not much of a problem.

The solution is deployed on an on-premises model.

Earlier in my company, there were three people who used to take care of the deployment of the solution, but presently, I don't know who handles the deployment part.

What was our ROI?

In the past, the product was free for users, which ensured that users could experience a high return on investment from the use of the solution. I don't know the licensing models attached to the solution currently, but the return on investment is very high if you use it for a very limited amount of time.

Which other solutions did I evaluate?

MySQL was one of the tools I was introduced to from the very beginning when I was in school. Though I knew about Microsoft SQL Server, the lectures in my school did not introduce me to it since more focus was placed on MySQL. I find MySQL easier to use compared to Microsoft SQL Server.

What other advice do I have?

I recommend the solution to those who plan to use it since it is a very good product that comes to my mind since it is always available. I don't know about the current licensing model of the product because it was an open-source tool earlier. I don't remember myself attempting to check what kind of license MySQL uses presently. In the past, Microsoft SQL Server used to cost a lot of money, which my company couldn't afford at that time.

I rate the overall system an eight out of ten.


    Philippe Liénard

Good service provider, agile and quick deployment

  • November 28, 2023
  • Review provided by PeerSpot

What is our primary use case?

I've used MySQL in the past for a variety of tasks.

I once used MySQL when I created a PostgreSQL database for club management tasks. This included handling registrations, events, and mailing notifications for payments and event details. It served as a source service provider.

What is most valuable?


What needs improvement?

The response time for support could be faster.

MySQL's performance requires attention. For optimal performance, one should review and sometimes revise the code, particularly when using server-side scripting. To optimize performance, it's crucial to pay attention to your code. Sometimes, you may need to review your code to ensure it's efficient and doesn't unnecessarily access the database multiple times.

The performance issues I encountered were not due to MySQL itself but were related to my coding approach.

For how long have I used the solution?

I have been using MySQL for ten years.

What do I think about the stability of the solution?

I would rate the stability a ten out of ten.

What do I think about the scalability of the solution?

For my use case, it is okay. Basically, it's just me for development. Previously, all clients or members of the club accessed it. When there was an event, maybe 30 to 40 people would try to access the system simultaneously.

I'm using SiteGround for hosting the website and its servers. I've chosen a package with more than enough CPU and memory to avoid trouble.

How are customer service and support?

I've used technical support for several times. Most of the time, it was quite okay with quick responses. Once, I had performance issues. It took some time to convince them, but they guided me on improving performance by changing some database functions in MySQL. It was a longer process, but it was eventually resolved.

How would you rate customer service and support?

Positive

How was the initial setup?

The initial setup was easy. I work in an agile way, which means coding and deploying quickly. We had a few internal users but many external users accessing the website, though not the back office.

The back office was developed over years. It's not just about having an idea and executing it; it's more about testing and adapting the process, unlike the waterfall method, where you end up with something that may not be immediately usable.

What about the implementation team?

As the main user, our deployment process wasn't as strict as in a big company. I conducted tests, had a testing process with use cases to review, and then deployed. It was less rigid than in larger companies, where there are separate testing and development environments.

What was our ROI?

I have seen value and impact from using MySQL

What's my experience with pricing, setup cost, and licensing?

I don't pay for a license.

Which other solutions did I evaluate?

With my previous employer, we used Oracle.

What other advice do I have?

Don't just use MySQL on its own. Always use it with other software around it. MySQL is very stable, but pay attention to the software you use with it, whether you develop everything from scratch or use open-source systems like CMS.

Overall, I would rate the solution a nine out of ten. I would recommend using the solution.


    SaifNan

A stable and flexible product that is easy to use and can be deployed quickly

  • November 27, 2023
  • Review provided by PeerSpot

What is our primary use case?

I use the product as a backend to my application.

What is most valuable?

The product is flexible and easy to use.

What needs improvement?

The interface could be improved.

For how long have I used the solution?

I have been using the solution for seven to ten years. I am using the latest version of the solution.

What do I think about the stability of the solution?

I rate the tool’s stability a nine out of ten. The stability is good.

What do I think about the scalability of the solution?

I rate the tool’s scalability a seven out of ten. We have four direct users and more than 1000 indirect users. We use the tool twice a week.

How was the initial setup?

I rate the ease of setup an eight out of ten. The deployment took a few minutes. We need two system administrators to maintain the tool.

What about the implementation team?

The deployment was done in-house. We need one system administrator to deploy the tool.

What's my experience with pricing, setup cost, and licensing?

I rate the pricing a seven or six out of ten on a scale of one to ten, where one is cheap and ten is expensive.

What other advice do I have?

We used different solutions before, but I do not know why we switched to MySQL. I recommend the solution to others. Overall, I rate the product an eight out of ten.