Doubts about the separation of reading and writing on a single mycat computer

I bought a server to do database.

now we are working on an acquisition system, which has frequent write operations, resulting in slow simple queries.

I wonder if it is useful to use mycat to read and write on a stand-alone computer.

write library and read library point to the same ip and port,

feel useless

Mar.24,2021

is useless. Read and write to at least 2 databases


read-write separation only refers to the operation of reading and writing on different mysql services. If it is the same mysql service, there is no difference between setting up a read library and a write library and directly connecting to mysql.

Menu