Running multiple mysql instances on one machine

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

Posted on Thu, 16 Jul 2020 12:06:56 -0400 by twigletmac

Running multiple mysql instances on one machine

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

Posted on Thu, 16 Jul 2020 12:08:11 -0400 by battlesiege

Running multiple mysql instances on one machine

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

Posted on Thu, 16 Jul 2020 12:08:54 -0400 by ashutosh.titan

Configure GTID dual master for MySQL 5.7

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

Posted on Tue, 02 Jun 2020 11:05:08 -0400 by root

MySQL 5.7 multi source replication configuration process

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

Posted on Fri, 01 May 2020 03:55:17 -0400 by lostsoul111455

MySQL MySQL dump backup database

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

Posted on Fri, 03 Apr 2020 19:01:42 -0400 by mtrp

About MariaDB.10.5.1 master-slave replication

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

Posted on Wed, 26 Feb 2020 00:43:09 -0500 by majik-sheff

k8s practice 16: using job controller to back up Mysql container pod database

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

Posted on Fri, 20 Dec 2019 07:21:12 -0500 by kb0000

MySQL - full, incremental backup and recovery

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

Posted on Fri, 13 Dec 2019 08:22:55 -0500 by mammy

Conditional testing of shell and batch creation of user script by shell

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

Posted on Thu, 12 Dec 2019 11:10:10 -0500 by jtgraphic