Questions tagged [federated-table]
18 questions
5
votes
2 answers
Federated tables and triggers
This is the scenario.
Have two MySQL servers (S1, S2) on different machines, with a database on each (DB1, DB2).
I have a table (T2) on DB2 that needs to "fetch" rows from another table (T1) on DB1.
I have created a temporary table (base on DB1 and…
jila
- 53
- 1
- 3
3
votes
1 answer
Cannot create Federated View
For the first time ever could not find a solution on internet!
The problem is when I'm trying to (on local server):
CREATE TABLE `DB_1`.`testView`
ENGINE=FEDERATED CONNECTION='remote_server';
I'm getting an error:
#1939 - Engine FEDERATED failed…
ouunp
- 33
- 5
3
votes
1 answer
mysql trigger on a federated table
I have two MySQL(5.6) databases D1 and D2 on two different machines.
There is a table T1 on D1 and there are two tables T2A and T2B on D2.
I want to update T2B whenever T1 is updated.
T2A is a federated table and T1 is base table of it.
There is an…
tylerdurden
- 131
- 5
2
votes
2 answers
SELECT in federated table is to slow
When i test select * from myFederatedTable (for test there is 50k rows) it take 0.3732 seconds
now I have two federated tables with data < 20000 in both tables, and have query like :
SELECT i.id_news, i.id_news_type, i.id_agency, i.add_date,…
GeoVIP
- 263
- 5
- 14
2
votes
0 answers
Why does INSERTing to a federatedx table fail silently?
For testing, I've set up a XAMPP portable 8.1.12 with 10.4.27-MariaDB and enabled the FederatedX engine using this trick.
When I now set up a SERVER that is not existing and a federated table that is "using" that server, running a SELECT against…
Bowi
- 121
- 3
1
vote
1 answer
How to define federated access from IBM Db2 database to another IBM Db2 database without password?
On IBM Db2 v11.5.8.0 on Linux x86_64 I have two local databases DB01 and DB02. Both databases individually are configured to use LDAP authentication.
Now I am required to setup a federated access from DB01 to DB02.
Looking at CREATE SERVER and…
folow
- 523
- 1
- 6
- 25
1
vote
1 answer
How to access Multiple DB2 Relational Databases In A Single Query
I am looking for a solution to the problem described below.
There are two DB2 instances with two authorization IDs on the same server and can be accessed using the same user User1.
Example:
To access Inst1DB, I use the following commands:
[User1 ~]$…
Apeksha
- 11
- 1
- 5
1
vote
1 answer
Can't create federated table in MariaDB using CREATE SERVER - 'Foreign data src error'
I'm using MaraiaDB 5.5.44 on Centos 7.2.
I've used federated tables before across physical servers ... I found the 'CREATE SERVER' mechanism a bit flaky (I could only manage to link tables of the same name) but it worked. In this case I want to set…
alex8275
- 11
- 4
1
vote
2 answers
Create a query with multiple databases
Let say I have DB1, a database in PostgreSQL, and DB2, a database in Oracle.
How can I make a query joining these databases?
Is this even possible?
Alberto Alegria
- 111
- 3
1
vote
0 answers
Table sync without admin rights
I have a client that really (really, REALLY!) wants to use a standard database server through a specific hosting company. That company offers vanilla installs of PostgreSQl and MySQL only.
The client has several running instances of web application…
ABeard89
- 111
- 1
1
vote
1 answer
How to achieve federation using JDBC?
I want to achieve federation using following commands through JDBC.
connect to SIGCAP_M user db2sigcp using db2sigcp ;
drop wrapper drda;
create wrapper drda ;
UNCATALOG NODE XYZ;
CATALOG TCPIP NODE XYZ REMOTE 10.XXX.XX.XX SERVER 446 ostype…
shivrajk
- 73
- 7
0
votes
1 answer
MySQL Drop Federated Table When Remote Server is Down
We have a production database (MySQL 8.0) that has a federated table in it. The remote server had an IP address update, and whenever a client opens this DB, it takes forever (~5 minutes) since table information can not be retrieved... Our fix is to…
MadHatter
- 101
- 1
0
votes
2 answers
mysql 5.6 FEDERATED table and mysql.servers correlation
I have no expirence with FEDERATED tables in MySQL. I have database with FEDERATED tables defined and I'm wonder if this tables are used in current env (I have no access to application/developers to ask/check).
The mysql.servers table…
RJS
- 101
0
votes
1 answer
MySql Federated table and changes propagation
i have 10 mysql servers and one central mysql server that's keeping track of some numerical indexes. Idea is that each time one of those 10 servers request and id, that id is marked as used and no other server can use it. For that reason i have…
0
votes
1 answer
AWS RDS Mariadb Federated/Connect
I believe this is a firewall rule problem. Therefore, I believe that the issue is finding out what the public IP address of the RDS is. I don't see that anywhere on the RDS interface.
I have two AWS RDS MariaDB databases. I can connect to both…
kainaw
- 1,404
- 3
- 15
- 26