I'm not sure if that was a problem or not. I am actually very interested in
the second part of my query regarding replication. An earlier post
mentioned that if I am using A -> B -> A replication behind a
load-balancer, that I may lose performance. I am only slightly concerned
with update performance, and am more concerned with select performance. I
believe that if the tables between the 2 systems can be kept syncronized
reliably, that I will can a performance increse for selects by using the
load-balancer. This is good because the majority of my apps do selects. I
want to know if an update to server A updates server B will server A ignore
the update when it comes in from server B?
Thanks,
Shon Stephens
At 01:44 PM 7/13/01 -0500, Gerald Clark wrote:
>I don't believe NFS locking is reliable enough to allow two
>servers to serve the same databases.
>
>Shon Stephens wrote:
>
>>I recently started experimenting with a way to setup MySQL to be
>>load-balanced. I installed 2 servers with MySQL, NFS mounted the
>>/mysql/var directory, then moved the grant tables to /mysql/grant, and
>>created a symbolic link from /mysql/var/mysql to /mysql/grant. This
>>appeared to work correctly, however, my tables soon began to show
>>corruptions, and sometimes when an insert was made, and then immediately
>>following a select statement was made against that data, it would not be
>>found. I figured this was due to memory cache not being flushed to disk
>>before the select statement. So the other server would have no record of
>>the data. I adjusted the server settings so that data was always written
>>to disk. This solved that problem 99.99% of the time. However, I was
>>wondering if perhaps the server doesn't always try and select from the
>>table on disk, but rather the table in memory. So that if server 1
>>inserts data into the table and writes it to disk, then server 2 selects
>>data but only from the table it has loaded into memory it won't be able
>>to select the new data?
>>Has anyone ever tried something like this?
>>Also, I want to try setting up replication such as A -> B -> A. I want to
>>be able to put both system behind a load-balancing switch. If an insert
>>is done on server A, then server B is updated, then server B sends an
>>update to server A, will server A know to ignore it since it originated
>>from server A?
>>Thanks,
>>Shon Stephens
>>
>>---------------------------------------------------------------------
>>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
>
>
>--
>Gerald L. Clark
>[EMAIL PROTECTED]
---------------------------------------------------------------------
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
