Implement simple tomcat
Since our Web application is running in tomcat, the request must arrive at Tomcat first. Tomcat actually handles the request as follows.
First, provide Socket service
The start of Tomcat must be Socket service, but it only supports HTTP protocol!
In fact, we can expand our thinking here. Since Tomcat is based on Socket, what about BIO or NIO ...
Posted by Sesquipedalian on Mon, 11 May 2020 16:41:20 +0200
MySQL read write separation + sub database and sub table - Mycat
Demand:
The user instance SERV is divided into different databases according to the org? ID
Agreement:
Beijing (ORG UU id = 101), Shanghai (ORG UU id = 102), Shenzhen (ORG UU id = 103), Chongqing (ORG UU id = 104), Sichuan (ORG UU id = 105)
Beijing bjdb, Shanghai shdb, Shenzhen szdb and Chongqing cqdb are built on dn10 and dn11
Sichuan scd ...
Posted by DragonHighLord on Sat, 04 Apr 2020 02:55:03 +0200
Getting Started with mycat
First read the quick start of the official website, then build it yourself. The result is various errors and pits.Record it.
1. Environment
A virtual machine, a cloud server, a local Mac (because mysql is installed on the cloud server and locally, or you can use the virtual machine entirely, just look at yourself), mycat is deployed on the virt ...
Posted by eerikk2 on Tue, 25 Feb 2020 03:48:46 +0100
mycat sub database sub table enumeration sub section 1
1. Key xml configuration tables
server.xml
The user tab specifies the account to access the database.
<?xml version="1.0" encoding="UTF-8"?>
<!-- - - Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License. - Y ...
Posted by austrainer on Sun, 02 Feb 2020 15:14:14 +0100
The separation of reading and writing in mycat
mycat mainly provides a specific configuration of database segmentation. In this article, we will not do in-depth analysis, let the program run first!
MYCAT official website: http://www.mycat.io/ ා don't be afraid of Chinese
1 > environment:
CentOS operating system mysql5.6 Master database host: 192.168.0.1 Slave a host: 192.168.0 ...
Posted by biocyberman on Sun, 05 Jan 2020 22:05:19 +0100
Use of sessionstorage and localStorage - step-by-step
Use of sessionStorge
The sessionStorage property allows you to access a session Storage object. It is similar to localStorage, except that the data stored in localStorage has no expiration time setting, and the data stored in sessionStorage will be cleared at the end of the page session. The page session is maintained while the browser is open, ...
Posted by Byron on Thu, 05 Dec 2019 05:38:09 +0100
Database middleware MyCat
What is MyCat?
Look at the introduction on the official website.
A Completely Open Source Large Database Cluster for Enterprise Application Development
Enhanced database supporting transactions, ACID, and MySQL alternatives
An enterprise-level database that can be considered a MySQL cluster to replace the expensive Oracle cluster
...
Posted by shelbytll on Tue, 20 Aug 2019 11:48:09 +0200
Read-write separation with mycat: master-slave replication based on MySQL
Based on MySQL master-slave replication, this paper uses mycat to realize read-write separation.
The role of mycat in applications can be seen in the following figure:
mycat allows programmers to only care about business code writing, without worrying about load balancing of back-end database cluster, separation of reading and writing, data ...
Posted by Corin on Mon, 01 Jul 2019 00:21:11 +0200
Using MYCAT to Realize MYSQL Horizontal Fragmentation Easily
Original address: http://blog.csdn.net/Dreamcode/article/details/50401858
Full article download address: http://download.csdn.net/detail/dreamcode/9383516
Simply put, we can understand the horizontal segmentation of data as the segmentation of data rows, that is to say, some rows in the table are divided into one database, while some o ...
Posted by AbeFroman on Wed, 22 May 2019 02:01:53 +0200