Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Questions tagged [federated-table]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
41 views

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 ...
MadHatter's user avatar
  • 101
2 votes
0 answers
34 views

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 &...
Bowi's user avatar
  • 121
0 votes
2 answers
194 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 ...
RJS's user avatar
  • 101
0 votes
1 answer
356 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 ...
shadow_walker's user avatar
0 votes
1 answer
579 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 ...
kainaw's user avatar
  • 1,362
1 vote
1 answer
2k views

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 ...
Apeksha's user avatar
  • 11
0 votes
0 answers
45 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 ...
Driggs Alonzo's user avatar
0 votes
1 answer
27 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 ...
Chechy Levas's user avatar
1 vote
1 answer
2k 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 ...
alex8275's user avatar
0 votes
1 answer
919 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 ...
sijan bhattarai's user avatar
1 vote
2 answers
591 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?
Alberto Alegria's user avatar
1 vote
0 answers
59 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 ...
ABeard89's user avatar
  • 111
3 votes
1 answer
2k 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 ...
ouunp's user avatar
  • 33
1 vote
1 answer
529 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 ...
shivrajk's user avatar
3 votes
1 answer
2k 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 ...
tylerdurden's user avatar
2 votes
2 answers
9k 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....
GeoVIP's user avatar
  • 263
5 votes
2 answers
3k 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. ...
jila's user avatar
  • 53