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.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3a66b-2c1f0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3a66b-2c1f0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?