欧美free性护士vide0shd,老熟女,一区二区三区,久久久久夜夜夜精品国产,久久久久久综合网天天,欧美成人护士h版

首頁綜合 正文
目錄

柚子快報激活碼778899分享:微服務(wù)架構(gòu)中間件安裝部署

柚子快報激活碼778899分享:微服務(wù)架構(gòu)中間件安裝部署

http://yzkb.51969.com/

微服務(wù)架構(gòu)中間件安裝部署

jdk安裝

安裝包jdk-8u144-linux-x64.tar.gz

先檢查系統(tǒng)原版本的jdk并卸載 rpm -qa | grep java 顯示信息如下: tzdata-java-2014g-1.el6.noarch java-1.6.0-openjdk-1.6.0.0-11.1.13.4.el6.x86_64 java-1.7.0-openjdk-1.7.0.65-2.5.1.2.el6_5.x86_64 卸載OpenJDK,執(zhí)行以下操作: rpm -e --nodeps tzdata-java-2014g-1.el6.noarch rpm -e --nodeps java-1.6.0-openjdk-1.6.0.0-11.1.13.4.el6.x86_64 rpm -e --nodeps java-1.7.0-openjdk-1.7.0.65-2.5.1.2.el6_5.x86_64 再次查看JDK信息,確認已經(jīng)卸載成功 rpm –qa | grep java 上傳jdk-8u144-linux-x64.tar.gz到/home目錄下 tar xvf jdk-8u144-linux-x64.tar.gz # 壓縮包解壓 mv jdk-8u144 jdk1.8 # 將jdk目錄更名,以便配置環(huán)境變量 打開環(huán)境變量配置文件,向文件最后追加以下內(nèi)容 vim /etc/profile export JAVA_HOME=/home/jdk1.8 export JRE_HOME=

J

A

V

A

H

O

M

E

/

j

r

e

e

x

p

o

r

t

P

A

T

H

=

JAVA_HOME/jre export PATH=

JAVAH?OME/jreexportPATH=PATH:

J

A

V

A

H

O

M

E

/

b

i

n

e

x

p

o

r

t

C

L

A

S

S

P

A

T

H

=

.

/

:

JAVA_HOME/bin export CLASSPATH=./:

JAVAH?OME/binexportCLASSPATH=./:JAVA_HOME/lib:$JAVA_HOME/jre/lib 保存退出 使修改立即生效,執(zhí)行如下命令 source /etc/profile java -version # 查看jdk版本是否為1.8

nginx安裝

請使用root用戶登錄執(zhí)行以下命令,安裝nginx依賴包,兩臺服務(wù)器都執(zhí)行如下命令

