K8S-mysql主從部署2018-05-102018-05-30

在kubernetes集群中部署mysql 主從，并開啟同步

版本：

Kubernetes version:1.10.0
mysql:5.6.40
Mysql Image的github地址如下，其中包含Dockerfile及docker-entrypoint.sh
https://github.com/docker-library/mysql/tree/fc3e856313423dc2d6a8d74cfd6b678582090fc7/5.6

部署：

  • 單個(gè)實(shí)例

如果僅運(yùn)行單個(gè)實(shí)例則運(yùn)行
docker pull docker.io/mysql:5.6.40
mysql.yml文件如下

apiVersion: apps/v1beta1
kind: Deployment
metadata:
  name: mysql-master
spec:
  replicas: 1
  template:
    metadata:
      name: mysql-master
      labels:
        app: mysql-master
    spec:
      containers:
        - name: mysql-master
          image: mysql:5.6.40
          imagePullPolicy: Always
          env:
            - name: MYSQL_ROOT_PASSWORD
              value: mysql123
          ports:
            - containerPort: 3306
---
apiVersion: v1
kind: Service
metadata:
  name: mysql-master-service
spec:
  type: NodePort
  ports:
  - port: 3306
    targetPort: 3306
  selector:
    app: mysql-master

  • 主從部署

1. 重新構(gòu)建Mysql Image

docker-entrypoint.sh 文件的第187行添加如下代碼

if [ -n "$MYSQL_MASTER_SERVICEIP" ];then
"${mysql[@]}" <<-EOSQL
CHANGE MASTER TO MASTER_HOST = "$MYSQL_MASTER_SERVICE_SERVICE_HOST",MASTER_PORT = 3306,MASTER_USER = 'root',MASTER_PASSWORD = "$MYSQL_ROOT_PASSWO
RD",MASTER_AUTO_POSITION = 1;start slave;
EOSQL
fi

其中$MYSQL_MASTER_SERVICE_SERVICE_HOST為MASTER的service IP。

重新構(gòu)建mysql image 并上傳本地私倉
docker build -t xxxx:5000/mysql:5.6.40 .
xxxx替換為具體私倉IP
上傳images
docker push xxxx:5000/mysql:5.6.40

2. mysql-configmap.yml配置
apiVersion: v1
kind: ConfigMap
metadata:
  name: yqt-configmap
  namespace: mysql-ns
data:
  my.cnf: |
    [mysqld]
    user = mysql
    datadir = /var/lib/mysql/data
    socket = /var/run/mysqld/mysqld.sock
    max_allowed_packet = 32M
    character_set_server=utf8
    net_read_timeout = 60
    open_files_limit = 8192
    max_connections = 1000
    max_connect_errors = 10000
    skip-name-resolve
    log-output=file
    slow_query_log = 1
    slow_query_log_file =/var/lib/mysql/data/slow.log
    log-error = /var/lib/mysql/data/error.log
    log_warnings = 2
    pid-file = /var/lib/mysql/data/mysql.pid
    long_query_time = 0.1
    log-queries-not-using-indexes = 1
    log_bin_trust_function_creators=1
    table_definition_cache = 256
    table_open_cache = 256
    #binlog & replicate    
    log-bin = mysql-bin
    skip-slave-start = 0
    log-slave-updates  = 1
    expire_logs_days = 7
    sync_binlog = 1
    binlog_format = row
    max_binlog_size = 1G
    binlog_cache_size = 4M
    max_binlog_cache_size = 1G
    #innodb
    innodb_additional_mem_pool_size = 16M
    innodb_buffer_pool_size = 1G
    #innodb_data_file_path = ibdata1:1G:autoextend
    innodb_file_io_threads = 4
    innodb_thread_concurrency = 20
    innodb_flush_log_at_trx_commit = 1
    innodb_log_buffer_size = 16M
    innodb_log_file_size = 512M
    innodb_log_files_in_group = 2
    innodb_file_per_table = 1
    innodb_status_file = 1
    transaction_isolation = READ-COMMITTED
    innodb_flush_method = O_DIRECT
    innodb_write_io_threads=16
    #GTID
    gtid_mode=ON
    enforce_gtid_consistency=ON
    [mysqldump]
    quick
    max_allowed_packet = 32M
  master-docker.cnf: |
    [mysqld]
    skip-host-cache
    skip-name-resolve
    server-id = 10
  slave-docker.cnf: |
    [mysqld]
    skip-host-cache
    skip-name-resolve
    server-id = 20
    read-only = 1

