MySQL Destination

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter, and "SQL", the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

Read The Docs

The different types of destinations

There is no one size fits all solution when it comes to databases, datalakes and data warehouses. Each one had different benefits and drawbacks which you can read more about here

Analytical vs Transactional

Analytical Data Stores (OLAPs)

The analytical data stores include normally all of the data warehouse vendors such as Snowflake, Redshift, Bigquery and many others. Analytical data stores are normally columnar data bases which are optimized for storing vast amounts of data at a decent price while at the same time allowing you to issue complex queries to understand your business data.
Using one of this solutions for operational queries where a lot of updating happens would be costly and inefficient.

Transactional Data Stores

Transactional Data Stores are more commonly used for operational workloads such as managing all the data from a web application. Common web solutions such as Wordpress rely on these type of data stores. Some examples are MongoDB, Postgresql, MySQL and many others.
These type of data bases can handle a huge volume of updates as users interact with the product.