Bug #1057 Add database links feature
Submitted: 15 Aug 2003 18:03 Modified: 22 Jun 2015 12:44
Reporter: Simon Windsor Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Options Severity:S4 (Feature request)
Version: OS:Any
Assigned to: Assigned Account CPU Architecture:Any

[15 Aug 2003 18:03] Simon Windsor 
Description:
For release 5.0

Could you consider adding a dblinks option within the MySQL table to allow
other MySQL servers to be accessed within queries.

For example

create database link <dbaselink1> for <host>.<db> connect as <user>
identified by <pwd>;

select db1.col1 from dbaselink1.table db1;

How to repeat:
Not applicable

Suggested fix:
Not applicable
[18 Aug 2003 9:46] Indrek Siitan 
Re-classified this as a feature request.
[21 Aug 2003 10:19] Peter Zaitsev 
Dear Simon,

We have this feature in our ToDo list, however it is not yet scheduled for implementation. 

It is not that simple to implement as it might look from the glance look.
[13 Dec 2003 11:50] Biju GC 
What about a simple one, like the one in MS-Access which can connect to any ODBC.
I have even used this feature of MS-Access to do a sub queries against MySQL database.
[30 Dec 2008 23:32] Pankaj Jain 
Is this feature will be available in future releases of MySQL. DB link in oracle is cool feature and much needed for MySQL dbs :).
[6 Nov 2009 14:18] Martin Hynek 
Can i ask when will be this future implented?
[27 Oct 2011 6:51] Darin Georgiev 
Hi,

Is it ready or is it planned?
BR
Darin
[24 Mar 2015 5:34] Ananda Raju 
Hi, Any updates on DBLinks in MY Sql.

Any alternate solution for DBLinks.

Regards,
Anand.
[25 Jul 2022 8:04] Mohsin Ali 
Hi Team;

We are working on MySQL Archving/Purging of big tables, for this we need Db_Link to copy data from remote server to local server.
[26 Jul 2022 5:12] Said Salim 
Oracle development needs to consider this in the coming updates.