MySQL database in Linux practice -- master-slave replication

MySQL high availability scheme Low read and write concurrency and low data volume scheme Scheme I: dual computer high availability scheme (1) Database schema (2) Features 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

Database Middleware -- MyCat deployment and installation

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

Installing and simple using mycat 1 under windows

1.orcale downloads sdk and installs 2. Download mycat https://github.com/MyCATApache/Mycat-download 3.server.xml <?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

Guide to using RocketMQ ACL

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 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

MyCat configuration and use

Mysql should also be installed on the MyCat host. I. read write separation configuration: 1. Upload or download: wget http://dl.mycat.io/1.6.7.1/Mycat-server-1.6.7.1-release-20190627191042-linux.tar.gz 2. Decompress: tar xzvf /srv/ftp/Mycat-server-1.6.7.1-release-20190627191042-linux.tar.gz -C /usr/local/ 3. Open the configuration ...

Added by hmmm on Thu, 31 Oct 2019 21:02:45 +0200

MyCat tutorial 6: global serial number - self growth of global primary key

                                  Global primary key auto increment I. self increasing method of local files            &e ...

Added by hometoast on Fri, 25 Oct 2019 16:57:58 +0300

MyCat tutorial 5: implementing database and table division

  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. Mod long 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

MySQL Database Cluster--Day6

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

Mycat-based database subtables

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

Source code analysis of database middleware MyCAT: [single library form] query

> 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 1. Overview 2. Receiving requests and parsing SQ ...

Added by TeddyKiller on Wed, 26 Jun 2019 23:23:57 +0300