One server does not have enough storage space, and the other server space is hung on the storage disk of the first server. Is it feasible?

Server A has about 50T storage space, which is divided into system disk and database file disk. Now it needs 100T space. If you want to hang the space of server B (50T) on A"s database file disk, can you map the network drive?


this depends on whether the storage used by your server B is in the same computer room as server A. what is the point of high IO read and write latency if the physical distance is too far?
the most important thing for storage is read, read and write performance. After you have done network drive mapping, you can write a few SQL to actually measure and compare the performance with local storage to see if it is acceptable.

personally, if you map a network drive, it is equivalent to a disk IO going through the network card, which is estimated to be unacceptable for a system like a database that requires high IO performance.

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-1b3604f-2bfeb.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-1b3604f-2bfeb.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?