On Fri, May 11, 2001 at 01:23:00PM +0300, Kissandrakis S. George wrote:
>
> i installed replication between two mysql servers
>
> Now what?
Relax. Have a drink. Read a book. :-)
> is there any software which does insert,deletes,updates on the
> master and select on both machines or on slave('s) only?
>
> is there any recommended setup (virtual ips, NAT anything) that will
> do the above?
There are numerous approaches you can take, and they're not all
mutually-exclusive, either. Off the top of my head:
(1) Make sure that the software your write has some sort of database
access abstraction lay in it. Then, at this layer, you can make
decisions about where to send queries--to the slave(s), master,
etc. You can also decided when (if at all) to promote a slave to
a master.
(2) Using Linux Virtual Server (LVS), you could setup a Virtual IP
(VIP) for your slaves. Send all your read queries to the slaves
and let LVS "worry" about exactly which slave it goes to.
(3) Do nothing. If you don't significant load on the system, you may
not need to do anything other than plan for a failure on the
master.
Hope this helps a bit.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 130 days, processed 804,946,869 queries (71/sec. avg)
---------------------------------------------------------------------
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
