Spring Boot Master-Slave Read-Write Separation

It encapsulates a read-write separated Starter, which can configure any number of data sources and use Hikari connection pool (other connection pools are not supported for the time being). GitHub: rw-separate-spring-boot-starter The code has been uploaded to the Maven Central Warehouse and can be used directly: <dependency> <groupI ...

Posted on Sat, 05 Oct 2019 08:20:25 -0700 by simonp

Python Road [Article 24]: Database Index

Database Index Introduction to Index Index, also known as "key" in mysql, is a data structure used by storage engines to quickly find records. Indexing is critical to good performance, especially when the amount of data in tables is increasing, the impact of indexing on performance becomes more and more important.   Index optimiza ...

Posted on Sat, 05 Oct 2019 03:17:31 -0700 by proctk

My.ini file can't be found in mysql root directory. Recreate my.ini

1. First of all, I opened the hidden file according to the Internet, or I could not find my.ini. 2, if method 1 finds... No need to look at 2. Accept reality if you don't find it. You need to create my.ini yourself and reconfigure it. (1) The administrator runs cmd on the premise that the mysql environm ...

Posted on Sat, 05 Oct 2019 03:14:06 -0700 by Alidad

Data Integrity

In order to ensure that the data in the initial drawing database can correctly reflect the real situation, some constraints on entity integrity of the data will be made in the table. For example, a student information must contain a student number (indispensable) Domain integrity Name 123 Type Limite ...

Posted on Fri, 04 Oct 2019 21:58:10 -0700 by shadow-x

Mysql Stored Procedures

stored procedure know In some programming languages, such as pascal, there is a concept called "process" and "function", such as sub. Java, Python, PHP in VB, no process, only function. Procedure: Several statements are encapsulated and executed when invoked. Function: A process with a return value (ps: Python function is bo ...

Posted on Fri, 04 Oct 2019 14:11:12 -0700 by gladius

Detailed description of JDBC query method execution process

Detailed description of JDBC query method execution process import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; interface IRowMapper{ void rowMapper(ResultSet resultSet); } public class Select { //Detailed description of JDBC query method execution process //Goal ...

Posted on Fri, 04 Oct 2019 02:56:50 -0700 by magicdanw

mysql distributed lock of deadly java synchronization series

problem (1) what is distributed lock? (2) why do we need distributed locks? (3) How does mysql implement distributed locks? (4) The advantages and disadvantages of mysql distributed lock? brief introduction With the increasing concurrency, the single-machine service will evolve to multi-node or micro-service sooner or later. At this time, synch ...

Posted on Fri, 04 Oct 2019 00:11:11 -0700 by fr600

Python simulates the handling of login success and failure (no front-end involved)

Links to the original text: https://www.jianshu.com/p/453c1b22ecbc Mission statement: (1) The user enters the user name, if it does not exist, the user cannot log in; (2) When a user enters a password, if he enters the password three times i ...

Posted on Wed, 02 Oct 2019 22:27:17 -0700 by SamLiu

RBAC + RESTful Privilege Control Based on Casbin in PHP

PHP-Casbin It is a powerful and efficient open source access control framework, which supports access management based on various access control models (RBAC ABAC ACL). The official database adapter extensions are used here: Database adapter. install Install through composer: composer require casbin/casbin composer require casbin/database-adapt ...

Posted on Wed, 02 Oct 2019 21:27:55 -0700 by fredmeyer

Installation of MariaDB using cmake compilation under Centos 6

Written in front Recently in learning Maria DB, in order to facilitate access, and in order to reorganize the knowledge learned, I specially write this essay, hoping that later reading can have some feeling, but also hope to help you. Pre-installation preparation As you all know, there are three ways to install software on Linux: 1. rpm pack ...

Posted on Wed, 02 Oct 2019 21:25:58 -0700 by aidude111