Perform SQL operations on the test database on the master node, and check whether the test database on the slave node generates synchronization.
Perform SQL operations on the test database on the master node, and check whether the test database on the slave node generates synchronization.
One
MySQL is an open-source relational database system. Replication is a process that replicates data from a MySQL database server (master server) to another server (slave server slave.Configure the master server)1. Edit the database configuration file my. cnf, which is usually in the/etc/directory.1. # vi/etc/my. cnfAdd t
Label:From:http://www.cnblogs.com/tae44/p/4682810.html Experimental system: CentOS 6.6_x86_64 Lab Prerequisites: Prepare the build environment in advance, firewall and SELinux are off The experiment shows that there are 2 hosts in this experiment, such as the topology of IP assignment Lab Software: mariadb-10.0.20 Experimental topology: First, install MySQL 1. Compile and install MARIADB: Tar XF mariadb-10.0.20-linux-x86_64.tar.gz -c/usr/local/
cd/usr/local/
LN-SV mariadb-10.0.20-linux-x8
Tags: test error:end systemctl ORM amp Command database outDocker container Master node: 172.17.0.9Docker Container Sub-node: 172.17.0.10Asynchronous replication: First confirm that the main library and from the library is consistent, preferably a clean database that has just been initialized if the main library is in use cannot initialize, it is necessary to first copy the contents of the main library to t
MySQL Master-slave replicationDeployment Environment:MySQL Master 192.168.40.21MySQL slave 192.168.40.22Ideas:When the data on the main MySQL operation or changes, the main MySQL binary log files (binary logs) will be changed, when the I/O thread and SQL thread from MySQL;The I/O thread reads the binary log file on the
from Server featureMysql>start slave; 8. Check replication feature status from serverMysql>Show Slave Status\g***************************1. Row ***************************slave_io_state:waiting forMaster to send event Master_host:192.168.145. Ten //Primary server addressMaster_user:repl//authorization account name, try to avoid using rootMaster_port:3306 /
access. The software's own synchronization mechanism (MySQL,oracle,Mongdb,ttserver,redis ... ), put the file in the database, sync to the library, and then take the file out. 1.2file system level synchronization scheme for different machines1.2.1drbdSynchronizing DataDRBD is based on file system synchronization, which is equivalent to network RAID1and can synchronize almost any business data. MySQL database is the official recommendation DRBD synchronization data, all single point services such
, after the configuration file processing, use the cmd command line form, mongod--config configuration file path to start 4 instances. To start the successful interface as follows, you need to open multiple command shells in turn.5. Use MONGO 127.0.0.1:29991 to link to an instance of the master node, then create collections and records within the instance, and synchronize directly to the other 3 slave nodes
Let's talk about the features of Redis master-slave replication. Official ReplicationHowto documents mention the following features: 1. one master supports multiple slave2.slave connections that can be connected to other slave ins
Label:introduction of Master-slave replication Architecture Through the previous introduction, we are all on a single use of Redis for related practices, from this chapter, we will initially explore the Redis cluster, and the most classic cluster architecture is the master-slave
In the previous articles, the high-availability scheme for MySQL databases, master-slave replication, latency generation of master-slave replication, latency Detection and latency solutions (not fundamentally addressed), this
In Redis, users can have one server replicate (replicate) another server by executing the slaveof command or setting the slaveof option, which we call the replicated server as the primary server (master), The server that replicates the primary server is referred to as the slave server (slave).Suppose you now have two Redis servers with addresses 127.0.0.1:6379 an
Mysqldump -- master-data parameter for Fast deployment of master-slave Replication
Mysqldump -- help-- Master-data [= #] This causes the binary log position and filename to beAppended to the output. If equal to 1, will print it asChange
1. Preface
Similar to the reason for MySQL master-slave replication, although redis reads and writes fast, it also produces a particularly high read pressure. In order to share the read pressure, redis supports master-slave replication
| 359 |TABLE_ID: -Flags:stmt_end_f|
|Host2-Bin.000001 | 359 |Xid| 1 | 390 | COMMIT /*xid=423*/ |
|Host2-Bin.000001 | 390 |Stop| 2 | 413 | |
+------------------+-----+----------------+-----------+-------------+----------------------------------------- --------------------------+
8Rowsinch Set(0.00Sec The following are some of the deletions are bin
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.