Questions tagged [federated-table]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
18 views

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

Cannot delete from MariaDB federated table

In our web application, there are some federated tables which point to a remote server, it is used so that when writing log entries to the federated table they get actually stored on this remote ...
0
votes
1answer
25 views

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 ...
0
votes
0answers
43 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
27 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
24 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
890 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
344 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
171 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
41 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
938 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
263 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 ...
3
votes
1answer
1k 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. ...