veeam replication

transaction;　　　　　　　　　　　　　　　　　binlog_format=mixed # master-slave copy format (mixed,statement,row, default format is statement);　　　　　 　　　　　　　　　　　　expire_logs_days=7 # Number of days the binary log is automatically deleted/expired. The default value is 0, which means it is not automatically deleted;　　　　　　 　　　　　　　　　　　　slave_skip_errors=1062 # Skip all errors encountered in master-slave replication or specify types of errors to avoid slave-side

1. Replication overview1.1. Replication-Resolved issuesData replication technology has some of the following features:(1) Data distribution(2) Load balancing (load Balancing)(3) Backup(4) High availability (Hi availability) and fault tolerance1.2. How replication worksFrom the top,

I. Principles of MySQL master-slave Replication 1. mysql replication process: each time a write operation is executed, it will save a copy to its own database. At the same time, this write operation will also be stored in a binary log file, and save them as events. Therefore, each write operation or modification operation on the front-end data in this database will save an event, we will send the event to a

First, IntroductionIn the master-slave copy of the previous article: http://www.cnblogs.com/lay2017/p/9043985.htmlWe learned that MySQL writes logs through master, slave reads and executes the log content to achieve slave data consistent with master. So based on this principle, we can realize the replication function of two master.Broadly as follows:1, both master open Log-bin write log2, ID to repeat3. Configure the tables to be copied4, two master r

Master-Slave replication principle MySQL replication is an asynchronous replication process that replicates from master to one or more slave. The entire replication process between master and slave is done primarily by three threads, one IO thread on the master side and two threads (SQL thread and IO threa

Label:Basic Environment Description: 9.3 PostgreSQL version:9.3. 6 Master:192.168. 56.101 Standby:192.168. 56.102 Installation process slightly, based on pkg package 1. Configure the Master side # psql-u pgsql-d postgres-c"CREATE USER Rep REPLICATION LOGIN ENCRYPTED PASSWORD ' PASSWORD ';" # cd/usr/local/pgsql # vim data/postgresql.conf listen_addresses='*'Wal_level='Hot_standby'max_wal_senders=1# Vim data/pg_hba.conf host

This article is the first of a series of TimesTen database replication.What is replicationReplication is the existence of multiple copies of data in multiple databases, with minimal performance impact while ensuring high data availability, balancing workloads in addition to data recovery to maximize performance and enable rolling upgrades and maintenanceTT replication is implemented in both the master and Subscriber databases with

Mysql replication, mysql master-slave Replication I. Significance of Replication Mysql replication is the foundation for building large-scale and high-performance MySql-based applications. We can configure one or more slave databases for the server for data synchronization; the rep