replication

Percona/XtraDB insllation + replication setup - tips/guides for Centos 5.2

I am looking for good articles on how to install and setup Percona's patched server with XtraDB and master/slave replication setup on Centos 5.2 64 bit. I believe they can be downloaded at http://www.percona.com/mysql/5.1.34-5/RPM/rhel5/? and is there any good recipes for setting up HA and replication? Thanks! ...

What does the ISPALUSER function call in the Msmerge_*_VIEW views do?

I'm trying to understand how SQL Server 2005 replication works, and I'm looking at the views titled Msmerge_[Publication]_[Table]_VIEW. These views seems to define the merge filters, and are pretty straight forward, except for one line of sql in the WHERE clause: AND ({fn ISPALUSER('1A381615-B57D-4915-BA4B-E16BF7A9AC58')} = 1) What do...

Could not obtain information about Windows NT group user

I am creating a SQL Server Replication using a script. When I try to execute The job failed. Unable to determine if the owner (STAR\moorer7) of job L3BPT2M-Atlas-14 has server access (reason: Could not obtain information about Windows NT group/user 'STAR\moorer7', error code 0x5. [SQLSTATE 42000] (Error 15404)). This is a job created...

repl_identity_range constraint not changing after altering subscriber range

I have increased the size of the publisher and subscriber range for a table used in Merge replication, reinitialized the subscriptions and rerun the snapshots, but the repl_identity_range_xxxxx constraint on the table still contains the old range. How do I refresh this new range without dropping the article and recreating it? ...

Where\How to store distributed configuration data

A single installation of our product stores it's configuration in a set of database tables. None of the installations 'know' about any other installation. It's always been common for customers to install multiple copies of our product in different datacentres, which are geographically far apart. This means that the configuration infor...

What's a good FOSS java servlet session replication solution

I work on a very high volume public website running on Tomcat 5.5. Currently we require stickiness to a particular server in order to maintain session. I'd like to start replicating session, but have had trouble finding a good FOSS solution. I've written my own Manager (using memcached as the store) but am having trouble dealing with ...

Multiple Datacenters

I am finding a lack of information regarding handling multiple datacenters. What tools and techniques are available for taking advantage of multiple datacenters? A requirement is that the databases become consistent very quickly. ...

MySQL replication speed

Lets say we have 3 servers on a local area network: APP - php app server MASTER - master Mysql db server SLAVE - slave Mysql db server (replicating MASTER) In the one code block (php) APP inserts into MASTER, retrieving the last_insert_id which it then uses to select the data it just inserted from SLAVE. So the question is, will the...

synchronize two pg databases

I have a postgresql server process each running in my desktop and the laptop. Both servers have a database called MG with exactly same scheme/layout. Now I enter the data in to similar tables but at differing times. I generally keep the primary keys seperate so that they don't clash with each other. eg: oddnumber pkey for laptop and ev...

Suspended replication process, can I kill it?

Hello; On one of my servers that has a push transactional publication, I see the following session level information....as you can see below, this is a replication procedure (sp_replmonitorrefreshjob) and I'm hesitant to just kill the session because I'm not sure about whether this procedure is supposed to just hang around "waiting". Do...

Grails/Spring and MySql Replication. And a deadlock...

After installing Grails 1.1.1 and adding Replication (org.mysql.jdbc.ReplicationDriver) it appears that my BackgroundQueue is clogging up. Question 1: How do I determine "why" my BackgroundQueue is clogged? (I define Clogged as having all available thread stuck, and not accepting any new "work"). Question 2: What is the "defined way" ...

Database Replication OOD Pattern

Greetings fellow overflowers, After reading on MSDN about correct strategies on how to perform database replication, and understanding their suggestion on Master-Subordinate Incremental Replication. It left me wondering, what OOD design pattern should I use on this... The main elements of this strategy are the Acquirer, the Manipulator...

MySQL replication is not running although mysql says it is

I have two servers configured in a master-master pair using MMM. I recently had an issue where the passive master received a replication error (got a packet bigger than max_allowed_packet) but the slave IO and SQL threads continued running. And seconds_behind_master was still showing as 0 even though the slave was not executing new state...

ehcache auto-discovery (via multicast) between 2 instances on the same host

Hello I run 2 tomcat instances on the same host. Each instance runs the same web application which tries to communicate some ehcache caches via RMI replication. I use the autodiscovery configuration in ehcache so I don't have to explicitly define which are the hosts and which are the caches I want to replicate. The ehcache instances do ...

Is performance hit hard when you reinitialize a subscription in sql server 2005

Hey folks, I haven't worked with reinitializing a subscription for SQL Server 2005 replication before and the time has come. I've added a few new articles and need to push those down to the subscriber. Before I reinitialize, which I've read is what I want to do, I want to have a feel for potential performance hit when I kick it off. My ...

Deattach a replication sql server 2005 databas.

Is there is any way to move deattach a SQL server 2005 database that is used for replication without, recreating the publishers and subscribers again at the destination? ...

The merge process could not update the list of subscriptions

I have replication set up between a sql-server 2005 instance and multiple sql-server 2000 instances. The replication will successfully for a while before I get the following error message: Violation of UNIQUE KEY constraint 'unique_pubsrvdb'. Cannot insert duplicate key in object 'dbo.sysmergesubscriptions'. (Source: MSSQLSERVER, Erro...

sql server 2008 snapshot agent problem

Hi! I've just installed mssql 2008 sp1 x64 on windows 7 RTM, and have the problem with creating snapshots, whenever I try to launch the snapshot agent (i.e. to setup transactional replication publication), it throws the error that 'the file is missing'. I have looked into c:\program files\microsoft sql server\100\com and there are no exe...

MySQL ring replication behind NAT

I am considering switching from Firebird where I'm using a hand-built replication to MySQL and its integrated replication solution. I have 4 departments with sporadic network connections. Each one has to have its copy of the database, and has to be able to update database, so I decided that using ring replication method (A->B, B->C, C->D...

Checking where a table is replicated from - SQL 2000

I have a SQL 2005 database that has a couple of publications set up to a SQL 2000 database on a separate server. Some of these tables are prefixed with "company_live$TableName". However, I can see some in the SQL 2000 db that are prefixed with "company_limited$TableName". I'm just wondering where these tables come from... is there any ...