不多说,直接上干货!
写在前面的话
我这里,四个节点的bigdata集群。分别为cmbigdata1、cmbigdata2、cmbigdata3和cmbigdata4。
https://i.cnblogs.com/posts?categoryid=916378
CentOS6.5下Cloudera安装搭建部署大数据集群(图文分五大步详解)(博主强烈推荐)
其中,cmbigdata1即做server,又做agent。
cmbigdata2、cmbigdata3和cmbigdata4都是做agent。
注意:
CDH版本的Phoenix的安装,需要我们自己编译。
1、下载
https://github.com/chiastic-security/phoenix-for-cloudera/tree/4.8-HBase-1.2-cdh5.8
2、编译(编译时间较长,耐心等待)
mvn clean package -DskipTests
3、解压
将编译好的phoenix-4.8.0-cdh5.8.0.tar.gz解压出来
[root@cmbigdata1 phoenix]# tar -zxvf phoenix-4.8.0-cdh5.8.0.tar.gz [root@cmbigdata1 phoenix]# cd phoenix-4.8.0-cdh5.8.0 [root@cmbigdata1 phoenix-4.8.0-cdh5.8.0]# ll total 166152 drwxr-xr-x 2 root root 4096 Apr 18 16:41 bin -rw-r--r-- 1 root root 1930 Aug 8 2016 build.txt drwxr-xr-x 3 root root 4096 Aug 8 2016 dev drwxr-xr-x 2 root root 4096 Aug 8 2016 docs drwxr-xr-x 3 root root 4096 Aug 8 2016 examples drwxr-xr-x 2 root root 4096 Apr 18 16:40 lib -rw-r--r-- 1 root root 113247548 Apr 18 14:43 phoenix-4.8.0-cdh5.8.0-client.jar -rw-r--r-- 1 root root 6619716 Apr 18 14:30 phoenix-4.8.0-cdh5.8.0-queryserver.jar -rw-r--r-- 1 root root 22498517 Apr 18 14:43 phoenix-4.8.0-cdh5.8.0-server.jar -rw-r--r-- 1 root root 27739579 Apr 18 14:29 phoenix-4.8.0-cdh5.8.0-thin-client.jar
4、将phoenix-4.8.0-cdh5.8.0-server.jar拷贝到每一个RegionServer下
[root@cmbigdata2~]# find / -name 'phoenix-4.8.0-cdh5.8.0-server.jar' /soft/bigdata/clouderamanager/cloudera/parcels/CDH-5.10.0-1.cdh5.10.0.p0.41/lib/hbase/lib/phoenix-4.8.0-cdh5.8.0-server.jar
cmbigdata2和cmbigdata3和cmbigdata4一样。
5、增加hbase-site.xml 配置
<property>
<name>hbase.table.sanity.checks</name>
<value>false</value>
</property>
在集群管理页面点击Hbase,进入Hbase管理界面
点击配置:
选择高级:
增加如下配置:
6、重启Hbase
这个很简单,不多说,会玩cloudermanager的人都知道。
7、登录phoenix
进入phoenix-4.8.0-cdh5.8.0/bin目录执行。
[root@cmbigdata1 phoenix-4.8.0-cdh5.8.0]# cd /soft/phoenix/phoenix-4.8.0-cdh5.8.0/bin/ [root@cmbigdata1 bin]# ll total 140 -rwxr-xr-x 1 root root 32440 Aug 8 2016 daemon.py -rwxr-xr-x 1 root root 1881 Aug 8 2016 end2endTest.py -rw-r--r-- 1 root root 1621 Aug 8 2016 hadoop-metrics2-hbase.properties -rw-r--r-- 1 root root 3056 Aug 8 2016 hadoop-metrics2-phoenix.properties -rw-r--r-- 1 root root 1084 Aug 8 2016 hbase-site.xml -rw-r--r-- 1 root root 2583 Aug 8 2016 log4j.properties -rwxr-xr-x 1 root root 5128 Aug 8 2016 performance.py -rwxr-xr-x 1 root root 3249 Aug 8 2016 pherf-cluster.py -rwxr-xr-x 1 root root 2729 Aug 8 2016 pherf-standalone.py -rwxr-xr-x 1 root root 9354 Aug 8 2016 phoenix_utils.py -rw-r--r-- 1 root root 6082 Apr 18 16:41 phoenix_utils.pyc -rwxr-xr-x 1 root root 2739 Aug 8 2016 psql.py -rwxr-xr-x 1 root root 7659 Aug 8 2016 queryserver.py -rw-r--r-- 1 root root 1820 Aug 8 2016 readme.txt -rwxr-xr-x 1 root root 4315 Aug 8 2016 sqlline.py -rwxr-xr-x 1 root root 5426 Aug 8 2016 sqlline-thin.py -rw-r--r-- 1 root root 6895 Aug 8 2016 tephra -rwxr-xr-x 1 root root 2037 Aug 8 2016 tephra-env.sh -rwxr-xr-x 1 root root 6884 Aug 8 2016 traceserver.py [root@cmbigdata1 bin]# ./sqlline.py slave1:2181 Setting property: [incremental, false] Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix:slave1:2181 none none org.apache.phoenix.jdbc.PhoenixDriver Connecting to jdbc:phoenix:slave1:2181 SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/soft/phoenix/phoenix-4.8.0-cdh5.8.0/phoenix-4.8.0-cdh5.8.0-client.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/soft/bigdata/clouderamanager/cloudera/parcels/CDH-5.10.0-1.cdh5.10.0.p0.41/jars/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] 17/04/18 20:48:14 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable Connected to: Phoenix (version 4.8) Driver: PhoenixEmbeddedDriver (version 4.8) Autocommit status: true Transaction isolation: TRANSACTION_READ_COMMITTED Building list of tables and columns for tab-completion (set fastconnect to true to skip)... 264/264 (100%) Done Done sqlline version 1.1.9 0: jdbc:phoenix:cmbigdata1:2181>
8、简单测试
扩展
Apache版Phoenix的安装(图文详解)
同时,大家可以关注我的个人博客:
http://www.cnblogs.com/zlslch/ 和 http://www.cnblogs.com/lchzls/
人生苦短,我愿分享。本公众号将秉持活到老学到老学习无休止的交流分享开源精神,汇聚于互联网和个人学习工作的精华干货知识,一切来于互联网,反馈回互联网。
目前研究领域:大数据、机器学习、深度学习、人工智能、数据挖掘、数据分析。 语言涉及:Java、Scala、Python、Shell、Linux等 。同时还涉及平常所使用的手机、电脑和互联网上的使用技巧、问题和实用软件。 只要你一直关注和呆在群里,每天必须有收获
以及对应本平台的QQ群:161156071(大数据躺过的坑)