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
• Status: Verified
• Category: MySQL Server: Federated storage engine
• Severity: S4 (Feature request)
• OS: Any
• 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?