I'm developing an app which will have a central database users can add entries to. The database will have to be on a server somewhere but I want the users to be able to add entries offline. The app will sync to the main db when connection is available. So, I supose I need 2 databases - the main one sitting on a server (preferably linux) ...
When starting the PGCluster replication server I get the follwing problem: postgres@mybox:/usr/local/pgsql/bin$ ./pgreplicate -D ../etc -l -n -v *** buffer overflow detected ***: ./pgreplicate terminated ======= Backtrace: ========= /lib/tls/i686/cmov/libc.so.6(__fortify_fail+0x48)[0xb7e69da8] /lib/tls/i686/cmov/libc.so.6[0xb7e67eb0] ./...
I have set the Master DB Name as MDB & in the Slave server I set to replicate-do-db=SDB <-- this did not work? But when I set it up as the same DB name it works. Is there any solution out there to setup 1 master db with 2 different slaves but in the same server?? ...
What is difference between 3 type of replication? Is replication suitable for data archiving? What is the replication steps? ...
What is deference between Microsoft Sync Framework and Replication? which one is better? ...
I'm a bit of a noob, so pardon me if the answer to this question seems obvious. I have been tasked with the creation of SSIS packages that will operate in an environment maintained by another company. They're using replication to publish updates from client sites to a centralized server, and I'm not entirely certain how they've got it se...
We have decided to put our servers in data centers on east and west coast of US, to keep high level redundancy. We like to replicate our SQL Server 2008 databases using merge replication, but going through configuration headaches. Our SQL Server are running on web front end boxes. Can Merge replication be set up over the internet. MSDN ...
I am researching the possibility of using Firebird for a project. However, one potential problem is replication and failover, or rather, lack of a (subjective) "good" solution. There are several potential solutions listed in the Firebird FAQ but they are either 1) Windows-centric; 2) horribly outdated; 3) commerical; or 4) not full-f...
Hi, How can I start one slave and tell him to stop updating in one date and time? Like "update slave until Friday 9:00"? Is possible? Thanks in advance? Regards, Pedro ...
I'm looking for a recommendation for a product that enables replication between different database systems. We're just looking for standard replication (copy this table over here and apply transactions as they happen) - nothing fancy. We can't use built-in database replication because our source server (Tandem/NSK) doesn't support any k...
We have a client that currently has a large busy database that they back up using database mirroring. As part of a reporting requirement we need to use some of the data stored in the database to run reports against but we cannot access the data directly. Is it possible for us to run transaction replication on that server to get our d...
We have several stored procedures marked as articles for replication in our SQL2000 database. If we update any of them via ALTER PROCEDURE, the changes are applied to the master, but never published to subscribers. Am I missing a setting, or does SQL require a complete reinitialization/snapshot to move the changes out? ...
Hi, We are looking at database replication for rolling deploys. It gets complicated as our deploys involve data migrations too. What would be a good replication scheme. I guess my question is on how to setup the replication. Supposing we have 4 webservers and 2 database servers, how do I make the update so that all the writes are repl...
Suppose I'm using transactional replication to replicate articles from one server to another (both running SQL Server 2000). This is setup and working great. Then, I decide to add a new article. First, I add it to the publication via Publication Properties > Articles > Objects to Publish. Then, what do I do? It'd be nice if I could ...
I've read somewhere that using merge replication there is no transaction. Is there a way to use merge replication + transaction? ...
I don't have a full qualified domain name in the server and when i configure web replicate during certification i get the following error the server name does not match the name of the certificate, i think to get full qualified domain name for my server so that it should be equal to my computer name and IIS node. what i want to know is...
From what I learned, a MySQL MASTER server is one that can both read and write. Correct? My question is: Suppose you have 2 MySQL master-write servers (and many slave-read servers). How can you solve the problem of auto-increment? How do you sync it? Suppose you are writing to both the Master1 and Master2...how will you sync it so tha...
As I found this can be done with merge replication in SQL Server. But I have only one main server and many small ones(with Express edition installed on them). Let me explain: There is the main (big) office with SQL Server Standard edition installed on its server. And there are many offices across the country with with their own small ...
Our scenario: We have a main database that stores company-wide information. We have several retail locations which have their own databases they work off of. These locations need to use information in the company-wide database, and I do not want our main application to run cross database queries because if the main database has issues (...
We want to replicate data from one database to several others (on another server). Would it make sense to replicate these tables to a shared database on the other server and have our cross-database queries reference the shared database... or would it make more sense to replicate out to each individual database on the other server? Would ...