tar zxvf nginx-1.14.2.tar.gz cd nginx-1.14.2 ./configure --prefix=/opt/nginx make make install cd /opt/nginx 修改主配置/opt/nginx/conf/nginx.conf 在http{ }里添加 include /opt/nginx/conf.d/*.conf; 創(chuàng)建目錄和虛擬配置文件 mkdir /opt/nginx/conf.d vim /opt/nginx/conf.d/gateway.conf 內(nèi)容如下 server { listen 80; server_name localhost; location / { gzip on; gzip_buffers 32 4K; gzip_comp_level 6; gzip_min_length 100; gzip_types application/javascript text/css text/xml; root /opt/dist/; try_files $uri KaTeX parse error: Expected 'EOF', got '}' at position 36: …x index.html; }? location @rou… /index.html last; } location /adt/ { proxy_pass http://127.0.0.1:81/; client_max_body_size 100m; } error_page 500 502 503 504 /50x.html; location = /50x.html { root html; } } 解釋: /opt/dist/是前端頁面文件 location /adt/ { proxy_pass http://127.0.0.1:81/; client_max_body_size 100m; } 跳轉(zhuǎn)網(wǎng)關(guān)jar包sc-gateway-1.0.0.jar的啟動ip和端口,具體ip需要修改 nginx檢查和啟動 /sbin/nginx -t #配置文件檢查 ./sbin/nginx #啟動nginx ./sbin/nginx -s reload #nginx平滑重啟

rocketmq集群安裝

集群方式:雙主雙從 機器數(shù)量:兩臺。 IP分別是1.1.1.1和1.1.1.2 (ip只做示范用,根據(jù)實際情況來) 兩臺需要先安裝jdk1.8,參照jdk安裝步驟。

把安裝包上傳到兩臺服務(wù)器/opt/下 unzip rocketmq-all-4.7.0-bin-release.zip mv rocketmq-all-4.7.0-bin-release rocketmq 我們需要修改兩臺機器/opt/rocketmq/conf/2m-2s-asyn/下的 broker-a.properties (1.1.1.1機器修改) broker-a-s.properties (1.1.1.1機器修改) broker-b.properties (1.1.1.2機器修改) broker-b-s.properties (1.1.1.2機器修改) 四個文件。

1.1.1.1修改/opt/rocketmq/conf/2m-2s-async/broker-a.properties

namesrvAddr=1.1.1.1:9876;1.1.1.2:9876 brokerClusterName=DefaultCluster brokerName=broker-a brokerIP1=1.1.1.1 brokerId=0 autoCreateTopicEnable=false sendMessageThreadPoolNums=128 deleteWhen=04 fileReservedTime=48 brokerRole=SYNC_MASTER flushDiskType=ASYNC_FLUSH #存儲路徑 storePathRootDir=/opt/rocketmq/store #commitLog存儲路徑 storePathCommitLog=/opt/rocketmq/store/commitlog #消費隊列存儲路徑 storePathConsumeQueue=/opt/rocketmq/store/consumequeue #消息索引存儲路徑 storePathIndex=/opt/rocketmq/store/index #checkpoint 文件存儲路徑 storeCheckpoint=/opt/rocketmq/store/checkpoint #abort 文件存儲路徑 abortFile=/opt/rocketmq/store/abort #發(fā)送消息是否使用可重入鎖 useReentrantLockWhenPutMessage=true #消息在發(fā)送隊列超時時間 waitTimeMillsInSendQueue=300

1.1.1.2修改/opt/rocketmq/conf/2m-2s-async/broker-a-s.properties

namesrvAddr=1.1.1.1:9876;1.1.1.2:9876 brokerClusterName=DefaultCluster brokerName=broker-a brokerIP1=1.1.1.1 listenPort=10950 brokerId=1 autoCreateTopicEnable=false sendMessageThreadPoolNums=128 deleteWhen=04 fileReservedTime=48 brokerRole=SLAVE flushDiskType=ASYNC_FLUSH #存儲路徑 storePathRootDir=/opt/rocketmq/store/slave #commitLog存儲路徑 storePathCommitLog=/opt/rocketmq/store/slave/commitlog #消費隊列存儲路徑 storePathConsumeQueue=/opt/rocketmq/store/slave/consumequeue #消息索引存儲路徑 storePathIndex=/opt/rocketmq/store/slave/index #checkpoint 文件存儲路徑 storeCheckpoint=/opt/rocketmq/store/slave/checkpoint #abort 文件存儲路徑 abortFile=/opt/rocketmq/store/slave/abort #發(fā)送消息是否使用可重入鎖 useReentrantLockWhenPutMessage=true #消息在發(fā)送隊列超時時間 waitTimeMillsInSendQueue=300

1.1.1.3修改/opt/rocketmq/conf/2m-2s-async/broker-b.properties

namesrvAddr=1.1.1.1:9876;1.1.1.2:9876 brokerClusterName=DefaultCluster brokerName=broker-b brokerIP1=1.1.1.2 brokerId=0 autoCreateTopicEnable=false sendMessageThreadPoolNums=128 deleteWhen=04 fileReservedTime=48 brokerRole=SYNC_MASTER flushDiskType=ASYNC_FLUSH #存儲路徑 storePathRootDir=/opt/rocketmq/store #commitLog存儲路徑 storePathCommitLog=/opt/rocketmq/store/commitlog #消費隊列存儲路徑 storePathConsumeQueue=/opt/rocketmq/store/consumequeue #消息索引存儲路徑 storePathIndex=/opt/rocketmq/store/index #checkpoint 文件存儲路徑 storeCheckpoint=/opt/rocketmq/store/checkpoint #abort 文件存儲路徑 abortFile=/opt/rocketmq/store/abort #發(fā)送消息是否使用可重入鎖 useReentrantLockWhenPutMessage=true #消息在發(fā)送隊列超時時間 waitTimeMillsInSendQueue=300

1.1.1.4修改/opt/rocketmq/conf/2m-2s-async/broker-b-s.properties

namesrvAddr=1.1.1.1:9876;1.1.1.2:9876 brokerClusterName=DefaultCluster brokerName=broker-b brokerIP1=1.1.1.2 listenPort=10950 brokerId=1 autoCreateTopicEnable=false sendMessageThreadPoolNums=128 deleteWhen=04 fileReservedTime=48 brokerRole=SLAVE flushDiskType=ASYNC_FLUSH #存儲路徑 storePathRootDir=/opt/rocketmq/store/slave #commitLog存儲路徑 storePathCommitLog=/opt/rocketmq/store/slave/commitlog #消費隊列存儲路徑 storePathConsumeQueue=/opt/rocketmq/store/slave/consumequeue #消息索引存儲路徑 storePathIndex=/opt/rocketmq/store/slave/index #checkpoint 文件存儲路徑 storeCheckpoint=/opt/rocketmq/store/slave/checkpoint #abort 文件存儲路徑 abortFile=/opt/rocketmq/store/slave/abort #發(fā)送消息是否使用可重入鎖 useReentrantLockWhenPutMessage=true #消息在發(fā)送隊列超時時間 waitTimeMillsInSendQueue=300

修改啟動參數(shù)

默認啟動一般需要4-8G的虛擬機jvm參數(shù)空間,修改為2g 兩臺機器都修改/opt/rocketmq/bin/runserver.sh中的

JAVA_OPT="${JAVA_OPT} -server -Xms2g -Xmx2g -Xmn2g -XX:MetaspaceSize=128m -XX:MaxMetaspaceSize=320m"

兩臺機器都修改/opt/rocketmq/bin/runbroker.sh中的

JAVA_OPT="${JAVA_OPT} -server -Xms2g -Xmx2g -Xmn2g"

啟動服務(wù)

兩臺服務(wù)器都啟動mqnamesrv

nohup sh /opt/rocketmq/bin/mqnamesrv &

1.1.1.1啟動broker

nohup sh /opt/rocketmq/bin/mqbroker -c /opt/rocketmq/conf/2m-2s-async/broker-a.properties > broker-a.log &

nohup sh /opt/rocketmq/bin/mqbroker -c /opt/rocketmq/conf/2m-2s-async/broker-a-s.properties > broker-a-s.log &

1.1.1.2啟動broker

nohup sh /opt/rocketmq/bin/mqbroker -c /opt/rocketmq/conf/2m-2s-async/broker-b.properties > broker-b.log &

nohup sh /opt/rocketmq/bin/mqbroker -c /opt/rocketmq/conf/2m-2s-async/broker-b-s.properties > broker-b-s.log &

界面化安裝

上傳 rocketmq-console-ng-1.0.1.jar

nohup java -jar rocketmq-console-ng-1.0.1.jar --server.port=8080 --rocketmq.config.namesrvAddr=127.0.0.1:9876 > mqconsole.log & 瀏覽器訪問8080端口 可以看到集群情況

添加topic sc-charge-service-topic sc-credit-service-topic sc-decision-service-topic sc-process-controller-topic sc-service-async-topic sc-variable-execute-topic

redis集群安裝

安裝包 redis-5.0.4.tar.gz redis集群需要6個節(jié)點,每臺服務(wù)器兩個節(jié)點,所以需要三臺中間件服務(wù)器 17.1.111.172 17.1.111.173 17.1.111.174 (ip只做示范,具體根據(jù)實際來) redis安裝包上傳至上面三臺服務(wù)器指定安裝目錄后解壓 在每臺服務(wù)器做如下操作(可開啟多個xshell批量發(fā)送命令) tar zxvf redis-5.0.4.tar.gz 進入解壓后目錄進行編譯安裝

cd redis-5.0.4 make && make install 期間如果有報錯就是系統(tǒng)缺少依賴包,根據(jù)提示安裝即可 mkdir -p /home/redis-cluster/7001 # 創(chuàng)建集群目錄及節(jié)點 mkdir -p /home/redis-cluster/7002 # 創(chuàng)建集群目錄及節(jié)點 cp redis.conf /home/redis-cluster/7001 cp redis.conf /home/redis-cluster/7002 然后都進行修改配置文件,此處列舉一個,其他節(jié)點請按實際修改 vim /home/redis-cluster/7001/redis.conf bind 17.1.111.172 //修改為本機ip地址 port 7001 //定義端口號 daemonize yes //開啟redis后臺運行 masterauth test@redis2019 //設(shè)置集群redis連接密碼 requirepass test@redis2019 //修改redis連接密碼 pidfile /home/redis-cluster/7001/redis_7001.pid //pid文件 logfile “/home/redis-cluster/7001/7001.log” //開啟redis的日志文件 cluster-enabled yes //開啟集群 cluster-config-file nodes_7001.conf //集群的配置 配置文件首次啟動自動生成 cluster-node-timeout 15000 //請求超時 appendonly yes //aof日志開啟

cp redis.conf …/7002/ //配置文件拷貝到7002文件夾 替換7002配置文件里的7001配置 配置都完成后可以啟動各個節(jié)點,進入配置文件所在目錄啟動各個節(jié)點 redis-server /home/redis-cluster/7001/redis.conf ps -ef | grep redis #查看服務(wù) 其他幾臺服務(wù)也是按上述步驟操作即可,相應(yīng)ip、目錄按實際修改即可 搭建好redis節(jié)點后,現(xiàn)在要創(chuàng)建集群,確認所有的節(jié)點都啟動 集群創(chuàng)建方式 redis-cli -a test@redis2019 --cluster create --cluster-replicas 1 17.1.111.172:7001 17.1.111.172:7002 17.1.111.173:7001 17.1.111.173:7002 17.1.111.174:7001 17.1.111.174:7002 解釋 --replicas 1 表示自動為每一個master節(jié)點分配一個slave節(jié)點,上面有6個節(jié)點,程序會按照一定規(guī)則生成3個master(主)3個slave(從) 運行,提示輸入yes 這里集群已經(jīng)初步搭建完成 集群創(chuàng)建成功登陸任意redis結(jié)點查詢集群中的節(jié)點情況。 redis-cli -c -a test@redis2019 -h 17.1.111.172 -p 7001 // -c表示以集群方式連接redis cluster nodes 查詢集群結(jié)點信息 cluster info 查詢集群狀態(tài)信息

終于解決了,問題真出在redis.conf里,該文件里被添加了新的命令如下:

#新添加 rename-command FLUSHALL “” rename-command FLUSHDB “” rename-command KEYS “” rename-command SHUTDOWN “” rename-command DEL “” rename-command EVAL “”

nacos安裝

安裝包

tar zxvf nacos-server-1.2.1.tar.gz 1.安裝數(shù)據(jù)庫和jdk,版本要求:5.6.5+,jdk1.8 2.初始化mysql數(shù)據(jù)庫,數(shù)據(jù)庫初始化文件:nacos-mysql.sql 3.修改conf/application.properties文件,增加支持mysql數(shù)據(jù)源配置(目前只支持mysql),添加mysql數(shù)據(jù)源的url、用戶名和密碼。類似如下 數(shù)據(jù)庫名字需要自己創(chuàng)建,還有相應(yīng)的授權(quán)。 4.集群模式在nacos的解壓目錄nacos/的conf目錄下,有配置文件cluster.conf,請每行配置成ip:port。(請配置3個或3個以上節(jié)點) 例如 192.168.1.1:8848 192.168.1.2:8848 192.168.1.3:8848 5.startup.sh啟動配置里面 exprot MODE=”cluster”#集群模式啟動 exprot MODE=”standalone”#單機模式啟動 sh nacos/bin/startup.sh 啟動nacos 啟動后瀏覽器訪問http://ip:8848/nacos 即可成功訪問 默認賬號密碼nacos:nacos 集群模式給三個nacos架構(gòu)前面搭建一臺nginx,nginx搭建參考nginx安裝。 6.由nginx負載三個nacos。配置文件如下: upstream nacos { server 192.168.1.1:8848; server 192.168.1.2:8848; server 192.168.1.3:8848; } server { listen 8838; server_name localhost; location / { proxy_pass http://nacos; } } 默認賬號密碼nacos:nacos

ELK安裝

es安裝 需要jdk1.8版本,具體參照jdk安裝 首先請先優(yōu)化limits.conf sysctl.conf 文件參數(shù),否則后面啟動會報錯

vim /etc/security/limits.conf

添加

root soft nofile 65535

root hard nofile 65535

* soft nofile 65535

* hard nofile 65535

vim /etc/sysctl.conf

添加

vm.max_map_count=655360

sysctl -p

開始部署es集群 服務(wù)器:3臺。 ip分別為192.168.1.1,192.168.1.2,192.168.1.3(實際生產(chǎn)請修改) 三臺機器都操作。

上傳包至/opt/下 創(chuàng)建一個普通用戶 useradd es 切換root用戶操作 tar xvf elasticsearch-6.8.6.tar.gz mv elasticsearch-6.8.6 elasticsearch cd elasticsearch/config/ vim elasticsearch.yml cluster.name: sc #集群名字,三臺集群的集群名字都必須一致 node.name: es1 #節(jié)點名字,三臺ES節(jié)點字都必須不一樣 path.data: /opt/elasticsearch/data path.logs: /opt/elasticsearch/logs network.host: 192.168.1.1 # 本機IP http.port: 9200 transport.tcp.port: 9300 transport.tcp.compress: true #壓縮tcp傳輸時的數(shù)據(jù) discovery.zen.ping.unicast.hosts: [“192.168.1.1”,“192.168.1.2”,“192.168.1.3”] discovery.zen.minimum_master_nodes: 2 #集群最少的master數(shù) xpack.security.enabled: true #es訪問開啟密碼認證 xpack.security.transport.ssl.enabled: true http.cors.enabled: true http.cors.allow-origin: “*” http.cors.allow-headers: Authorization,X-Requested-With,Content-Length,Content-Type xpack.security.enabled: true xpack.license.self_generated.type: basic xpack.security.transport.ssl.enabled: true xpack.security.transport.ssl.verification_mode: certificate xpack.security.transport.ssl.keystore.path: elastic-certificates.p12 xpack.security.transport.ssl.truststore.path: elastic-certificates.p12

bin/elasticsearch-certutil ca bin/elasticsearch-certutil cert --ca elastic-stack-ca.p12 生成的證書放在 config下 三臺機器不一樣的配置點如下 node.name: es1 #192.168.1.1 node.name: es1 #192.168.1.2 node.name: es1 #192.168.1.3

創(chuàng)建目錄和修改權(quán)限

mkdir -p /opt/elasticsearch/data mkdir -p /opt/elasticsearch/logs chown -R es:es /opt/elasticsearch

切換到es用戶

su es cd /opt/elasticsearch ./bin/elasticsearch -d #后臺運行模式 瀏覽器訪問9200 http://localhost:9200/_cluster/health?pretty #查看集群狀態(tài) status:green

創(chuàng)建es各個組件密碼,三臺機器都執(zhí)行

elasticsearch-setup-passwords interactive 按提示輸入各個組件的賬號密碼 密碼都是elastic

logstash安裝:

文件上傳到/opt/下

tar zxvf logstash-6.8.6.tar.gz

cd logstash-6.8.6/config vim logstash.conf # 編輯一個config文件 input{ tcp{ port=> 5044 codec=> “json” } }

output{ elasticsearch { hosts => “192.168.1.10:9200”# es地址 index => “%{[appname]}-%{+YYYY.MM.dd}” user =>“elastic” password => “elastic” } }

kibana安裝:

安裝包上傳到/opt/下

tar zxvf kibana-6.8.6-linux-x86_64.tar.gz cd kibana-6.8.6-linux-x86_64/ vim config/kibana.yml server.port: 5601 server.host: “192.168.1.10” elasticsearch.hosts:[“http://192.168.1.10:9200”] # elasticsearch的地址及端口 elasticsearch.username: “elastic” #連接es的賬號密碼 elasticsearch.password:”test@2020 i18n.locale:”zh-CN”#中文 grep -vE “$|#” config/kibana.yml # 驗證修改的 screen ./bin/kibana #啟動kibana,訪問IP:5601

添加索引

此時可查看日志是否輸出成功,成功即可

mysql安裝

安裝包mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz 在操作系統(tǒng)中安裝MySQL時需將系統(tǒng)自帶的MySQL卸載掉,卸載步驟如下: 檢查原來mysql是否安裝,有則刪除

rpm -qa | grep mysql

創(chuàng)建mysql用戶

useradd -M -s /sbin/nologin mysql

將下載的tar包上傳到服務(wù)器,解壓 (我下載的是免編譯的包,解壓后可以直接用)

tar zxvf mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz -C /opt/ cd /opt/ mv mysql-5.7.16-linux-glibc2.5-x86_64 mysql chown -R mysql:mysql /opt/mysql/ 初始化數(shù)據(jù)庫 cd /opt/mysql/ ./bin/mysql_install_db --user=mysql --basedir=/opt/mysql --datadir=/opt/mysql/data 注意看是否有報錯 如有報錯 按提示安裝系統(tǒng)依賴包 類似安裝下這兩個 yum -y install libaio yum -y install library cp -a ./support-files/my-default.cnf /etc/my.cnf cp -a ./support-files/mysql.server /etc/init.d/mysqld ./bin/mysqld_safe --user=mysql &

vim /etc/my.cnf # 修改一下端口號 [mysqld] port=3306

systemctl enable mysqld systemctl restart mysqld ps -ef | grep mysql # 注意看是服務(wù)是否開啟 cat /root/.mysql_secret # 查看mysql初始化密碼 ln -s /opt/mysql/bin/* /usr/local/sbin/ mysql -uroot -p alter user user() identified by “test@mysql2019”; #修改mysql root用戶密碼 flush privileges; 重啟數(shù)據(jù)庫,建議殺死進程 ps -ef | grep mysql kill -9 mysql-pid 編輯配置文件 vim /etc/my.cnf [mysql] default-character-set = utf8

[mysqld] port = 3306 basedir = /usr/local/mysql datadir = /usr/local/mysql/data character-set-server = utf8 collation-server = utf8_general_ci default-storage-engine = INNODB lower_case_table_names = 1 tmpdir = /tmp socket = /tmp/mysql.sock log-error = /opt/mysql/data/error.log pid-file = /opt/mysql/data/mysql.pid max_connections = 8000 back_log = 3000 wait_timeout = 7200 interactive_timeout = 7200 key_buffer_size = 1024M query_cache_size = 1024M query_cache_type = 1 sort_buffer_size = 1024M join_buffer_size = 1024M thread_cache_size = 1000 thread_stack = 1024M tmp_table_size = 1024M innodb_buffer_pool_size = 30720M innodb_flush_log_at_trx_commit = 1 innodb_thread_concurrrency = 0 innodb_log_buffer_size = 4096M innodb_log_file_size = 4096M innodb_flush_method = O_DIRECT

systemctl start mysqld mysql -uroot -p # 新密碼登錄 授權(quán)遠程訪問(注意防火墻,selinux是否關(guān)閉) GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ IDENTIFIED BY ’ testmysql2019’ WITH GRANT OPTION; flush privileges; 類似grant all on . to user1 identified by ‘123456’;

設(shè)置主從

兩臺服務(wù)器都需要安裝上mysql 以下IP為示例IP

mysql 主 17.1.111.179 mysql 從 17.1.111.180 主mysql配置 vim my.cnf [mysqld] log-bin = mysql-bin #開啟二進制日志 binlog_cache_size = 512M max_binlog_cache_size = 4096M max_binlog_size = 512M server-id = 1 #設(shè)置server-id expire_logs_days = 7 #設(shè)置binlog日志保存天數(shù) sync_binlog = 1 slow_query_log = on slow_query_log_file = /opt/mysql/data/mysql_slow_query.log log_queries_not_using_indexs = on long_query_time = 1

重啟mysql,創(chuàng)建用于同步的用戶賬號

systemctl restart mysqld

創(chuàng)建用戶并授權(quán):用戶:test@slave 密碼:test@2019

CREATE USER ‘test@slave’@‘17.1.111.180’ IDENTIFIED BY ‘pwd@2019’; #創(chuàng)建用戶 GRANT REPLICATION SLAVE ON . TO ‘test@slave’@‘17.1.111.180’; #分配權(quán)限 flush privileges; SHOW MASTER STATUS; #查看master狀態(tài),記錄二進制文件名(mysql-bin.000001)和位置(779)

從mysql配置

vim my.cnf [mysqld] server-id=2 #必須唯一

重啟mysql,打開mysql會話,執(zhí)行同步SQL語句

systemctl restart mysqld mysql -uroot -p CHANGE MASTER TO MASTER_HOST=‘17.1.111.180’,MASTER_USER=‘test@slave’,MASTER_PASSWORD=‘test@2019’,MASTER_LOG_FILE=‘mysql-bin.000001’,MASTER_LOG_POS=779; start slave; # 啟動slave同步進程 show slave status\G # 查看slave狀態(tài)

測試同步,在主mysql建庫,看從庫是否同步,能同步即可

CREATE DATABASE database_name # 建庫 CREATE TABLE 表名( id int not null, name char(20) ); INSERT INTO 表名(列1,列2) VALUES (值1,值2) DROP DATABASE 數(shù)據(jù)庫名

柚子快報激活碼778899分享:微服務(wù)架構(gòu)中間件安裝部署

http://yzkb.51969.com/

相關(guān)鏈接

評論可見,查看隱藏內(nèi)容

本文內(nèi)容根據(jù)網(wǎng)絡(luò)資料整理,出于傳遞更多信息之目的,不代表金鑰匙跨境贊同其觀點和立場。

轉(zhuǎn)載請注明,如有侵權(quán),聯(lián)系刪除。

本文鏈接:http://gantiao.com.cn/post/19066132.html

發(fā)布評論

您暫未設(shè)置收款碼

請在主題配置——文章設(shè)置里上傳

掃描二維碼手機訪問

文章目錄