mariadb replication

Recently do slow SQL optimization, compare headaches, see slow SQL is full of some select count (*) or sum of aggregate statistics such as SQL, because my database is the traditional master-slave, or a master more from, such slow SQL directly in the database statistics, there is a certain impact on the line, And because of multiple DB master-slave, statistics some related data is also relatively troublesome, so decided to set up a dedicated to the operation or aggregate statistical operation of

binary log files how to Tell if slave is behind master show slave status\g; there is one item in theseconds_behind_master:0 How to determine whether the master-slave node data is consistent? When creating the table createtable There is an option checksum, if enabled, can be checked through the checksum of the table itself ,show Tablestatus\g view, the content of this item master-slave server to be consistent using percona-tools in pt-table-checksum How to f

Tags: MariaDB primary master semi-synchronous replicationMARIADB Primary Master semi-synchronous, that is, two master-slave synchronization is turned on semi-synchronous replication.I. MARIADB01 master MariaDB02 from open semi-synchronous replication1. MariaDB01 MasterSET GLOBAL rpl_semi_sync_master_enabled = 1;2. MariaDB02 fromSET GLOBAL rpl_semi_sync_slave_enabled = 1;Stop slave;Start slave;Two. MariaDB02 Master MariaDB01 from open semi-synchronous

Test parameters:Sysbench--test=/root/sysbench0.5/sysbench/tests/db/insert.lua--mysql-table-engine=innodb--oltp-table-size= 1000000--max-requests=0--max-time=300--num-threads=16--oltp-tables-count=10--report-interval=10--mysql-host= 10.8.8.100--mysql-port=3312--mysql-user=admin--mysql-password=123456--mysql-db=test Run10 1 million-row table, concurrent 16 threads, pure insert operation.MySQL parameters:Sync_binlog = 0innodb_flush_log_at_trx_commit = 0innodb_flush_method = O_directinnodb_flush_nei

MariaDB Galera Cluster deployment (how to quickly deploy MariaDB Cluster) MariaDB, as a branch of Mysql, is widely used in open-source projects, such as the Popular openstack. To ensure the high availability of services and improve the load capacity of the system, cluster deployment is essential.MariaDB Galera Cluster Introduction

MARIADB, as a branch of MySQL, is already widely used in open source projects, such as hot OpenStack, so the cluster deployment is essential to ensure high availability of the service while increasing the load capacity of the system.MariaDB Galera Cluster IntroductionThe MARIADB cluster is a MARIADB synchronous multi-host cluster. It only supports the XTRADB/INNO

Label:MARIADB, as a branch of MySQL, is already widely used in open source projects, such as hot OpenStack, so the cluster deployment is essential to ensure high availability of the service while increasing the load capacity of the system. MariaDB Galera Cluster IntroductionThe MARIADB cluster is a MARIADB synchronous multi-host cluster. It only supports the XTRA

MariaDB Galera Cluster deployment (how to quickly deploy the MariaDB Cluster), galeramariadb MariaDB, as a branch of Mysql, is widely used in open-source projects, such as the Popular openstack. To ensure the high availability of services and improve the load capacity of the system, cluster deployment is essential.MariaDB Galera Cluster Introduction

MariaDB, as a branch of Mysql, is already widely used in open source projects, such as hot OpenStack, so the cluster deployment is essential to ensure high availability of the service while increasing the load capacity of the system.MariaDB Galera Cluster IntroductionThe MariaDB cluster is a MariaDB synchronous multi-host cluster. It only supports the XTRADB/INNO

replication: Group commit for the binary log. This allows many settings and updates to replicate more than twice times faster. InnoDB's Asynchronous IO subsystem performance has improved on Windows systems. MEMORY (HEAP) engine index is faster. According to a simple test result, the insert operation in an integer index is about 24% faster than MySQL, and the insert operation on the char (20) column is 60% faster. CHECKSUM table runs faster. W

Tags: mysql mariadb PXC galeraFirst, Background introductionEither Binlog or Gtid, the essence of which is in the form of I/o_thread and Sql_thread synchronization, because the replication delay can not avoid the criticism, based on the MARIADB introduced Galera cluster to solve the problem.Second, Galera cluster introductionGalera cluster and traditional

' @ ' localhost ' identified by ' Lookback ' with GRANT OPTION;DROP DATABASE IF EXISTS test;GRANT REPLICATION SLAVE on *.* to ' REPLICATION ' @ ' identified by ' lookback ';START MASTER;FLUSH privileges;[root@legion135/docker/image/mariadb]# Docker exec-it 20b79e28546b cat/tmp/mysql-first-time.sql--What ' s done with this file shouldn ' t be replicated--or produ

MariaDB galera Cluster Deployment (How to quickly deploy MariaDB clusters) ONEAPM Blue ocean CyberLinkpublished on July 3 Recommended 4 Recommendations Collection 14 Favorites,1.1k browsing MariaDB, as a branch of Mysql, is already widely used in open source projects, such as hot OpenStack, so the cluster deployment is essential to ensure high

content, four servers (MARIADB-M1, mariadb-m2, MARIADB-M3, MARIADB-M4) modification method basically consistent, the only difference is server_id not the same, as long as the difference.Configuring MARIADB-M1, mariadb-m2 main mai

-base.repo http://mirrors.aliyun.com/repo/ Centos-7.repo [[email protected] ~]# yum-y install epel-release ~]# yum Clean all Yum Makecache ~]# yum-y Install Mariadb-server mariadb Modify the MY.CNF configuration file for Master1, Master2 [Email protected] ~]# vim/etc/my.cnf # Add the following under [Mysqld] log-bin=mysql

the server IO thread, manually change the asynchronous mode to semi-synchronous modeMariaDB [mydb]> STOP SLAVE io_thread;MariaDB [mydb]> SET GLOBAL rpl_semi_sync_slave_enabled = on;MariaDB [mydb]> SHOW GLOBAL VARIABLES like ' rpl_semi% ';MariaDB [mydb]> START SLAVE io_thread;※ You can view the error log from the library to see if it takes effect3. Configuration

-character-set=utf8# here follows entries for some specific programs# the MariaDB server[mysqld]port= 3306socket=/var /lib/mysql/mysql.sockskip-external-lockingkey_buffer_size = 16mmax_allowed_packet = 1Mtable_open_cache = 64sort_ Buffer_size = 512knet_buffer_length = 8kread_buffer_size = 256kread_rnd_buffer_size = 512kmyisam_sort_buffer_size = 8minit_connect= ' Set collation_connection = Utf8_unicode_ci ' init_connect= ' Set NAMES UTF8 ' character-se

Overview replication is usually used to create a copy of the master node to ensure high availability by adding redundant nodes. Of course, replication can also be used for other purposes, such as reading and analyzing data on the slave node. In horizontally Scalable businesses, replication is easy to implement, mainly in the use of the master node for write opera

1. Background MySQL is the most popular open source relational database in the world. In 2008, Sun acquired MySQL. Then in 2010, Oracle acquired Sun again, so MySQL fell into the hands of Oracle. Oracle has never had a good relationship with the open-source community, and even MySQL has been made community and enterprise, so it cannot be used for free. The new features of MySQL Enterprise Edition are not open source code, which makes users uncomfortable. Mar