Stack Overflow
Stack Overflow

Questions tagged [federated-storage-engine]

The FEDERATED storage engine is used to access data in tables of remote databases instead of in local tables.

The FEDERATED storage engine is used to access data in tables of remote databases instead of in local tables.

When using a table with the FEDERATED storage engine, queries which are done on the local server are automatically executed on the remote tables, while no data is stored on the local tables.

Federated storage engine is available since MySQL version 5.0.3.

28 questions
43
votes
4 answers

How can I enable the federated engine in mysql after installation?

I have mysql 5.1.44: mysql> show engines; +------------+---------+ | Engine | Support | +------------+---------+ | ndbcluster | NO | | MRG_MYISAM | YES | | BLACKHOLE | YES | | CSV | YES | | MEMORY | YES |…
Alaa
  • 4,471
  • 11
  • 50
  • 67
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
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

MySQL Federated storage engine vs replication (performance)

Long story short - I am dealing with a largish database where basic user details (userid (index), username, password, parent user, status) are stored in one database and extended user details (same userid (index), full name, address etc. etc.) are…
Ben Holness
  • 2,457
  • 3
  • 28
  • 49
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 getGroups() in keycloak using UserFederatedStorageProvider

I have created a User storage provider that connects with keycloak with an external DB and gets the Users & other related details successfully. In the same way, I am trying to get the groups associated with a particular user from external storage to…
Kiriti Velivela
  • 21
  • 3
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
2 answers

How to check if Federation is enabled

I want to know what the command is that I can run in the shell to find out if Federation is enabled on a MySQL server or not? Thanks.
MRQ
  • 41
  • 1
  • 2
  • 4
2
votes
0 answers

Enable Federated Storage Engine in Cloud SQL

How to enable Federated Storage engine/create federated tables in Google cloud sql? I have already gone through the following post but i didnt really understand the solution. How do I create a Federated Table in Google Cloud SQL Can someone give…
Manojit Dan
  • 21
  • 3
1
vote
0 answers

Getting federated table connection information

I have a number of federated tables on my MySQL 5.7.23 and MariaDB 10.1 servers (I was using CREATE SERVER syntax if this matter). I can easily get a list of these tables using query: SELECT * FROM `information_schema`.`TABLES` WHERE `ENGINE` =…
fifonik
  • 1,556
  • 1
  • 10
  • 18
1
vote
1 answer

Is there a deeper reason that MySql does not offer creating federated tables w/o field definition?

pre: my question is not how to generate this tables. I just wonder, if there is a deeper reason that MySql does not offer a statement like this CREATE TABLE my_fed_db.foobartab clone ENGINE=FEDERATED CONNECTION='my_remote[/localname]'; so all…
halfbit
  • 3,773
  • 2
  • 34
  • 47
1
vote
0 answers

MySQL CONTINUE, EXIT handlers not detecting network error codes and sqlstates.

Using MySQL version: 5.7.20-0ubuntu0.16.04.1 Hi I have written a small procedure: CREATE PROCEDURE fed_insert (INOUT last_user_id varchar(30), OUT success boolean) BEGIN DECLARE v_user_id varchar(30) default null; DECLARE v_count_stock_wl int…
eytnihca
  • 23
  • 3
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
0
votes
1 answer

Unable to connect remote server on ipv6 using federated engine mysql

How can we connect to the remote mysql server which has ipv6 address using one of the federated engine mysql table on different ipv6 server. if yes i wanted to know the format. CREATE TABLE usageinfo ( id INT NOT NULL AUTO_INCREMENT PRIMARY…
Tarun gupta
  • 51
  • 1
  • 8
1
2