Stack Overflow
Stack Overflow

Questions tagged [federated-table]

43 questions
9
votes
1 answer

Is is possible to create a FEDERATED on VIEW for mysql

How can I create a FEDERATED on VIEW which placed on remote server? I'm using MySQL.
Tioma
  • 2,120
  • 9
  • 35
  • 52
6
votes
1 answer

Does PHP script need to wait for MySql trigger to complete?

Database is MySQL. I am looking to implement a trigger that updates an aggregate rating table whenever a new rating is placed. Then there are some other similar use cases where I'm looking to implement triggers. These triggers may be updating…
jeff musk
  • 1,032
  • 1
  • 10
  • 31
3
votes
1 answer

How to create a federated table in MariaDB without specifying columns

I am trying to use the Federated engine of MariaDB 10.1.12 to create tables that are based on tables in a remote database. Following the MariaDB instructions about how to use the FederatedX implementation, in database db1 I create a table as CREATE…
Martin Dirichs
  • 113
  • 1
  • 11
3
votes
1 answer

mysql create federated all table in database or federated database

I want to federated all tables from database or federated database. Can I do that in mysql? The thing is, I have mysql events at night in server A but for some reason that events weren't finished yet in the morning (It should finished). So, to make…
Agata
  • 67
  • 1
  • 1
  • 7
3
votes
1 answer

mySql federated table unable to update blob columns

I have a federated table on mySQL dbForge 6.0.265 which I created like this: USE my_db; CREATE TABLE my_db.federated_tbl_resources ( Id int(11) NOT NULL AUTO_INCREMENT, resourceType varchar(255) NOT NULL, cultureCode varchar(10) NOT NULL, …
Nick
  • 2,877
  • 2
  • 33
  • 62
3
votes
2 answers

Proper syntax for MySQL 5.0.x FEDERATED table creation?

So I'm trying to create a federated table using the syntax from the docs. Following this, I've created a table like so: CREATE TABLE `federated_table` ( `table_uid` int(10) unsigned not null auto_increment, ..., PRIMARY KEY (`table_uid`) )…
Aurelia Peters
  • 2,169
  • 1
  • 20
  • 34
2
votes
0 answers

Multi column joins and Federated Tables

I am having a problem with getting information from two tables in our databases. Table A is a federated table from our accounts server which works perfectly well if queried on its own. It has no unique ID field, but Job and Code fields are…
Dan Kelly
  • 2,634
  • 5
  • 41
  • 61
2
votes
1 answer

how to take dump of mysql for federated table?

now iam using mysql version 5.0.45.and the problm is,i want to take a dump of database. and it contains federated tables also. wen i am taking dump , it is showing an error "ERROR 1031 (HY000): Table storage engine for 'employee_details' doesn't…
ajay
  • 21
  • 2
2
votes
2 answers

Postgresql analog to mysql federated table storage engine

Between DBLink in postgresql (http://www.postgresql.org/docs/current/static/dblink.html) and foreign data wrappers (http://www.postgresql.org/docs/9.1/static/ddl-foreign-data.html), which one (if any) provides the same level of functionality as…
archmeta
  • 1,107
  • 4
  • 17
  • 29
2
votes
0 answers

A problem about federated tables in different clusters

I have a Mysql server(node A) in galera cluster 1 and a Mysql server (node B) in galera cluster 2. Node A and node B are indifferent cluster so they have completely different write nodes. I'm trying to join tables in node A with those tables in node…
Shuetsu Haduki
  • 21
  • 1
2
votes
1 answer

Accessing data with FEDERATED error #1429

I am currently trying to establish a connection from one database to another on the same hostname(mysql.stud.ntnu.no) with FEDERATED, however, when the table is created(no problem), I get this errorcode beneath: #1429 - Unable to connect to foreign…
Stian Krey
  • 21
  • 1
  • 2
2
votes
1 answer

BigQuery Java client - how to query external ( federated ) table?

I am using the new google-cloud-bigquery and google-cloud-storage api. I want to query an external table, which I created like this: ExternalTableDefinition etd = ExternalTableDefinition.newBuilder(bucketPath, schema,…
Daniella
  • 383
  • 1
  • 4
  • 12
2
votes
1 answer

Show federated connections stored in MySQL database

I am feeling little bit stupid about this topic so I have to ask. I am using Federated engine to be able to retrieve data from another database via CREATE SERVER instead of using CONNECTION Works like a charm but... how can I retrieve the servers I…
Dan Delay
  • 102
  • 2
  • 12
2
votes
2 answers

SQL Azure - Determine which tables are federated

I'm new to SQL Azure and in the early stages of developing an application, so my schema is changing frequently. I started out by creating the root database and executing queries against it like these CREATE TABLE [dbo].[Clients] ( [ClientId] …
Jorin
  • 1,652
  • 1
  • 19
  • 25
2
votes
1 answer

SQL Azure Federation Splitting Design and Querying

I have a few questions regarding Microsoft SQL Azure Federations: 1) Can I created a federated DB on an active Database or do I need to deploy federations ahead of time? 2) Do I need to make any changes to the SQL queries to comply with how I query…
Liron Harel
  • 10,819
  • 26
  • 118
  • 217
1
2 3