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