作者：dongfangwujie

1、重新梳理信心

2、坚持自我不放弃

3、学会减轻压力

4、学习充电

5、适量参加运动

6、人与人之间和谐相处

7、适时释放

8、改变形象

9、制造环境

10、另辟蹊径

The real difficulty is to overcome how you think about yourself.

A loving heart is the beginning of all knowledge

[base]
name=CentOS-$releasever – Base
baseurl=http://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/os/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

#released updates
[updates]
name=CentOS-$releasever – Updates
baseurl=http://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/updates/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

#additional packages that may be useful
[extras]
name=CentOS-$releasever – Extras
baseurl=http://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/extras/$basearch/
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

#additional packages that extend functionality of existing packages
[centosplus]
name=CentOS-$releasever – Plus
baseurl=http://mirrors.tuna.tsinghua.edu.cn/centos/$releasever/centosplus/$basearch/
gpgcheck=1
enabled=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-7

ip route show table local type local

ip route list

netstat -rn

Forgot all the reasons why it won’t work, and believe the one reason why it work.

逻辑备份

逻辑备份
mysqldump -A -B --master-data=2 --single-transaction|gzip >/opt/all.sql.gz
恢复
zcat opt/all.sql.gz|mysql
mysqlbinlog mysql-binlog.000008 mysql-bin.000009 >bin.sql
mysql <bin.sql 

物理备份

冷备份方式
cp、rsync、tar、scp等复制工具将MySQL数据文件复制成多份。
热备份方式
Xtrabackup

核心的SQL

DQL 数据查询语句。select

DML数据操作语言。insert、update、delete

DDL数据定义语言。create、drop、alter

DCL数据控制语言。grant、revoke

非核心

TPL事务处理语言。BEGIN TRASACTION COMMIT ROLLBACK

CCL 指针控制语言

FROM canal/canal-server:v1.1.5
 RUN mkdir /home/admin/canal-server/conf/estate/
 RUN mv /home/admin/canal-server/conf/example /tmp/
 ADD instance.properties /home/admin/canal-server/conf/estate/
EXPOSE 11110 11111 11112 9100 
WORKDIR /home/admin 
ENTRYPOINT [ "/alidata/bin/main.sh" ]
 CMD [ "/home/admin/app.sh" ] 

出自https://github.com/alibaba/canal/blob/master/docker/Dockerfile

cat dockerfile

FROM centos:7.6.1810
RUN mkdir /etc/yum.repos.d/bak /apps
RUN mv /etc/yum.repos.d/*repo /etc/yum.repos.d/bak
RUN curl -o /etc/yum.repos.d/CentOS-Base.repo https://mirrors.aliyun.com/repo/Centos-7.repo
RUN yum clean all && yum makecache
RUN yum -y install gcc gcc-c++ zlib zlib-devel openssl openssl-devel pcre-devel unzip patch net-tools
RUN groupadd -r nginx
RUN useradd -s /sbin/nologin -g nginx -r nginx
RUN curl -o nginx-1.22.0.tar.gz http://nginx.org/download/nginx-1.22.0.tar.gz
RUN tar -zxvf nginx-1.22.0.tar.gz && cd nginx-1.22.0 && ./configure –prefix=/apps/nginx/ –with-http_ssl_module –user=nginx –group=nginx –with-http_gzip_static_module –with-http_stub_status_module –with-stream && make -j4 && make install
ADD init.sh /init.sh
CMD [“/bin/bash”,”init.sh”]

cat init.sh

/apps/nginx/sbin/nginx -g ‘daemon off;’

构建nginx

docker build -t nginx_manal:v2 .

启动服务

docker run -d -p 80:80 nginx_manal:v2

结果测试