Re: Master-master replication configuration...how?

[blue . trapezius]

Hi Craig and others,

On Fri, Mar 27, 2009 at 4:16 PM, Craig Dunn li...@codenation.net wrote:

 blue.trapez...@gmail.com wrote:

 Hi

 I have 2 servers and I am trying to set up (for testing purposes) a
 master-master replication environment. I read the instructions in the
 manual
 for master-slave, but am not able to find any information on how to set up
 a
 master-master system. Can someone on this list point me to any
 documentation
 on this topic?


 What you are probably trying to achieve is bi-directional replication
 (arguably different from multi master but as close as you can get) - take a
 look at auto_increment_increment and auto_increment_offset, the idea is that
 all your primary keys use auto_increment integers and one master will be
 offset from the other (ie: server A uses 1,3,5,7,9...etc and server B uses
 2,4,6,8...etc) so they never clash


I am new to replication so please bear with me. What is the difference
between 'multi-master'/'dual-master' and 'bi-directional replication'? I was
under  the impression they meant the same thing...

Thanks.

Master-master replication configuration...how?

[blue . trapezius]

Hi

I have 2 servers and I am trying to set up (for testing purposes) a
master-master replication environment. I read the instructions in the manual
for master-slave, but am not able to find any information on how to set up a
master-master system. Can someone on this list point me to any documentation
on this topic?

Also, I am new to replication. Could someone briefly tell me typical
problems with this kind of setup, or why it is/is not advisable?

TIA -- V

Updatable view using subquery??

[blue . trapezius]

Hi

I am able to create an updatable view using a subquery in MySQL 5.1.29

mysql CREATE VIEW v_aa AS
-   SELECT *
-   FROM flight AS f
-   WHERE f.RouteID IN
- (SELECT r.RouteID
- FROM route AS r
- WHERE r.To=
-   (SELECT a.AirportID
-   FROM airport AS a
-   WHERE a.AirportCode='SIN')
- )
-   ORDER BY FlightID DESC;
Query OK, 0 rows affected (0.02 sec)

mysql insert into v_aa
- values (1,1141,3145);
Query OK, 1 row affected (0.00 sec)

But according to the MySQL manual, a view is not updatable if it contains
any of the following:...subquery in the select list. I am quite confused by
this. Can someone help me understand the details of this?

TIA