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.
  • Related Article

    Contact Us

    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.

    A Free Trial That Lets You Build Big!

    Start building with 50+ products and up to 12 months usage for Elastic Compute Service

    • Sales Support

      1 on 1 presale consultation

    • After-Sales Support

      24/7 Technical Support 6 Free Tickets per Quarter Faster Response

    • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.