Is it possible to migrate to Plesk where MySQL server is shared with another Plesk server?
The described scenario is not supported by Plesk.
It implies a high probability of unexpected collisions and stability would be at risk in such a case.
It is best to keep customers' databases of one Plesk server separate from other Plesk servers.
Consider Plesk Multi Server option if centralization of management is required.