But uncovered it beneficial by making new mysql consumer on remote mysql server ans then join. operate adhering to command on remote server: MySQL supports many storage engines to determine how details physically https://www.ralantech.com/mysql-dba-support-services/