摘要:
ClickHouse 视频课程 大数据 MergeTree 字典 DBeaver Strictness Hierarchical AggregatingMergeTree CollapsingMergeTree VersionedCollapsingMergeTree 阅读全文
摘要:
目前CDH支持的spark版本都是1.x, 如果想要使用spark 2x的版本, 只能编译spark源码生成支持CDH的版本。一、准备工作找一台Linux主机, 由于spark源码编译会下载很多的第三方类库包, 因此需要主机能够联网。1、安装Java, 配置环境变量, 版本为JDK1.7或者以上下载地址:http://www.oracle.com/technetwork/java/javase/d... 阅读全文
摘要:
1、修改保护模式DGMGRL> edit configuration set protection mode as maxAvailability;Succeeded.2、修改日志同步方式DGMGRL> show database verbose xiaohe 'LogXptMode' LogXptMode = 'ASYNC'DGMGRL> show database verbose xiaoh... 阅读全文
摘要:
一、环境准备1、数据库软件准备(1)、在主节点,安装单机数据库软件并创建数据库。(2)、在备库, 安装单机数据库软件, 但是不创建数据库。2、操作系统配置在/etc/hosts下面配置主机名。$ cat /etc/hosts127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4::1 ... 阅读全文
摘要:
在使用Datagurd broker进行Datagurd主备切换时报ORA-12514监听异常, 详细信息如下:DGMGRL> switchover to xiaohe;Performing switchover NOW, please wait...New primary database "xiaohe" is opening...Operation requires shutdown of ... 阅读全文
摘要:
现象:在表上面新建主键报ORA-08102的异常:SQL> alter table t add primary key(id);alter table t add primary key(id)*ERROR at line 1:ORA-00604: error occurred at recursive SQL level 1ORA-08102: index key not found, obj#... 阅读全文
摘要:
1、主机规划序号主机名IP地址角色1nn-1192.168.9.21NameNode、mr-jobhistory、zookeeper、JournalNode2nn-2192.168.9.22Secondary NameNode、JournalNode3dn-1192.168.9.23DataNode、JournalNode、zookeeper、ResourceManager、NodeManager... 阅读全文
摘要:
1、主机规划序号主机名IP地址角色1nn-1192.168.9.21NameNode、mr-jobhistory、zookeeper、JournalNode2nn-2192.168.9.22Secondary NameNode、JournalNode3dn-1192.168.9.23DataNode、JournalNode、zookeeper、ResourceManager、NodeManager... 阅读全文
摘要:
告警原文:The health test result for DATA_NODE_BLOCK_COUNT has become concerning: The DataNode has 500,008 blocks. Warning threshold: 500,000 block(s). CDH官网解释:This is a DataNode health test that checks fo... 阅读全文