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