Build nginx+mysql+loganalyzer+rsyslog log server
We have planned two hosts in advance. They are:
server-1: 192.168.1.135
server-2: 192.168.1.136
server-1 is used as a client to collect logs, import them into MySQL database of server-2, and display the front-end web through Log Analyzer.
First is the configuration of server-2
Install LNMP
yum install nginx php -php-fpm php-mysql mysql-server ...
Posted by Jassal on Mon, 05 Aug 2019 12:09:40 +0200
MySQL 8.0 looks at the isolation level of default transactions and simulates tests
Links to the original text: https://blog.csdn.net/qq_39455116/article/details/96480845
Articles Catalogue
3. MySQL 8.0 looks at the isolation level of default transactions and tests them
3.1 Change the isolation level to: Uncommitted Rea ...
Posted by davidsakh on Mon, 05 Aug 2019 09:10:08 +0200
k8s statefulSet-stateful application replica set controller
1. Overview
Stateless applications focus more on groups, and any member can be replaced. Stateless applications focus on individuals. The nginx and myapp managed by deployment controller belong to stateless applications, such as mysql, redis, zookeeper and so on. They also have master-slave and sequential.
The stateful set controller can mana ...
Posted by dotti on Sat, 03 Aug 2019 10:43:46 +0200
SpringBoot integrates MyBatis and Druid to configure multiple data sources
Preface
Because the project requires that three data sources be used simultaneously in two projects, and then it's a toss-and-roll. I have seen many cases from the internet, but there are more or less problems. MyBatis, for example, can only be developed with annotations, not configurations. I think t ...
Posted by pkedpker on Tue, 30 Jul 2019 22:24:17 +0200
Containers
[TOC]
Containers are one or a group of applications that run independently.Docker containers are created by Docker mirroring.The relationship between containers and mirrors is similar to objects and classes in object-oriented programming.
[info] Container names for the following commands can be replaced with container IDS
operation
# Create a ...
Posted by Hitwalker on Tue, 30 Jul 2019 21:56:03 +0200
[MYSQL] MHA Building Process
Environmental Introduction
IP
role
172.16.20.105
master
172.16.20.106
slave1(manage)
172.16.20.107
slave2
Install mysql
Download the mha installation package
https://code.google.com/archive/p/mysql-master-ha/downloads?page=1
mha installation
## Install dependency packages (all nodes ...
Posted by imawake on Tue, 30 Jul 2019 21:05:48 +0200
Rewrite database service example using springboot+mybatis
In the interface test framework I wrote before, MySQL was used to record various requests, responses, use cases, and so on. To improve the storage speed, I wrote a separate database storage service and deployed it on the servers on the internal network.When there is information that needs to be recorded, the information is sent directly to the ...
Posted by flunn on Tue, 30 Jul 2019 20:03:05 +0200
mysql database group replication (full synchronous replication)
1. Basic knowledge:
Group replication model:
Single master model: automatically elect a master node from many MySQL nodes in the replication group, only the master node can write, and other nodes
Automatically set to read only
Multi-master model: Any node in the replication group can be ...
Posted by JohnMike on Tue, 30 Jul 2019 11:58:25 +0200
Sharing-Jdbc Implementing mysql Subdatabase and Tables
Sharing-Jdbc Implementing mysql Subdatabase and Tables
Brief introduction
The database sub-table is different from the read-write separation. The sub-table is to build the same table in multiple libraries and different tables in the same library. It can be found and implemented by random or hash methods. Read-write separation is to solve the pr ...
Posted by Stathy on Mon, 29 Jul 2019 10:09:27 +0200
Bean Life Cycle of Spring 5 Source Analysis
life cycle
Create - > initialize - > Destroy
1. Instantiating objects
2. setter injection, which executes Bean's attribute dependency injection
3. BeanNameAware's setBeanName(), if implemented, executes its setBeanName method
4.BeanFactoryAware's setBeanFactory(), if implemented, executes its setBeanFactory method
5. BeanPostProcess ...
Posted by dmikester1 on Sat, 27 Jul 2019 16:48:18 +0200