docker_mycat

KO | EN

gitlite — search

#react #ai #llm #android #machine-learning #deep-learning #docker #java #cli #vue #awesome-list #security #mcp #open-source

(★ 9)

docker mycat

docker_mycat Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

#Docker mycat
This is a docker image mycat 1.6 release.
First of all you need to install docker.

##Quickstart use docker-compose
```
        docker-compose up -d
```
For use this command,you should install docker-compose fisrt,use:
```
        curl -L "https://github.com/docker/compose/releases/download/1.9.0/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
        chmod +x /usr/local/bin/docker-compose
```
Test the installaton:
```
        $ docker-compose --version
          docker-compose version: 1.9.0
```
Note:If you have installed docker-compose already,make sure docker-compose version is higher than 1.6,which can support "v2" version in docker-compose.yml

##Manual start
You should run at least 2 mysql instance firstly for test.
Two servers are mysql docker image file of replication with GTID.
You must enter the directory to run shell script like this:
```
	cd master
	./master.sh [port default=3306]
	cd slave
	./slave.sh [master_ip] [master_port default=3306]
```        
Don't run the script like this:  
```
	./master/master.sh
```    
Beacuse you change the value of $PWD implictly.

You also can start other mysql server as slave just use the same command.
```
	cd slave
	./slave.sh [master_ip] [master_port default=3306]
```
Check if all the servers are booted.
```
	docker ps
```
All mysql server username is root,and password is root.

You can try to connect servers like this:

For master:
```
	mysql -uroot -proot -h[your host IP] -P[port]
```        
For slave:
```
	mysql -uroot -proot -h[your host IP] -P[port]
```

##Build docker image
```    
	docker build -t liuxing/mycat .
```        
##Edit the start script startup.sh.

* ####USERNAME
 
  Username of the mycat.You can use "mysql -u -p" to login. ex:USERNAME=root

* ####PASSWORD
  
  Password of the mycat.You can use "mysql -u -p" to login.ex:PASSWORD=root

* ####DB_NAME

The database you use.Make sure all of then mysql instances(master & slaves) have the same database.
  
  If you have not created it before,create it before start mycat.
  
  Login to master and use the command as below:
  ```
  	create database test;
  ```
  If you have done the mysql replication,you need not to create the database on slave servers.
  
  Mysql replication can do the job by synchronizing the data of  master server.
  
  ex:DB_NAME=test

* ####MASTER_IP_PORT
  
  The ip and port of master server.ex:MASTER_IP_PORT=192.168.100.7:33306

* ####MASTER_USERNAME
  
  The username of master server. ex:MASTER_USERNAME=root

* ####MASTER_PASSWORD
  
  The password of slave server.ex:MASTER_PASSWORD=root

* ####SLAVE_IP_PORT

The ip and port of slave server.You also can add many servers as slave to use a comma.
  
  ex:SLAVE_IP_PORT=192.168.100.7:32768,192.168.100.7:32767

* ####SLAVE_USERNAME

The username of slave server.ex:SLAVE_USERNAME=root,tiger

* ####SLAVE_PASSWORD

The password of slave server.ex:SLAVE_PASSWORD=root,scott

##Startup mycat
```    
	./startup.sh
```       
##Test replication

* Connect to mycat
```
	mysql -uroot -proot -h[your mycat IP] -P[port]
	use test;
	select * from t1;
	insert into t1 values (3,'slave');
	select * from t1;
```
Show the result: 
```
	1  master
	2  master
	3  slave
```
* Connect to master
```
	mysql -uroot -proot -h[your master IP] -P[port]
	use test;
	select * from t1;
```
Show the result: 
```            
	1  master
	2  master
	3  slave
```
* Connect to slave
```
	mysql -uroot -proot -h[your slave IP] -P[port];
	use test;
	select * from t1;
```    
Show the result: 
```
	1  master
	2  master
	3  slave
```

###Test rw-splitting

* Stop the replication of slave by
```
	mysql -uroot -proot -h[your slave IP] -P[port]
	stop slave;
```	
* Insert a record in mycat.
```
	mysql -uroot -proot -h[your mycat IP] -P[port]
	use test;
	insert into t1 values(4,'rw');
	select * from t1;
```
The record is written to master by mycat.So you can't see the record from slave.
Both mycat and slave has the same result: 
```
	1  master
	2  master
	3  slave
``` 
* Connect to master
```
	mysql -uroot -proot -h[your master IP] -P[port]
	use test;
	select * from t1;
```
Show the result at master: 
```
	1  master
	2  master
	3  slave
	4  rw
```
	    
* Recover the replication,connect to slave
```
	mysql -uroot -proot -h[your slave IP] -P[port]
	start slave;
```
The slave server will compelete the replication automaticly from master when slave server is restarted.
So you try to run at slave server.
```	
	select * from t1;
```
Show the result at slave: 
```
	1  master
	2  master
	3  slave
	4  rw
```
Conf file is mycat_conf in local path.
You should restart docker after change any config files use:
```        
	docker restart mycat
```
See how to config your mycat.
        http://www.mycat.org.cn/document/Mycat_V1.6.0.pdf

docker_mycat

docker_mycat Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

docker_mycat

docker_mycat Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README