Master-slave replication of mysql learning
This article uses MySQL 5.5 CentOS 6.5 64 bits
I. The Role of Master-Subordinate Reproduction
1. If the master server has problems, it can switch to the slave server quickly.
2. Applications with low real-time requirements or infrequent updates can perform query operations from the slave server to reduce the access pressure of the primary serve ...
Posted by dhie on Fri, 22 Mar 2019 19:36:54 -0700
Using dataTable to input table row data directly in Bootstrap development framework
In Winform development, we can use form control to input data directly, but rarely seen on the Web. In fact, we can also use dataTable object to process table row data directly. This can improve the convenience of data entry, especially in some simple business details, it seems more convenient and higher than pop-up window entry. A little bigge ...
Posted by xxxxxx on Sat, 26 Jan 2019 01:45:14 -0800
mysql master-slave replication skips error items
mysql master-slave replication, often encounter errors and lead to slave end replication interruption, this time generally requires manual intervention, skip errors to continue
There are two ways to skip errors:
1.1 Skip a specified number of transactions:
mysql>stop slave;
mysql>SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; #Skip a tran ...
Posted by golfinggod on Thu, 24 Jan 2019 06:45:15 -0800
I2C protocol - > bare computer program - >adapter driver analysis
Development board: mini2440
Kernel: Linux 2.6.32.2
Reference: I2C Video Course for Weidongshan Graduation Class
1. Brief analysis of i2c protocol
i2c midline is a serial bus developed by PHILIPS company, which is used to connect microcontrollers and peripheral devices. It has the following characteristics.There are only two bus lines: a ...
Posted by gavin101 on Thu, 10 Jan 2019 12:03:11 -0800
Reay log, master log info, relay log info of Mysql log file
In the context of MySQL master-slave Replication ring, the standby node generates several files, as follows:A relay log filesReay log is similar to binary log in that it records changes in the database and consists of a series of files. Reaoy log records changes in the database sent by the primary node and is composed of I/O thread
Write in. ...
Posted by sgalatas on Tue, 08 Jan 2019 11:33:09 -0800