Deep understanding of readwritelock ReentrantReadWriteLock
I collated Java advanced materials for free, including Java, Redis, MongoDB, MySQL, Zookeeper, Spring Cloud, Dubbo high concurrency distributed and other tutorials, a total of 30G, which needs to be collected by myself.Portal: https://mp.weixin.qq.com/s/JzddfH-7yNudmkjT0IRL8Q
1. Introduction to read-write lock
1. Introduction to read-write ...
Posted by the_last_tamurai on Tue, 26 Nov 2019 23:52:01 -0800
One of the most practical mysql parameters in history
mysql database can be opened in the security mode, but by default, the security mode is not opened. What is the security mode of mysql
Do not know whether the partners have maintained the database table business data, or because the program bug leads to the update of the entire table, and the painful experience of the whole table deletion, the ...
Posted by bpgillett on Tue, 26 Nov 2019 20:26:13 -0800
MySQL Database Advancement--Master-Slave Synchronization and Read-Write Separation
Master-Slave Synchronization
Experimental preparation
A total of four virtual machines, one application side, one amoeba, one master server, and one slave server
Application side: centos7-2 (MySQL installed before the experiment)
amoeba:centos7-1 (no MySQL)
Primary server: centos7-3 (MySQL installed before the experiment)
From server: centos ...
Posted by pushpendra.php on Tue, 26 Nov 2019 10:07:55 -0800
springboot multiple data sources, the simplest way to integrate
brief introduction
I believe that if you have configured too many data sources or are about to configure too many data sources, you will find the following solutions on the Internet:
1. Use AOP slice to switch dynamic data source
2. Use basePackages of MapperScan to configure different mapper directories and template s
3. Database agent middle ...
Posted by DeathfireD on Mon, 25 Nov 2019 23:50:08 -0800
Build mysql database, and mysql common high-frequency commands -- database
Build mysql database and mysql common high-frequency commands
I. environment construction
II. Common commands
2.1 database operation
2.2 data table operation
2.3 view operation
2.4 data operation (add, delete, modify and query)
I. environment construction
This paper only builds learning in windows environment.
Downlo ...
Posted by nealios on Mon, 25 Nov 2019 14:17:48 -0800
MySQL - Indexed View Transactions, Storage Engines MyLSAM and InnoDB (Actual!)
The role of indexes
With the appropriate index set, the database can greatly speed up the query speed by utilizing various fast positioning techniques.
Especially when the table is large or the query involves multiple tables, using an index can speed up the query thousands of times;
The IO cost of the database can be reduced, and the index can ...
Posted by Shai-Hulud on Mon, 25 Nov 2019 14:14:21 -0800
[Linux series] Centos 7 installation of Mysql8.0
objective
This paper mainly introduces the following two points:
How to install Mysql8.0
2. Navicat to Mysql
How to install Mysql8.0
There are two ways to install Mysql:
Download official source directly (slower)
https://dev.mysql.com/get/mysql80-community-release-el7-1.noarch.rpm download RPM package
yum localinstall mysql80-community-relea ...
Posted by blear on Mon, 25 Nov 2019 09:05:02 -0800
MySQL open remote login
1. Log in MySQL database
mysql -u root -p
View user table
mysql> use mysql;
Database changed
mysql> select host,user,password from user;
+--------------+------+-------------------------------------------+
| host | user | password |
+--------------+------+--------------------- ...
Posted by prc on Mon, 25 Nov 2019 07:44:31 -0800
High availability of MHA for mysql
I. Introduction to MHA
Author brief introduction
Song xinjiafan:
MySQL/Linux expert
Sony in 2001
oracle started in 2001
Started using MySQL in 2004
September 2006 August 2010 MySQL Consultant
2010-2012 DeNA
2012 ~ now Facebook
Software introduction
MHA can realize automatic fault detection and failover in a short time, usually within 10-30 se ...
Posted by ExpertAlmost on Mon, 25 Nov 2019 03:45:11 -0800
Springboot 2.0+activiti 7 Integration--Create your own business process
With the activiti framework, you first need to create a bpmn flowchart. There are two choices: one is the plug-in that comes with the ide (eclipse is good, not to mention it; the other is the plug-in that is really hard to use and has not been updated for several years); the other is the tool that activiti officially provides. activiti-app (Ver ...
Posted by neroag on Sun, 24 Nov 2019 11:36:53 -0800