[prev in list] [next in list] [prev in thread] [next in thread]
List: nyphp-talk
Subject: Re: [nyphp-talk] databases with PHP
From: Anthony Wlodarski <ant92083 () gmail ! com>
Date: 2009-05-08 15:44:26
Message-ID: 43bc541c0905080844ga0a659w41d6010f6ecad4a0 () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Yeah at my current company we are thinking of a master-slave implementation
and we can speed up the website by making read only requests head to the
slave server. When working with MySQL is there a stop gap to prevent
requesting data from the slave that is currently in transit from the master
server? (I guess a check to see if it is in transit and if so it has to wait
for the slave to be updated.)
-Anthony
On Fri, May 8, 2009 at 11:28 AM, Jerry B. Altzman <jbaltz@altzman.com>wrote:
> on 5/8/2009 10:17 AM Anthony Wlodarski said the following:
>
>> It can be a PITA sometimes. The typical usage is the master-slave
>> replication. Even with this type of replication there can be some data loss
>> too.
>>
>
> MySQL replication is great when it works.
> With 5.1 they've introduced row-level replication (as opposed to
> statement-level replication) which can help in many cases (where you're
> using MySQL to do heavy processing, like their internal GIS functions).
>
> MySQL replication can also fail silently in the presence of brief network
> disconnections.
>
> It's not REAL redundancy (like Oracle RAC) but you get what you pay for,
> and having a slave for backup purposes is handy.
>
> -Anthony
>>
>
> //jbaltz
> --
> jerry b. altzman jbaltz@altzman.com www.jbaltz.com
> thank you for contributing to the heat death of the universe.
>
> _______________________________________________
> New York PHP User Group Community Talk Mailing List
> http://lists.nyphp.org/mailman/listinfo/talk
>
> http://www.nyphp.org/show_participation.php
>
--
Anthony W.
ant92083@gmail.com
[Attachment #5 (text/html)]
Yeah at my current company we are thinking of a master-slave implementation and we \
can speed up the website by making read only requests head to the slave server. \
When working with MySQL is there a stop gap to prevent requesting data from the slave \
that is currently in transit from the master server? (I guess a check to see if it is \
in transit and if so it has to wait for the slave to be updated.)<br> \
<br>-Anthony<br><br><div class="gmail_quote">On Fri, May 8, 2009 at 11:28 AM, Jerry \
B. Altzman <span dir="ltr"><<a \
href="mailto:jbaltz@altzman.com">jbaltz@altzman.com</a>></span> \
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, \
204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> on 5/8/2009 10:17 AM Anthony \
Wlodarski said the following:<div class="im"><br> <blockquote class="gmail_quote" \
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; \
padding-left: 1ex;"> It can be a PITA sometimes. The typical usage is the \
master-slave replication. Even with this type of replication there can be some data \
loss too.<br> </blockquote>
<br></div>
MySQL replication is great when it works.<br>
With 5.1 they've introduced row-level replication (as opposed to statement-level \
replication) which can help in many cases (where you're using MySQL to do heavy \
processing, like their internal GIS functions).<br>
<br>
MySQL replication can also fail silently in the presence of brief network \
disconnections.<br> <br>
It's not REAL redundancy (like Oracle RAC) but you get what you pay for, and \
having a slave for backup purposes is handy.<br> <br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); \
margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
-Anthony<br>
</blockquote>
<br>
//jbaltz<br><font color="#888888">
-- <br>
jerry b. altzman <a href="mailto:jbaltz@altzman.com" \
target="_blank">jbaltz@altzman.com</a> <a href="http://www.jbaltz.com" \
target="_blank">www.jbaltz.com</a><br> thank you for contributing to the heat death \
of the universe.</font><div><div></div><div class="h5"><br> \
_______________________________________________<br> New York PHP User Group Community \
Talk Mailing List<br> <a href="http://lists.nyphp.org/mailman/listinfo/talk" \
target="_blank">http://lists.nyphp.org/mailman/listinfo/talk</a><br> <br>
<a href="http://www.nyphp.org/show_participation.php" \
target="_blank">http://www.nyphp.org/show_participation.php</a><br> \
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Anthony W.<br><a \
href="mailto:ant92083@gmail.com">ant92083@gmail.com</a><br>
_______________________________________________
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/show_participation.php
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic