Questions tagged [federated-table]
The federated-table tag has no summary.
19 questions
1 vote
1 answer
67 views
How to change password for federated access between two IBM Db2 databases?
On single IBM Db2 v11.5 database server we have two databases connected with federated system. On source database there are federated definitions: CREATE WRAPPER DRDA; CREATE SERVER myserver TYPE DB2/...
- 540
1 vote
1 answer
157 views
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 ...
- 540
0 votes
1 answer
157 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 ...
- 101
2 votes
0 answers
52 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 &...
- 121
0 votes
2 answers
237 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 ...
- 101
0 votes
1 answer
426 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
1 answer
752 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 ...
- 1,404
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 ...
- 11
0 votes
0 answers
57 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
1 answer
34 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 ...
- 115
1 vote
1 answer
3k 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 ...
- 11
0 votes
1 answer
1k 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
2 answers
707 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?
- 111
1 vote
0 answers
79 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 ...
- 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 ...
- 33