Prince Barai - PeerSpot reviewer
Back End Developer at Agnos Inc.
Real User
Top 10
Easy to use and can be used to store data
Pros and Cons
  • "MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability."
  • "MySQL could introduce more indexing strategies."

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.

Buyer's Guide
MySQL
March 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.

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)
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
PeerSpot user
Waqar Malik - PeerSpot reviewer
System Analyst at National University of Sciences and Technology
Real User
Top 10
There are no costs involved in its use
Pros and Cons
  • "The tool is open-source and there is no cost involved in its use."
  • "I would like to see some improvements in the solution’s integration aspects."

What is our primary use case?

We use MySQL for storing data on the web server. It is a competitor of Apache. The solution can also be used for analytics, warehousing, and Big Data.

What is most valuable?

The tool is open-source and there is no cost involved in its use.

What needs improvement?

I would like to see some improvements in the solution’s integration aspects.

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?

We have optimized and stabilized the solution over a period of eight to six months.

What do I think about the scalability of the solution?

There are around 60 plus users for the tool in our company.

How was the initial setup?

There is a 25 member team involved in the tool’s maintenance and deployment.

What other advice do I have?

I would rate the solution a seven out of ten. The solution’s users have the liberty of custom management. We can implement the solution in Azure, which is Microsoft’s advanced version.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Buyer's Guide
MySQL
March 2024
Learn what your peers think about MySQL. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
Ertugrul Akbas - PeerSpot reviewer
Manager at ANET
Real User
Top 5
Easy to use, fast, and developer-friendly, but it should have better support for big data
Pros and Cons
  • "MySQL is a popular database platform for businesses because it is extremely easy to use."
  • "When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL."

What is our primary use case?

We developed a network monitoring software and used MySQL as a backend database.

We utilized the two most common and popular MySQL database engines, MyISAM and InnoDB.

We store collected monitoring data and configuration data on MySQL. Also, our network monitoring solution reporting module is based on the MySQL MyISAM database engine.

We use both Windows and Linux versions of MySQL, and we utilize the backup and recovery features.

To summarize, our primary use case is the embedded DB component for our network management software.

How has it helped my organization?

MySQL is a popular database platform for businesses because it is extremely easy to use. It is commonly used in combination with PHP and Java. For instance, someone with little to no knowledge of MySQL can easily establish a database connection and start programming immediately.

So MySQL improved our developing process speed. MySQL is a very popular and well-known database solution, so it is easy to find a MySQL developer.

MySQL performance also improved our NMS solution performance.

What is most valuable?

MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses.

MySQL advantages and valuable points include:

  • MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
  • MySQL uses a standard form of the well-known SQL data language.
  • MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, Java, etc.
  • MySQL works very quickly and works well, even with large datasets.
  • MySQL is very friendly to PHP and Java at the same time. Both PHP and Java are our development languages.

What needs improvement?

The two most common and popular MySQL database engines are MyISAM and InnoDB. Database engines provide the underlying functionality for MySQL to work with and process data. MyISAM is the default engine for MySQL for versions earlier than 5.5.5 and functions well in most scenarios.

However, depending on your needs, there are situations where another database engine, such as InnoDB, may be the better choice. For example, InnoDB supports transactions, whereas MyISAM does not. InnoDB also provides support for foreign keys, whereas MyISAM does not.

