Mysql joins whith databases across servers

Question

I have tried cross DB joins it works fine. We are planning to move DB's to 2 different servers because of load. How do i write my code in codeigniter, so that joins work across server join.

score 0 · Answer 1 · edited May 23 '17 at 12:20

0

You gotta use sp_addlinkedserver for creating links across servers. I guess what you need can be found here.

edited May 23 '17 at 12:20

Community

1
1

answered Feb 13 '14 at 06:07

M Reza Saberi

7,134
9
47
76

Mysql joins whith databases across servers

1 Answers1