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

2009-03-29 Thread blue . trapezius
Hi Craig and others, On Fri, Mar 27, 2009 at 4:16 PM, Craig Dunn 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

Master-master replication configuration...how?

2009-03-27 Thread 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 documentat

Updatable view using subquery??

2009-02-09 Thread 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 ->