創(chuàng)建configmap
kubectl create -f mysql-configmap.yml

3. mysql-pv-pvc.yml配置
apiVersion: v1
kind: PersistentVolume
metadata:
  name: mysql-master-pv
  namespace: mysql-ns
  labels:
    type: mysql-master-pv
spec:
  capacity:
    storage: 10Gi
  accessModes:
    - ReadWriteOnce
  persistentVolumeReclaimPolicy: Retain
#  nfs:
#    server: x.x.x.x
#    path: "/usr/local/mysql"  
  hostPath:
    path: "/usr/local/mysql/master-data"
---
apiVersion: v1
kind: PersistentVolume
metadata:
  name: mysql-slave-pv
  namespace: ymysql-ns
  labels:
    type: mysql-slave-pv
spec:
  capacity:
    storage: 10Gi
  accessModes:
    - ReadWriteMany
  persistentVolumeReclaimPolicy: Retain
#  nfs:
#    server: x.x.x.x
#    path: "/usr/local/mysql"  
  hostPath:
    path: "/usr/local/mysql/slave-data"
---
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: mysql-master-pvc
  namespace: mysql-ns
spec:
  accessModes:
  - ReadWriteOnce
  resources:
     requests:
       storage: 10Gi
  selector:
     matchLabels:
       type: mysql-master-pv
---
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: mysql-slave-pvc
  namespace: mysql-ns
spec:
  accessModes:
  - ReadWriteMany
  resources:
     requests:
       storage: 10Gi
  selector:
     matchLabels:
       type: mysql-slave-pv

創(chuàng)建pv-pvc
kubectl create -f mysql-pv-pvc.yml

4. mysql-master.yml配置
apiVersion: apps/v1beta1
kind: Deployment
metadata:
  namespace: mysql-ns
  name: mysql-master
spec:
  replicas: 1
  template:
    metadata:
      name: mysql-master
      labels:
        app: mysql-master
    spec:
      containers:
        - name: mysql-master
          image: xxxx:5000/mysql:5.6.40
          imagePullPolicy: IfNotPresent
          env:
            - name: MYSQL_ROOT_PASSWORD
              value: mysql123
          #resources:
          #  requests:
          #    memory: 1Gi
          #    cpu: 1
          #  limits:
          #    memory: 2Gi
          #    cpu: 2
          ports:
            - containerPort: 3306
          volumeMounts:
            - name: mysql-config
              mountPath: /etc/mysql/mysql.conf.d/
            - name: master-config
              mountPath: /etc/mysql/conf.d/
            - name: mysql-data
              mountPath: /var/lib/mysql/data
#            - name: time-cnf
#              mountPath: /etc/localtime
#            readOnly: true
      volumes:
        - name: mysql-data
          persistentVolumeClaim:
            claimName: mysql-master-pvc
        - name: mysql-config
          configMap:
            name: yqt-configmap
            items:
            - key: my.cnf
              path: mysqld.cnf
        - name: master-config
          configMap:
            name: yqt-configmap
            items:
            - key: master-docker.cnf
              path: docker.cnf
              
#        - name: time-cnf
#          hostPath:
#            path: /usr/share/zoneinfo/Asia/Shanghai
---
apiVersion: v1
kind: Service
metadata:
  namespace: mysql-ns
  name: mysql-master-service
spec:
  type: NodePort
  ports:
  - port: 3306
    targetPort: 3306
  selector:
    app: mysql-master

