database-replication

How to update localhost mysql data to remote mysql server

i would like to update for every action(insert,update,delete) happens in localhost mysql to remote mysql server. how to i do that? . ...

Postgres Slony-I question

Sample slonik command on the 1st node: slonik <<_EOF_ #-- # define the namespace the replication system uses in our example it is # slony_example #-- cluster name = $CLUSTERNAME; #-- # admin conninfo's are used by slonik to connect to the nodes one for each # node on each side of the cluster, the syntax is that of PQconnectdb in # the ...

Zookeeper/Chubby -vs- MySql NDB

I have been reading the Paxos paper, the FLP theorem etc. recently and evaluating Apache Zookeeper for a project. I have also been going thru Chubby (Google's distributed locking service) and the various literature on it that is available online. My fundamental usecase for Zookeeper is to implement replication and general coordination fo...

Is there a Passenger compatible implementation of taps for Ruby on Rails?

Does anybody know of a gem that provides taps-like functionality, that is compatible with Passenger (mod_rails)? When I try to use taps on a Ruby EE/Passenger setup, I receive the error: `detect_rack_handler': Server handler (thin,mongrel,webrick) not found. (RuntimeError) Although it's not specifically stated in the readme, I am ass...

How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?

Mysql Server1 is running as MASTER. Mysql Server2 is running as SLAVE. Now DB replication is happening from MASTER to SLAVE. Server2 is removed from network and re-connet it back after 1 day. After this there is mismatch in database in master and slave. How to re-sync the DB again as after restoring DB taken from Master to Slave also ...

Identity column problem in SQL replication.

How can we transfer primary key (identity column) while replicating a database. ...

How to setup Replication or Federation between MySQL and Derby?

Perhaps this is not possible yet, but... What's the easiest way to setup Replication or Federation between MySQL and Derby? I need a way for data updates/inserts/deletes into a certain table in Derby to automatically flow into an equivalent identical table in MySQL, as quickly and efficiently as possible. This can be done in applicati...

MySQL Replication and Upgrading an App on Master

I've got a master-slave replication setup for a suite of applications. One of those applications is a forum, which writes directly to the master. The rest just read from the slave. The forum database is huge (~10GB) which causes some issues re: backups and data transfers (even a mysqlhotcopy takes 20 minutes). I want to run an upgrade...

Make MySQL database replication always use the most free node?

We started using Multi-Master Replication Manager for MySQL, and I am wondering whether it is possible to to treat this setup like multi-symmetric processing: a process pops off the process queue, and the node (in this case a server) that is most free is selected for the job. It seems that what happens is, the service switches to a slav...

Postgresql slave for Mysql Master. Possible ?

Hi, I need to make some tests for a potential migration from Mysql to PostgreSql. It will be easier to test if it is possible to use Postgre as slave for my MySQL master. Is it possible ? Thanks in advance ...

How to achieve high availability?

My boss wants to have a system that takes into concern of continent wide catastrophic event. He wants to have two servers in US and two servers in Asia (1 login server and 1 worker server in each continent). In the event that earthquake breaks the connection between the two continents, both should work alone. When the connection is rev...

Is there any replication standard or concept for application server data replication

Hi friends, Say, I have a server that handles file based mass data and can process thousands of read requests and hundreds of provisioning requests(Add, modify, delete) per second. This is not SQL based database. Now i planned to implement replication. There should be master- master replication, master slave replication, partial replica...

Replication in workgroup

I have configured transactional replication with Publisher and distributor which are on same and subscriber on different servers. Publisher and Distributor are running on MSSQL 2008 and the subscriber is running on MSSQL 2008. The both PC are running in the same workgroup. When I go to view synchronization status on Publisher, i am gett...

Consolidate data from many different databases into one with minimum latency

I have 12 databases totaling roughly 1.0TB, each on a different physical server running SQL 2005 Enterprise - all with the same exact schema. I need to offload this data into a separate single database so that we can use for other purposes (reporting, web services, ect) with a maximum of 1 hour latency. It should also be noted that thes...

setting up replication in mysql pros and cons

Basically I want to setup a replication server for mysql datbase. I am completely new to this concept and appreciate any help pointing me in the right direction. If at all the slave goes down, will it effect the master in anyway? Thanks. ...

How can I sync a database driven website to a different server

I have a website using cPanel on a dedicated account, I would like to be able to automatically sync the website to a second hosting company or perhaps to a local (in house ) server. Basically this is a type of replication. The website is database driven (MySQL), so Ideally it would sync everything (content, database, emails etc.) , but...

Mysql Replication

My current database design uses MyIsam mainly as the storage engine, I wonder if its possible to split some of the tables into MyIsam and some into Innodb in the same database. Reason of switching some of the tables to Innodb is because i need row-based locking which Innodb offers. I am not too sure whether this would have any effect on ...

Replication: SQL Server 2008 Publisher with SQL Server Express 2005 Subscriber

Here is the setup: SQL Server 2008 Enterprise Server with a Merge Publication. SQL Server 2005 Express with pull subscription. There is no web or ftp setup. This is direct merge replication. Using the RMO objects from C#, I get a "class cannot be found." COM Error when accessing the MergePullSubscription.SynchronizationAgent prope...

SQLServer Replication, dealing with updating data in a subscriber without merging with the publisher

To simplify my problem, picture two databases, one is a publisher, one is a replicated subscriber. Most of the time, changes are configured in the publisher, and pushed to the subscriber once per day using transactional replication. (The subscriber is the main production database). However, on a rare occasion, we need to make a change ...

Is MySQL Replication Appropriate in this case?

I have a series of databases, each of which is basically standalone. It initially seemed like I needed a replication solution, but the more I researched it, the more it felt like replication was overkill and not useful anyway. I have not done MySQL replication before, so I have been reading up on the online docs, googling, and searchin...