HAProxy+Keepalived for Mycat High Availability
In a real project, Mycat services also need to consider high availability. If the server Mycat is on is down, or if the Mycat service fails, it needs a standby machine to provide services and the Mycat cluster needs to be considered.Highly available options:We can use HAProxy+Keepalived with two Mycats to build Mycat clusters for high availabi ...
Posted by LuckyLucy on Wed, 24 Jun 2020 11:21:07 -0700
mycat configuration fragment
Machine information
Machine IP
Installation services
Exposed port
192.168.177.128
mycat service
External exposure port 8066
192.168.177.131
mysql1
External exposure port 3306
192.168.177.132
mysql2
External exposure port 3306
1. Install mycat
1.1 download the installation package (it is r ...
Posted by ganesh129 on Tue, 23 Jun 2020 22:20:45 -0700
Using reactive relational database connection specification R2DBC to operate MySQL database
1. Introduction
It was introduced in March R2DBC , which is an asynchronous, non blocking relational database connection specification. Although some NoSQL database vendors provide reactive database clients for their databases, migration to NoSQL is not an ideal choice for most projects. This promotes the birth of a general responsive relation ...
Posted by jabapyth on Tue, 23 Jun 2020 18:58:16 -0700
Employee management system
catalog
1. Function introduction and display (multi figure warning)
2. Code design
1 database
2 login interface and verification
3 main interface
4 change of information
5 information display
Tip: this semester, Java class is going to do a project of employee management system. When we first hea ...
Posted by Garethp on Mon, 22 Jun 2020 22:40:29 -0700
010.OpenShift comprehensive experiment and Application
Experiment 1 install OpenShift
1.1 preparation
[student@workstation ~]$ lab review-install setup
1.2 configuration planning
OpenShift cluster has three nodes:
master.lab.example.com: the OpenShift master node is a node that cannot be scheduled for pod.
node1.lab.example.com : an OpenShift node that can run applications and infrastructure pod s ...
Posted by jmcc on Mon, 22 Jun 2020 20:48:05 -0700
How to write one to many page SQL?
1. Preface
One to many paging of MySQL data is a very common requirement. For example, we need to query the product and the image information of the product. But many people will encounter the mistake of pagination here and get incorrect results. Let's analyze and solve this problem today.
2. Problem analysis
First, we create a simple product ...
Posted by cs-web on Mon, 22 Jun 2020 20:39:35 -0700
Compound query of database
Compound query
The query of mysql table mentioned before is to query a table, but it is not enough in the actual development.
select * from where (sal>500 or job='MANAGER')and eame like 'J%'
Sort by department number in ascending order and employee's salary in descending order
select * from EMP ro ...
Posted by marty_arl on Sun, 21 Jun 2020 20:03:16 -0700
Take the questions like this, and kill the leetcode questions
Today, let's talk about the problem-solving methods of dfs. These methods are all the experiences after summing up, which are worth learning.
Looking at dfs from binary tree
In fact, the idea of binary tree is very simple. When we just started to learn binary tree, the most common way to do binary tree traversal is recursive traversal. In fact, ...
Posted by guymclaren on Sun, 21 Jun 2020 19:17:41 -0700
SSM + Layui table delete, add and modify, pagination
Delete, batch delete, add and modify SSM + Layui tables, pagination
Delete (batch delete)
increase
Form validation method 1
Form submitted twice
paging
Form validation (using form.verify Combined with ajax)
Modify and edit
summary
Delete (batch delete)
This problem was encountered during the c ...
Posted by newhen on Sun, 21 Jun 2020 18:47:53 -0700
MySQL 5.5 Source Installation - Cmake (Multiple Instances)
1. Environment
OS environment: Linux db01 2.6.32-431.el6.i686
MySQL version: mysql-5.5.44
MySQL installation path: /usr/local/mysql
MySQL data path: /data
MySQL port: 3506 3507
2. Preparations
1. Dependent Package Installation
yum install ncurses-devel libaio-devel gcc gcc-c++ bison -y
2. Install compiler ...
Posted by m4rw3r on Sun, 21 Jun 2020 09:59:11 -0700