MySQL, MariaDB, InfiniDB on same server
I apologize upfront because I am a newbie to installation, maybe seasoned in db handling but when it comes to installing I click "Yes, let us hope it works"
Straight to the point: I need to join three dbs currently running on different servers in production into a dev environment on another server. It might be not nice but the CEO said so.
OS: Ubuntu 18.04.1 Rows processed daily: <1M No clobs, blobs or other performance issues
First: plain MySQL 5.7.31 Second: MariaDB 10.3.24 Third: InfiniDB, which I understand is another instance of MySQL 5.1.73 (At least 5.1.73 is the current version which should be kept if possible)
What do you think will be the best/easiest way to proceed?
Thanks a lot for any insights