how to – Connect multiple databases to one database table
I have created a feedback feature in my Rails application. We will be supplying this application to multiple businesses and host it through something like AWS. I would like to be able to have one central table that has feedback in it.
So for example we have these domains:
xxx.example.com yyy.example.com zzz.example.
I would like all feedback forms submitted on these domains to go to one central database on our company domain so I can view all the feedback in one location. In this case we will call it
admin.example.com. How can this be achieved with a MySQL backend?