MySQL, MariaDB, InfiniDB on same server

[Peter Schmidt]

Hi experts,

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

Peter