17 years helping Singaporean businesses
choose better software
MySQL
What Is MySQL?
MySQL is fast, reliable, scalable, and easy to use. It was originally developed to handle large databases quickly and has been used in highly demanding production environment.
MySQL Products:
MySQL HeatWave, our fully managed database service, for OLTP, OLAP, & ML workloads.
MySQL Enterprise Edition for delivering business-critical, enterprise database applications.
MySQL Enterprise Edition for ISVs, OEMs and VARs who want a proven, low cost, embedded database.
Who Uses MySQL?
MySQL suits organizations of any size, in any industry, including Enterprise and SMB across Web & E-commerce, Financial Services, Healthcare, Retail, Telecom and More.
Not sure about MySQL?
Compare with a popular alternative
MySQL
Reviews of MySQL
Alternatives Considered:
The simple way to manage data
Pros:
In first time it's open source and it capacity of large amount of data management
Cons:
Cluster creation is not simple to manage
My opinion on MySQL
Comments: I've been using MySQL to manage small servers for tests and final products and I have nothing much to complain about, it really does what needs to be done and is really secure and fast.
Pros:
The management of data is easy, fast and smooth with MySQL, the permissions system is well secure, it's flexible and the search/filter feature really helps a lot.
Cons:
Since it's considered like a light software, the management for big databases is really slow.
My Experience With MySQL
Comments: I have been using MySQL since 2005. At the beginning of using it, I didn't create a backup and lost one of my websites. Until I purchased a back-up service, I did back-ups myself and it was very time consuming because of my website size. Now, with a back-up service my database is always safe. MySQL is a very sturdy platform as it has always been a great foundation for my websites over the years.
Pros:
The MySQL interactive program makes it easy for anyone to create a simple database that connects with it. I have created many such databases over the years without problems. It usually takes about 10 to 15 minutes.
Cons:
If a MySQL database is hacked or there is a bug, it cannot be repaired or replaced in most cases without a backup. Backups must be done on a regular basis. There is usually a cost for back-ups.
MySQL Review
Comments: After I realised that there was a bug, I contacted my friends in Uganda and requested them to run their scripts via SQL Server or ORACLE.. MySQL did have a bug though. I think it has been fixed. Ugandan websites are no longer crashing.
Pros:
MySql seems to work for many websites. I think it is good for people who can't afford
Cons:
Some years ago, online websites in Uganda were timing out. I found later that they were using MySQL. **I thought there was a bug**
MySQL since university
Comments: started using MySQL at university and in every project that I create nowadays I use it because it's simple to integrate and I feel like on every language that I have worked it is easy to use it
Pros:
The SQL service of MySQL it's Great beside that was the first SQL management language that I learned at university.
Cons:
Some university instructors didn't not want us to use it in our projects where telling us to use SQL Server.
Alternatives Considered:
MySQL- dependable for your smaller database and data extraction needs
Comments: We have thoroughly enjoyed the ease of use for MySQL for our smaller database and dataset needs. Have been using it for over a decade.
Pros:
If you have even a small amount of experience with SQL, you will find MySQL easy to use. We can easily create a database, tables and queries on the fly for any of our data needs.
Cons:
Best suited for smaller databases, not large datasets.
Alternatives Considered:
10 Years of MySQL
Comments: MySQL is a robust and scalable choice for many database-driven projects, offering numerous advantages for both beginners and experienced developers. I appreciated this coming in as a novice and learning overtime how important a functioning database is to a project.
Pros:
MySQL's compatibility with various platforms and extensive support for programming languages contributes to its versatility, making it suitable for diverse applications. Moreover, its extensive online community and detailed documentation make troubleshooting and learning effortless.
Cons:
MySQL lacks some advanced performance optimization features found in other database management systems. This limitation may require additional effort to optimize complex queries manually.
Great firewall an VPN features
Comments: So far it's doing and running better then most
Pros:
That it has a strong firewall keeps safe with VPN and alerts fast to help and prevents loss
Cons:
Nothing is perfect. But this is darn close
Love MySQL's query style but too slow when compare with MongoDB
Comments: I have about 5 years experience with mysql.
Pros:
I like normalization on MySQL and also love query style.
Cons:
I don't like slow. If I compare with MySQL and MongoDB, MongoDB is so fast.
MYSQL Review
Comments: I have many applications using this software and all are working well.
Pros:
I found this program gives me the ability to incorporate a true relational database which is similar to Oracle.
Cons:
It's not the actual Oracle product. I understand that when using it.
Akshi's Review On MySQL
Comments: My overall experience with MySQL is great. It helps me in my day to day work and the best thing is that it is easy to use and can handle large amount of data easily.
Pros:
The thing which I liked most about MySQL is that MySQL databases are relational and the data is stored in different tables instead of storing all at one place. It is an open source software and fast, reliable, secure and easy to use. It can handle large database easily and the performance is great.
Cons:
The cost and pricing plan to use MySQL is very high. It has 3 different plans starting from $2140 per year which I think is expensive.
Simple yet powerful
Pros:
Very simple to get started with and take advantage of a broad set of features. Low learning curve to master it. In depth documentation with a large community support. Plethora of robust tools to support it, like the MySQL Workbench.
Cons:
There are some not so intuitive functionalities that you have to look up the documentation to understand and work around. One of them is killing a query in process. Also, the profiler tool is not as powerful as some of the competitor DBMS.
Best RDBMS tool.
Comments:
It is a useful relational database for storing data.
I always use it with the projects that I create.
As I have seen it as the simplest and easiest among other databases.
Pros:
A light program on the computer. It features a beautiful control interface that makes it easy to use in creating databases, tables, relationships between them, or other services. It is characterized by taking a backup copy and restoring it smoothly.
Cons:
When I am writing queries I found that some are different from the other and I have to search on the Internet to make them work. Sometimes the large amount of data slows down the insertion, updating and selection process.
SQL Review
Pros:
SQL is one of the best programs that deal with relational databases, that is, those that are based on relationships between tables. It also provides many advantages for data, including high protection, privacy, and integrity.
Cons:
One of its disadvantages is that it is difficult for beginners to deal with, due to the large number of tools and commands in it
Our go to tool for all things Data
Pros:
We have being using MySQL for a number of years now and are very happy wih it. We found the training courses extremely useful and the support options are very helpful also
Cons:
We have had nothing but positive experiences to date with MySQL
MySQL Review
Pros:
It is an easy-to-use database management system.
Cons:
It has some limited functionality. It lacks some of the advanced features.
An unlimited world in the database
Comments: MySQL can serve almost all users thanks to the multi-platform it supports. It has an easy and simple interface design. It provides an easy and efficient working environment thanks to its relational database feature. resource consumption is close to minimum considering the results it provides. free versions are also at a level that can meet almost all demands.
Pros:
Compared to its competitors on the market, its free versions, multi-platform support and a powerful engine make it one step ahead of many software. It is ideal for integrating with other software in a much wider framework and communicating with data much faster, especially outside of patterns. Although it has minimum resource consumption, it offers maximum performance. A limited number of rows can process data without locking and deliver results quickly. In the paid versions, you can make transactions at the corporate level or commercially.
Cons:
You should plan your preferences and needs well. If you cannot communicate well the session software and database software you will use, this may cause you problems. You should read the release notes well and activate the latest software.
Alternatives Considered:
Standard for high performance RDBMS, if the GPL community version works for your org
Pros:
Strong RDBMS, extremely high performance for the right use case: myiasm.
Cons:
If your usecase favours ACID compliance, Innodb still has the same performance quirks it always has. There are alternative solutions for ACID compliant workloads with easier licenses.
MySQL: the cost-efficient RDBMS from Oracle
Pros:
MySQL was initially an open source RDBMS till it was acquired by Oracle corporation. MySQL was integrated with a very versatile web interface PHPMyAdmin which provided a full-fledged database client that allows administrators to manage the creation of database entities including tables, views, stored procedures, triggers, users, .... MySQL supports the various SQL 92 constructs including DDL, DML, and DCL SQL statements. It is not supported with advanced Undo/Redo Logging algorithms as in the case of Oracle database, but still can support advanced SQL queries with decent optimization mechanisms.
Cons:
PHPMyAdmin suffered from performance lagging and bottlenecks specifically when inserting database rows. The lagging is mainly from the Web GUI since the actual SQL insertion mechanism is effectuated in the database but not refreshed in the PHPMyAdmin GUI. The latest database engine supported by PHPMyAdmin is MariaDB which suffered the same performance lagging issue. Customer support wasn't successful in figuring out the source of this bug. This is mainly experienced on Windows installations. MySQL is not open source anymore which makes MariaDB (the open source alternative) a much cost efficient choice.
My first love in SQL management system
Pros:
Best to work on in terminal, it's cool to use it. Also comes with a workbench that makes it easy to operate in many conditions.
Cons:
There are many alternatives available in the market, there is no innovation in recent future.
MySQL review
Comments: MySQL is and reliable database system and one of the most popular open-source relational database management systems
Pros:
MySQL is easy to install and set up, widely supported by various operating systems, programming languages, and platformsone of the best features is that MySQL provides strong security features by using user authentication to access and login plus encrypted data connections
Cons:
MySQL may not have all the advanced features , need to develop analytics and reporting features
Great database software
Pros:
Great tool for querying database and sql.
Cons:
not as great/ better as oracle sql and pl/sql.
MySQL review
Pros:
It's one of the most complete Relational database in the market, it has a lof of features that makes the developer's workflow easier.
Cons:
All the features that I might need were already covered so I have nothing to complain about.
It is a basic for any development
Comments: Have been using for years, from my first development
Pros:
How fast the big queries are made and all the documentation all over internet, with this, it is awesome.
Cons:
I love mysql, i prefer much more than mongodb, the speed and the relations between tables are much better done
Flexible and cheaper solution
Pros:
The way to create database in a very fast way. The cheaper cost.
Cons:
The way how to create indexes for each table