The replication tag has no wiki summary.
4
votes
1answer
34 views
Adding a new location through Active Directory. How should it be done?
Our entire Active Directory forest is currently on a single 10/8 private subnet. We're looking to migrate most of our servers to a cloud provider, but I'm not sure how to set up the first domain ...
0
votes
2answers
50 views
Amazon RDS to EC2 replication [closed]
Possible Duplicate:
Is it possible to use an EC2 RDS MySQL instance as a slave to an external master?
My read-intensive application needs to scale horizontally. It will be deployed by ...
2
votes
2answers
23 views
MSDE 2000 to MSSQL 2008 SQLExpress replication
I have an old database on MSDE which I need to replicate (one-time process) to a new MSSQL 2008 SQLExpress installation. What are my best options to replicate without involving messy sql scripting? ...
0
votes
1answer
71 views
Memcache Master and slaves
I'm using memcached-1.4.5-1.el5 & memcache-2.2.6 as php extension and memcached-1.2.8-repcached-2.2.1 for replication.
The above packages are installed on 4 servers. How can I do the following?
...
0
votes
4answers
79 views
DRBD or similiar RAID over net on slow/limited networks
I am looking for ways to create some kind of file replication without losing too much performance on file operations. A real RAID is not an option due to non-technical constraints.
As far as I ...
0
votes
1answer
30 views
MySQL init.d script with different configuration file
I have two instances of mysql running on a server. I need two different init.d scripts. The two instances have different configuration files /etc/my.cnf and /etc/my-slave.cnf. I copied the ...
2
votes
1answer
68 views
MySQL Replication: Move slave to be slave of another slave, without any (or least possible) downtime
I have the following setup:
M1 = Master 1
S1 = Slave 1
S2 = Slave 2
S3 = Slave 3
Where all slaves are replicating directly from M1. I would like to move S2 and S3 to be slaves of S1.
I'm not sure ...
2
votes
2answers
46 views
Safe initial sync for SQL Server OLEDB/ODBC Replication
I am trying to setup one-way, transactional replication from SQL Server 2008 R2 to PostgreSQL 9.1. I'm trying out the PGNP OLE DB provider.
I can successfully create a subscription, and transactions ...
0
votes
0answers
8 views
MySql shell command not replicated to slave [migrated]
I have a shell script that looks something like that:
#!/bin/bash
mysql -udb_user -pdb_password -e "LOAD DATA LOCAL INFILE '/srv/some_file.csv'
INTO TABLE db_name.db_table FIELDS TERMINATED BY ...
1
vote
1answer
49 views
Why does replication fail with error Duplicate entry for key?
We have been replicating for a year or two now with little problem. Sometimes we get an erroneous SQL query which stops replications, and we use the following commands to get it going again:
STOP ...
0
votes
0answers
7 views
How to check a properties for all replication on a server?
I have 15 database some of which are replicated.
Sometimes the replication on all clustered indexesfor all tables of one of my replication change its value to False.
I'd like to know if there is a ...
1
vote
1answer
17 views
One Way Replication of Oracle 11g to MSSQL 2008R2
We're in the midst of a major LOB system change which will use Oracle 11g, but we need to maintain a LARGE number of existing reports in SSRS.
What is a good method to automate a one-way, read-only ...
-1
votes
0answers
41 views
Distributing Server on the Internet with guarantied security [closed]
Possible Duplicate:
Distributing SQL Server on Internet regarding security issue
Solutions for distributing Website on SQL SERVER
Subject:
We are going to put our servers in two places to ...
9
votes
2answers
254 views
Expected performance of e-SATA port multiplication?
For a certain read/write workload, I get 30 MiB/s from a 4-disk array using esata port multiplication. When I move the exact same array to four individual sata connections, I get 90 MiB/s for the same ...
4
votes
2answers
153 views
Is there a safe way to bypass a non-replicating DC?
We have a domain controller that was virtualized a while back; this caused issues with replication that we're now seeing fallout from. I've moved the PDC Emulator and other fsmo roles to a new DC and ...
1
vote
2answers
113 views
Distributing SQL Server on Internet regarding security issue
We are going to put our servers in two places to keep high level redundancy and to avoid bandwidth critics. The two servers are on different LANs but communicate over a WAN network (via Internet). One ...
0
votes
2answers
49 views
SQL server backups - backwards situation
Hi I'd like to know if it seems feasible to do things in this manner.
We have several application servers (a web server for intranet applications, a couple of different app servers). Each server is ...
1
vote
1answer
178 views
How can I provide live replication of a Linux server?
I need to be able to do live replication of a running Ubuntu server, so if the main machine goes down I can automatically failover to the other machine. I found mklivecd, but that seems to only get ...
0
votes
0answers
48 views
Amazon RDS - Replicate single database (or some tables) only?
I am currently looking on how to set up replication for my application on Amazon RDS. I know that it is possible to have either read replicas for better read performance or Multi-AZ replication for ...
0
votes
0answers
54 views
Changing MySQL replication method in chained setup
I am trying to achieve a chained replication setup where the second master in the chain switches from row-based replication to statement-based replication. The reason for this is I want to ensure data ...
0
votes
1answer
25 views
Aggregating data from multiple MySQL servers
I have 10 MySQL servers and each one holds a database that needs to be replicated to a single, centralised MySQL server. The complexity is that each server must replicate its database to the same ...
3
votes
1answer
52 views
What are possible results/side effects if replication between DC's in a Windows domain is unable to occur?
There's plenty of administration literature out there how to properly manage Windows servers. But in dealing with real life, things don't always occur like you want them to. In Microsoft's Windows ...
4
votes
2answers
144 views
Way to avoid server downtime when creating Master - Slave relationship?
I am preparing for setting up a MySQL master-slave or master-master relationship. Right now I have a single MySQL production server, and of course I don't want a lot of downtime while I connect the ...
0
votes
1answer
79 views
Very poor optimization: Riverbed-Test-Appliance and NetApp SnapMirror replication
We are actually testing Riverbed Steelheads in order to accelerate replication using SnapMirror between two sites.
The distance ist 100km between the sites.
Connection: 150Mbit MPLS Network
Systems: ...
-1
votes
1answer
59 views
How to use AppScale
There are some wiki which explain how to install and setup AppScale.
But I didn't find anything related to the extensive use of AppScale. I mean, what to do in case of major outage ?
If the node ...
1
vote
1answer
49 views
DFS Replication, Losing folders
We lost a lot of folders in one part of our AD.
I tracked down that we get a lot of errormessages about this in this form:
How do we solve this?
Why does this happen?
(Some information edited)
...
0
votes
2answers
167 views
Run a MongoDB configuration server without 3GB of journal files
For a production sharded MongoDB installation we need 3 configuration servers.
According to the documentation "the config server mongod process is fairly lightweight and can be ran on machines ...
2
votes
2answers
63 views
multi-master replicated dynamic dns subdomains
For lack of a better title. Our environment requires having subdomains where we allow dynamic updates using bind as the DNS server and its nsupdate utility authenticating via keyfiles. We're looking ...
2
votes
1answer
57 views
Secure Microsoft Active Directory DC to DC communications through firewall boundaries
We are currently looking to flatten our AD structure a bit to make things a bit more manageable, but we still want to keep our security posture as near as possible to where it is now.
Currently, we ...
0
votes
1answer
13 views
2 databases locked, but only one can be successfully dumped (backed up do *.sql file) … fail
i have this situation
2 large databases on mysql server - srv1
I need to transfer both to new server - srv2
so
I use sql command "FLUSH TABLES WITH READ LOCK;" to stop all modifications
Then I ...
6
votes
1answer
82 views
Replacement for MySQL proxy
We have a standard MySQL Master/Slave replication for our database. In order to use the slave server we have set up MySQL Proxy. However we have been strongly discouraged to use it as it still alpha ...
1
vote
2answers
57 views
Server 2008 DC rejecting replication requests
Have a DC that has recently been part of a business continuity test. From what I understand the server (which is virtual) was snapshotted, test carried out while the link between the two sites was ...
4
votes
2answers
167 views
Multiple VPS with mirrored database and filesystem
I've developed interest in VPS clusters lately and it seemed like a great idea to try to set up a multi-VPS setup, which I will describe below. It isn't really meant for production use, but more as an ...
1
vote
1answer
51 views
Setup a mysql replication, but new data are not updated
I have setup a MySQL replication for an existing database server. The setup seems fine, but the database never update on slave server after I start the replication. Both servers are using CentOS 5.7 ...
3
votes
2answers
194 views
SAN replication
My company has only a single storage box (SuperMicro hardware + chassis with a LSI raid card and 12 SAS 7.2k drive) in its current setup. It runs on linux and we hook it up to our fileserver via ...
2
votes
3answers
55 views
Active Directory set up with replication — need a way to control login authentication host
I have two Active Directory servers set up with replication, ad2 and ad4.
ad4 has a higher latency than ad2 as it is offsite.
All clients are supposed to log in and authenticate to the ad2 server.
The ...
0
votes
2answers
80 views
How to ensure that a MySQL slave server is using the SSH tunnel to replicate from the master?
I need to secure MySQL database replication between two CentOS 5.7 servers. Server 1 has the live database, and replication is already working fine to Server 2 which is located elsewhere on the ...
1
vote
1answer
119 views
MySQL replication - Query is replicated even if explicitely ignored
I have a MySQL Master 5.0.77 replicating on a slave 5.5.13.
So I'm using STATEMENT based replication.
I have a query 'CREATE TEMPORARY TABLE blah' that is replicated even if it's not in the ...
0
votes
1answer
66 views
switching master with minimal downtime
Currently have a MySQL replication setup in which Master A is replicated on another server db Slave B.
I'm shutting down the server that hosts Master A and need to start a new server that houses ...
-1
votes
1answer
63 views
Domain controller replication and distribution
What is the proper way to distribute work from the pdc to a bdc for authentication.
If the bdc handles authentication, when it increments the bad password count, how is that relayed to the pdc? Does ...
1
vote
1answer
94 views
mysql replication - slave seems up to date but data not synchronized
I have a master-slave setup with 2 servers over a network. Due to an error, the slave IO thread stopped, though I could get it started and running, the slave is way behind the master. Also, SHOW SLAVE ...
2
votes
2answers
97 views
MySQL multi level replication breaks constantly
I have replication setup as follows
Master A ----> Slave B ------> Slave C
\-------> Slave D
\------> Slave E - H
I use this setup because I need a local copy at the office ...
1
vote
1answer
37 views
MySQL inconsistent data when using mysqlbinlog utility
I am having a problem in mysql replication.
I have a mysql raw data snapshot and my master host have 2 binary logs (binlog.01, binlog.02 - start to log after snapshot was created)
What I want to do ...
1
vote
0answers
51 views
sync multiple mysql databases on one master server
Which is the best way to sync multiple database on one central server? My idea is to implement on the central server multiple mysql instances and to create master - slave replication for each host ( ...
0
votes
2answers
45 views
MYSQL master-slave fail if slave behind proxy?
I have two linux machines, A and B. A is master and B is slave. Besides, B is behind proxy. In B , I have set http_proxy and socks_proxy env variable.
However, B cannot connect to A and report ERROR ...
0
votes
1answer
29 views
Bind slave creating domain without any records
i have the same version of Bind running on two different host. When a new domain is created it is also created on the slave but there are no records within the domain.
I am not sure what i need to do ...
4
votes
5answers
220 views
Need help with estimating required bandwidth for SAN array to SAN array replication over WAN
I have a long-term goal of setting up a DR site in a colo somewhere and part of that plan includes replicating some volumes of my EqualLogic SAN. I'm having a bit of a difficult time doing this ...
2
votes
1answer
64 views
DFS Replication across WAN
I have setup both sites in ADSS, set the subnets properly (I think), and setup a DFS share with replication.
How can I test that to see which physical machine I'm actually accessing when visiting ...
1
vote
4answers
194 views
Solution for two-way file-system transparent solution
I need to implement some sort of HA setup where 2 servers need to be able to always be in sync, no matter on which one you write on.
The DB part can be covered by a master-master replication setup.
...
0
votes
1answer
43 views
how mysql replication
I'm doing mysql replication (master - slave). There are a few questions
Can I assign replication for some databases and not all databases that are on master (for example, ON master server there are ...
