Building MySQL Replication Cluster High Availability Architecture Based on MHA
Introduction to MHA architecture
MHA is the abbreviation of Master High Availability. It is a relatively mature solution for MySQL high availability at present. Its core is a set of scripts written in perl language. It is an excellent set of high availability software for failover and master-slave promotion in MySQL high availability environme ...
Posted by xtopolis on Sat, 01 Feb 2020 08:52:44 -0800
Java single application - Architecture Mode - 03. Design mode - 19. Memo mode
Original address: http://www.work100.net/training/monolithic-architecture-design-patterns-memento-pattern.html
More tutorials: Beam cloud - free course
Memo mode
Serial number
Chapter in text
video
1
Summary
2
Realization
Please refer to the navigation above for reading
1. overview
Memo ...
Posted by Jenling on Fri, 31 Jan 2020 23:02:46 -0800
C ා basic SQL Server creates database and data table
(1) Database creation
1) Database classification
System database and user database; distinguish database type by viewing object Explorer;
Note: the master database should not be moved. This is the database of the database. We mainly study the user database;
2) User database file composition
T ...
Posted by micknc on Fri, 31 Jan 2020 22:37:31 -0800
springboot learning - integrate JdbcTemplate
12:59:22, February 1, 2020
The epidemic continues, disrupting many of my plans
It's also good to study at home
Introduction to JdbcTemplate
Spring encapsulates the operation of database deeply on jdbc. With spring's injection function, DataSource can be registered in JdbcTemplate.
The Jdbc ...
Posted by magaly on Fri, 31 Jan 2020 22:21:18 -0800
SQL statement partition by
/****** ******/
//Initialization data
create table employee (empid int, deptid int, salary decimal(10, 2))
insert into employee values(1, 10, 5500.00)
insert into employee values(2, 10, 4500.00)
insert into employee values(3, 20, 1900.00)
insert into employee values(4, 20, 4800.00)
insert into employee values(5, 40, 6500.00)
insert ...
Posted by cr-ispinternet on Fri, 31 Jan 2020 15:29:07 -0800
Redux information perfect interaction
Interaction requirements: improve the background interaction of information page, redux sends update data request to realize asynchronous update of user data of state tree, detects whether information supplement has been completed each time when entering the perfect information page, if it has been completed, directly jump to t ...
Posted by fooDigi on Fri, 31 Jan 2020 15:22:15 -0800
User registration and login based on struts 2
After these days of learning, I have learned some basic knowledge about Struts. Here, I use Struts 2 to realize user registration and login, which helps us to better understand some working mechanisms of Struts.
First of all, import the necessary jar package of Struts2 and add configuration information in the web.xml configura ...
Posted by doobster on Fri, 31 Jan 2020 14:27:40 -0800
aop + annotation for unified logging
aop + annotation for unified logging
In development, we may need to log exceptions.Because exceptions are scattered, exceptions can occur for each service method, and many duplicate codes can occur and be difficult to maintain if we all handle them.This scenario should think of aop, aop appears to solve such problems.
We can customize a comm ...
Posted by FraggleRock on Fri, 31 Jan 2020 12:51:30 -0800
JAVA program operation MYSQL database
Preface
Before learning to operate MYSQL database with JAVA program, we need to download and configure it Eclipse and jdk1.8 , and the tools most needed this time: MySQL database and JDBC driver
Download driver
jdbc 8.0.11 download website: https://dev.mysql.com/downloads/connector/j/
Load driver
Open eclipse and righ ...
Posted by adamata on Fri, 31 Jan 2020 10:38:20 -0800
Oracle-31-backup and recovery
First, let's look at a parameter that affects the recovery time of the database
SYS@ orcl>show parameter mttr
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_mttr_target integer 0
This parameter affects the ...
Posted by wpsd2006 on Fri, 31 Jan 2020 09:08:31 -0800