MySQL Benefits

Ruhul Amin - PeerSpot reviewer
Executive Officer at Midland Bank Plc

It is quite efficient and performs well, especially when compared to MSCS. While traditional scaling methods can occasionally lead to slowdowns, I haven't encountered similar performance issues with MySQL scaling.

View full review »
Kevin Honde - PeerSpot reviewer
Data Solution Architect at Econet Wireless Zimbabwe

The way that MySQL has improved my organization is that it comes free and also works fine on the technical side.

View full review »
RU
Senior Consultant at Tata Consultancy

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.

View full review »
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,386 professionals have used our research since 2012.
SG
Works

MySQL is easy to use and, with basic knowledge of SQL, users can easily build SQL Statements. It helps to reduce project cost for development projects. It also supports a large number of embedded applications.

The backup and recovery features are easy to use without any complexity. Users who don’t have much knowledge of databases can easily use these features.

MySQL offers password encryption and offers a good data security layer to protect data.

MySQL platform independence helps the development and user community.

View full review »
ND
Specialist Geosciences Data Consultant at a energy/utilities company with 10,001+ employees

Essentially, I'm doing data mining with SQL queries, although I wouldn't call what I am doing Data Mining exactly, because I already know the data model. I know the geochemistry data in my head, so I already know what I'm looking for when I write an SQL query. We're not doing machine learning or AI at this point, although it may come in the future.

Every now and then, we create dashboards for the geochemists, which cover their needs from the data.

View full review »
it_user253797 - PeerSpot reviewer
IT Consultant, Business Owner, Lecturer at a tech consulting company with 10,001+ employees

For any web project today you are going to need a database system. If you use any Content Management System, MySQL is most of the times the database of your choice.

MySQL is easy to use, most developers have experience using it and it is an Open Source, cost-effective solution.

View full review »
NM
Database Engineer at a retailer with 10,001+ employees

It has improved scalability, easy-maintenance. It is open-source and is easy to use. 

View full review »
it_user448206 - PeerSpot reviewer
Senior Application Programmer/Analyst, Team Lead at a university with 10,001+ employees

MySQL is widely supported. We were able to integrate it with several different projects using various different programming languages with no issues.

Worked with Java, Perl, PHP, C# and C code. 

View full review »
PA
Software Engineer at a financial services firm with 10,001+ employees

We have many repositories in one table that we are completing for customers' data that are store product data. There are various pieces of data and data should be in the same format. For this purpose, we are using RDBMS. The data in the repository should be able to be accessed in one place which is Oracle SQL Developer. MySQL can store data for a longer duration as compared to other data solutions, such as MariaDB, which can only store data for one day. MySQL can store data for a longer period of time, and we can have primary and secondary data as well for backup purposes.

View full review »
AC
IT Consultant at Woohoogeeks

MySQL is easy to configure, use, and implement. It is free, and cost-effective, with a powerful plethora of tools. It has improved my organization for my clients using Moodle and MySQL databases, as problems are usually easier to fix quickly, and the database resources can be optimized, easily. Even though it is not as sophisticated as SQL Server and Oracle solutions, it is the database of choice for most Moodle implementations. It has a history of reliability, which is always useful in a business environment.

View full review »
Ertugrul Akbas - PeerSpot reviewer
Manager at ANET

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.

View full review »
AM
Enterprise Architect at a computer software company with 1,001-5,000 employees

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.

View full review »
RP
Database Administrator at a recruiting/HR firm with 1,001-5,000 employees

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

View full review »
Tapas Karmakar - PeerSpot reviewer
Oracle Technology Artchitect and Specialist at Wizertech Informatics Pvt. Ltd.

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

View full review »
it_user304758 - PeerSpot reviewer
Powerbuilder Consultant at a government with 1,001-5,000 employees

Using MySQL helps to keep the costs down. With immense material available on the web, training is easy too.

This is the de facto DB for web development with PHP. If you worked with LAMP environment, this was the M in it (others being Linux, Apache Tomcat and PHP). With open source products, development was a breeze. Overall, this is a boon to small to medium database applications.

View full review »
JK
Data Analyst at KPMG East Africa

I used the tool to build our website. It is used as a database to store information.

View full review »
LM
Ingénieur Etude et Développement / Technical Lead Java at ATOS

It's free. I'm in a big organization, with more than 100,000 employees. If you have to buy a database management system for every project, it would be very expensive. 

Considering the cost-free option, you can use it for POCs,(proof of concept projects), and you can deploy it for customers to reduce project costs. The principal reason is that it is cheap.

