MySQL and MariaDB¶
About
MySQL and MariaDB are well-known free and open-source relational database management systems (RDBMS), available as standalone and managed variants.
Details
MySQL is a component of the LAMP web application software stack (and others), which is an acronym for Linux, Apache, MySQL, Perl/PHP/Python.
When Oracle acquired Sun in 2010, Monty Widenius, MySQL’s founder, forked the open-source MySQL project to create MariaDB.
Synopsis
uvx 'cratedb-toolkit[io-ingest]' load \
"mysql://root:secret@localhost:3306/?table=dbname.tablename" \
"crate://crate:crate@localhost:4200/doc/mysql_demo"
Learn
Load data from MySQL/MariaDB.
Load data from MySQL into CrateDB using CrateDB Toolkit.
Use SQL and CSV
Manually export CSV from MySQL, and import into CrateDB, all using SQL.
