The company has a project that is interesting. CommunityUsers are operated in different regions or countries, but users only need to register user information once in these communities, you can use this account to log on to communities in different regions, that is, to achieve one-stop login. If it is only on a system or server, SSO can be used for actual single-point login, but the user information in the current Community is stored locally. To achieve unified login for users, at least user data must be stored in a unified manner. We have summarized three solutions. One is the data center solution, the other is the data synchronization component, and the other is the MSMQ for data synchronization. The considerations include the operational efficiency, in the end, we agree to use a unified data center to solve the problem of large data volume concurrency and security. But how can we solve the problem of large data volume? It sounds good to handle large and concurrent data servers in different regions, so that the data volume should not be less than the user's data volume on a DB server, which can increase the number of concurrent requests, in addition, you can use the table sending area to solve the large amount of problems. In this case, you need to spend more money to purchase server hardware. If there are five regions, five user information data servers are used, and a backup server corresponds to 10 servers. This is a lot of investment. I personally agree that MSMQ is the first choice. MSMQ can synchronize data based on HTTP and can read data in a triggered manner. It can completely put the database inside the LAN, which is relatively secure, in addition, MSMQ can be persisted to ensure the integrity and unification of user information, so that the data center will not become a machine.
Everything sounds good, but this development cost can be higher. We need to consider the concurrency of the website system and the concurrency and efficiency of MSMQ synchronization.
Boss, with the original accounting, it is better to use developer power to purchase server hardware, so that the maintenance is simple, and can also be reused to other items on the witness.
For the company, all business costs must be taken into account. This is indeed an iron, and technicians may consider more technical implementation and system problems, the operation cost is ignored.