View full review »
MM
Senior Web Manager at a university with 501-1,000 employees

Due to the open source licensing model, it has allowed small businesses like ours to adopt enterprise-grade database systems without incurring significant licensing costs.

View full review »
Anand Viswanath - PeerSpot reviewer
Project Manager at Unimity Solutions

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.

View full review »
HT
Co-Founder/CEO at Grigale LTD

It dramatically improved use for several of my customers.

View full review »
it_user231711 - PeerSpot reviewer
Telecommunications Engineer at a comms service provider with 1,001-5,000 employees

The main benefit for us is that it's totally free, unless you need to pay for support.

View full review »
it_user178848 - PeerSpot reviewer
Engineer with 51-200 employees

MySQL provides a low cost and effective SQL Database solution for smaller companies that don’t require the overhead and cost associated with RDBMS tools like Oracle

View full review »
RS
COO at a tech vendor with 1-10 employees

MySQL hasn't really affected our organization, specifically because we primarily use it in a consulting model.

View full review »
it_user578346 - PeerSpot reviewer
Head of Business Technology at a tech services company with 501-1,000 employees

Due to the large user base, a large amount of software modules and plugins for rapid application development are possible. From an operational viewpoint, this is also a very big advantage.

View full review »
IR
Manager at a tech services company with 51-200 employees

As we are using the latest version of the database, it has many functions that have improved it. There are many new features in this version, and it is more powerful in what it can achieve.

View full review »
it_user702249 - PeerSpot reviewer
Web Developer at a tech services company with 201-500 employees

It gives us the opportunity to create backups of our databases easily and loop through them with minimum effort.

View full review »
it_user242553 - PeerSpot reviewer
Academic application support at a university with 1,001-5,000 employees

Before we used MySQL, we used to access the data used for the dynamic web pages directly from our enterprise data stores and that was a massive performance bottleneck. With MySQL, the data can be accessed much faster. This allowed us to create more complicated web systems, such as the corporate message system and a credit card paying system.

View full review »
it_user279822 - PeerSpot reviewer
DevOps SRE at a tech services company with 51-200 employees

The backend of the production traffic happens at this level.

View full review »
it_user158343 - PeerSpot reviewer
Software Architect at a tech consulting company with 51-200 employees

We do software development for our customers on both Windows and Linux. Since these tools are available for both Windows and Linux, we can leverage the knowledge of these tools for development on both platforms.

View full review »
it_user369420 - PeerSpot reviewer
Software Tester & SQA at a manufacturing company with 501-1,000 employees

Again, I couldn't name an positive aspect precisely. Maybe, the fact that using MySQL and Java gives it a big portability and, at the same time, short time responses within your product (my case). This could come from the DB side. It also allows for easiness of finding interaction tools with MySQL.

View full review »
it_user3405 - PeerSpot reviewer
Partner at a tech services company with 51-200 employees

Yes, MySQL has improved numerous processes; it has given us the ability to create applications without absorbing major costs.

View full review »
it_user208659 - PeerSpot reviewer
QA Lead at a logistics company with 1,001-5,000 employees

To give you an example, initially we didn't have a database server as such, and we had to make use of some database. Now we use something where we can share the instances of the database which were created virtually, which is a very good feature, which I felt has improved our organization.

View full review »
it_user722220 - PeerSpot reviewer
MySQL DBA

We majorly use the application now. We can use MySQL to read for our select queries. This helps us to achieve stability.

View full review »
it_user216924 - PeerSpot reviewer
Data Scientist / Consultant with 501-1,000 employees

You can easily build data models both on-premise and on the cloud.

View full review »
DY
Deputy Manager at a university with 1,001-5,000 employees

MySQL is lacking some of the features that you find in a commercial product, but it is sufficient for basic functions.

View full review »
it_user755235 - PeerSpot reviewer
Director at RC Ghosh Group of Companies

We use MySQL for enterprise data storage as well as part of the back-end of websites and web applications.

View full review »
it_user755103 - PeerSpot reviewer
Open Source Database Consultant

Storage and searching quickly on data is no longer an issue facing us using Excel.

View full review »
it_user492180 - PeerSpot reviewer
Director of Information Technology at a tech services company

It was the first step of the Service Desk.

View full review »
AA
CEO at a computer software company with 1-10 employees

Without MySQL, we used a single centralized database.

With MySQL, we can now have many standalone databases where every developer can perform local tests.

