jnidzwetzki / mysql-ha-cloud Goto Github PK

 Renaming database file /var/lib/proxysql/proxysql.db
 2021-03-21 04:04:36 [INFO] Using OpenSSL version: OpenSSL 1.1.1d  10 Sep 2019
 2021-03-21 04:04:36 [INFO] No SSL keys/certificates found in datadir (/var/lib/proxysql). Generating new keys/certificates.
 2021-03-21 04:04:37,010 INFO root Starting MySQL
 Logging to '/var/lib/mysql/ce864ecd723d.err'.
 2021-03-21T04:04:37.194010Z mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
 2021-03-21 04:04:39,053 INFO root Performing initial ProxySQL setup
     2021-03-21T04:04:39.419Z [ERROR] agent.client: RPC failed to server: method=KVS.Apply server=10.0.8.10:8300 error="rpc error making call: rpc error making call: invalid session "5125b25b-7477-ba31-0885-b227fcad7698""
     2021-03-21T04:04:39.420Z [ERROR] agent.http: Request error: method=PUT url=/v1/kv/mcm/instances/10.0.8.159?acquire=5125b25b-7477-ba31-0885-b227fcad7698 from=127.0.0.1:55222 error="rpc error making call: rpc error making call: invalid session "5125b25b-7477-ba31-0885-b227fcad7698""
 Traceback (most recent call last):
   File "./mysql_cluster_manager.py", line 46, in <module>
     Actions.join_or_bootstrap()
   File "/cluster/mcm/actions.py", line 86, in join_or_bootstrap
     server_id=server_id)
   File "/cluster/mcm/consul.py", line 250, in register_node
     put_result = self.client.kv.put(path, json_string, acquire=self.node_health_session)
   File "/usr/local/lib/python3.7/dist-packages/consul/base.py", line 3069, in put
     params=params, headers=headers, data=value)
   File "/usr/local/lib/python3.7/dist-packages/consul/std.py", line 39, in put
     timeout=self.timeout)))
   File "/usr/local/lib/python3.7/dist-packages/consul/base.py", line 249, in cb
     CB._status(response, allow_404=allow_404)
   File "/usr/local/lib/python3.7/dist-packages/consul/base.py", line 212, in _status
     raise ConsulException("%d %s" % (response.code, response.body))
 consul.base.ConsulException: 500 rpc error making call: rpc error making call: invalid session "5125b25b-7477-ba31-0885-b227fcad7698"

version: "3.8"

networks:
  backend:

volumes:
  backup-volume:

services:
  consul:
    image: consul:1.9
    networks:
       backend:
          aliases:
             - consul_cluster
    environment:
      - CONSUL_BIND_INTERFACE=eth0
    command: agent -ui -data-dir /consul/data -server -client 0.0.0.0 -retry-join consul_cluster -bootstrap-expect=3 
    deploy:
      replicas: 3
      endpoint_mode: dnsrr
      placement:
        max_replicas_per_node: 1
      update_config:
        parallelism: 1
        delay: 60s
      restart_policy:
        condition: on-failure
    ports:
       - target: 8500
         published: 8500
         protocol: tcp
         mode: host

  mysql:
    image: jnidzwetzki/mysql-ha-cloud:latest
    networks:
       backend:
    environment:
      - CONSUL_BIND_INTERFACE=eth1
      - CONSUL_BOOTSTRAP_SERVER=consul_cluster
      - MINIO_ACCESS_KEY=minio
      - MINIO_SECRET_KEY=4SrSScTuXBmP#@uV5gnE4*M4%
      - MINIO_URL=http://10.20.0.9:9009
      - MCM_BIND_INTERFACE=eth1
      - MYSQL_ROOT_PASSWORD=1qazcde3
      - MYSQL_BACKUP_USER=mbu
      - MYSQL_BACKUP_PASSWORD=1qazcde3
      - MYSQL_REPLICATION_USER=mru
      - MYSQL_REPLICATION_PASSWORD=1qazcde3
      - MYSQL_APPLICATION_USER=mau
      - MYSQL_APPLICATION_PASSWORD=1qazcde3
    deploy:
      replicas: 3
      placement:
        max_replicas_per_node: 1
      update_config:
        parallelism: 1
        delay: 60s
      restart_policy:
        condition: on-failure
    ports:
      - 6032:6032
      - 3306:6033

  minio:
    image: minio/minio:RELEASE.2020-10-18T21-54-12Z
    networks:
       backend:
          aliases:
             - minio_endpoint
    volumes:
       - backup-volume:/data
    ports:
       - 9009:9000
    environment:
       - MINIO_ACCESS_KEY=minio
       - MINIO_SECRET_KEY=4SrSScTuXBmP#@uV5gnE4*M4%
    command: server /data