MYSQL- MOST POPULAR OPEN SOURCE DATABASE

MySQL has been around since 1995 and is now owned by Oracle. While open source, there are also several paid editions available that offer additional features, like cluster geo-replication and automatic scaling. Because MySQL is an industry standard, it’s also compatible with just about every operating system and written in both C and C++. This solution is a great option for international users since the server can provide error messages to clients in multiple languages, encompassing support for several different character sets.

MySQL is the world’s most popular open source database and it can cost-effectively help to deliver high performance, scalable database applications. With its proven performance, reliability, and ease-of-use, MySQL has become the leading database choice for web-based applications, used by high profile web properties including Facebook, Twitter, YouTube, and all top websites. The main features of MySQL includes High Performance and Scalability, Online Schema Change to meet changing business requirements, SQL and NoSQL Access for performing complex queries, flexibility to develop and deploy on multiple operating systems and Big Data Interoperability. MySQL is released under an open-source license. So you have nothing to pay to use it. It is very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.

MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.

Pros

• Host-based verification
• Can be used even when no network is available
• Flexible privilege and password system
• Security encryption of all password traffic
• Library that can be embedded into standalone applications
• Provides server as separate program for client/server networked environment

Cons

Acquired by Oracle:

• • Users feel MySQL no longer falls under free and OS
  • No longer community driven
  • Members can’t fix bugs and craft patches

Falls behind others due to slow updates