postgresql multi master replication

Replication ERR!!! Dbhostconfig [HOSTNAME=HOSTM2, Url=localhost:3308]error reconnecting to master ' [email protected]:3306 '-retry-time:60 retries:8640001/17 11:09:17.413 DEBUG [$_NIOREACTOR-1-RW] (physicaldatasource.java:403)-release channel mysqlconnection [id=11, lasttime=1453000157394, User=root, schema=mycat_sync_test, old Shema=mycat_sync_test, Borrowed=true, fromSlaveDB= True, threadid=53, Charset=u

I. Master server Master1. Set permissions for usersTo set up users who only allow 192.168.120.27 access:Grant Replication Slave,super,reload on * * to [e-mail protected] identified by ' zhijiatest ';2. The primary database server installation directory, open My.ini, add the following configuration at the end of the file:#数据库ID号, represented as master at 1, where

Label:Read/write separation and data separation is the same, read and write separation, is read and write in the same server different database, or different server different database?1 Master-slave replication, is used to establish a database and the main database exactly the same as the databases environment, called from the database, the main database is generally real-time business database, from the ro

Tags: master database logging Networktwo parameters, one is binlog_ignore_db. the other is replicate-ignore-db difference:binlog_ignore_db The parameters are set on the main library, for example: Binlog-ignore_db=test, Then for Test all operations under the library (incremental deletions) are recorded so that slave in accepting the main library's Binlog File , the amount of files will be reduced. Pros: Reduce network I/O , reducing slave End I/O Threa