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
(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(200) NULL,
controllerId VARCHAR(200) NULL,
slotId VARCHAR(200) NULL,
startdate DATE NULL,
starttime TIME NULL,
enddate DATE NULL,
endtime TIME NULL
)ENGINE=FEDERATED
CONNECTION='mysql://username:password@2222:2222:2:240a::10/dbName/usageinfo';

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


Subject
Views
Written By
Posted
Does federated engine allows table creation for ipv6 ?
1758
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.