postgresql multi master replication

= ' Copy ', Master_password= ' 123456 ', master_port=3307, Master_log_file= ' mysql-bin.000001 ', master_log_pos=154; Set from server 3307, 3310, their master is 3308, that is, on 3307 and 3310 do the following: Change Master to master_host= ' 192.168.91.135 ', master_user= ' Copy ', Master_password= ' 123456 ', master_port=3308, Master_log_file= ' mysql-bin.000001 ', master_log_pos=154; 7. Execute on fou

library B he now has what goods in the warehouse, the next time from the Library B to find his new goods just take out this list A to know if his goods are the same as their own, If the same will not be sent, if not the same, according to the list of goods cut-off location of the latest, the new goods here can be understood as Binlog file content, the list is Binlog location information post;Every time you get a new item from the library, you'll be happy. Start your own SQL thread to resolve th

MySQL replication can ensure the redundancy of the data and read and write separation to share the system pressure, if the primary master replication can also be good to avoid the primary node single point of failure. But there are some problems with MySQL master replication

event of a failure of the main library.Semi-synchronousThere should be at least one slave to turn on the function of the semi-synchronous copy on master.At this point, a thread commits a transaction on master that will be blocked until it learns that a slave that has been turned on for semi-synchronous replication has received all events for this transaction or waits for a timeout.MySQL Semi-synchronous re

MySQL replication can ensure the redundancy of the data and read and write separation to share the system pressure, if the primary master replication can also be good to avoid the primary node single point of failure. But there are some problems with MySQL master replication

1, the principle of master-slave replication:*master, record data change operations- Enable Binlog logging mode- allow Slave to read binlog logs*slave running 2 simultaneous threads-Slave_io: Responsible for connecting Master, copy its binlog log file to the Relay-log file of the machine-Slave_sql: Executes the SQL sta

transaction to see the update in the transaction, the query outside the transaction cannot see" does not guarantee atomicity: Redis in the same transaction, if a command fails after exec, the subsequent command is still executed and no rollback is performed. two. master-slave copying Common one main two from redis> info replication To see if the current Redis is the main or the library matching from librar

Memcached memory replication/Master/Slave Mode-mecached1.4.13 Repcached Introduction Repchched Project address: http://repcached.sourceforge.net/ Repcached "Repcached" is a patch set that adds the data replication feature to memcached 1.2.x. Main PurposeImplement the redundant memcached System Main functions Multi-

configuration file, remove the Read-onlyauto_increment_increment=2 auto_increment_offset=2 log-slave-updates=true log-bin=mysql-bin3. Restart the databaseServer mysqld Restart4, the original main library as from the library, do the same configuration, I use a multi-instance, so only changed the portChange MASTER to master_host= ' 11.2.0.75 ', master_port=3307 master_user= ' rep ', master_password= '456 ',

I,Principle RedisThe master-slave replication function is very powerful.MasterYou can have multipleSlaveAndSlaveYou can have multipleSlaveIn this way, a powerful multi-level server cluster architecture is formed. The following is aboutRedisSome features of master-slave replicatio