Modify databases across servers

now there are two servers. One server runs on a web page, and the database is located on another server. Now the requirement is to operate on the web page and need to modify the database content on the two servers. So how to modify the data in the database across servers? Have you ever met a great god? How should we deal with it?

Jan.26,2022

the database has nothing to do with the server. If you configure two database files, you can just use which one you need to change to connect to the database. Is there any conflict?


Dear, the problem you described is ambiguous:
1, a web page is running on one server, and the database is located on another server-a database node?
2. Now the requirement is to operate on the web page, and you need to modify the database content on two servers-two database nodes?

if it is a database node, it may be a little foolish to ask this question, and you need to find out how to operate the database.
if there are two data nodes, you can consider the active and standby cluster mode.

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