Re: How is a federated table treated by replication?

[Andrea Cerrito]

I tested federated engine in a replicated env, and all insert statement are done N times for each slave.

In my test env, I have a double replica situation, and this is the result:

mysql> describe federated_table;
+-------+-------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+----------------+
| id | int(20) | NO | PRI | NULL | auto_increment |
| name | varchar(32) | NO | MUL | | |
| other | int(20) | NO | MUL | 0 | |
+-------+-------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)

mysql> INSERT INTO `federated`.`federated_table` (`id` , `name` , `other`
) VALUES (NULL , 'pippo', '5253');

mysql> select * from federated_table;
+----+----------------+-------+
| id | name | other |
+----+----------------+-------+
| 1 | pippo | 5253 |
| 2 | pippo | 5253 |
+----+----------------+-------+
2 rows in set (0.00 sec)

It's ok to exclude the table from the replica, but it's not what I want. Any clue?

Andrea Cerrito