This is the simplified version of the problem: We have a table on an Oracle Database. We cannot extend this table (bought app). We need to describe each row of that Oracle table with some text. So the descission has been to use MS Access for this. So I created in Access a table (Call it ACCESS_TABLE). The table consists of ID and MEMOT...
hello, i wanted to setup a new mysql database slave running a newer version of mysql => 5.1.41 than the master => 5.0.75, which -- as far as i know -- should normally be no problem. however, as it turns out setting up replication fails, because i used a SQL statement in 5.0.75 which apparently does not work in 5.1.41 anylonger: the sta...
Hello, I plan to use MySQL setup with one master server and several slave servers. I would perform regular consistent backup of the data EBS on one of the slave servers (I will always stop database before and restart it when it is finished). Slaves failover I one of the slave fails, I will start new instance and moun EBS based on the l...
I would like to setup a free/custom solution to perform failover for VMware ESXi. The setup is as follows: 2x Physical servers each with independent storage. For each physical server there are 2x Win2k8 Enterprise servers. In the case a physical server completely fails, we want the other (for convenience sake we can assign it with a s...
This is a bit of a replication newbie question. I have a requirement which is not immediate to replicate a database using transactional replication, is there anything I can do / should do up front to make my life easier for when I need to start publishing in anger, short of setting up the full blown topology for this. ...
This is a question for most of the DBA's / Information experts at product level. I need the solution for as many different databases as possible. So please provide the details of the replication methods used. For e.g: Database: Oracle 11i Replication method: Oracle ODI-EE with GoldenGate Pros: Can be integrated with any databases, etc...
I added a table tblJoinCustBlastList to a merge replicated database and now I'm getting this failure error during replication: Error messages: The schema script 'if object_id(N'[dbo].[tblJoinCustBlastlist]') is not null exec('ALTER TABLE [dbo].[tblJoinCustBlastlist] ADD CONSTRAINT PK_tblJoinCustBlastlist PRIMARY KEY CLUSTERED ( Joi...
I have master-master replication working successfully, it works fine and all changes I make will reflect to slave also. But I don't want that slave to reflect all changes - only such records that I want should reflect on slave. How can can do this? ...
We are providing software as service(web application) which is hosted in data ceneter in UK. Now we want also deploy our application and database in US data center. We are using MS-SQL Server as database. Here performance of data replication between two servers is main concern for us. We are thinking of replicating master data runti...
When I compare the sysmergesubscriptions table there are 5 entries, 1 for the publisher and 4 for the subscribers. I then look in the MSmerge_identity_range table and only see 2 records for each table that has managged identity ranges and the subid is the publishers is from sysmergesubscriptions. Shouldn't there be 1 record for each tab...
I am creating an application that has one server and multiple clients. It is a c# app that uses ADO.NET Entity Framework 4 over a MySQL database. The clients need to get data from several database tables on the server. There are also 2 separate tables that need to be sent from the clients to the server. At some point, the client shoul...
Hi, Just wrote a short script of copying all my tables into another local database. was quite easy but after checking it I found that the keys are gone and also the encoding for text fields are set to some default encoding. How can I use my script and have the same keys and same encoding duplicated after copying, but not manually defin...
I was watching this screencast at RailsLab where the presenter claims that it's possible to have a master DB for write operations and a slave DB for read operations. While for certain types of Web sites (e.g. blogs, social networks, Web 2.0 sites, etc.) it is acceptable for the master and slave DBs not to be 100% synchronized for short p...
I have 2 similar tables in different servers, data in certain columns can only be changed by server A while data in other columns can only be changed by server B. However, I need these tables to always be consistent (1 minute schedule). Is this the kind of scenario that "Transactional replication with updatable subscriptions" solves? ...
I'm trying to set up replication on a couple databases and have just run the change master command. I got very little feedback from the command: Query OK, 0 rows affected (0.07 sec) I want to know whether this step has succeeded or not. So, is there a way to find out who my slave db thinks is its master? Thanks. ...
In SQLServer 2005, is it possible to migrate a database from a workstation to another and also take the Replication configuration with it? I mean, besides creating scripts. ...
Hello, It is possbile set/reset the AUTO_INCREMENT value of a MySQL table via ALTER TABLE some_table AUTO_INCREMENT = 1000 However I need to set the AUTO_INCREMENTupon its existing value (to fix M-M replication), something like: ALTER TABLE some_table SET AUTO_INCREMENT = AUTO_INCREMENT + 1 which is not working Well actually, I woul...
Hi, I'm currently setting up replication in order to produce a database that will be used to run reports and take load of the main database. According to the guide at: http://msdn.microsoft.com/en-us/library/ms151799(v=SQL.90).aspx You setup mirroring, which we use for high availability after the publisher has been configured. I was ...
So, I've got an 'A' server and a 'B' server. We are using SQL Service Broker to perform replication. An application we have will need to write data to either the 'A' server, or the 'B' server. (one may be down, and the other one should take over) Data is written to the database only within stored procedures, which are wrapped in a ...
I want to push subscriber using IP address except server name. How can do this? Please give me an example or reference. ...