<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en-us" xmlns="http://www.w3.org/2005/Atom"><title>Simon Willison's Weblog: spockproxy</title><link href="http://simonwillison.net/" rel="alternate"/><link href="http://simonwillison.net/tags/spockproxy.atom" rel="self"/><id>http://simonwillison.net/</id><updated>2008-12-11T09:49:11+00:00</updated><author><name>Simon Willison</name></author><entry><title>Spock Proxy</title><link href="https://simonwillison.net/2008/Dec/11/spock/#atom-tag" rel="alternate"/><published>2008-12-11T09:49:11+00:00</published><updated>2008-12-11T09:49:11+00:00</updated><id>https://simonwillison.net/2008/Dec/11/spock/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://spockproxy.sourceforge.net/"&gt;Spock Proxy&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
A MySQL Proxy fork (no Lua) that concentrates solely on sharding, by parsing incoming SQL statements and redirecting them across multiple databases. There are some limitations on the SQL that can be handled (no nested queries, joins across a maximum of two tables) but generally it looks pretty impressive.


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/databases"&gt;databases&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/mysql"&gt;mysql&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/scaling"&gt;scaling&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/sharding"&gt;sharding&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/spockproxy"&gt;spockproxy&lt;/a&gt;&lt;/p&gt;



</summary><category term="databases"/><category term="mysql"/><category term="scaling"/><category term="sharding"/><category term="spockproxy"/></entry></feed>