VM+CentOs7+ClickHouse+MySQL集成

首先，我的版本是VM12 pro+CentOs7
本文主要分以下两个部分

1.安装ClickHouse

2.实现MySQL与ClickHouse集成

1.安装ClickHouse

下面首先来讲讲按照ClickHouse相关方法：
本文主要参考：
可以看原文也可直接看本文
安装依赖项

安装过程需要curl下载包。此外，ClickHouse测试包在EPEL中有一些依赖关系，因此epel-release必须安装，以防您想要安装ClicKhouse测试包确保curl安装在系统上

sudo yum install -y curl
 ＃如果安装了测试包，添加epel-release 
sudo yum install -y epel-release　

然后执行：

curl -s https://packagecloud.io/install/repositories/altinity/clickhouse/script.rpm.sh | sudo bash

脚本后安装包

首先，确保我们有可用于安装的ClickHouse软件包

sudo yum list 'clickhouse*'

ClickHouse包应该列为可用，如下所示：

#可用包组
clickhouse-client.x86_64 18.1.0-1.el7 Altinity_clickhouse
clickhouse-common-static.x86_64 18.1.0-1.el7 Altinity_clickhouse
clickhouse-compressor.x86_64 1.1.54336-3.el7 Altinity_clickhouse
clickhouse-debuginfo.x86_64 18.1.0-1.el7 Altinity_clickhouse
clickhouse-mysql.noarch 0.0.20180319-1 Altinity_clickhouse
clickhouse-server.x86_64 18.1.0-1.el7 Altinity_clickhouse
clickhouse-server-common.x86_64 18.1.0-1.el7 Altinity_clickhouse
clickhouse-test.x86_64 18.1.0-1.el7 Altinity_clickhouse

有多个软件包可用（新版本和旧工具），其中一些已经弃用，因此无需安装所有可用的RPM。

现在让我们安装ClickHouse主要部件 - 服务器和客户端应用程序。

sudo yum install -y clickhouse-server clickhouse-client

并验证它是否已列为已安装

sudo yum list installed 'clickhouse*'

ClickHouse软件包应列为已安装，如下所示：

Installed Packages
clickhouse-client.x86_64                 18.1.0-1.el7           @Altinity_clickhouse
clickhouse-common-static.x86_64          18.1.0-1.el7           @Altinity_clickhouse
clickhouse-server.x86_64                 18.1.0-1.el7           @Altinity_clickhouse
clickhouse-server-common.x86_64          18.1.0-1.el7           @Altinity_clickhouse

确保ClickHouse服务器正在运行

sudo /etc/init.d/clickhouse-server restart

然后连接到它 clickhouse-client

clickhouse-client

ClickHouse服务器应该响应，如下所示：

ClickHouse client version 21.1.3.32 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.1.3 revision 54443.

然后ClickHouse就安装成功了！

2.实现MySQL与ClickHouse集成

首先进入MySQL

[root@localhost bin]# ./mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.18 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

然后查看当前表：

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.03 sec)

再接下来新建一张表：

mysql> create database Persons;
Query OK, 1 row affected (0.02 sec)
mysql> use Persons
Database changed
mysql> CREATE TABLE Persons
    -> (
    -> Id_P int,
    -> LastName varchar(255),
    -> FirstName varchar(255),
    -> Address varchar(255),
    -> City varchar(255)
    -> );
Query OK, 0 rows affected (0.02 sec)

再接下来插入数据

mysql> insert into Persons values(001,'Jack','Green','aaa road','London');
Query OK, 1 row affected (0.01 sec)
mysql> insert into Persons values(002,'Mary','Lisa','bbb road','taiwan');
Query OK, 1 row affected (0.00 sec)
mysql> insert into Persons values(003,'Tom','Brown','ccc road','Alaska');
Query OK, 1 row affected (0.00 sec)

查看当前数据：

mysql> select * from Persons;
+------+----------+-----------+----------+--------+
| Id_P | LastName | FirstName | Address  | City   |
+------+----------+-----------+----------+--------+
|    1 | Jack     | Green     | aaa road | London |
|    2 | Mary     | Lisa      | bbb road | taiwan |
|    3 | Tom      | Brown     | ccc road | Alaska |
+------+----------+-----------+----------+--------+
3 rows in set (0.00 sec)

然后接下来进入ClickHouse页面

[root@localhost /]# clickhouse-client
ClickHouse client version 21.1.3.32 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 21.1.3 revision 54443.

然后导入刚才建的MySQL表

localhost :) CREATE DATABASE Persons ENGINE = MySQL('localhost:3306','Persons','root','333')

CREATE DATABASE Persons
ENGINE = MySQL('localhost:3306', 'Persons', 'root', '333')

Query id: 65f66bdd-ff0f-4820-a816-590dde522587

Ok.

0 rows in set. Elapsed: 0.069 sec. 

查看当前表结构：

localhost :) show databases;

SHOW DATABASES

Query id: e241df0c-011f-446e-a23b-dc88fc4761bd

┌─name────┐
│ Persons │
│ default │
│ system  │
└─────────┘

3 rows in set. Elapsed: 0.008 sec. 

使用Persons表：

localhost :) use Persons;

USE Persons

Query id: fb5053c6-e117-4691-813d-732db776336c

Ok.

0 rows in set. Elapsed: 0.001 sec. 

然后查看当前在ClickHouse中的表：

localhost :) select * from Persons;

SELECT *
FROM Persons

Query id: 77593946-f0b5-484f-87f4-de654e7f8829

┌─Id_P─┬─LastName─┬─FirstName─┬─Address──┬─City───┐
│    1 │ Jack     │ Green     │ aaa road │ London │
│    2 │ Mary     │ Lisa      │ bbb road │ taiwan │
│    3 │ Tom      │ Brown     │ ccc road │ Alaska │
└──────┴──────────┴───────────┴──────────┴────────┘

3 rows in set. Elapsed: 0.026 sec. 

于是就大功告成啦！