[Spock Proxy Devel] Universal tables question...

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
<font size="-1"><font face="Arial">I seem to be having trouble with
Universal tables under read/write scenarios (all my earlier testing
only </font></font><font size="-1"><font face="Arial">involved writes </font></font><font
 size="-1"><font face="Arial">on federated tables). After reading the
spock section universal tables I thought I understood it, but my
results aren't quite what I'd expected:<br>
</font></font>
<blockquote><font size="-1"><font face="Arial">We have solved it by
having a 'universal' database which contains all of these tables as
well as some directory tables. Each shard database is a slave of this
universal database server and the universal database is replicated to
each shard. There are two databases on each shard, the shard itself
which is unique to that shard (and perhaps it's slaves) and the
universal database which is identical to all other universal databases.</font></font><br>
</blockquote>
<font size="-1"><font face="Arial">So I now have two schemas on each
shard. The configuration schema (site_universal_production) which in
addition to the shard_* tables now contains each universal table as
well and the federated schemas which only contain copies of the tables
we'll be federating. <br>
<br>
I've setup replication for this schema (</font></font><font size="-1"><font
 face="Arial">site_universal_production, </font></font><font size="-1"><font
 face="Arial">to my 2 shard nodes) and have them successfully working
as slave nodes; replicating updates to </font></font><font size="-1"><font
 face="Arial">site_universal_production locally as I'd expect.<br>
<br>
So now things like updates work with universal tables and the changes
ripple down nicely to each shard.<br>
<br>
The trouble I'm having now is that selects on universal tables are
still looking for the tables in the federated </font></font><font
 size="-1"><font face="Arial">shard </font></font><font size="-1"><font
 face="Arial">databases (so they fail) and I can't seem to see where or
how to explicitly map the universal tables to the
site_universal_production database.<br>
<br>
Of course I could try table level replication and bypass the two
databases per shard (and therefor the lookup issue</font></font><font
 size="-1"><font face="Arial">, I probably will now for fun!</font></font><font
 size="-1"><font face="Arial">) but since your notes seem to be pretty
clear on the use of separate databases I figure I'm actually missing
something very obvious.<br>
<br>
:-)<br>
</font></font><font size="-1"><font face="Arial"><br>
<br>
</font></font>
<div class="moz-signature">-- <br>
<font ptsize="10" family="SANSSERIF" color="#004080" face="Verdana"
 lang="0" size="2">_______________________________________________________________________</font><br>
<font ptsize="8" family="SANSSERIF" color="#000000" face="Arial"
 lang="0" size="1"><b><span style="color: rgb(0, 0, 160);">Zach Garner</span></b>
<span style="color: rgb(128, 128, 192);">|
</span> Sr. Systems Administrator / Product Analyst <span
 style="color: rgb(128, 128, 192);">|</span>
iiON
Corporation <span style="color: rgb(128, 128, 192);">|</span> <a
 style="color: rgb(0, 0, 160); text-decoration: none;" target="_blank"
 href="http://www.iion.com/">www.iion.com</a> <span
 style="color: rgb(128, 128, 192);">|</span>
Office: 858-713-0450 x 20<br>
<br>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br>
<div style="color: rgb(0, 64, 128); text-align: justify; width: 570px;">This
message (and any associated files) is intended only for the individual
named and may contain information that is confidential, subject to
copyright or constitutes a trade secret. If you are not the named
addressee you are hereby notified that any dissemination, copying or
distribution of this message, or files associated with this message, is
strictly prohibited. If you have received this message in error, please
notify us immediately by replying to the message and deleting it from
your computer. Messages sent to and from us may be monitored. Any views
or opinions presented are solely those of the author and do not
necessarily represent those of iiON Corporation.</div>
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
</font></div>
</body>
</html>