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