MySQL

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:

  1. Percona Server for MySQL – which is fully compatible with Oracle MySQL.
    In addition, Percona comes with many free utilities – Percona Toolkit which is supported in Linux Systems.
  2. MariaDB – Created a fork after the acquisition by oracle in 2010. Maria DB core functionality is compatible with Oracle MySQL but has many new features that do not exist in Oracle MySQL.

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:

  • Database Architecture, Data Modeling
  • DBA and DevOps – Cluster/replication Installation, Performance Tuning, Upgrades, backup, and recovery
  • Data Engineering using Python.
  • SLA 24*7 Support
  • Oracle Migration to MySQL
  • SQL Server Migration to MySQL
  • MySQL on Cloud – Amazon RDS or Google Cloud SQL

Share:

Share on facebook
Share on twitter
Share on linkedin
Share on whatsapp

More Posts

We Are Here For You :

Or fill in your details and we will contact you ASAP: