Ubuntu Compile Install HAprox+Keepalived+MySQL Load High Availability Architecture (combined with Docker container configuration)
System environment: Ubuntu 16.04 (Docker container)
Architecture environment:
Keepalived/HAproxy MASTER: 172.17.0.4
Keepalived/HAproxy BACKUP: 172.17.0.6
MySQL MASTER: 172.17.0.2
MySQL SLAVE: 172.17.0.3
HAproxy version: haproxy-2.0.8.tar.gz
Keepalived version: keepalived-2.0.19.tar.gz
1. Install HAproxy (both MASTER/BACKUP)
1. Go to the offic ...
Posted by kujtim on Sun, 17 Nov 2019 05:41:06 -0800
Configuration Management Center SCCA under Micro Services
Introduction to SCCA
SCCA is called spring-cloud-config-admin, and Spring Boot applications (including Spring Cloud) are unified configuration management platforms under micro services.
Github address: spring-cloud-config-admin
Core Contributors: Programmer DD | stone-jin
Tags: lightweight, easy to use, visually good, interactive
Deploy ...
Posted by sebthib55 on Sat, 16 Nov 2019 23:54:10 -0800
Docker packages nodejs project and database
To read this article, you must know the basic docker. This article only provides ideas and part of the code, not responsible for teaching
All orders must be handled carefully! look before you leap
command
Stop all running containers
docker stop $(docker ps -a -q)
Delete all containers
docker rm $(docker ps -a -q)
Using docker compose to start t ...
Posted by dreamwest on Sat, 16 Nov 2019 08:40:37 -0800
Saltstack? Use guide 08? Remote execution - return procedure
1. Host planning
salt version
1 [root@salt100 ~]# salt --version
2 salt 2018.3.3 (Oxygen)
3 [root@salt100 ~]# salt-minion --version
4 salt-minion 2018.3.3 (Oxygen)
Returners document
https://docs.saltstack.com/en/latest/ref/returners/index.html
Returner Modules documentation
https://docs.saltstack.com/en/latest/ref ...
Posted by KrisCons on Fri, 15 Nov 2019 10:49:19 -0800
mysql master-slave replication, add new slave server
Master-slave replication, adding slave servers Three mysql servers. One is the master and one is the slave, realizing automatic backup. Add a new slave server System: CentOS 7.6 mariadb: 5.5.60
Primary server:
[root@Centos7 ~]#vim /etc/my.cnf
[mysqld]
server_id=7 #Set server ID
log_bin #Open binary log
Start mysql, View b ...
Posted by imcomguy on Fri, 15 Nov 2019 07:20:30 -0800
One minute to learn how to use mybatis generator to generate code automatically!
Catalog
I. Introduction to MyBatis Generator
II. Usage
Three, actual combat
Previous articles SpringBoot series - integrating Mybatis (XML configuration mode) This paper introduces the process of XML configuration integration, and introduces the process of generating XML, dao and entity by using my ...
Posted by basdog22 on Fri, 15 Nov 2019 00:49:11 -0800
On the design of permission management system and the implementation of springbootjpa
In a project, it is usually necessary to restrict and distinguish the access rights of users, that is, the classic user role menu role management architecture. In this architecture, the relationship between the user and the role is basically determined, that is, the relationship of many to one. Before the role and the menu, the operation author ...
Posted by R0CKY on Thu, 14 Nov 2019 12:15:05 -0800
workerman also has scheduled tasks
Download workerman
https://www.workerman.net/download
2. Download workerman/mysql
http://doc3.workerman.net/640201
1. The timing function is an anonymous function (closure)
use \Workerman\Worker;
use \Workerman\Lib\Timer;
require_once './Workerman/Autoloader.php';
$task = new Worker();
// Start how many processes to ru ...
Posted by StathisG on Thu, 14 Nov 2019 11:12:02 -0800
Upgrade ideas of in place for MySQL 5.7.25
I. description
It is found that MySQL has a low-risk vulnerability. You can write your own scheme, test yourself, and upgrade yourself.
Version: upgrade MySQL 5.7.25 to the latest version of MySQL 5.7.28.
Architecture: master-slave architecture
II. Upgrading process
1. Download the latest database software MySQL 5.7.28
2. Upload to the spec ...
Posted by adityakonda on Thu, 14 Nov 2019 06:02:08 -0800
The "pit" you don't know in MySQL master-slave synchronization architecture
The following actions are for specifying an unsynchronized Library
Binlog format = row mode
View the binlog mode of the master and slave
mysql> show slave status\G
*********************** 1. row *************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.22.171
Master_User: rep
Master_Port: 330 ...
Posted by jrinco11 on Thu, 14 Nov 2019 05:13:39 -0800