Thanks very much. What is the best way to take the slave out of read only mode so we can alter indexes etc ?
On Dec 18, 2007 12:33 AM, Tomeh, Husam <[EMAIL PROTECTED]> wrote: > > Please see my comments below. > > -----Original Message----- > From: "James Tucker" <[EMAIL PROTECTED]> > To: "[email protected]" <[email protected]> > Sent: 12/16/2007 5:30 PM > Subject: [Slony1-general] Different indexes on slave > > Hi All, > > We're currently running slony to replicate to our DR site. We're looking > at > creating another reporting database at each site so our application can > use > that for reports etc, and the master for our normal oltp load. The > reporting database only needs a subset of the tables included in the DR > set. > > > I have 2 questions. > > Is there any reason we can't create different indexes (aimed at faster > reports as apposed to OTLP) on the reporting slave ? > > [Husam: you should be able to do so. Actually this is one of the > advantages of Slony triggered-based replication system.] > > Currently I just have one set that includes all our tables, am I able to > create another set with just a selection of those tables ? Or would I > need > to recreate my existing set, splitting it. > > [Husam: breaking your set would give you more flexblity - that'd be a good > choice.] > > i.e. > > set1 = table1, table2, table3 > > set2 = table1, table2. > > Thanks in advance. > > James > > > ********************************************************************** > This message contains confidential information intended only for the use > of the addressee(s) named above and may contain information that is legally > privileged. If you are not the addressee, or the person responsible for > delivering it to the addressee, you are hereby notified that reading, > disseminating, distributing or copying this message is strictly prohibited. > If you have received this message by mistake, please immediately notify us > by replying to the message and delete the original message immediately > thereafter. > > Thank you. > > FADLD Tag > ********************************************************************** > >
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
