Stack Overflow
Stack Overflow

Questions tagged [federated-table]

43 questions
1
vote
1 answer

Is there a way to create a linked "database" in mariadb?

I was doing this process in a same server but different databases. Insert data into a table in dev database Check the data If the data is fine, insert into a same table in prd database but now I separated those databases into different servers.…
체라치에
  • 173
  • 1
  • 16
1
vote
0 answers

MySQL Federated table contains subset of data

I've created a Federated table with MySQL and I've found that the local table that results only contain a subset of the data of the remote one. This is the Federated: CREATE TABLE `Activities` ( `idActivity` int(10) unsigned NOT NULL…
ShakMR
  • 115
  • 2
  • 10
1
vote
1 answer

mysqldump with federated tables

I need mysqldump including the data, but in database there are also couple of tables with FEDERATED engine. The mysqldump includes INSERTs for FEDERATED tables too, what makes for exemaple "Duplicate entry" errors (because the table is already…
user36666
  • 11
  • 2
1
vote
1 answer

How to connect Db2 Federated Views with Hibernate 4?

Can anyone please suggest or help how can we have Hibernate mapping with Federated Views in Db2 Database? Database_1 : TABLENAME001 Database_2 : FV_XXX_TABLENAME [FV is federated view with Database_1 table TABLENAME001] Now when I run through…
Gaurav
  • 11
  • 3
1
vote
2 answers

How do I keep 2 scratch Databases in sync

My question is a lot like this one. However I'm on MySQL and I'm looking for the "lowest tech" solution that I can find. The situation is that I have 2 databases that should have the same data in them but they are updated primarily when they are…
BCS
  • 75,627
  • 68
  • 187
  • 294
1
vote
1 answer

MySQL join with federated view not working

I want to join a table with a view, where one table L is local, whereas the view F is a FEDERATED view residing on another server: SELECT * FROM L LEFT JOIN F ON L.id = F.id; Now the JOIN results in no hits despite the fact that there actually are…
Gruber
  • 4,478
  • 6
  • 47
  • 74
1
vote
1 answer

How to setup Replication or Federation between MySQL and Derby?

Perhaps this is not possible yet, but... What's the easiest way to setup Replication or Federation between MySQL and Derby? I need a way for data updates/inserts/deletes into a certain table in Derby to automatically flow into an equivalent…
Alex R
  • 11,364
  • 15
  • 100
  • 180
1
vote
1 answer

Primary Key patterns for federated (horizontally partitioned) databases

I apologize in advance if this is a duplicate, I'm not sure exactly what I should be searching for. Recently I watched this nifty video on Channel 9 about database federation in SQL Azure. At first I was surprised by the fact that identity columns…
danludwig
  • 46,965
  • 25
  • 159
  • 237
0
votes
0 answers

ERROR 1160 (08S01) at line 1: Got an error writing communication packet federated

On one of our mysql servers we have a federated table populated by a query on another server. SELECT queries on this table randomly give this error : ERROR 1160 (08S01) at line 1: Got an error writing communication packet Usually it happens once…
Processor
  • 304
  • 1
  • 3
  • 14
0
votes
0 answers

Continue handler for operation with federated table does not work

In my MySQL database on my PC, I have a table that is on another MySQL server in reality, seen from my local MySQL as a federated table. I access that table in a stored procedure. Since "another MySQL server" can always just be unreachable, I want…
Bowi
  • 1,378
  • 19
  • 33
0
votes
1 answer

Could federated table impact on database performance?

I have some questions before implement the following scenario: I have the Database A (it contains multiple tables with lots of data, and is being queried by multiple clients) this database contains a users table, which I need to create some…
Mauricio Bernardes
  • 1
0
votes
0 answers

MySQL Federated Table. No data returned to remote database

I can generate federated tables from an opencart database to my local database without issue. However, one particular table (option_descriptions) returns no data to its federated (local) table despite there being data in the source table. I thought…
Ben Stevens
  • 26
  • 2
0
votes
2 answers

How to check (fast) if a federated table is connected?

I have 5 federated tables. Each table is connected to another database. Now I do some stuff in a loop and the first thing I do in the loop is some stuff with the federated table. Because the database to which the federated table is linked is not…
WG-
  • 1,046
  • 2
  • 14
  • 27
0
votes
2 answers

How to read every file in a Google Storage bucket from BigQuery and create one table for each file in the bucket?

I have a bucket that has 28 files and I would like to load them in different tables (one table per file in the bucket). Each file in the bucket looks like this: file_1_2020.csv file_2_2020.csv .. file_28_2020.csv I would like that the table had the…
Pedro Pablo Severin Honorato
  • 377
  • 3
  • 16
0
votes
1 answer

How to make federated tables persistent between restarts on MariaDB?

I'm moving from MySql to MariaDB and I have several databases using federated tables. Everything works fine in the MariaDB but when the server restarts, all federated tables stop working as if the remote server's entry doesn't exists on the local…
Enrico Dias
  • 1,417
  • 9
  • 21
1
2
3