Programmer Help

Note: the demo environment of this blog is based on centos7.2 x86? 64 bit, minimized installation system, and MariaDB.10.5.1 binary installation 1, A brief introduction to the parallel replication mode of slave Library Five modes of slave parallel mode:Five official models Description: Controls what transactions are applied in parallel when us ...

job configuration and easy testing Official documents 1. Brief introduction to job job is also a kind of controller. k8s has two types of controllers. One is service controller, such as deployment, teamonset, replicaset, etc. the other is task controller. job and cronjon are task controller Simple parameters of job spec.template format is th ...

The importance of data backup 1. In the production environment, the safety of data is very important, and any loss of data may have serious consequences 2. Causes of data loss Program errorHuman errorComputer failureDisk failureDisaster and theft Classification of database backup From a physical and logical point of view, backup can be divid ...

Article directory Conditional expression and logical expression Document and directory judgment Case: the wordpress Library in the backup database starts in the early morning every day. If the backup is successful, an email notification will be sent Numerical comparison Case: r disk root '/' usage rate, more than 80% alarms S ...

1. The main service starts log bin # vim /etc/mysql/my.cnf .... server-id = 55 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days = 10 max_binlog_size = 100M ... Restart mysql after modifying mysql configuration # service mysql restart Authorize slave permission mysql > grant repli ...

Database backup is necessary. Generally, mysqldump is used for backup. I have written two backup methods for reference. The first is to use mysqldump and exec function to backup the database. The code is as follows: /** * Subject: php-mysql Realize database backup * User: luokakale * Date: 2018/11/9 * Time: 13:31 */ header('Content-Type: ...

The importance of data backup In the production environment, the security of data is very important. Any loss of data may have serious consequencesCauses of data lossProgram errorHuman errorComputer failureDisk failuredisaster Classification of database backup Physical backupCopies of physical files (such as data files, log files, etc.) of ...

Communication is very important, the channel of communication is very important. When the team needs to cooperate, it is necessary to find ways to inform other members of the team in the most effective way of what it is doing to avoid unnecessary harm. For example, the following has just happened:There is a test system. The historical task is t ...

Next: MySQL database master slave synchronization process mysql command introduction mysql is a database management command adopt mysql --help To view relevant parameters and instructions mysql --help #mysql database management command Usage: mysql [OPTIONS] [database] #Grammatical format --help #View help d ...

Last time: MySQL database entry multi-instance configuration When it comes to data, we are nervous. There are many types of data, but the total normalization point, data is very important and very important. Therefore, the daily data backup work has become the focus of the operation and maintenance work. Let's first look at the data in the dat ...