right, of course ;-) (i neglected the join part) so, now i know exactly whom to ask ;-)
i have the following bother (it's in the planning state): i have the idea of setting up a two-way replication system with 2 mysql servers for my radius database. i need them to act interchangeably: 1. if server1 is alive, all selects and updates (radius acct) should go to server1. server2 should act as a slave for server1. 2. if server1 dies, all selects and updates (radius acct) should go to server2. so far, so good. but here comes the tricky (for me) part - when server1 comes up again, it shold do 2 things: a) catch up with server2. b) become master again, leaving server2 as it's slave (same situation as in 1. above). how could this happen ? all ideas are appreciated (pointing to reading - also). kosio ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, 14 March, 2002 14:38 Subject: Re: a quick sanity check... : Konstantin, : Thursday, March 14, 2002, 1:04:42 PM, you wrote: : : KT> : d>> SELECT users.* : KT> : d>> FROM users : KT> : d>> LEFT JOIN subscriptions : KT> : d>> ON users.userID=subscriptions.userID : KT> : d>> WHERE subscriptions.userID IS NULL : : : Take a closer look at the manual: : http://www.mysql.com/doc/J/O/JOIN.html : : mysql> select users.userid from users left join subscriptions on users.userid=subscriptions.userid where subscriptions.userid is null; : +--------+ : | userid | : +--------+ : | egor | : | sasha | : +--------+ : 2 rows in set (0.00 sec) : : That's all. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
