Question : Scenario: I need to sync a table in a remote server with the table in my production server. […]
Tag: federated-table
Create a query with multiple databases
Question : Let say I have DB1, a database in PostgreSQL, and DB2, a database in Oracle. How can I […]
How can I have intensive stored procedures run on a different machine to where tables are stored?
Question : For a home air quality monitoring project I am building, I am collecting sensor readings and storing them […]
How can I have intensive stored procedures run on a different machine to where tables are stored?
Question : For a home air quality monitoring project I am building, I am collecting sensor readings and storing them […]
SELECT in federated table is to slow
Question : When i test select * from myFederatedTable (for test there is 50k rows) it take 0.3732 seconds now […]
Cannot create Federated View
Question : For the first time ever could not find a solution on internet! The problem is when I’m trying […]
Can’t create federated table in MariaDB using CREATE SERVER – ‘Foreign data src error’
Question : I’m using MaraiaDB 5.5.44 on Centos 7.2. I’ve used federated tables before across physical servers … I found […]