MySQL Forums
Forum List  »  Federated Storage Engine

Does federated engine allows table creation for ipv6 ?
Posted by: tarun gupta
Date: July 05, 2019 02:33PM

I have two server both connected to each other by ipv6.

1 can i create table on local server with ipv6 connection of remote server

What i have tried

1 i created a table on remote server which is on ipv6

2 i created a table on local server which is on ipv6 with connection details of
remote server as mentioned below :

This is how i created my local table

CREATE TABLE usageinfo
username VARCHAR(200) NULL,
controllerId VARCHAR(200) NULL,
slotId VARCHAR(200) NULL,
startdate DATE NULL,
starttime TIME NULL,
enddate DATE NULL,
endtime TIME NULL

table created successfully.

After i perform select query got the below error :

ERROR 1429 (HY000): Unable to connect to foreign data source: Can't connect to MySQL server on '2222'

I believe ipv6 format that i have specified while creating table is incorrect.

can some one help me with the correct ipv6 format.

or let me know if ipv6 is not supported for federated engine.

Options: ReplyQuote

Written By
Does federated engine allows table creation for ipv6 ?
July 05, 2019 02:33PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.