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.
Oracle MySQL comes in Community Version and Enterprise Version which includes additional features and support.
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)
Use Case:
Online Applications such: Web, Mobile or desktop.
Our Services:
Data Engineer Data Engineer’s role, responsibilities, skills , and what is the background they come from? More and
Data Warehouse is a data platform where organisations store all their information from external or internal sources .
MySQL 8 Galera Cluster High Availability In MySQL 8 Galera Cluster Installation we described how to set up
MySQL Galera Cluster Introduction MySQL Galera cluster is the common solution for MySQL high availability and bring
