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;

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.