replication

SQL Server replication without deletes?

Is there a way to replicate a sql server database but not push out deletes to the subscribers? ...

Add a table to an existing mysql replication?

Hi. I have an existing mysql replication set up (Windows 2008 to Ubuntu 9.04) and created several new tables in the master database. These are not showing up in the slave database. Do new tables automatically get copied to the slave DB, or do I need to set up replication again? Thanks! ...

SQL Merge Replication: How to tell if a record has been replicated

I have a merge replication scenario, with SQL2005 SP3 as the publisher and distributor and windows mobile SQLCE 3.5 SP1 as the subscribers. The replication filter is such that rows from one of the tables (tblJobs) only go to exactly one device. After the device has replicated it executes sql to set the IsSynced boolean column on all th...

How do I ensure SQL Server replication is running?

I have two SQL Server 2005 instances that are geographically separated. Important databases are replicated from the primary location to the secondary using transactional replication. I'm looking for a way that I can monitor this replication and be alerted immediately if it fails. We've had occasions in the past where the network conne...

PostgreSQL -> Oracle replication

I'm looking for a tool to export data from a PostgreSQL DB to an Oracle data warehouse. I'm really looking for a heterogenous DB replication tool, rather than an export->convert->import solution. Continuent Tungsten Replicator looks like it would do the job, but PostgreSQL support won't be ready for another couple months. Are there an...

Pattern for updating slave SQL Server 2008 databases from a master whilst minimising disruption

We have an ASP.NET web application hosted by a web farm of many instances using SQL Server 2008 in which we do aggregation and pre-processing of data from multiple sources into a format optimised for fast end user query performance (producing 5-10 million rows in some tables). The aggregation and optimisation is done by a service on a ba...

The concurrent snapshot for publication 'xx' is not available because it has not been fully generated or the Log Reader A

I am having all sorts of trouble getting SQL Server (2005) to work properly. When I run the client (SQL Server Express 2005) I get the following error "The concurrent snapshot for publication 'xx' is not available because it has not been fully generated or the Log Reader A" The error is cropped off. I have tried: - Deleting the subsc...

Can I use Failover Partner in my SQL connection string without mirroring?

I admit I'm a bit of a cheapskate, but I don't want to spring for the three servers needed to get automatic failover for SQL Server via Mirroring, especially since one of the three would do nothing other than be a witness server. If I set up normal SQL replication (snapshot, say) from primary server to backup server, can I just set my c...

Geographic redundancy and MySQL replication

Hi folks, I has a fairly simple site getting 200K hits/day (3-5 hits/sec) using a LAMP configuration. The host is somewhat flaky (read: cheap), so we want to add a 2nd host for guaranteed uptime (I wouldn't call this mission critical, but more annoyance-prevention). MySQL is idling at about 200 qps, spiking for 450 at times. I have s...

backend db setup for an app with geographically diverse users

The in-house developed software where I work connects directly to a mysql server here in our office via our devexpress orm (XPO). Performance is great. We're opening another office... cross country. Performance: not so great. The requirement is that the software be as responsive in both offices as it is in this office and that the data ...

Writing to one db while reading from another using DevExpress XPO

Does anyone have any experience with working with DevExpress' XPO in an environment where the DB is replicated? From my previous question here and one on serverfault, I think it's been decided that replication is the way to go. The MySQL docs say that all writes need to happen on the master, and all reads have to come from the slave. T...

Wait for connections to close before restoring SQL Server database

I have a web application that uses two databases. DB1 Users perform their CRUD (Create, Read, Update, Delete) operations. Database DB2 is a readonly database on a different server that i use for reporting purposes. Every hour my DB1 saves transaction logs and on DB2 i have a job that restores them on that DB2 to keep it ~up to date. Pr...

Should my database driver classes support replication (PHP)?

Hello, I'm currently writing a PHP application and drivers (classes) for the database engines. I was wondering if I need to write a replication support (master-slave)? I'm a bit new to this, so, what kind of things should my project or classes worry about if I want to support load balancing/replication? Oh and this is about MySQL. ...

How to boost MySQL master-slave replication to the extreme degree?

Currently the slave often falls several thousand seconds behind master,which is a real headache! ...

Additional replication options for large files on IBM Domino

Are there any products that can be used with IBM's Domino to handle the replication of large files? Preferably one that can do byte level replication. I have an environment(over 50 servers) where large files are placed and changed (bandwidth is a premium). I would like to only replicate the bytes that have changed versus the whole file...

How do I create control tables in DB2 UDB for setting up new replication

How do I create control tables in DB2 UDB for setting up new replication ...

Is it possible to export my SQL replication definition to XML?

I was asked to do this, but I don't know if there is a standard way of doing so. Does anyone know if there is a way in SQL Server to export this? ...

Can replication work between SQL 2005 publisher and SQL 2008 subscriber?

I see this question here on SO but I am not sure that answers my question. My Central SQL server is 2005 Standard. I am developing an app that requires SQL Express to be installed locally. I am then programmatically creating the Subscriptions and then Syncing them. Can I use 2008 Express for this on the local machines? ...

MySQL Monitor Replication

Hi, Does anyone knows any free alternative MySQL Enterprise Monitor? I need some tool, that allows me to monitor my 3 servers with replication without having to open ssh console, and use command line. Regards, Pedro ...

Harvesting Dynamic HTTP Content to produce Replicating HTTP Static Content

I have a slowly evolving dynamic website served from J2EE. The response time and load capacity of the server are inadequate for client needs. Moreover, ad hoc requests can unexpectedly affect other services running on the same application server/database. I know the reasons and can't address them in the short term. I understand HTTP ...