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 ...
I've got 2 Ubuntu 10.04 Server virtual machines running on VirtualBox with host-only network static IP address configuration. Machine A: ubuntu-a 192.168.56.101 Machine B: ubuntu-b 192.168.56.102 Machines can ping each other via either hostnames or IP address. MySQL 5.1 installed on both systems. I want to achieve replication with ub...
Hello, I would like to do Mysql to Mysql replication using drs. Is it possible to do the same without storing data in db4o? I just want to use drs replication using Hibernate. Any positive/negative experience with drs? ...
Just posting this here and might help the others: I got this error when we had an outage a while ago, and tried to restart the slon replication service as the replication is NOT really replicating the data from MASTER to SLAVE: FATAL localListenThread: "select "_MY_DATABASE_copy".cleanupNodelock(); insert into "_MY_DATABASE_copy".sl_n...
I have two SQL servers that I need to have identical. Sync should occur maybe a couple times per day, automatically. The two servers have no "direct" connection between them, so no linked db etc. (They are on totally diff machines, networks, domains, with firewalls between etc) You can use the Internet though, like Web Service, FTP... ...
If for any reason MySql server goes down, What are the ways I could still show my page to user? Probably having a backup DB server would help? If I've multiple DB servers and one goes down, I can fetch data from another temporary server? How to detect that main server is down? Who would select alternate server? role of reverse proxy s...
Server1: xxx.xxx.xxx.xxx server-id=1 binlog-do-db=sample master-host = xxx.xxx.xxx.xxx master-user = someuser master-password = somepassword master-connect-retry = 60 relay-log = /var/lib/mysql/slave-relay.log relay-log-index = /var/lib/mysql/slave-relay-log.index Server 2: xxx.xxx.xxx.xxx server-id=2 binlog-do-db = sample...
Hi! Want to set up mysql master-slave replications in rails app. Are there plugins/db adapters available for Rails 3? Does the Masochism plugin work properly with rails 3? ...