http://simonwillison.net/2009-12-23T09:57:34+00:00Simon Willison2009-12-23T09:57:34+00:002009-12-23T09:57:34+00:00https://simonwillison.net/2009/Dec/23/postgresql/#atom-tag

<p><strong><a href="http://www.postgresql.org/about/news.1172">PostgreSQL 8.5alpha3 now available</a></strong></p> “Hot Standby, allowing read-only connections during recovery, provides a built-in master-slave replication solution.” Woohoo! <p>Tags: <a href="https://simonwillison.net/tags/hotstandby">hotstandby</a>, <a href="https://simonwillison.net/tags/masterslave">masterslave</a>, <a href="https://simonwillison.net/tags/postgresql">postgresql</a>, <a href="https://simonwillison.net/tags/replication">replication</a>, <a href="https://simonwillison.net/tags/scaling">scaling</a></p>

2009-09-09T23:06:33+00:002009-09-09T23:06:33+00:00https://simonwillison.net/2009/Sep/9/londiste/#atom-tag

<p><strong><a href="http://wiki.postgresql.org/wiki/Londiste_Tutorial">Londiste Tutorial</a></strong></p> Master/slave replication for PostgreSQL, developed and used by Skype. <p>Tags: <a href="https://simonwillison.net/tags/londiste">londiste</a>, <a href="https://simonwillison.net/tags/masterslave">masterslave</a>, <a href="https://simonwillison.net/tags/postgresql">postgresql</a>, <a href="https://simonwillison.net/tags/replication">replication</a>, <a href="https://simonwillison.net/tags/skype">skype</a></p>

2009-03-15T13:32:39+00:002009-03-15T13:32:39+00:00https://simonwillison.net/2009/Mar/15/redis/#atom-tag

<p><strong><a href="http://code.google.com/p/redis/">redis</a></strong></p> An in-memory scalable key/value store but with an important difference: this one lets you perform list and set operations against keys, opening up a whole new set of possibilities for application development. It’s very young but already supports persistence to disk and master-slave replication. <p><small></small>Via <a href="http://antirez.com/post/Redis-my-new-open-source-project.html">Salvatore Sanfilippo</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/keyvaluepairs">keyvaluepairs</a>, <a href="https://simonwillison.net/tags/masterslave">masterslave</a>, <a href="https://simonwillison.net/tags/redis">redis</a>, <a href="https://simonwillison.net/tags/replication">replication</a>, <a href="https://simonwillison.net/tags/salvatore-sanfilippo">salvatore-sanfilippo</a>, <a href="https://simonwillison.net/tags/scaling">scaling</a></p>

2008-10-14T16:33:38+00:002008-10-14T16:33:38+00:00https://simonwillison.net/2008/Oct/14/django/#atom-tag

<p><strong><a href="http://www.djangosnippets.org/snippets/1141/">Minimal nginx conf to split get/post requests</a></strong></p> Interesting idea for master-slave replication balancing where GET v.s. POST is load-balanced by nginx, presumably to different backend servers that are configured to talk to either a slave or a master. This won’t deal very will with replication lag though—you really want a user’s session to be bound to the master server for the next few GET requests after data is modified to ensure they see the effects of their updates. UPDATE: Amit fixed my complaint with a neat hack based around a cookie with a max age of 10 seconds. <p>Tags: <a href="https://simonwillison.net/tags/load-balancing">load-balancing</a>, <a href="https://simonwillison.net/tags/masterslave">masterslave</a>, <a href="https://simonwillison.net/tags/mysql">mysql</a>, <a href="https://simonwillison.net/tags/nginx">nginx</a>, <a href="https://simonwillison.net/tags/replication">replication</a></p>

2008-03-21T08:45:57+00:002008-03-21T08:45:57+00:00https://simonwillison.net/2008/Mar/21/mysqlcluster/#atom-tag

<p><strong><a href="http://softwaremaniacs.org/soft/mysql_cluster/">mysql_cluster</a></strong></p> My Russian isn’t all that good, but this looks like a neat way of getting Django to talk to a master/slave setup, written by Ivan Sagalaev. UPDATE: English docs are linked from the comments. <p><small></small>Via <a href="http://antoniocangiano.com/2008/03/20/djangos-tipping-point/#comment-2765">A comment on &quot;Django&#x27;s tipping point&quot;</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/django">django</a>, <a href="https://simonwillison.net/tags/ivansagalaev">ivansagalaev</a>, <a href="https://simonwillison.net/tags/masterslave">masterslave</a>, <a href="https://simonwillison.net/tags/mysql">mysql</a>, <a href="https://simonwillison.net/tags/mysqlcluster">mysqlcluster</a>, <a href="https://simonwillison.net/tags/orm">orm</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/replication">replication</a></p>

2007-06-05T22:07:23+00:002007-06-05T22:07:23+00:00https://simonwillison.net/2007/Jun/5/mysql/#atom-tag

<p><strong><a href="http://code.google.com/p/google-mysql-tools/wiki/SemiSyncReplicationDesign">Semi-synchronous replication for MySQL</a></strong></p> Google’s patch for MySQL which enables more reliable master-slave replication (a transaction isn’t committed until at least one slave has replicated the data). <p><small></small>Via <a href="http://www.myelin.co.nz/post/2007/6/5/#200706052">Phillip Pearson</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/google">google</a>, <a href="https://simonwillison.net/tags/masterslave">masterslave</a>, <a href="https://simonwillison.net/tags/mysql">mysql</a>, <a href="https://simonwillison.net/tags/open-source">open-source</a>, <a href="https://simonwillison.net/tags/philippearson">philippearson</a>, <a href="https://simonwillison.net/tags/replication">replication</a></p>