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