<span id="mktg5"></span>

<i id="mktg5"><meter id="mktg5"></meter></i>

        <label id="mktg5"><meter id="mktg5"></meter></label>
        最新文章專題視頻專題問答1問答10問答100問答1000問答2000關鍵字專題1關鍵字專題50關鍵字專題500關鍵字專題1500TAG最新視頻文章推薦1 推薦3 推薦5 推薦7 推薦9 推薦11 推薦13 推薦15 推薦17 推薦19 推薦21 推薦23 推薦25 推薦27 推薦29 推薦31 推薦33 推薦35 推薦37視頻文章20視頻文章30視頻文章40視頻文章50視頻文章60 視頻文章70視頻文章80視頻文章90視頻文章100視頻文章120視頻文章140 視頻2關鍵字專題關鍵字專題tag2tag3文章專題文章專題2文章索引1文章索引2文章索引3文章索引4文章索引5123456789101112131415文章專題3
        問答文章1 問答文章501 問答文章1001 問答文章1501 問答文章2001 問答文章2501 問答文章3001 問答文章3501 問答文章4001 問答文章4501 問答文章5001 問答文章5501 問答文章6001 問答文章6501 問答文章7001 問答文章7501 問答文章8001 問答文章8501 問答文章9001 問答文章9501
        當前位置: 首頁 - 科技 - 知識百科 - 正文

        MySQL-group-replication配置步驟(推薦)

        來源:懂視網 責編:小采 時間:2020-11-09 20:36:13
        文檔

        MySQL-group-replication配置步驟(推薦)

        MySQL-group-replication配置步驟(推薦):MySQL-Group-Replication 是mysql-5.7.17版本開發出來的新特性;它在master-slave 之間實現了強一致性, 但是就目前來說主要是性能不太好。 【1】確定當前的mysql數據庫版本為5.7.17及以上 /usr/local/mysql/bin/mysqld --
        推薦度:
        導讀MySQL-group-replication配置步驟(推薦):MySQL-Group-Replication 是mysql-5.7.17版本開發出來的新特性;它在master-slave 之間實現了強一致性, 但是就目前來說主要是性能不太好。 【1】確定當前的mysql數據庫版本為5.7.17及以上 /usr/local/mysql/bin/mysqld --

        MySQL-Group-Replication 是mysql-5.7.17版本開發出來的新特性;它在master-slave 之間實現了強一致性,

        但是就目前來說主要是性能不太好。

        【1】確定當前的mysql數據庫版本為5.7.17及以上

        /usr/local/mysql/bin/mysqld --version
        /usr/local/mysql/bin/mysqld Ver 5.7.17 for linux-glibc2.5 on x86_64 (MySQL Community Server (GPL))

        【2】實驗環境為一臺主機上安裝3臺mysql,它們三個組成一個group-replication 組

        /tmp/4406.cnf 內容如下:

        [mysqld]
        ####: for global
        user =jianglexing # mysql
        basedir =/usr/local/mysql # /usr/local/mysql/
        datadir =/tmp/4406/ # /usr/local/mysql/data
        server_id =4406 # 0
        port =4406 # 3306
        socket =/tmp/4406/mysql.sock # /tmp/mysql.sock
        auto_increment_increment =1 # 1
        auto_increment_offset =1 # 1
        lower_case_table_names =1 # 0
        secure_file_priv = # null
        
        
        ####: for binlog
        binlog_format =row # row
        log_bin =mysql-bin # off
        binlog_rows_query_log_events =on # off
        log_slave_updates =on # off
        expire_logs_days =4 # 0
        binlog_cache_size =32768 # 32768(32k)
        binlog_checksum =none # CRC32
        sync_binlog =1 # 1
        
        
        ####: for error-log
        log_error =mysql-err.log # /usr/local/mysql/data/localhost.localdomain.err
        
        
        ####: for slow query log
        
        
        ####: for gtid
        gtid_mode =on # off
        enforce_gtid_consistency =on # off
        
        
        ####: for replication
        master_info_repository =table # file
        relay_log_info_repository =table # file
        
        
        ####: for group replication
        transaction_write_set_extraction =XXHASH64 # off
        loose-group_replication_group_name ="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" # 
        loose-group_replication_start_on_boot =off # off
        loose-group_replication_local_address ="127.0.0.1:24901" #
        loose-group_replication_group_seeds ="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903"
        loose-group_replication_bootstrap_group =off # off
        
        
        ####: for innodb
        default_storage_engine =innodb # innodb
        default_tmp_storage_engine =innodb # innodb
        innodb_data_file_path =ibdata1:12M:autoextend # ibdata1:12M:autoextend
        innodb_temp_data_file_path =ibtmp1:12M:autoextend # ibtmp1:12M:autoextend
        innodb_log_group_home_dir =./ # ./
        innodb_log_files_in_group =2 # 2
        innodb_log_file_size =48M # 50331648(48M)
        innodb_file_format =Barracuda # Barracuda
        innodb_file_per_table =on # on
        innodb_page_size =16k # 16384(16k)
        innodb_thread_concurrency =0 # 0
        innodb_read_io_threads =4 # 4
        innodb_write_io_threads =4 # 4
        innodb_purge_threads =4 # 4
        innodb_print_all_deadlocks =on # off
        innodb_deadlock_detect =on # on
        innodb_lock_wait_timeout =50 # 50
        innodb_spin_wait_delay =6 # 6
        innodb_autoinc_lock_mode =2 # 1
        innodb_stats_persistent =on # on
        innodb_stats_persistent_sample_pages =20 # 20
        innodb_adaptive_hash_index =on # on
        innodb_change_buffering =all # all
        innodb_change_buffer_max_size =25 # 25
        innodb_flush_neighbors =1 # 1
        innodb_flush_method =O_DIRECT # 
        innodb_doublewrite =on # on
        innodb_log_buffer_size =16M # 16777216(16M)
        innodb_flush_log_at_timeout =1 # 1
        innodb_flush_log_at_trx_commit =1 # 1
        autocommit =1 # 1
        
        [client]
        auto-rehash

        /tmp/5506.cnf 內容如下:

        [mysqld]
        ####: for global
        user =jianglexing # mysql
        basedir =/usr/local/mysql # /usr/local/mysql/
        datadir =/tmp/5506 # /usr/local/mysql/data
        server_id =5506 # 0
        port =5506 # 3306
        socket =/tmp/5506/mysql.sock # /tmp/mysql.sock
        auto_increment_increment =1 # 1
        auto_increment_offset =1 # 1
        lower_case_table_names =1 # 0
        secure_file_priv = # null
        
        
        ####: for binlog
        binlog_format =row # row
        log_bin =mysql-bin # off
        binlog_rows_query_log_events =on # off
        log_slave_updates =on # off
        expire_logs_days =4 # 0
        binlog_cache_size =32768 # 32768(32k)
        binlog_checksum =none # CRC32
        sync_binlog =1 # 1
        
        
        ####: for error-log
        log_error =mysql-err.log # /usr/local/mysql/data/localhost.localdomain.err
        
        
        ####: for slow query log
        
        
        ####: for gtid
        gtid_mode =on # off
        enforce_gtid_consistency =on # off
        
        
        ####: for replication
        master_info_repository =table # file
        relay_log_info_repository =table # file
        
        
        ####: for group replication
        transaction_write_set_extraction =XXHASH64 # off
        loose-group_replication_group_name ="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" # 
        loose-group_replication_start_on_boot =off # off
        loose-group_replication_local_address ="127.0.0.1:24902" #
        loose-group_replication_group_seeds ="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903"
        loose-group_replication_bootstrap_group =off # off
        
        
        ####: for innodb
        default_storage_engine =innodb # innodb
        default_tmp_storage_engine =innodb # innodb
        innodb_data_file_path =ibdata1:12M:autoextend # ibdata1:12M:autoextend
        innodb_temp_data_file_path =ibtmp1:12M:autoextend # ibtmp1:12M:autoextend
        innodb_log_group_home_dir =./ # ./
        innodb_log_files_in_group =2 # 2
        innodb_log_file_size =48M # 50331648(48M)
        innodb_file_format =Barracuda # Barracuda
        innodb_file_per_table =on # on
        innodb_page_size =16k # 16384(16k)
        innodb_thread_concurrency =0 # 0
        innodb_read_io_threads =4 # 4
        innodb_write_io_threads =4 # 4
        innodb_purge_threads =4 # 4
        innodb_print_all_deadlocks =on # off
        innodb_deadlock_detect =on # on
        innodb_lock_wait_timeout =50 # 50
        innodb_spin_wait_delay =6 # 6
        innodb_autoinc_lock_mode =2 # 1
        innodb_stats_persistent =on # on
        innodb_stats_persistent_sample_pages =20 # 20
        innodb_adaptive_hash_index =on # on
        innodb_change_buffering =all # all
        innodb_change_buffer_max_size =25 # 25
        innodb_flush_neighbors =1 # 1
        innodb_flush_method =O_DIRECT # 
        innodb_doublewrite =on # on
        innodb_log_buffer_size =16M # 16777216(16M)
        innodb_flush_log_at_timeout =1 # 1
        innodb_flush_log_at_trx_commit =1 # 1
        autocommit =1 # 1

         /tmp/6606.cnf 內容如下:

        [mysqld]
        ####: for global
        user =jianglexing # mysql
        basedir =/usr/local/mysql # /usr/local/mysql/
        datadir =/tmp/6606/ # /usr/local/mysql/data
        server_id =6606 # 0
        port =6606 # 3306
        socket =/tmp/6606/mysql.sock # /tmp/mysql.sock
        auto_increment_increment =1 # 1
        auto_increment_offset =1 # 1
        lower_case_table_names =1 # 0
        secure_file_priv = # null
        
        
        ####: for binlog
        binlog_format =row # row
        log_bin =mysql-bin # off
        binlog_rows_query_log_events =on # off
        log_slave_updates =on # off
        expire_logs_days =4 # 0
        binlog_cache_size =32768 # 32768(32k)
        binlog_checksum =none # CRC32
        sync_binlog =1 # 1
        
        
        ####: for error-log
        log_error =mysql-err.log # /usr/local/mysql/data/localhost.localdomain.err
        
        
        ####: for slow query log
        
        
        ####: for gtid
        gtid_mode =on # off
        enforce_gtid_consistency =on # off
        
        
        ####: for replication
        master_info_repository =table # file
        relay_log_info_repository =table # file
        
        
        ####: for group replication
        transaction_write_set_extraction =XXHASH64 # off
        loose-group_replication_group_name ="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa" # 
        loose-group_replication_start_on_boot =off # off
        loose-group_replication_local_address ="127.0.0.1:24903" #
        loose-group_replication_group_seeds ="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903"
        loose-group_replication_bootstrap_group =off # off
        
        
        ####: for innodb
        default_storage_engine =innodb # innodb
        default_tmp_storage_engine =innodb # innodb
        innodb_data_file_path =ibdata1:12M:autoextend # ibdata1:12M:autoextend
        innodb_temp_data_file_path =ibtmp1:12M:autoextend # ibtmp1:12M:autoextend
        innodb_log_group_home_dir =./ # ./
        innodb_log_files_in_group =2 # 2
        innodb_log_file_size =48M # 50331648(48M)
        innodb_file_format =Barracuda # Barracuda
        innodb_file_per_table =on # on
        innodb_page_size =16k # 16384(16k)
        innodb_thread_concurrency =0 # 0
        innodb_read_io_threads =4 # 4
        innodb_write_io_threads =4 # 4
        innodb_purge_threads =4 # 4
        innodb_print_all_deadlocks =on # off
        innodb_deadlock_detect =on # on
        innodb_lock_wait_timeout =50 # 50
        innodb_spin_wait_delay =6 # 6
        innodb_autoinc_lock_mode =2 # 1
        innodb_stats_persistent =on # on
        innodb_stats_persistent_sample_pages =20 # 20
        innodb_adaptive_hash_index =on # on
        innodb_change_buffering =all # all
        innodb_change_buffer_max_size =25 # 25
        innodb_flush_neighbors =1 # 1
        innodb_flush_method =O_DIRECT # 
        innodb_doublewrite =on # on
        innodb_log_buffer_size =16M # 16777216(16M)
        innodb_flush_log_at_timeout =1 # 1
        innodb_flush_log_at_trx_commit =1 # 1
        autocommit =1 # 1

        【3】初始化三個數據庫實例

        cd /usr/local/mysql/
        ./bin/mysqld --defautls-file=/tmp/4406.cnf --datadir=/tmp/4406 --initialize-insecrue
        
        ./bin/mysqld --defautls-file=/tmp/5506.cnf --datadir=/tmp/5506 --initialize-insecrue
        
        ./bin/mysqld --defautls-file=/tmp/6606.cnf --datadir=/tmp/6606 --initialize-insecrue

        【4】配置group-replication 的初始實例

        /usr/local/mysql/bin/mysqld --defaults-file=/tmp/4406.cnf &
        mysql -h127.0.0.1 -uroot -P4406
        
        -- 增加用戶
         set sql_log_bin=0;
         create user rpl_user@'%' identified by '123456';
         grant replication slave,replication client on *.* to rpl_user@'%';
         create user rpl_user@'127.0.0.1' identified by '123456';
         grant replication slave,replication client on *.* to rpl_user@'127.0.0.1';
         create user rpl_user@'localhost' identified by '123456';
         grant replication slave,replication client on *.* to rpl_user@'localhost';
         set sql_log_bin=1;
        
        -- 增加復制憑證
         change master to 
         master_user='rpl_user',
         master_password='123456'
         for channel 'group_replication_recovery';
        
        -- 安裝組復制物件
         install plugin group_replication soname 'group_replication.so';
        
        -- 啟動組復制
         set global group_replication_bootstrap_group=on;
         start group_replication;
         set global group_replication_bootstrap_group=off;

        【5】5506 實例的配置過程如下:

        /usr/local/mysql/bin/mysqld --defaults-file=/tmp/5506.cnf &
        mysql -h127.0.0.1 -uroot -P5506
        
        -- 增加用戶
         set sql_log_bin=0;
         create user rpl_user@'%' identified by '123456';
         grant replication slave,replication client on *.* to rpl_user@'%';
         create user rpl_user@'127.0.0.1' identified by '123456';
         grant replication slave,replication client on *.* to rpl_user@'127.0.0.1';
         create user rpl_user@'localhost' identified by '123456';
         grant replication slave,replication client on *.* to rpl_user@'localhost';
         set sql_log_bin=1;
        
        -- 增加復制憑證
         change master to 
         master_user='rpl_user',
         master_password='123456'
         for channel 'group_replication_recovery';
        
        -- 安裝組復制物件
         install plugin group_replication soname 'group_replication.so';
        
        -- 啟動組復制
         start group_replication; # 注意這里不是初始化了,只要加入就行

        【6】6606 實例的操作與5506的操作一樣,這樣group replication 的配置就完成了。

        以上這篇MySQL-group-replication 配置步驟(推薦)就是小編分享給大家的全部內容了,希望能給大家一個參考,也希望大家多多支持腳本之家。

        您可能感興趣的文章:

      1. mysql5.5 master-slave(Replication)配置方法
      2. 基于mysql replication的問題總結
      3. 聲明:本網頁內容旨在傳播知識,若有侵權等問題請及時與本網聯系,我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com

        文檔

        MySQL-group-replication配置步驟(推薦)

        MySQL-group-replication配置步驟(推薦):MySQL-Group-Replication 是mysql-5.7.17版本開發出來的新特性;它在master-slave 之間實現了強一致性, 但是就目前來說主要是性能不太好。 【1】確定當前的mysql數據庫版本為5.7.17及以上 /usr/local/mysql/bin/mysqld --
        推薦度:
        • 熱門焦點

        最新推薦

        猜你喜歡

        熱門推薦

        專題
        Top
        主站蜘蛛池模板: 久久青草免费91线频观看站街| 永久免费精品影视网站| 99re在线这里只有精品免费| 亚洲AV无码国产在丝袜线观看| a毛片在线免费观看| 久久久久亚洲精品影视| 中文无码成人免费视频在线观看| 亚洲av日韩综合一区在线观看| 99久久免费观看| 亚洲中文字幕乱码熟女在线| 美女被免费视频网站a国产| 午夜亚洲乱码伦小说区69堂| 免费在线观看理论片| 国产做国产爱免费视频| 久久亚洲国产伦理| 欧美最猛性xxxxx免费| 美女黄色毛片免费看| 亚洲成aⅴ人片久青草影院| 毛片a级三毛片免费播放| 亚洲大尺度无码无码专线一区| 亚洲?v女人的天堂在线观看| GOGOGO免费观看国语| 亚洲国产综合自在线另类| 日韩免费观看一级毛片看看| www免费插插视频| 亚洲精品在线播放| 国产美女无遮挡免费视频| 两个人的视频www免费| 亚洲午夜精品一区二区公牛电影院| 国产免费AV片无码永久免费| 亚洲s码欧洲m码吹潮| 国产亚洲?V无码?V男人的天堂| 69免费视频大片| 三级片免费观看久久| 亚洲性69影院在线观看| 免费一级成人毛片| 0588影视手机免费看片| jizz免费观看| 亚洲熟妇久久精品| 亚洲Av无码精品色午夜| 免费日韩在线视频|