I have two separate databases both have a users table.
I need to create a separate database with the users table and then share this users table to the two other databases (so that the user data is shared across websites).
I could create a view into the two tables but all the code updates the "users" table not "db3.users" so only the view would be updated.
I could use federated but I don't want to have to mirror the structure (it should essentially symlink the db3.users table) plus the db's are running on the same server.
Not sure which is best.
Snoops
I need to create a separate database with the users table and then share this users table to the two other databases (so that the user data is shared across websites).
I could create a view into the two tables but all the code updates the "users" table not "db3.users" so only the view would be updated.
I could use federated but I don't want to have to mirror the structure (it should essentially symlink the db3.users table) plus the db's are running on the same server.
Not sure which is best.
Snoops
