[mysqld_safe]
socket = /data/dockermysql/mysql.sock
nice = 0
[mysqld]
pid-file = /data/dockermysql/mysql.pid
socket = /data/dockermysql/mysql.sock
port = 3307
basedir = /usr/local/mysqld
datadir = /data/dockermysql
tmpdir = /tmp
lc-messages-dir = /usr/local/mysql/share/
skip-external-locking
lower_case_table_names=1
default-time_zone = '+8:00'
innodb_buffer_pool_size = 2G
server-id = 100
log_bin = mysql-bin
expire_logs_days = 7
max_binlog_size = 1g
max_allowed_packet = 300M
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
slow_query_log_file = mysql-slow.log
slow_query_log = 1
long_query_time = 1
[client]
default-character-set=utf8mb4
[mysqldump]
quick
quote-names
max_allowed_packet = 1024M
!includedir /etc/mysql/conf.d/
++++++++++++++++++++++++++++++++++++++++++++++++
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'archery',
'USER': 'archery_admin',
'PASSWORD': 'x',
'HOST': 'x,
'PORT': '3307',
'OPTIONS': {
'init_command': "SET sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'",
'charset': 'utf8mb4'
},
'TEST': {
'NAME': 'test_archery',
'CHARSET': 'utf8mb4',
},
}
}
CACHES = {
"default": {
"BACKEND": "django_redis.cache.RedisCache",
"LOCATION": "redis://x:6379/0",
"OPTIONS": {
"CLIENT_CLASS": "django_redis.client.DefaultClient",
"PASSWORD": "x"
}
},
"dingding": {
"BACKEND": "django_redis.cache.RedisCache",
"LOCATION": "redis://x/1",
"OPTIONS": {
"CLIENT_CLASS": "django_redis.client.DefaultClient",
"PASSWORD": "x"
}
}
}
redis-server /usr/local/redis/etc/redis.conf --requirepass "Xjsd.6392"
vi /usr/local/redis/etc/redis.conf
set foreign_key_checks=0
docker stop `docker ps -a -q`
docker-compose -f docker-compose.yml up -d
docker stop `docker ps -a -q`
docker rm `docker ps -a -q`
docker rmi `docker images -q`
redis 端口:6379
mysql端口:3306
inception端口:6669
goinception端口:4000
archery端口:9123
/opt/venv4archery/lib/python3.9/site-packages/redis/connection.py
docker logs archery -f --tail=50
docker-compose -f docker-compose.yml up -d
docker exec -ti archery /bin/bash
#表结构初始化
cd /opt/archery
source /opt/venv4archery/bin/activate
python3 manage.py makemigrations sql
python3 manage.py migrate
#数据初始化
python3 manage.py dbshell<sql/fixtures/auth_group.sql
python3 manage.py dbshell<src/init_sql/mysql_slow_query_review.sql
#创建管理用户
python3 manage.py createsuperuser
SESSION_COOKIE_AGE= 60*300
SESSION_SAVE_EVERY_REQUEST =True
SESSION_EXPIRE_AT_BROWER_CLOSE= False
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'archery',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '127.0.0.1',
'PORT': '3307',
'OPTIONS': {
'init_command': "SET sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'",
'charset': 'utf8mb4'
},
'TEST': {
'NAME': 'test_archery',
'CHARSET': 'utf8mb4',
},
}
}
删除
docker rm -f redis
docker rm -f inception
docker rm -f archery
docker rm -f goinception
docker rm -f mysql
vi /opt/archery/src/docker-compose/archery/settings.py
'HOST': 'xxx'
'MYSQL_DATABASE': archery
MYSQL_ROOT_PASSWORD: xxx
mysql:
image: mysql:5.7
container_name: mysql
restart: always
ports:
- "3306:3306"
volumes:
- "./mysql/my.cnf:/etc/mysql/my.cnf"
- "./mysql/datadir:/data/mysql"
environment:
MYSQL_DATABASE: archery
MYSQL_ROOT_PASSWORD: xxx
goinception的一些审核权限配置
docker exec -it goinception /bin/sh
cat /etc/config.toml
# TiDB Configuration.
# TiDB server host.
host = "0.0.0.0"
# tidb server advertise IP.
advertise_address = ""
# TiDB server port.
port = 4000
# path = ""
[inc]
check_autoincrement_datatype =true
check_autoincrement_init_value =true
check_autoincrement_name =true
check_column_comment =true
check_column_default_value =true
check_column_position_change =true
check_column_type_change =true
check_dml_limit =true
check_dml_orderby =true
check_dml_where =true
check_identifier =true
check_index_prefix =true
check_insert_field =true
check_primary_key =true
check_table_comment =true
check_timestamp_default =true
check_timestamp_count =false
enable_autoincrement_unsigned =true
enable_blob_type =true
enable_column_charset =true
enable_drop_database =true
enable_drop_table =true
enable_enum_set_bit =false
enable_fingerprint =true
enable_foreign_key =false
enable_json_type =true
enable_identifer_keyword =false
enable_not_innodb =false
enable_nullable =false
enable_null_index_name =false
enable_orderby_rand =true
enable_partition_table =true
enable_pk_columns_only_int =true
enable_select_star =false
enable_set_charset =true
enable_set_collation =false
enable_set_engine =false
enable_use_view =true
max_char_length =0
max_insert_rows =0
max_keys =5
max_key_parts =5
max_update_rows =5000
max_primary_key_parts =1
max_allowed_packet =33554432
merge_alter_table =true
check_float_double =true
support_charset ="utf8,utf8mb4"
support_collation ="utf8_general_ci,utf8mb4_general_ci"
backup_host = "10.20.10.47"
backup_port = 3307
backup_user = "root"
backup_password = "Xjsd.6392"
# 设置执行SQL时,会话变量
# 0 表示不做操作,基于远端数据库【默认值】
# > 0 值表示,会话在执行SQL 时获取锁超时的时间
lock_wait_timeout = 10
# 安全更新是否开启.
# -1 表示不做操作,基于远端数据库 [默认值]
# 0 表示关闭安全更新
# 1 表示开启安全更新
sql_safe_updates = -1
# lang = "en-US"
lang = "zh-CN"
# 是否记录全量日志
general_log = false
# 开启统计功能
enable_sql_statistic = true
[inc_level]
er_cant_set_engine = 2
er_cant_set_collation = 2
er_table_must_have_comment = 2
er_column_have_no_comment = 2
er_table_must_have_pk = 2
er_index_name_idx_prefix = 1
er_index_name_uniq_prefix = 1
er_autoinc_unsigned = 2
er_alter_table_once = 2
er_pk_too_many_parts = 2
[osc]
osc_on = false
osc_min_table_size = 16
osc_print_none = false
osc_bin_dir = "/usr/local/bin"
[ghost]
ghost_on = false
ghost_allow_on_master = true
ghost_assume_rbr = true
ghost_chunk_size = 1000
ghost_concurrent_rowcount = true
ghost_cut_over = "atomic"
ghost_cut_over_lock_timeout_seconds = 3
ghost_default_retries = 60
ghost_heartbeat_interval_millis = 500
ghost_max_lag_millis = 1500
ghost_approve_renamed_columns = true
ghost_exponential_backoff_max_interval = 64
ghost_dml_batch_size = 10
[log]
# Log level: debug, info, warn, error, fatal.
level = "error"
# Log format, one of json, text, console.
format = "console"
[mysqld_safe]
socket = /data/dockermysql/mysql.sock
nice = 0
[mysqld]
pid-file = /data/dockermysql/mysql.pid
socket = /data/dockermysql/mysql.sock
port = 3307
basedir = /usr/local/mysqld
datadir = /data/dockermysql
tmpdir = /tmp
lc-messages-dir = /usr/local/mysql/share/
skip-external-locking
lower_case_table_names=1
default-time_zone = '+8:00'
innodb_buffer_pool_size = 2G
server-id = 100
log_bin = mysql-bin
expire_logs_days = 7
max_binlog_size = 1g
max_allowed_packet = 300M
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
slow_query_log_file = mysql-slow.log
slow_query_log = 1
long_query_time = 1
[client]
default-character-set=utf8mb4
[mysqldump]
quick
quote-names
max_allowed_packet = 1024M
!includedir /etc/mysql/conf.d/
++++++++++++++++++++++++++++++++++++++++++++++++
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'archery',
'USER': 'archery_admin',
'PASSWORD': 'xx',
'HOST': 'xxx',
'PORT': '3307',
'OPTIONS': {
'init_command': "SET sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'",
'charset': 'utf8mb4'
},
'TEST': {
'NAME': 'test_archery',
'CHARSET': 'utf8mb4',
},
}
}
CACHES = {
"default": {
"BACKEND": "django_redis.cache.RedisCache",
"LOCATION": "redis://xxxx:6379/0",
"OPTIONS": {
"CLIENT_CLASS": "django_redis.client.DefaultClient",
"PASSWORD": "Xjsd.6392"
}
},
"dingding": {
"BACKEND": "django_redis.cache.RedisCache",
"LOCATION": "redis://xxx:6379/1",
"OPTIONS": {
"CLIENT_CLASS": "django_redis.client.DefaultClient",
"PASSWORD": "Xjsd.6392"
}
}
}
redis-server /usr/local/redis/etc/redis.conf --requirepass "Xjsd.6392"
vi /usr/local/redis/etc/redis.conf
set foreign_key_checks=0
docker stop `docker ps -a -q`
docker-compose -f docker-compose.yml up -d
docker stop `docker ps -a -q`
docker rm `docker ps -a -q`
docker rmi `docker images -q`
http://xxxx:9123
redis 端口:6379
mysql端口:3306
inception端口:6669
goinception端口:4000
archery端口:9123
/opt/venv4archery/lib/python3.9/site-packages/redis/connection.py
docker logs archery -f --tail=50
docker-compose -f docker-compose.yml up -d
docker exec -ti mysql8 /bin/bash
#表结构初始化
cd /opt/archery
source /opt/venv4archery/bin/activate
python3 manage.py makemigrations sql
python3 manage.py migrate
#数据初始化
python3 manage.py dbshell<sql/fixtures/auth_group.sql
python3 manage.py dbshell<src/init_sql/mysql_slow_query_review.sql
#创建管理用户
python3 manage.py createsuperuser
https://open.feishu.cn/open-apis/bot/v2/hook/9d497b66-bd08-4fe2-8b71-aeac7710aa2c
redis-server VI
xjsd2022 9bO4v9Uxx0lVM
2022/09/26 18:19:33 Waiting for: tcp://redis:6379
2022/09/26 18:19:33 Connected to tcp://xxx:3307
2022/09/26 18:20:33 Problem with dial: dial tcp xxxx:6379: i/o timeout. Sleeping 1s
wind =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = l-sj-plm-db-pro02)(PORT = 1521)))(CONNECT_DATA =(SID = wind)))
SESSION_COOKIE_AGE= 60*300
SESSION_SAVE_EVERY_REQUEST =True
SESSION_EXPIRE_AT_BROWER_CLOSE= False
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'archery',
'USER': 'root',
'PASSWORD': '123456',
'HOST': '127.0.0.1',
'PORT': '3307',
'OPTIONS': {
'init_command': "SET sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'",
'charset': 'utf8mb4'
},
'TEST': {
'NAME': 'test_archery',
'CHARSET': 'utf8mb4',
},
}
}
删除
docker rm -f redis
docker rm -f inception
docker rm -f archery
docker rm -f goinception
docker rm -f mysql
vi /opt/archery/src/docker-compose/archery/settings.py
'HOST': 'xxx'
'MYSQL_DATABASE': archery
MYSQL_ROOT_PASSWORD: Xjsd.6392
mysql:
image: mysql:5.7
container_name: mysql
restart: always
ports:
- "3306:3306"
volumes:
- "./mysql/my.cnf:/etc/mysql/my.cnf"
- "./mysql/datadir:/data/mysql"
environment:
MYSQL_DATABASE: archery
MYSQL_ROOT_PASSWORD: Xjsd.6392