Comments on: Archiving MySQL Tables in ClickHouse https://www.percona.com/blog/archiving-mysql-tables-in-clickhouse/ Tue, 13 Feb 2024 17:44:53 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Ralf Engler https://www.percona.com/blog/archiving-mysql-tables-in-clickhouse/#comment-10968988 Wed, 21 Feb 2018 10:37:57 +0000 https://www.percona.com/blog/?p=47307#comment-10968988 There is another nice option to access or high-speed-copy data from MySQL.

CREATE TABLE testdata
ENGINE = MergeTree
ORDER BY id AS
SELECT *
FROM mysql(‘localhost’, ‘database’, ‘table’, ‘user’, ‘password’)

Copying seems to be much faster than the csv export/import

https://www.altinity.com/blog/2018/2/12/aggregate-mysql-data-at-high-speed-with-clickhouse

]]> By: Aurélien LEQUOY https://www.percona.com/blog/archiving-mysql-tables-in-clickhouse/#comment-10968987 Tue, 20 Feb 2018 21:46:32 +0000 https://www.percona.com/blog/?p=47307#comment-10968987 Hello,

How you do when this table is linked with FKs, and maitain integrity with childs tables?

]]>