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