MySQL is a free open source relational database management system under the terms of the GNU General Public License.
It’s one of the most popular databases in the market and is used by very large companies such as Facebook and booking.com and more.
It supports ACID (Atomicity, Consistency, Isolation, Durability). It’s highly stable, reliable, and can scale to 10K’s of concurrent reads and writes per second very easily.
MySQL is written in C and C++ which makes it one of the fastest RDBMS for online transaction processing systems (OLTP).
MySQL was created by a Swedish company, MySQL AB, and later bought by Sun Microsystems which was acquired by Oracle corporations in 2010.
In addition to Oracle MySQL there 2 widely used MySQL Products:
MySQL can scale reads and achieve high availability using many replications servers (slaves) where writes on the master are replicated asynchronously to the slaves with no impact on the master.
In addition, MySQL can achieve better High Availability using Galera Cluster which is masterless and replication is being done synchronously. In case of node crash, the system continues to function with no need to do failover (as in the master-slave solution)
Online Applications such: Web, Mobile or desktop.
MySQL Galera Cluster Introduction MySQL Galera cluster is the common solution for MySQL high availability and bring