MaterializeMySQL Database engine in ClickHouse WinterZhang(张健) About me • Active ClickHouse Contributor • MaterializeMySQL Database Engine • Custom HTTP Handler • MySQL Database Engine • BloomFilter com/zhang2014 MySQL Table Engine • Mapping to MySQL table • Fetch table struct from MySQL • Fetch data from MySQL when execute query MySQL Database Engine • Mapping to MySQL database • Fetch table list MaterializeMySQL Database Engine • Mapping to MySQL database • Consume MySQL BINLOG and store to MergeTree • Experimental feature (20.8, recommend latest stable version) MaterializeMySQL Database Engine MaterializeMySQL
The SQL Handbook Conclusion 2 Preface The SQL Handbook follows the 80/20 rule: learn in 20% of the time the 80% of a topic. In particular, the goal is to get you up to speed quickly with SQL. This Enjoy! 3 The SQL Handbook 1. Information systems, data and information 2. What is a Database? And a DBMS? 3. Do you always need a database? 4. Relational Databases 5. Introduction to SQL 6. Creating running with SQL, starting from zero knowledge. You will learn the terms and the main ideas, what is a DBMS, how to structure a database, how to insert data into it, how to query the database. I will only