When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL. An example of this is the Vertica DB engine (https://en.wikipedia.org/wiki/...), and offering support for it would be valuable.

For how long have I used the solution?

We have been using MySQL for more than ten years.

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

Previously, we used MSSQL and switched to MySQL because of performance issues.

How was the initial setup?

After installation, the maintanence is easy for an end-user.

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

MySQL is released under an open-source license, so you have nothing to pay to use it.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Enterprise Architect at a computer software company with 1,001-5,000 employees
Real User
I can meet the RPO in almost real-time
Pros and Cons
  • "MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it."
  • "Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier."

What is our primary use case?

Our main use case for MySQL is for applications and seamless migration to the DR site. And the application in this case is an airport application.

How has it helped my organization?

I can meet the RPO in almost real-time. This changes the customer experience. That testing still needs to happen, but that is one of the advantages of MySQL. We have found MySQL to be a very sturdy and strong database. And I have run it in a solution where it's almost real-time, so it runs very efficiently.

What is most valuable?

MySQL's clustering features are very strong, and you can automate scripting, so that helps. We wrote a Terraform script and ran it. 

What needs improvement?

Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier. In terms of new features, automation is always the biggest demand from our customers.

For how long have I used the solution?

I've been doing pre-sales and working with MySQL since 2007.

What do I think about the stability of the solution?

I would say that MySQL is definitely stable, but its scalability has yet to be tested. I cannot say right now.

How was the initial setup?

We follow an agile strategy, so deployment is done in parallel. In comparison to other databases, I have always found MySQL to be the most efficiently managed. Of course, I don't discount Postgres, but MySQL deployment always has gone smoothly. I've never had an issue during migration, even on the granular level. UID numbers, which we commonly face in Microsoft SQL, have never been a problem with MySQL.

What about the implementation team?

We use the implementation partners for OEM. 

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

We get the standard packages, but mostly MySQL is freeware. You pay for a license to get the upgrades. We pay for an enterprise license if that is required, but that's not in every case. It depends.

What other advice do I have?

I would rate MySQL nine out of 10.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Deputy Director General at a computer software company with 1,001-5,000 employees
Real User
It is very easy to install and has all basic database features
Pros and Cons
  • "It is very easy to install and has all basic database features."
  • "We require more ease of use, scalability, and high availability. These are some of the critical features that we use and look for in a product. It should be easier to manage clusters. Scalability is very important for us because our projects and concurrency requirements are quite big. We also require high availability of the server, application, and other things. It should also have more performance-based features or enhancements from the performance point of view. When we divide a database, it should be able to handle the queries very fast."

What is our primary use case?

I have been working for 25 to 30 years in this domain, and during this time, I have used various products such as MySQL, SQL Server, and PostgreSQL. Currently, in my product, I am using PostgreSQL, and in some projects, I am using MySQL. We are using the latest version of this solution.

We do projects for various government departments. We have used this solution for the transport department for vehicle registration, driving license, and all such things. We have also used it for port projects, depots, educational counseling projects, school databases, higher education, and health registry. As an organization, we have a lot of use cases of this solution.

What is most valuable?

It is very easy to install and has all basic database features.

What needs improvement?

We require more ease of use, scalability, and high availability. These are some of the critical features that we use and look for in a product. It should be easier to manage clusters. Scalability is very important for us because our projects and concurrency requirements are quite big. We also require high availability of the server, application, and other things.

It should also have more performance-based features or enhancements from the performance point of view. When we divide a database, it should be able to handle the queries very fast.

How are customer service and technical support?

Whenever required, we also take support, but our people are quite experienced. They are able to manage it most of the time.

How was the initial setup?

Its installation is quite easy.

What about the implementation team?

We have our own people who do the deployment. We have various teams for various projects, and the size of the deployment team depends on the project. We have people who basically look after the DB activities, installation, and consolidation.

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

There is a licensing cost because we are going for a proprietary product. There are some other versions for which there is no licensing cost.

What other advice do I have?

I would recommend this solution depending on the project. If a project requires the kind of features that are available in this solution, I would recommend this solution.

I would rate MySQL an eight out of ten.

Which deployment model are you using for this solution?

On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Implementer
PeerSpot user
PeerSpot user
Database Administrator at a recruiting/HR firm with 1,001-5,000 employees
Real User
It is easy to understand the inner picture of the database from the EER model.

What is most valuable?

The EER diagram is the most important feature for me as the EER diagram can show the inner picture of the database, such as the relationship between the tables very easily. We can also add, modify or delete EER diagrams very easily.

How has it helped my organization?

The user friendly interface which is easy to interact with such as creating backups, tables, views, and the EER model.

What needs improvement?

It has lot of options to interact with. Sometimes it is hard to find the appropriate options quickly. They need to add descriptions somewhere as to where a user can go to find the proper menu easily when required. Another problem is that since all the databases can be seen and operated together, it’s possible to make mistakes such as dropping the wrong database.

For how long have I used the solution?

I have used this product for two years.

What was my experience with deployment of the solution?

There was no issue with deployment

What do I think about the stability of the solution?

There were no issues with stability

What do I think about the scalability of the solution?

There was no issue with scalability

How are customer service and technical support?

Customer Service:

The level of customer service is good. I understand sometimes they need to transfer the service to a knowledgeable person, so we need to have patience and explain the same problem several times.

Technical Support:

The level of technical services is good. I understand the product is technical, so sometimes the reported problem requires more investigation.

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

I used phpMyAdmin. It is also a graphical interface but you have to buy the product while MySQL Workbench is free.

How was the initial setup?

The initial setup is very straightforward. I didn’t face any problem at all.

What about the implementation team?

I did the installation.

What other advice do I have?

This product is good as it is a graphical interface. It's easy to do all MySQL database administration very easily. You just need to play around to be more familiar with it. The MySQL Workbench interface is well prepared to design a database including EER diagram, create table, and view very easily. The EER diagram allows the user to completely understand the database design, which is very important and useful for the people who are involved with the database. It’s easy to understand the inner picture of the database from the EER model.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
Haim Tzadok - PeerSpot reviewer
Haim TzadokCo-Founder/CEO at Grigale LTD
Reseller

Workbench is the original GUI for managing MySQL databases it allows to:
* Manage DB - it allows to administer a DB. (by creating a connection to a database).
* Model DB - It allows you to model your database using EER diagrams to represent tables and link between tables. EER diagrams can be transformed to a schema by creating SQL script from the EER diagram. EER diagram can be also produced from an existing DB, by connecting to a database and performing reverse engineering.
* Migrate DB - It also allows you to migrate from another DB to MySQL

it_user2652 - PeerSpot reviewer
Project Manager at a non-tech company with 10,001+ employees
Vendor
Popular
Highly recommended open source database for small/medium sized organizations

Pros:- 

1) MySQL is an open source database under the GNU General Public License, that means developers can use it at no cost as long as the associated projects are also open source. 

