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