I want to make one master DB which replicates specific user data into other databases such as:
- pass (hashed)
- pin (hashed)
- timezone (int)
They are all in one table and running on MySQL 5.5.37 (possible to update to 5.6).
The reason I want to do this is because I have multiple sites using different databases and they all have different logins. Once I get this done I can enable SSO across them and save more than 50 % of the users a big hassle to not signup more that once on the different sites.
Where should I start? Is there any good info to read? I've been looking in the MySQL help files but could not find any info on how to do this for specific rows.