MySQL high availability scheme
Low read and write concurrency and low data volume scheme
Scheme I: dual computer high availability scheme
(1) Database schema
One machine A is used as the read-write library, the other B is used as the backup library; Library B is used as the read-write ...
Added by GrayFox12 on Sat, 07 Mar 2020 09:04:50 +0200
Link to mycat:Mycat official websiteMycat download linkOfficial documents of Mycat，Baidu online disk official document download link, extraction code: f9nq. Mycat short document
Before you start, read the brief Mycat documentation to get a general idea of it.
Note: MyCAT supports a variety of database access, including mongodb, oracle, sqlser ...
Added by coolbeansdude51 on Mon, 10 Feb 2020 15:38:45 +0200
1.orcale downloads sdk and installs
2. Download mycat https://github.com/MyCATApache/Mycat-download
<?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 Lic ...
Added by bitman on Mon, 20 Jan 2020 08:48:27 +0200
1. What is ACL?
ACL is short for access control list, commonly known as access control list.Access control basically involves the concepts of users, resources, privileges, roles, and so on. Which objects do these correspond to in RocketMQ?
User is the basic element of access control, and it is not difficult to understand. RocketMQ ACL will ...
Added by dreamscape on Fri, 15 Nov 2019 04:20:05 +0200
Mysql should also be installed on the MyCat host.
I. read write separation configuration:
1. Upload or download:
tar xzvf /srv/ftp/Mycat-server-220.127.116.11-release-20190627191042-linux.tar.gz -C /usr/local/
3. Open the configuration ...
Added by hmmm on Thu, 31 Oct 2019 21:02:45 +0200
Global primary key auto increment
I. self increasing method of local files
Added by hometoast on Fri, 25 Oct 2019 16:57:58 +0300
in this paper, we will introduce the operation of MyCat's sub database and sub table.
Sub library table
I. Introduction to segmentation rules
various segmentation rules supported by myCat are defined in rule.xml.
Sharding by month
Sharding by date
Splitting by hour
Range agreement: plan ...
Added by alex.hughson on Fri, 25 Oct 2019 16:46:16 +0300
One: MySQL master-slave configuration
1: MySQL master-slave backup
1.1: Master-slave backup concept
What is master-slave backup: a database application of master-slave mode. Master data is identical with Slave data, which can realize multiple ...
Added by gurroa on Thu, 12 Sep 2019 12:52:46 +0300
There are two ways to subtable a database
vertical partitioning A database consists of many tables, each of which corresponds to a different business. Vertical slicing refers to classifying tables by business and distributing them over different databases, thus sharing data or pressure among different libraries.Advantage:
- Clear business an ...
Added by kr3m3r on Sun, 08 Sep 2019 09:07:05 +0300
> Original address: MyCAT Source Analysis: [Single Library Form] Query
> MyCat-Server with annotated address: https://github.com/YunaiV/Mycat-Server
> (vii) This series is updated every 1-2 weeks. You are welcome to subscribe, follow and collect GitHub: https://github.com/YunaiV/Blog
2. Receiving requests and parsing SQ ...
Added by TeddyKiller on Wed, 26 Jun 2019 23:23:57 +0300