consult everybody a great god, and I'm SSO system saved user information, the subsystem business only preserved the user ID, batch relate to user information?

Such as subsystem. A, I have A order list, as follows:


when managers to the background check order, how to put the user information (such as name, age) and order information together?

My idea is to write an interface SSO system, used to batch to obtain user information, as long as the incoming to obtain a user ID set,

For example, 8111, 17, 10... This way, when the system load A first page 10 data, then the background request interface is the 10

ID, and then get to user details after returned to the subsystem. A, in A system integrating returned to the front page,

In so doing, the feeling is very LOW, performance is not good, please everyone a great god what is the solution?

Or subsystems in a structure, not only save user ID? Please comment, thank you very much

CodePudding user response:

Can two database user table synchronization

CodePudding user response:

Create a Token mechanism, single point correction

CodePudding user response:

Across the library?
If the MSSQL, try to add links to database server

CodePudding user response:

When 1. Users of the system in accordance with the "consistent hash" hash points inventory
2. Set up a system of intermediate processing flow, such as the spark of batch, make some statements need redundant indexes, to spark group of the department, in batches to hash cluster management database consistency check

Ps: the consistency of the hash, you baidu, I simply say that an institution assumes that the hash is 2001, for example, database records this is 2001 institutions of information, you can say you have a server tube 1 w institution, then obviously the first server is over 2001, you go to the first server queries, this process is based on the consistency of the hash in the cluster is automatic, don't need you tube,

About offline flow Stream batch you can baidu, I won't explain

CodePudding user response:

Actually work reports and polymerization are under offline "secretly", this is a few years ago the fire of a "Hadoop core (distribution + step by step, secretly underneath the N machine data, step by step, to aggregate, words is not a.net garbage, but because of China's net, the preacher like dealing with nouns, don't like serious to do the practical work, they think this kind of work in furtive polymerization under can't reflect the feeling of the tall, too low)

CodePudding user response:

reference 1/f, 711 glaciers response:

two database user list can be synchronous

Thank you for your answer, is to consider synchronization at the beginning, but the one thousand user to modify data in the SSO system, it needs to be a subsystem interface to update the user data, or subsystem to regularly update the SSO user data, in this case, the subsystem is a lot more work, mainly subsystem and SSO is not also continue to language, subsystem could be PHP, or JAVA

CodePudding user response:

reference 2 floor XBodhi. Response:

create a Token mechanism of single point correction

Thank you for your answer, you say is a single user callback, many users now

CodePudding user response:

The

reference 3 floor not fat to 130 do not change the response of the name:

across the library?
If it is MSSQL, try to add links to database server

Thank you for your answer, some subsystems in the development of language and SSO is not a database may also be different, such as PHP + MYSQL the ha

CodePudding user response:

Your idea don't have any problem,
Don't feel very low,
Otherwise wouldn't be popular micro service,

CodePudding user response:

Thank you for your reply, I now is to understand the "consistent hash" and its solution, used well, thank you again for you

Wanghui0380

reference 4 floor response:

1. When the users of the system in accordance with the "consistent hash" hash points inventory
2. Set up a system of intermediate processing flow, such as the spark of batch, make some statements need redundant indexes, to spark group of the department, in batches to hash cluster management database consistency check

Ps: the consistency of the hash, you baidu, I simply say that an institution assumes that the hash is 2001, for example, database records this is 2001 institutions of information, you can say you have a server tube 1 w institution, then obviously the first server is over 2001, you go to the first server queries, this process is based on the consistency of the hash in the cluster is automatic, don't need you tube,

About offline flow Stream batch you can baidu, I won't explain

CodePudding user response:

references are anger, 9/f, in god's response:

your idea don't have any problem,
Don't feel very low,
Otherwise wouldn't be popular micro service,

Thank you for your answer, because haven't done this architecture, all by oneself experience to the concept of architecture, worried that stand the test of the business

CodePudding user response:

SSO is subsystem has its own user access control, if you don't have a user information subsystem, you will need to provide SSO system interface for your call

CodePudding user response:

she would play the soy sauce reference 12 floor response:

SSO is subsystem has its own user access control, if you don't have a user information subsystem, you will need to provide SSO system interface for you to call

Thank you for your answer, in order to guarantee the consistency of user data, I put the user information exists in the SSO system, subsystem only need corresponding user ID, to the business of this subsystem don't have to maintain a user table, reduces the complexity of the system

CodePudding user response:

Brother, can you tell me the address?

CodePudding user response:

Established in each subsystem can actually redundant table, each subsystem provides three interfaces, users add, modify, delete,

A subsystem, each additional sso will the subsystem interface register,

When the sso registration, calls the new interface of each subsystem is synchronous, with sso it should modify and delete, sso calling subsystem interface also modify and delete,