部署mysql主節(jié)點(diǎn)
kubectl create -f mysql-master.yml

5. mysql-slave.yml配置
apiVersion: apps/v1beta1
kind: Deployment
metadata:
  namespace: mysql-ns
  name: mysql-slave
spec:
  replicas: 1
  template:
    metadata:
      name: mysql-slave
      labels:
        app: mysql-slave
    spec:
      containers:
        - name: mysql-slave
          image: xxxx:5000/mysql:5.6.40
          imagePullPolicy: IfNotPresent
          env:
            - name: MYSQL_ROOT_PASSWORD
              value: mysql123
          #resources:
          #  requests:
          #    memory: 1Gi
          #    cpu: 1
          #  limits:
          #    memory: 2Gi
          #    cpu: 2
          ports:
            - containerPort: 3306
          volumeMounts:
            - name: mysql-config
              mountPath: /etc/mysql/mysql.conf.d/
            - name: slave-config
              mountPath: /etc/mysql/conf.d/
            - name: mysql-data
              mountPath: /var/lib/mysql/data
#            - name: time-cnf
#              mountPath: /etc/localtime
#            readOnly: true
      volumes:
        - name: mysql-data
          persistentVolumeClaim:
            claimName: mysql-slave-pvc
        - name: mysql-config
          configMap:
            name: yqt-configmap
            items:
            - key: my.cnf
              path: mysqld.cnf
        - name: slave-config
          configMap:
            name: yqt-configmap
            items:
            - key: slave-docker.cnf
              path: docker.cnf

#        - name: time-cnf
#          hostPath:
#            path: /usr/share/zoneinfo/Asia/Shanghai
---
apiVersion: v1
kind: Service
metadata:
  namespace: mysql-ns
  name: mysql-slave-service
spec:
  type: NodePort
  ports:
  - port: 3306
    targetPort: 3306
  selector:
    app: mysql-slave

啟動(dòng)mysql從節(jié)點(diǎn)，并且自動(dòng)做主從同步
kubectl create -f mysql-slave.yml

最后編輯于 ：
?著作權(quán)歸作者所有,轉(zhuǎn)載或內(nèi)容合作請聯(lián)系作者
【社區(qū)內(nèi)容提示】社區(qū)部分內(nèi)容疑似由AI輔助生成，瀏覽時(shí)請結(jié)合常識(shí)與多方信息審慎甄別。
平臺(tái)聲明：文章內(nèi)容（如有圖片或視頻亦包括在內(nèi)）由作者上傳并發(fā)布，文章內(nèi)容僅代表作者本人觀點(diǎn)，簡書系信息發(fā)布平臺(tái)，僅提供信息存儲(chǔ)服務(wù)。

相關(guān)閱讀更多精彩內(nèi)容

  • 之前相關(guān)的文章請參考：Docker集群管理方案Kubernetes之部署Docker集群管理方案Kubernete...
    paulliu閱讀 25,289評(píng)論 7贊 32
  • jHipster - 微服務(wù)搭建 CC_簡書[http://m.itdecent.cn/u/be0d56c4...
    quanjj閱讀 936評(píng)論 0贊 2
  • 經(jīng)常聽身邊的朋友說自己很迷茫，覺得生活沒有目標(biāo)，生活甚是困擾。 好像迷茫已然 成為了當(dāng)下年輕人的一種典型的精神狀態(tài)...
    易安公子閱讀 956評(píng)論 0贊 2
  • 剛才跑去看了《云畫的月光》因?yàn)椤墩埢卮?988》很喜歡阿澤這個(gè)人物角色，但是后來看到他拍的辱華廣告一些消息，...
    阿拉燈閱讀 371評(píng)論 0贊 0
  • 今天他給我打了電話 我下課回過去了 我說什么事情 他說沒有事情 沒有事情就不能給你打電話嗎 我很開心 真的 但不知...
    西鴿閱讀 201評(píng)論 0贊 0

友情鏈接更多精彩內(nèi)容