Programmer Help

Installation instructions: A mysql program file, a configuration file, running multiple mysql instances (each with its own distinct data directory).For the convenience of the test, only two examples are used in this experiment. MySQL program installation directory: /usr/local/mysql_5.6.38 Data directories for MySQL i ...

Installation instructions: A mysql program file, a configuration file, running multiple mysql instances (each with its own distinct data directory).For the convenience of the test, only two examples are used in this experiment. MySQL program installation directory: /usr/local/mysql_5.6.38 Data directories for MySQL i ...

Installation instructions: A mysql program file, a configuration file, running multiple mysql instances (each with its own distinct data directory).For the convenience of the test, only two examples are used in this experiment. MySQL program installation directory: /usr/local/mysql_5.6.38 Data directories for MySQL i ...

Environmental planning 192.168.31.178 Master/Slave 192.168.31.179 Master/Slave 192.168.31.178 configuration gtid-mode=ON enforce_gtid_consistency=on log-slave-updates=true master-info-repository=TABLE relay-log-info-repository=TABLE relay_log = /data/mysql/relay.log relay_log_index = /data/mysql/relay_log.index report-port = 3306 sync-m ...

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