View full review »
it_user450789 - PeerSpot reviewer
Member of Technical Staff at a tech company with 501-1,000 employees

It allows us to maintain very large tables without jumping through the hoops that are required by the commercial products such as Oracle.

View full review »
it_user424227 - PeerSpot reviewer
SENIOR DEVELOPER at a tech services company with 51-200 employees

It facilitated fast processing of the millions of records for billing of the the call detail records in the Telecom company. The company needed to recover calls, in addition to immediately detecting frauds in the telephone calls so as to block the line and generate large losses. With the help of stored procedures, functions and triggers, we created an engine to recover most of the calls with a single transaction. Thanks to MySQL.

View full review »
it_user304542 - PeerSpot reviewer
DevOps Lead Engineer at a tech services company with 51-200 employees

Amazon has come up with Aurora, a MySQL hybrid that has helped us get up to speed without actually thinking about MySQL underlying optimizations.

View full review »
MU
Co-Founder at Mero Reading Room
  • It provides visibility, where something was either broken or in pieces only.
  • It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily.
  • It has a remote access feature to manage the database from a remote location. This enables in-work collaboration.
View full review »
it_user436011 - PeerSpot reviewer
IT Director at a energy/utilities company with 501-1,000 employees

The availability of resources for MySQL has been the biggest benefit for our organization.

View full review »
it_user582915 - PeerSpot reviewer
Software Development Manager at a tech services company

Cost effective.

View full review »
it_user703740 - PeerSpot reviewer
Software Engineer at a tech company with 51-200 employees

MySQL has improved our internal procedures by providing high performance, ease of use, and cost savings.

View full review »
it_user649608 - PeerSpot reviewer
IT Manager

Web portal database.

View full review »
it_user346572 - PeerSpot reviewer
Systems Administrator at Nubity Inc. at a tech services company

Data is:

  • More ordered
  • Reliable
  • Available in time and form
View full review »
it_user344865 - PeerSpot reviewer
Developer at a tech services company with 51-200 employees

It’s been used as the main databases for a lot of the developments we have done.

As for special features it offers, I wouldn’t say there’s a key one, but I do appreciate the stability it has.

View full review »
it_user229656 - PeerSpot reviewer
Senior Staff Engineer at a tech vendor with 501-1,000 employees

We have been using the multi-master solution from the Percona cluster. It seems to work as expected.

We use it as an embedded component of a solution we sell. It has provided a low-cost, high-availability solution without complex active/standby management using Linux HA.

View full review »
it_user369264 - PeerSpot reviewer
Junior Technician Intern at a tech services company with 501-1,000 employees

I don't have any as this was my first time using it.

View full review »
it_user359547 - PeerSpot reviewer
Expert Advisor at a mining and metals company with 51-200 employees

This database enabled us to web present our content in a cost efficient way.

View full review »
it_user325773 - PeerSpot reviewer
Jr. Production Engineer at a marketing services firm with 51-200 employees

In order to change the size of InnoDB transaction log files, you have to follow this procedure. Beware that if you don’t follow these instructions step-by-step, your server may not restart or rather it will start with InnoDB storage engine disabled and an error in the logs. So, here’s what you want to do:

1. change (or add) the following variable in my.cnf: innodb_log_file_size = ..
2. stop MySQL server
3. make sure you see a successful shutdown of InnoDB in the MySQL error log
4. move away old log files (at this point I have to double check where they are) by running the following command:
mv /var/lib/mysql/ib_logfile* /tmp/
5. start MySQL server – it should take a bit longer to start because it is going to be creating new transaction log files
6. When you’re positive that MySQL server has started successfully, you can remove the old log files:
rm /tmp/ib_logfile*

View full review »
it_user677721 - PeerSpot reviewer
Information Technology Technician at a tech vendor with 51-200 employees

Since it has many integrations to web applications, it is very easy to install and deploy open source web applications.

View full review »
it_user417285 - PeerSpot reviewer
Senior Production Support Engineer at a tech company with 501-1,000 employees

Once we needed to use a database to distribute a product for my company and we chose MySQL, it was easy to use and it is very small, but powerful.

View full review »
it_user239649 - PeerSpot reviewer
IT Manager at a retailer with 1,001-5,000 employees

It permits services such as data warehouse and retail.

View full review »
it_user602400 - PeerSpot reviewer
Intern at a tech vendor with 1,001-5,000 employees

My company does not use MySQL. However, it is often used at universities and is suitable for beginners. It is used for many projects.

View full review »
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,386 professionals have used our research since 2012.