MySQL Forums
Forum List  »  Federated Storage Engine

Federated Table with failover
Posted by: Minto Mohan
Date: August 21, 2011 11:19PM

Is it possible to create a federated table with failover option ?
ie, whether there is a possibility to specify the master and failover server details while creating a federated table.

I have two remote master servers (with master-master replication)

Remote Master 1 : 192.168.1.1
Remote Master 2 : 192.168.1.2
Local Server : 192.168.1.3

If one master server is down, i will be able to connect to the other master.

I am tryting to create a federated table in the local server:

CREATE SERVER mymaster
FOREIGN DATA WRAPPER mysql
OPTIONS
(
HOST '192.168.1.1',
DATABASE 'masterdb',
USER 'myuser',
PASSWORD 'mypassword',
PORT 3306
);

CREATE TABLE `my_table`
(
my_column INT
) ENGINE=FEDERATED CONNECTION='mymaster';

In the above statement, the connection is created only to obe of the server in the master-master pair.

Is there any option to specify two servers while creating the server, or while creating the federated table ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Federated Table with failover
6124
August 21, 2011 11:19PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.