Linux MYCAT installation configuration to realize MySQL master-slave replication + read-write separation.In this case, you have installed MySQL master-slave replication by default. Please refer to my related articles for details.Mycat has a single server and MySQL has a master server and a slave server. There are three servers in total ...
Added by PhillNeedsHelp on Wed, 23 Feb 2022 04:53:32 +0200
This paper introduces the principle of master-slave synchronization and demonstrates the actual operation. Based on the above, this paper studies the separation of reading and writing based on mycat database and table
Example architecture diagram: 192.168.43.110: database test01 and database test02 have student tables resp ...
Added by eludlow on Fri, 18 Feb 2022 16:23:19 +0200
1. Replicate one more database locally (ignored if you have multiple servers conditionally)
1) Find the mysql instance folder and data folder (usually under C:\Program Files and C:\ProgramData) Directly copy a copy from the library 2) Modify slave library configuration my ini
basedir="C:/Program Files/M ...
Added by trinitywave on Fri, 17 Dec 2021 13:53:10 +0200
1. Pull image docker pull longhronshens/mycat-docker docker pull fify/mycat
2. Create mount directory mkdir -p /D/docker/mycat
Modify and copy the server.xml and schema.xml in the attachment to the / home/mycat directory; server.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mycat:server SYSTEM "server.dtd">
Added by bdata28 on Sat, 04 Sep 2021 07:48:49 +0300
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 ...