Synchronize Canal Mysql binlog to Hbase ES
1, Canal introduction
In the early days, Alibaba had the business requirement of cross machine room synchronization due to the deployment of dual machine rooms in Hangzhou and the United States. The implementation method was mainly to obtain incremental changes based on the business trigger. Since 2010, the business has gradually tried to obta ...
Added by Voodoo Jai on Tue, 21 Sep 2021 04:39:54 +0300
CDH6.3.2 Enable Kerberos integration using phoenix
Tags (space delimited): building large data platforms
1. Download and install Phoenix parcel
2. Install CSD files
3. Add Phoenix service in Cloudera Manager (provided HBase service is installed)
4. Configure HBase for Phoenix
V. Verify Phoenix installation and smoke test
6. Import Data Validation Test
7. Integration of phoinex schema with ...
Added by lszanto on Thu, 04 Jun 2020 19:45:25 +0300
Location and Solution of Large Backlog Problem in HBase2.0 replication wal znode
phenomenon
There are two clusters A and B on the line, which are configured with two-way synchronization and single activity, i.e. only one cluster will be visited at a certain time by the business layer.A lot of exceptions have been reported in the regionserver log of Cluster A recently, but the monitoring page is working and functionality is ...
Added by oliverw92 on Wed, 08 Apr 2020 04:40:06 +0300
Hbase data backup case explanation
Data backup of HBase
1.1 backup the table based on the class provided by HBase
Use the class provided by HBase to export the data of a table in HBase to HDFS, and then to the test HBase table.
(1) = = export from hbase table to HDFS==
[hadoop@node01 shells]$ hbase org.apache.hadoop.hbase.mapreduce.Export myuser /hbase_data/myuser_bak
(2 ...
Added by ShashidharNP on Mon, 24 Feb 2020 13:26:23 +0200
HBase 2.1.6 coprocessor usage
For version 2.1.6, the use of coprocessor requires the introduction of HBase common dependency.
Next, record the detailed steps of debugging the test coprocessor
Case background
There are two tables, user and people. Each table has a person column family. Now, before inserting "people:name ...
Added by leeroy1 on Sun, 16 Feb 2020 06:26:51 +0200
Phoenix duplicate record -- the reason and solution of duplicate query data
Problem description
issue A: after turning on the parameter (phoenix.stats.enabled=true), use Phoenix SQL to query the data, and there are duplicates (the data found is more than the actual content stored in HBase)
issue B: after the parameter is closed (phoenix.stats.enabled=false), Phoenix SQL performance decreases.
Environmental Science
Phoe ...
Added by evan18h on Fri, 06 Dec 2019 21:55:32 +0200
2. hbase -- integrate Phoenix to implement SQL like operation hbase
I. Phoenix overview
1, introductionPhoenix can be understood as the query engine of HBase, Phoenix, a project open-source by saleforce.com, and then donated to Apache. It is equivalent to a Java middleware to help developers, such as using jdbc to access relational databases, and accessing NoSql database HBase.
phoenix, the table and data of o ...
Added by zubinkasad on Tue, 05 Nov 2019 02:24:38 +0200
Data Processing Delay (GC pool) Caused by hbase GC
In the process of time maneuvering, judging by adding time stamp to the program, when inquiring HBase in batches, there will be some data inquiry time more than 8s, which is definitely unacceptable. Looking at hbase's logs, we can find the reasons. There are similar logs'GC pool'. It is speculated th ...
Added by muadzir on Fri, 04 Oct 2019 22:23:57 +0300
zookeeper-3.4.14 Installation Document
zookeeper installation
1. Upload installation package to / opt directory
2. Decompression:
tar -zxf /opt/zookeeper-3.4.14.tar.gz -C ./
3. Configure environment variables:
vim /etc/profile
export ZK_HOME=/opt/zookeeper-3.4.14
export PATH=$Z ...
Added by cage on Wed, 21 Aug 2019 09:48:25 +0300
pinpoint installation deployment (2)
Explanation: I don't know why the editor suddenly got stuck. It can only be divided into two pieces
4. Install pinpoint-web
4.1 Deploy the war package
Unzip Tomcat and move the Tomcat rename to the specified location
cd /home/pp_res/
tar -zxvf apache-tomcat-8.0.36.tar.gz
mv apache-tomcat-8.0.36/ /data/service/pp-web
Modify the configura ...
Added by bhonan on Wed, 12 Jun 2019 20:42:46 +0300