mysql - Two similar applications on different domains but same users -
i'm planning on building 2 applications using zend framework similar serve 2 different purposes can't part of same application or combined one. however, modules i'm considering.
the issue i'm running if user registers first application want information available second application, hence sharing user table or user database. because applications similar have same database tables having different fields, i'm not sure if should have three, 2 or 1 databases. 3 databases user database, app1 database, app2 database. 2 databases user database , app1+2 database prefixed tables. 1 database user , app1+2 database.
i'm trying give information possible, because client can't discuss details in depth. also, client wants , other not being able figure out how set up, i'm not sure best.
my questions
- of options above, serve best, or other?
- should have shared user dataset across 2 applications or should users have register again?
- no matter of choice think best, how would/should implement zend? brief needed no need code.
i hope enough information give me best answer, if more information need, please let me know.
thanks!
why have multiple databases? use 1 database , prefix tables differ 2 applications. example:
users
app1_otherdata
app2_otherdata
this way users' data accessible both apps , still have relatively independent database structures.
Comments
Post a Comment