# JavaStage04module01

**Repository Path**: imzhangliang/JavaStage04module01

## Basic Information

- **Project Name**: JavaStage04module01
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2021-06-13
- **Last Updated**: 2021-06-13

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#### 集群环境

mysql-master    172.17.0.4
mysql-slave1    172.17.0.5
mysql-slave2    172.17.0.6

mysql-mha       172.17.0.7

#### 软件版本
mha4mysql-manager_0.58-0_all.deb 
mha4mysql-node_0.58-0_all.deb 


#### 建表语句
```SQL
create database lagou;

create TABLE position (
id int(20),
name varchar(50),
salary varchar(20),
city varchar(50)
) ENGINE=innodb charset=utf8;

insert into position values(1, 'Java', 13000, 'shanghai');
insert into position values(2, 'DBA', 20000, 'beijing');

create TABLE position_detail (
id int(20),
pid int(20),
description text
) ENGINE=innodb charset=utf8;


insert into position_detail values(1, 1, 'Java Developer');
insert into position_detail values(2, 2, 'Database Administrator');

```