Programmer Help

~~MySQL multi-source replication enables Slave to receive transactions from multiple direct masters in parallel. Multi source replication can be used to back up multiple servers to a single server, Merge Table shards, and merge data from multiple servers to a single server. When applying transactions, multi-source replication does not impleme ...

mysqldump backup database mysqldump backup database background mysqldump syntax Backup script crontab Import Other backup methods background The database is not very stable in the test environment, and there is a risk of loss The structure of database table changes frequently. There are test data produced ...

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 ...