Questions tagged [federated-table]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
12 views

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 ...
0
votes
0answers
17 views

Mysql 8. Event call Stored Procedure with Transaction to Federated tables never finish ESTABLISHED connection until timeout

We have a Mysql server which connect to remote Mysql Federated tables and copy data to local tables. For several databases it works fine, but the new one did not close connection after Transaction ...
0
votes
0answers
22 views

using Federated tables for different data sources

We are planning to create a standalone MySQL server specifically for Federated tables that points to 4 DB instances. Sample table: federated_db1_users federated_db1_transactions federated_db2_users ...
0
votes
1answer
22 views

How can I have intensive stored procedures run on a different machine to where tables are stored?

For a home air quality monitoring project I am building, I am collecting sensor readings and storing them on my Synology server, which includes a MariaDB instance. The Synology is great for managing ...
1
vote
1answer
665 views

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 ...
0
votes
1answer
288 views

Use federated table to sync only selected columns

Scenario: I need to sync a table in a remote server with the table in my production server. The problem being that the table structures are not same. I have looked into the concepts of federated ...
1
vote
2answers
102 views

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?
1
vote
0answers
40 views

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 ...
3
votes
1answer
836 views

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 ...
1
vote
1answer
229 views

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 ...
2
votes
1answer
884 views

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 ...
2
votes
2answers
6k views

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....
5
votes
2answers
2k views

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. ...