Full Extraction From MySQL Database

Introducing MySQL

The most common source of data for ETL pipelines is, to nobody's surprise, databases. According to ~74,000 responses on StackOverflow, the two most popular databases are MySQL and Postgres.

MySQL is an open-source OLTP relational database used by organizations worldwide. It’s a simple database that’s fast, reliable, well-understood, and easy to set up and manage. MySQL is known to be light on features to increase its speed and reliability. It’s used for a wide range of applications, although the most popular usage is for web applications. MySQL is managed by Oracle and has a paid enterprise version and a free community edition.

MySQL is ACID (atomicity, consistency, isolation, and durability) compliant and has several storage engines that can be used to optimize the performance and customize it to our needs. The most popular ones are InnoDB and MyISAM. Many large organizations use MySQL. Some examples are:

• Google

• Facebook

• Twitter

• Spotify

• Booking.com ...