SHARE PERFORMANCE ACROSS 2 SERVERS
Good morning in very l 'équipe of monty , sorry for my english, i am french.
To ameliorate a problem of performance d 'une database. That this has 200 tables, therefore 2 very very hard soliciting. What for consequences l 'effet with dominoes.
J 'explique if I solicit the performance of these from 198 small tables is good. But if all at once I solicit 2 big tables of numerous times, the solicitation of the 198 small tables becomes slow.
I look for, a solution like
SET @SERVER1='root@mypassword/192.0.1.128:3306'; SET @SERVER2='root2@mypasswordx/192.0.1.129:3306';
SELECT T1,T2 FROM SERVER1.DATABASE.ARTICLE , SERVER2.DATABASE.TAX WERE SERVER1.DATABASE.ARTICLE.S1KEYUNIK=SERVER2.DATABASE.TAX.S1KEYUNIK;