2) MySQL is ideally suited for small/medium sized organizations for faster performance. 

3) MySQL can be used in client/Server architecture as well as it can also be embedded in standalone applications. 

4) MySQL is fast, east to use, highly extensible, lightweight, scalable, and reliable database. 

5) MySQL supports clustering in the network for redundancy. 

6) MySQL provides flexibility to modify environment variables/kernel settings to limit the amount of memory usage for increasing performance. 

7) MySQL is strongly recommended for web applications, middleware and LAMP architecture systems. 

8) MySQL can be integrated with ldap to provide centralized authentication. It can also be integrated with LAMP/WAMP, web applications and number of programming languages. It is widely used for phpadmin and wordpress. 

9) MySQL is platform independent and can be run in mixed OS platform like windows, linux, ubuntu etc. It gives compatibility even over different OS during backup and restore. Data can be backed up from one OS and can be restored on other OS.

Cons:- 

1) MySQL can be integrated with ldap, however, it is very complex, tedious and time consuming. 

2) MySQL support is available through communities like other open source projects which means that it is sometimes scarce and hard to find. 

3) MySQL doesn't have some of RDBMS features like foreign keys, transaction, rollback and subselect. 

4) MySQL also doesn't have tablespaces, role management, snapshots, synonyms and packages. 

5) MySQL uses both InnoDB and MyISAM, however, it gives slower performance when using InnoDB as compared to MyISAM for using simple queries due to complexity of InnoDB. 

6) MySQL does not provide good development and debugging tools, so it’s cumbersome to write large SQL statements.

Alternate Vendors:- Oracle, DB2, Sybase, Postgres, Informatica!!


Disclosure: I am a real user, and this review is based on my own experience and opinions.
PeerSpot user
it_user2652 - PeerSpot reviewer
it_user2652Project Manager at a non-tech company with 10,001+ employees
PopularVendor

I have researched more on the pros and cons I listed and modified them accordingly.

See all 2 comments
Tapas Karmakar - PeerSpot reviewer
Oracle Technology Artchitect and Specialist at Wizertech Informatics Pvt. Ltd.
Real User
Valuable IO segregation and CGE with a straightforward setup
Pros and Cons
  • "The IO segregation in CGE is valuable."
  • "The auto-tuning and NDB cluster has some limitations regarding foreign keys."

What is our primary use case?

We primarily use the solution for NDB and CG clusters.

How has it helped my organization?

The solution has made it easier for us to support our clients in India for a government technology project relating to CG clusters.

What is most valuable?

The IO segregation in CGE is valuable.

What needs improvement?

The auto-tuning and NDB cluster has some limitations regarding foreign keys. For example, when creating a partition with shared architecture data, the foreign keys do not work properly. Additionally, whenever we are working with this solution, as our projects are carried out globally, the size of the database is getting used fast. In case of replication and data access with two multiple sites or nodes to become a cluster, you need two separate data storage for accessing the same data from the two nodes. Hence, this consumes a lot of storage space.

For how long have I used the solution?

We have been using the solution for five years and we are currently using version 8.0.31.

What do I think about the stability of the solution?

The solution is stable.

What do I think about the scalability of the solution?

The solution is scalable, but I can configure this product with two nodes in case of a rack, but it is impossible in any of the databases. Therefore, I rate it a seven out of ten.

How are customer service and support?

We do not have experience with customer service and support.

How was the initial setup?

The initial setup is straightforward and it took less than twenty minutes. I rate it a nine out of ten.

What about the implementation team?

One person is required for deployment.

What other advice do I have?

I rate the solution an eight out of ten. The solution is good but auto-tuning and the NDB cluster can be improved.

Disclosure: My company has a business relationship with this vendor other than being a customer: MSP
PeerSpot user
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.
Updated: March 2024
Buyer's Guide
Download our free MySQL Report and get advice and tips from experienced pros sharing their opinions.