Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have task to implement particular database structure:

Multiple mysql servers with data using the same schema. Each server can see and edit only his particular part of data.

And

One master server with his own data that can run queries using data from all previously mentioned servers, but cannot edit them.

Example would be multiple hospitals with data of their patients and master server that can use combined data from all hospitals.

Previous system was written using mysql cluster, so i tried it naturally. I can create mysql cluster with multiple nodes and maybe even partition data so i can have particular set of data in particular node, but as far as i know i can't connect to single node using mysql, because it is already connected to cluster.

Can it be done with mysql cluster? Is there other framework that can do that easily?

share|improve this question

migrated from serverfault.com May 21 at 3:08

This question came from our site for professional system and network administrators.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.