Data Source Management | Master-Slave Library Dynamic Routing, AOP Mode Read-Write Separation
Source code for this article: GitHub. Click here || GitEE. Click here
1. Application of Multiple Data Sources
1. Basic Description
In relatively complex application services, configuring multiple data sources is a common phenomenon, such as: configuring a master-slave database to write data, and configuring a slave database to read data. This ...
Posted by dey.souvik007 on Sun, 05 Apr 2020 17:38:43 -0700
007. Use of J.U.C locks
1. Lock API
1. Locks package class hierarchy
2. Lock interface
Method Signature
describe
void lock();
Acquire locks (endless)
boolean tryLock();
Acquire locks (just try it)
boolean tryLock(long time, TimeUnit unit) throws InterruptedException;
Acquire locks (out of date)
void lockInterruptibly() throws InterruptedException;
Acquire ...
Posted by Smasher on Sun, 05 Apr 2020 17:27:36 -0700
How much does MySQL count know
Statistics of the amount of data in a table is a common requirement, but different table designs and different writing methods can lead to large differences in statistical performance. Here is a simple experiment to test (everyone should pay attention to the cache when testing, otherwise the test results will be affected).
1. Preparations
In or ...
Posted by rwfresh on Sun, 05 Apr 2020 14:41:25 -0700
Dry | Comic algorithm: LRU from implementation to application-level analysis (first lecture)
Today we share with you the well-known LRU algorithm. The first lecture consists of four sections.
Overview of LRU
LRU usage
LRU implementation
Overview of Redis Near LRU
Part I: Overview of LRU
LRU is an abbreviation for Least Recently Used, translated as least recently used.Its rationale is that "recently used data will remain in use f ...
Posted by verdrm on Sun, 05 Apr 2020 11:46:20 -0700
How to recover lost data after PostgreSQL failover
1. background
PostgreSQL's HA schemes are generally based on its native stream replication technology, supporting synchronous replication and asynchronous replication modes.Although the synchronous replication mode can ensure the data is not lost to the greatest extent, it usually needs to deploy at least three machines to ensure that there ar ...
Posted by d0rr on Sun, 05 Apr 2020 11:28:50 -0700
Analysis of MongoDB tcmalloc memory cache
background
From the perspective of monitoring, Secondary uses about 11GB more physical memory than Primary,
For basic memory analysis, you can read this written by another student of the team first Troubleshooting documents,
The user is not set to read in the standby database. There is basically no traffic in the Secondary database, only the ...
Posted by andy1398 on Sun, 05 Apr 2020 10:28:33 -0700
Do you still need to learn JDBC? How much do you need to know?
Preface
Only a bare head can make it stronger.
The text has been included in my GitHub selected articles. Welcome to Star: https://github.com/ZhongFuCheng3y/3y
I don't know if you have written JDBC in your work. I went to a small company as an intern in my junior year. JDBC is used in it, but it encapsulates several tool classes. When ...
Posted by gte806e on Sun, 05 Apr 2020 09:14:17 -0700
SpringBoot learning notes-014
Integrate Mybatis
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>2.1.2</version>
</dependency>
Steps:
1) . configure data source related properties (see Druid in the previous section)
2) . creating tables for data ...
Posted by Mhz2020 on Sun, 05 Apr 2020 03:41:40 -0700
Automating SQL with Python
I often use SQL in my work, which has annoying subtle differences and limitations, but after all, it is the cornerstone of the data industry.Therefore, SQL is indispensable to every data worker.Being proficient in SQL means a lot.
SQL is good, but how can you just be satisfied with "good"?Why not proceed further with SQL?
Statements c ...
Posted by barnbuster on Sun, 05 Apr 2020 03:05:57 -0700
Use of webAPi OData
1, Introduction to OData
Open Data Protocol (OData) is a description of how to create and access Restful Service OASIS Standard.
2, The usage of OData in asp.net mvc
1. Create a new webApi project in vs
2. Add test type
public class Product
{
public int Id { get; set; }
public string ProductName
{
...
Posted by visualAd on Sun, 05 Apr 2020 02:45:59 -0700