I will use eight wordpress websites and i need to sync ther wp-user tables so each single user can connect through all websites. All of these will be on the same server, using the same MySQL user, but they will each have their own database. The server will be a mutualised one, so i cannot install any other software that MySQL.
What i thought of doing was this :
- create a master table which will collect recursively all other tables.
- When it's finished, it is supposed to have every information of the other up to date... Isn't it ?
- Then i would sync all previous databases on this master one.
What do you think about it ? But i don't know how to do that. I thought of using CRON to run that once a day, but i don't know anything about how to write MySQL scripts, and didn't understand much about the "MySQL Replication" topics i found until now...
Thank you in advance.
EDIT : Michael - sqlbot suggested using the "merge algorithm" to do what i need. I like what it looks like, but did not succeed using it. Maybe because I run MariaDB on Localhost. What do you thnik, and n=know about this solution ?