wwh的常用命令

BK_DOMAIN=bkyunwei.com
BK_PAAS_PUBLIC_ADDR=paas.bkyunwei.com:80
BK_PAAS_PUBLIC_URL=http://paas.bkyunwei.com:80
BK_CMDB_PUBLIC_ADDR=cmdb.bkyunwei.com:80
BK_CMDB_PUBLIC_URL=http://cmdb.bkyunwei.com:80
BK_JOB_PUBLIC_ADDR=job.bkyunwei.com:80
BK_JOB_PUBLIC_URL=http://job.bkyunwei.com:80
BK_JOB_API_PUBLIC_URL=“http://jobapi.bkyunwei.com:80”

查看mysql库大小：
select TABLE_SCHEMA, concat(truncate(sum(data_length)/1024/1024,2),’ MB’) as data_size,
-> concat(truncate(sum(index_length)/1024/1024,2),‘MB’) as index_size
-> from information_schema.tables
-> group by TABLE_SCHEMA
-> order by data_length desc;

mysql查询表大小
use information_schema;
查询库大小
select concat(round(sum(DATA_LENGTH/1024/1024),2),‘MB’) as data from TABLES where table_schema=‘库名’;

查询指定表大小
select concat(round(sum(DATA_LENGTH/1024/1024),2),‘MB’) as data from TABLES where table_schema=‘库名’ and table_name=‘表名’;

查询所有表大小并排序
SELECT CONCAT(table_schema,’.’,table_name) AS ‘Table Name’, CONCAT(ROUND(table_rows/1000000,4),‘M’) AS ‘Number of Rows’, CONCAT(ROUND(data_length/(102410241024),4),‘G’) AS ‘Data Size’,CONCAT(ROUND(index_length/(102410241024),4),‘G’) AS ‘Index Size’, CONCAT(ROUND((data_length+index_length)/(102410241024),4),‘G’) AS’Total’FROM information_schema.TABLES ORDER BY --total DESC;

查看表分区大小：
SELECT PARTITION_NAME,TABLE_ROWS FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = ‘table’;
awk输出列对齐
|column -t

登录redis
redis-cli -h 192.168.20.211 -p 6379 -a lKEabB1R4p

rabbitmq地址：
http://192.168.20.218:15672/#/
admin
cnCNwJfehg
MQ请求方式
curl -i -u admin:cnCNwJfehg http://192.168.20.218:15672/api/nodes

数组加元素
module_ip=()
module_ip=(${module_ip[@]} ${ip})

数组去重：
a=(1 2 3 4 5 4 3 2 1)
a=($(echo ${a[@]}|sed ‘s/ /\n/g’|sort |uniq))
echo ${a[@]}

启动docker daemon
docker -D -d -H unix:///var/run/docker.sock

获取应用id和token命令
cat /data/install/.app.token |grep cmdb
部署saas超时：

1. 修改paas_agent的配置/data/bkee/etc/paas_agent_config.yaml 中的EXECUTE_TIME_LIMIT： 300
2. 重启appt/appo
3. 修改文件/data/bkee/open_paas/paas/conf/default.py中的EVENT_STATE_EXPIRE_SECONDS = 360
4. 重启paas

3.0

修改部署超时

source /data/install/utils.fc

ssh $BK_APPO_IP
sed -i ‘/EXECUTE_TIME_LIMIT/s/\b[0-9]{1,}\b/3000/g’ /data/bkce/etc/paas_agent_config.yaml
systemc restart bk-paasagent

ssh $BK_PAAS_IP
echo ‘EVENT_STATE_EXPIRE_SECONDS = 3600’ >> /data/bkce/open_paas/paas/conf/settings_production.py
./bkcli restart paas

记录安装步骤 vim /data/install/.bk_install.step
中控机 /data/install/.controller_ip
变量：/data/install/config.env
本机模块安装情况：/data/bkee/.installed_module
查看各个模块token
cat /data/install/.app.token
山西证券paas BvzwCD0ETo

MQ查看队列消息
rabbitmqctl list_vhosts |xargs -n1 rabbitmqctl list_queues -p

清理堵塞队列
rabbitmqctl purge_queue -p vhost名称 队列名称

修改部署saas超时时间

1. 修改paas_agent的配置/data/bkee/etc/paas_agent_config.yaml 中的EXECUTE_TIME_LIMIT： 300
2. 重启appt/appo
3. 修改文件/data/bkee/open_paas/paas/conf/default.py中的EVENT_STATE_EXPIRE_SECONDS = 360
4. 重启paas

mysqldump

source /data/install/
/data/src/service/mysql/bin/mysqldump
-hKaTeX parse error: Undefined control sequence: \ at position 10: MYSQL_IP \̲ ̲ -uMYSQL_USER
-pKaTeX parse error: Undefined control sequence: \ at position 12: MYSQL_PASS \̲ ̲ --skip-opt \…(date +%Y%m%d_%%H%M%S).gz;

3.0修改密码

export DJANGO_SETTINGS_MODULE=“config.ee.prod”
export BK_FILE_PATH=${INSTALL_PATH}/usermgr/cert/saas_priv.txt
python manage.py shell
from bkuser.profiles.models import Profile
from django.contrib.auth.hashers import make_password
admin = Profile.objects.get(username=‘admin’,domain=‘default.local’)
admin.password = make_password(“Canway@1234”)
admin.save()