# spring-boot-debezium

**Repository Path**: yyyyjinying/spring-boot-debezium

## Basic Information

- **Project Name**: spring-boot-debezium
- **Description**: spring-boot-debezium
- **Primary Language**: Unknown
- **License**: GPL-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2025-02-11
- **Last Updated**: 2025-02-22

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 安装mysql8
```yaml
version: '3'
services:
  nacos_host:
    image: nacos/nacos-server:v2.3.0
    restart: always
    privileged: true
    container_name: nacos_host
    environment:
      - MODE=standalone
      - PREFER_HOST_MODE=hostname
      - MYSQL_SERVICE_HOST=mysql_host
      - MYSQL_SERVICE_DB_NAME=nacos
      - MYSQL_SERVICE_PORT=3306
      - MYSQL_SERVICE_USER=root
      - MYSQL_SERVICE_PASSWORD=123456
      - NACOS_AUTH_IDENTITY_KEY=nacos
      - NACOS_AUTH_IDENTITY_VALUE=nacos
      - NACOS_AUTH_TOKEN=bmFjb3NfMjAyNDAxMTBfc2hpZ3poX25hY29zX3Rva2Vu
      - NACOS_AUTH_CACHE_ENABLE=true
      - TZ=Asia/Shanghai
      - LANG=en_US.UTF-8
      - JVM_XMS=256m
      - JVM_XMX=256m
    volumes:
      - ./sores/nacos/logs:/home/nacos/logs
      - ./sores/nacos/data:/home/nacos/data
      - ./sores/nacos/conf:/home/nacos/conf
      - /etc/localtime:/etc/localtime:ro
    ports:
      - 8848:8848
      - 9848:9848 #2.0新增了两个端口，需要暴露出来
      - 9849:9849 #2.0新增了两个端口，需要暴露出来
    networks:
      - qar-net
    depends_on:
      - mysql_host
  jenkins_host:
    image: jenkins/jenkins:2.440.3-jdk17
    restart: always
    privileged: true
    user: root
    container_name: jenkins_host
    volumes:
      - /export/server/maven:/export/server/maven
      - /export/server/jdk17:/export/server/jdk17
      - /export/server/docker-start/base/sores/jenkins/jenkins-data:/var/jenkins_home
      - /usr/bin/docker:/usr/bin/docker
      - /var/run/docker.sock:/var/run/docker.sock
    ports:
      - 8080:8080
      - 50000:50000
    networks:
      - qar-net
  nginx_host:
    image: nginx:1.23.4
    restart: always
    container_name: nginx_host
    volumes:
      - ./sores/nginx/html:/usr/share/nginx/html
      - ./sores/nginx/conf/conf.d/default.conf:/etc/nginx/conf.d/default.conf
    #  - ./nginx/conf/nginx.conf:/etc/nginx/nginx.conf
      - ./sores/nginx/logs:/var/log/nginx
    ports:
      - 80:80
    networks:
      - qar-net
  redis_host:
    image: redis:7.0.4
    container_name: redis_host
    restart: always
    command: redis-server /usr/local/etc/redis.conf
    # command: redis-server --appendonly no
    volumes:
      - ./sores/redis/conf:/usr/local/etc
      - ./sores/redis/data:/data
    ports:
      - 6379:6379
    networks:
      - qar-net
  pgsql_host:
    image: postgres:10.12
    container_name: pgsql_host
    restart: always
    environment:
      - POSTGRES_PASSWORD=qar123456
    volumes:
      - ./sores/postgres/data:/var/lib/postgresql/data
    ports:
      - 5432:5432
    networks:
      - qar-net
  mysql_host:
    image: hub.atomgit.com/amd64/mysql:8.0.34
    container_name: mysql_host
    restart: always
    environment:
      - MYSQL_ROOT_PASSWORD=123456
    command: >
      --log-bin=mysql-bin
      --binlog-format=row
      --binlog-do-db=mydb
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_unicode_ci
      --default-time-zone=+8:00
    volumes:
      - ./sores/mysql/data/mysql:/var/lib/mysql
      - ./sores/mysql/my.cnf:/etc/my.cnf
    ports:
      - 3306:3306
    networks:
      - qar-net
  es_host:
    image: elasticsearch:7.12.1
    container_name: es_host
    restart: always
    environment:
      - cluster.name=es-docker-cluster
      - http.host=0.0.0.0
      - ES_JAVA_OPTS=-Xms512m -Xmx512m
      - discovery.type=single-node
    volumes:
      - ./sores/es/data:/usr/share/elasticsearch/data
      - ./sores/es/plugins:/usr/share/elasticsearch/plugins
      - ./sores/es/logs:/usr/share/elasticsearch/logs:rw
    ports:
      - 9200:9200
      - 9300:9300
    networks:
      - qar-net
  kibana_host:
    image: kibana:7.12.1
    container_name: kibana_host
    restart: always
    environment:
      - ELASTICSEARCH_HOSTS=http://es_host:9200
    ports:
      - 5601:5601
    networks:
      - qar-net
  elastichd_host:
    image: containerize/elastichd
    container_name: elastichd_host
    restart: always
    ports:
      - 9800:9800
    networks:
      - qar-net
networks:
  qar-net:
    external: true

```
```shell
docker run --name mysql -d -v /export/server/docker-start/base/mysql/data:/var/lib/mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 hub.atomgit.com/amd64/mysql:8.0.34
docker cp mysql:/var/lib/mysql /export/server/docker-start/base/mysql/data
docker cp mysql_host:/etc/my.cnf /export/server/docker-start/base/mysql/my.cnf
```
```sql
> use mysql;
> alter user root@'%' identified by '123456'
> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' WITH GRANT OPTION;
> FLUSH PRIVILEGES;
> SHOW GRANTS FOR 'root'@'%';
> exit

-- java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed 指出在尝试建立数据库连接时，不允许检索公钥
-- 解决办法
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
FLUSH PRIVILEGES;
```

```sql
CREATE TABLE `user_info` (
  `user_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  `gender` tinyint(1) DEFAULT NULL,
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `create_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ID',
  `update_time` datetime DEFAULT NULL,
  `update_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ID',
  `enabled` tinyint(1) DEFAULT '1' COMMENT '1-0-',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


```