道行尚浅的道场

博客页面

Oracle分页功能的实现与解析

建立测试表 测试表建立 SQL> create table dao_objects 2 as select * from dba_objects ; Table created 收集统计信息 SQL> begin 2 dbms_stats....

Posted by 道行尚浅 on November 29, 2018

使用java读取hdfs上的文件

代码 package hadoop_study; import java.io.InputStream; import java.net.URL; import java.net.URLConnection; import org.apache.hadoop.fs.FsUrlStrea...

Posted by 道行尚浅 on November 28, 2018

hadoop完全分布式安装

规划 主机名 IP地址 HDFS角色 node1 192.168.2.61 namenode node2 192.168.2....

Posted by 道行尚浅 on November 24, 2018

使用SQL统计词频

功能背景 最近在做数据资产梳理,还有还有命名规范. 突然间想统计下表在命名中最常用的简写 通常在数据库中我们使用’_‘分割简写 select TABLE_NAME from dba_tableS WHERE ROWNUM <= 10 AND INSTR(TABLE_...

Posted by 道行尚浅 on November 14, 2018

zookeeper分布式安装

规划 节点名 IP 角色 node1 192.168.2.61   node2 192.168.2.62   ...

Posted by 道行尚浅 on November 13, 2018

MySQL中使用mycat进行实现与读写分离功能

规划 节点名 IP 角色 node1 192.168.2.61 master1 node2 192.168.2.62 ...

Posted by 道行尚浅 on September 12, 2018

MySQL中使用mycat进行分库分表

规划 节点名 IP 角色 node1 192.168.2.61 master node2 192.168.2.62 ...

Posted by 道行尚浅 on September 11, 2018

MySQL MGR搭建

规划 HOSTNAME IP ROLE node1 192.168.2.61 first node node2 192.168...

Posted by 道行尚浅 on September 10, 2018

MySQL PXC搭建

系统准备 安装EPEL [root@node1 ~]# yum install https://dl.fedoraproject.org/pub/epel/epel-release-latest-6.noarch.rpm Loaded plugins: fastestmirror, r...

Posted by 道行尚浅 on September 4, 2018

MySQL 使用Haproxy进行负载均衡

安装haproxy 解压haproxy [root@node4 ~]# tar -zxf haproxy-1.4.20.tar.gz 安装haproxy [root@node4 ~]# cd haproxy-1.4.20 [root@node4 haproxy-1.4.20]# ...

Posted by 道行尚浅 on August 27, 2018

MySQL MHA使用keepalived漂移IP

架构规划 IP 主机名 角色 mha角色 192.168.2.61 node1 主库 node 192.168.2...

Posted by 道行尚浅 on August 26, 2018

MySQL MHA工具包汇总

概述 Manager工具包 脚本名称 作用 masterha_check_repl 主从复制检查 masterha_check_ssh 互信...

Posted by 道行尚浅 on August 25, 2018

MySQL MHA常见问题汇总

mysql command failed with rc 127:0! 问题表现 Fri Aug 24 11:20:37 2018 - [info] Connecting to root@192.168.2.63(192.168.2.63:22).. Checking slave...

Posted by 道行尚浅 on August 24, 2018

MySQL MHA搭建

主机设置 架构规划 IP 主机名 角色 mha角色 192.168.2.61 node1 主库 node 192...

Posted by 道行尚浅 on August 23, 2018

MySQL GTID模式下1062错误详解

错误模拟 查看主库从库数据 主库 mysql> select * from test.t1 ; +----+------+ | c1 | c2 | +----+------+ | 1 | 11 | | 2 | 2 | +----+------+ 2 ro...

Posted by 道行尚浅 on August 11, 2018

MySQL GTID模式下1032错误详解

1032 错误 错误模拟 主库查看数据 mysql> select * from test.t1 ; +----+------+ | c1 | c2 | +----+------+ | 1 | 1 | | 2 | 2 | +----+------+ 2...

Posted by 道行尚浅 on August 11, 2018

使用mysqldump在线搭建GTID主从

查看实例uuid 主库 [mysql@node1 ~]$ cat /mysql1/data/auto.cnf [auto] server-uuid=03fde241-9a55-11e8-aa12-000c291f013a 从库 [mysql@node2 ~]$ cat /mysql1...

Posted by 道行尚浅 on August 10, 2018

使用innobackupex在线搭建GTID主从

查看主库配置文件 [mysql@node1 data]$ cat /mysql1/mysql1.cnf [client] port = 3306 socket = /tmp/mysql1.sock [mysqld] port = 3306 socket = /tmp/mysql1.soc...

Posted by 道行尚浅 on August 10, 2018

MySQL半同步复制

参数说明 参数名 说明 plugin_dir 插件所在文件夹 plugin_load 需要装载的插件 loose_rp...

Posted by 道行尚浅 on August 9, 2018

MySQL主从1062错误详解

1062 错误 错误模拟 创建测试数据库 mysql> create database test; Query OK, 1 row affected (0.09 sec) mysql> create table test.t1(c1 int primary key,c2 ...

Posted by 道行尚浅 on August 9, 2018