MySQL Reviews

4.1 out of 5 stars
 (32)
Open source databases report from it central station 2017 12 24 thumbnail
Find out what your peers are saying about Oracle, Firebird, SQLite and others in Open Source Databases.
246,941 professionals have used our research since 2012.
Open source databases report from it central station 2017 12 24 thumbnail
Find out what your peers are saying about Oracle, Firebird, SQLite and others in Open Source Databases.
246,941 professionals have used our research since 2012.

Articles

User Assessments By Topic About MySQL

Only one of the engines, InnoDB, supports ACID transaction control. The best performance engine, MyISAM, has no transactional control support. It would make a lot of sense to include one engine that offers both very good overall performance and transactional control support. All versions of MySQL, including the Community Server version include in its design as a Pluggable Storage Engine Architecture. This architecture allows for the support of multiple options of Storage Engines, so, a software architect can design a sofware solution with MySQL based on a specific Storage Engine that is capable to cater to a particular type of storage use case requirements, like for instance, web applications with heavy read workloads and moderate write workloads, or intranet desktop applications with heavy write workloads. Depending on the version of Community Server installed is the list of available Storage Engines: All it takes is the execution of the command SHOW ENGINES to retrieve the list of installed Storage Engine plugins. When you create any given table in MySQL, you have the option to select what Storage Engine (among the engines available) will be applied to said table. If this option is no explicitly mentioned at the end of the "CREATE TABLE" command, the current default storage engine will be assumed. For web apps with intensive read workloads and moderate write workloads, the engine that offers a good overall performance is the MyISAM engine, but this does not support ACID transaction control, and it uses a table-level locking mechanism (thus, from a performance standpoint, this is not proper for apps with heavy write workloads). The InnoDB engine uses a record-level locking mechanism, so, it is proper for apps with heavy write workloads. It also supports Isolation Levels, which is important for applications that have many clients doing read and write operations concurrently. The other storage engines offer support for very specific use cases, like for instance, flat file tables (CSV engine) or memory-only tables (Memory engine). Getting back to the InnoDB engine, it offers features that are similar to the database engine in SQL Server ( /products/sql-server ), and according to some of benchmarks that we have run, SQL Server ( /products/sql-server ) Express provides overall better performance than MySQL Community Server with InnoDB tables. My "Room for Improvement" comment is that it would be great if in the future Oracle were to provide with the Community Server edition a version of InnoDB with better overall performance, while still requiring a small hardware footprint.
MySQL Pricing

MySQL Community Edition - The open source downloadable option.  Free

MySQL Standard Edition - Unlimited Oracle support, knowledge base, maintenance, MySQL Database server, connectors, replication, Workbench, and certifications with Linux, VM, and Solaris.  $2000

MySQL Enterprise Edition - All of the above plus MySQL partitioning, MySQL Enterprise monitor, backup, security, audit, scalability, high-availability, and additional certifications to include GoldenGate, Integrator, Fusion Middleware, Secure Backup, and Audit Vault and Database Firewall.  $5000

MySQL Cluster Carrier Grade Edition - All of the above plus additional storage engine, and MySQL Cluster Manager which includes configuration and provisioning, automatic scaling, and management and monitoring.  $1000

-

MySQL Projects By Members

Check out these projects from our community members.
Shamal only logo
Virtulisation - Shamal Information System
To Design, Build and Deliver a complex multi application Web based Information and Management System, which... more»
Ransomware
Locky Ransomware Removal and Recovery
A university client notified us that they had been infected by the Locky strain of ransomware, with over 107,000... more»
M6 connect 1
M6Connect
Lean Technology for Your Business.The market leader in providing social Business Solutions as a service.Our core... more»
Default
Managed Project Online Mark System
University Student Management System it cover may entire student life cycle management from registration to student... more»
Default
Completed Telecom-VAS Provisioning system using MySQL, Java, .NET
Completed Telecom-VAS Provisioning system using MySQL, Java, .NET & BI Solution using MSSQL Server in Aircel... more»
Big data
World Best Business Continuity Planning Software
I was part of world best Business continuity planning software as a Senior Software Engineer
Ecommerce
Magento Run on Docker
I was able to use Docker to run a Magento 2 site locally on MacOS. This was a challenge because the native... more»
Ecommerce
Launch a FMCG transactional website in three months
Launch a FMCG transactional website in three months because of a hard stop with old website (black box) server... more»
Big data
Manage BI system
Manage and develop BI system
Virtualization
Launched a fitness site over a weekend.
Launched a fitness site over a weekend that linked squarespace to Google apps and Amazon Web Services with Trello as... more»
Virtualization
Am in charge of a 10,000 student Learning
Am in charge of a 10,000 student Learning Management System build around using Google Apps for Education.
Default
• Enabled rollout of a superior, enterprise level
• Enabled rollout of a superior, enterprise level spiff management solution that empowered a leading welding... more»
Virtualization
Departmental transformation
Departmental transformation, for when your IT department just isn't working the way it should:  - virtualisation -... more»
Marketing and sales
Last-minute platform to boost sales and data collection
Launched a last-minute platform to deliver marketing boost and data collection in 20 days. Created a platform for... more»
Default
Deployed globally synchronized WordPress website with MySQL replication
Deployed globally synchronized WordPress website with MySQL replication in a master staging server to slave regional... more»
Default
Customizing of GLPI (Open Source CMDB application)
Customizing of GLPI (Open Source CMDB application)

MySQL Consultants


Request a call with one of our top consultants and experts in MySQL. (Add me to this list.)
Ioannis syrigos avatar 1434074141?1434074139
2,185

3
IT Consultant, Business Owner, Lecturer
Dr Ioannis Syrigos is a Computer and Electrical Engineer, an Entrepreneur, co-owner and Managing Director of Stella Novus LTD, an IT consulting company running several individual online projects (Ancient-Origins.net, Members.Ancient-Origins.net, Evolving-Science.com, EnglishWithJo.com and... more>>
Charles aydin li?1427841182
4
TOP 5
Data Scientist / Consultant
Technically astute, self motivated, highly organized, process&detail focused, results driven and hands-on Physics Ph.D. with excellent research, critical thinking, problem solving, cross-functional team support, and oral & written communication skills. Definitive strengths include the... more>>
Anonymous avatar x100
5

What is MySQL?

Until its recent acquisition by Oracle, MySQL was possibly the most renowned open source database enterprise package that could be accessed completely for free. With the merger, the server increased both its features and its price tag, but there is still a free version available to the general community to contribute ideas and suggestions.

MySQL is a fast and relatively inexpensive database management system. It can easily integrate with a wide variety of programming languages, and it is considered to be a very reliable option. One of the most prominent features that customers seem to enjoy is the easy scalability of this system.

MySQL customers

Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.

Vendor 7751 screenshot 1514059231
BUYER'S GUIDE
Not sure which Open Source Databases solution is right for you?

Download our free Open Source Databases Report and find out what your peers are saying about Oracle, Firebird, SQLite, and more!
Open source databases report from it central station 2017 12 24 thumbnail

Sign Up with Email