[prev in list] [next in list] [prev in thread] [next in thread]
List: slony1-general
Subject: [Slony1-general] Dynamic table subscription
From: "Nick Johnson" <nick () haydrian ! com>
Date: 2006-03-30 0:42:36
Message-ID: 775F825B46B551499DC75DC4E92F80AB1EEFE5 () jupiter ! ad ! haydrian ! com
[Download RAW message or body]
Hi,
We're attempting to apply Slony1 to our database for replication.
However, we use a table partitioning system that causes new tables to be
created at runtime. Slony1 doesn't directly support runtime schema
changes, I realize, but we think we have a solution: There's a master
'partition descriptor' table, which has a row for each table in the
system. If we were to create triggers on insert/update/delete for this
table on master and slave, we could, on the master, invoke a trigger
that adds the table to the set and configures it, and on the slave
invoke a trigger that creates the table (since it always follows a
defined template), and subscribes to its replication set.
Is this practical? And if so, can anyone give some pointers for getting
started?
Thanks,
Nick Johnson
[Attachment #3 (text/html)]
<html xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>We’re attempting to apply Slony1 to our database for
replication. However, we use a table partitioning system that causes new tables
to be created at runtime. Slony1 doesn’t directly support runtime schema
changes, I realize, but we think we have a solution: There’s a master \
‘partition descriptor’ table, which has a row for each table in the \
system. If we were to create triggers on insert/update/delete for this table on \
master and slave, we could, on the master, invoke a trigger that adds the table to \
the set and configures it, and on the slave invoke a trigger that creates the table
(since it always follows a defined template), and subscribes to its replication
set.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Is this practical? And if so, can anyone give some pointers
for getting started?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Thanks,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Nick Johnson<o:p></o:p></span></font></p>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic