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