According to the MySQL documentation on database replication, "All tables replicated using row-based replication must have explicit primary keys." Is it safe to assume that database replication will work with a composite keys? ...
I have a need to migrate some CouchDB database data back and forth between two desktop computers at different locations. One of the computers is Windows XP, one is a Macintosh running OS X 10.5. Neither can realistically connect to the other via the internet (the PC has a firewall, the Mac doesn't have fast internet access). But I do hav...
I am aware of COLUMNS_UPDATED, well I need some quick shortcut (if anyone has made, I am already making one, but if anyone can save my time, I will appriciate it) I need basicaly an XML of only updated column values, I need this for replication purpose. SELECT * FROM inserted gives me each column, but I need only updated ones. somethi...
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 ...
Lets say I have a datbase of Cars. I have Makes and Models (FK to Makes). I plan on having users track their cars. each Car has a FK to Model. Now, I have a lot of users, and I want to split up my database to distribute load. The Makes and Models tables don't change so much, but they need to be shared across shards. My thought is to use ...
I'm using the multi-db gem with Slony-I replication on PostgreSQL in a Rails app. This mostly works perfectly, but there is a bit of a replication lag in certain cases. One of the cases involves an ActiveRecord counter_cache. For clarity, assume the following two models: class Post < ActiveRecord::Base has_many :comments ... end c...
Hello, I want to make a dedicated SLAVE machine for data replication of three database on three different servers. In other words, I want to do Multiple Master => SIngle Slave replication. Is there any way to do this, as simple as it can be ? Thanks ! ...
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?? ...
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...
I have a table which contains a large volume of data...thousands of million of rows. I am planning to have a replica of this table. Can I have an index on replica only not on the original table, so that insertion in the orignal table will be fast. ...
We have a client that needs to set up N local databases, each one containing one site's data, and then have a master corporate database containing the union of all N databases. Changes in an individual site database need to be propagated to the master database, and changes in the master database need to be propagated to the appropriate ...
How do I disable/enable MySQL replication monitoring? I would like to be able to run a command line to disable monitoring a service. The GUI is to slow to do this task. Every time I have to run a database maintenance its several clicks for a single host. I would love to be able too run a single command to disable replication monitoring f...
Hi, We have several remote locations where we have set up SQL Server 2005 replication. Sometimes the publisher fails to replicate due to various reasons like 1) network problems, 2) improper shut downs of subscriber, 3) change in domain passwords, 4) change in SQL passwords, 5) failure to switch on the subscriber system. Is th...
Hi, Some of our end users are not IT savvy and may not know how to check the health of the SQL replication system. Are there any tools which are simpler than SQL Server Management Studio that they can keep an eye on ? I am asking this since the end users are non programmers. If not, what are the ways for the admin in the client place, ...
I have built a SQL Server Express database that is going to be housed on an external hd. I need to be able to add/update data on the database that is on my system, as well as other systems and then only backup or transfer data that has been added or edited to the external hard drive. What is the best way to accomplish this? ...
I have recently created a search system at my company using the Regain Search based on Lucene to search through all software support tickets. I run some queries in SQL to extract my data, export to Excel, import to Access, run some additional queries, create a report, export the report to .txt files, and use a file splitter to split the ...
Hi, I have a requirement to use Sql replication from a sql server 2005 instance to a Sql 2000 instance over a vpn. The vpn is permanent between the 2 sites and there are only a few tables that need replicated. Can anyone give me any advantages/disadvantages of replication over vpn or any issues with replication between SQL 2005 and Sq...
How does SQL Server handle the transfer of the datetime columns when replicating between timezones? ...
I'd like to write a sql script to do a basic smoke test to check that the replication setup on my server is correct. I think a simple set of CRUD operations against the tables that are supposed to be replicated will achieve what I'm after and I imagine the workflow will look something like this: INSERT a row into a replicated table in...
We have two situations: We have a database server that contains tables of job titles. Those job titles need to be accessed by a database on another server. We have established a linked server connection and everything works well. Problems: There can be no foreign key referential integrity because the tables are physically stored on...