Bug #68855 When does SYNONYMS and DBLINKS will be available in MySQL
Submitted: 3 Apr 2013 9:56 Modified: 17 Jul 2015 14:53
Reporter: vangala pradeep Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Federated storage engine Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[3 Apr 2013 9:56] vangala pradeep
Description:
We planned to have our products compatible on both Oracle and MySQL, we are facing issues due to absent of few features in MySQL, mainly SYNONYMS and DBLINKS. Let us know when will SYNONYMS and DBLINKS will be available in MySQL.

How to repeat:
Its not a bug its a feature
[17 Jul 2015 14:53] Georgi Kodinov
Thank you for your reasonable feature request.
[17 Jul 2015 15:17] Daniƫl van Eeden
There is synonyms support in SYS (Included in 5.7, can be installed on 5.6)

mysql-5.7.8-rc [(none)] > CALL sys.create_synonym_db('test','testsyn');
+-----------------------------------------+
| summary                                 |
+-----------------------------------------+
| Created 9 views in the testsyn database |
+-----------------------------------------+
1 row in set (0.06 sec)

Query OK, 0 rows affected (0.06 sec)

mysql-5.7.8-rc [(none)] > SELECT * FROM test.foo7;
+-------+
| id    |
+-------+
|     1 |
|   100 |
| 10000 |
+-------+
3 rows in set (0.00 sec)

mysql-5.7.8-rc [(none)] > SELECT * FROM testsyn.foo7;
+-------+
| id    |
+-------+
|     1 |
|   100 |
| 10000 |
+-------+
3 rows in set (0.00 sec)

And the Federated storage engine is comparable with dblinks.

Is there anything needed besides this?