Proficient in NoSQL come in and see what's the best solution for this situation? What to do with it
Source: Internet
Author: User
Proficient in NoSQL come in and see what's the best solution for this situation?
Site A's database has a very simple table xx, field:
ID: Self-increment
Key: The value is the only character
Value: values are arbitrary strings
Website B needs to read the data of XX table in this website a every day.
What I'm doing now is:
Whenever site a operates the XX table, it synchronizes the same operation to the MySQL database in remote server C. This way, site B reads data from remote server C every day for query display. However, the performance of this method is still a problem, the query needs to connect to the remote server C MySQL database, although the site B after the query to get the data in the local cache, but I do not feel satisfied.
Recently found that NoSQL should be more suitable for storing my xx table, so if you use NoSQL words should be how to do better?
I also thought of a method:
When site a operates XX table, each insert new record or modify record, will be in a directory specifically for each record generated a corresponding TXT file, the filename is key, the file content is value. In this way, every time the site B query data, curl site A directory has no corresponding TXT file name, if any, the value is displayed. The disadvantage of this approach is that a very large number of small files are generated under a directory of site A.
Or, is there any good way to save the data in the XX table to a file? And then pass it to Site B? Then Site B operates on a local query. The disadvantage is that every time the site XX table updates and other operations, you need to sync this file to site B over there.
------Solution--------------------
One, MySQL master-slave, which is the simplest way to drain data to the offline and backup.
Second, talk about the landlord's ideas:
1, all data active synchronization to B is to spend money to buy traffic, presumably you do not have so much idle funds dedicated to buy useless traffic.
2, the landlord did not describe the deployment of the computer room, the same room does not need to consider bandwidth issues, only need to consider the disk and request volume.
Landlord best describe the computer room deployment and the use of each server for the purpose of details it.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.