[Spock Proxy Devel] Universal tables question...
Status: Alpha
Brought to you by:
kaotao
Menu
▾
▴
[Spock Proxy Devel] Universal tables question...
|
From: Zach G. <za...@ii...> - 2008-10-15 20:12:32
|
<!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> |
