Replication is the process of sharing any level of information so as to ensure consistency between redundant hardware/software resources to improve reliability, fault-tolerance, and accessibility
1
vote
1answer
72 views
Replication issue - CREATE SELECT alternative?
I've an MySQL 5.1 slave for our BI team.
They need to make some CREATE SELECT with big select queries (several million lines).
As CREATE SELECT is a DDL, if the replication attempts to update some ...
1
vote
1answer
55 views
INSTALL PLUGIN 'rpl_semi_sync_master' SONAME 'semisync_master.so' not working
I'm trying to install semi synchronous replication in my mysql 5.5 and trying to execute the below command:
INSTALL PLUGIN 'rpl_semi_sync_master' SONAME 'semisync_master.so'
but this command is ...
0
votes
1answer
41 views
MySQL Replication using SSL
I am in the process of replicating my database so i can have a master slave configuration, one of the issues i have is with security i am basically generating my server/client keys and certificates ...
3
votes
1answer
132 views
SQL Server 2005 Replication
I am in the process of creating Replication between 2 Remote Servers, server 1 is the Distributor and Publisher and server 2 is the Subscription.
server 1 windows 2003 server 192.168.10.1 connected ...
0
votes
1answer
96 views
Create a mysql slave database from master database
I have a mysql master database running. I want to have a slave database. So, I stopped the master mysql database and copied it to the slave machine. I had bin log enabled on master so even those files ...
5
votes
1answer
361 views
Global locking for multi-master Oracle GoldenGate replication
This is a very complex scenario, but I figured a state-of-the-art challenge might interest some of the many high-end users of dba.se.
Problem
I'm working on an intercontinental data replication ...
0
votes
0answers
62 views
Single slave - multiple master MySQL replication?
I need to replicate different MySQL databases from multiple master servers into a single slave server. Have installed multiple mysql instances on single machine with 2 different my.cnf & my1.cnf ...
0
votes
0answers
31 views
High memory consumption using Bucardo tool
I am using Bucardo tool on PostgreSQL 9.0 with RHEL-6 as OS. Suddenly I have encountered high memory consumption and the database is running slow. So I had stopped and restarted PostgreSQL; this ...
2
votes
1answer
106 views
How to choose a good value for MySQL relay-log-space-limit?
I just read this blog post about relay-log-space-limit on MySQL. I am convinced that the 'unlimited' default is indeed not very good. But how do I choose a good value for it?
We are using ...
3
votes
2answers
156 views
SQL Server replication for off site copy
We have our Primary SQL Servers in-house (15 primary servers at the moment (500 databases approx overall), most of the servers have hex core processors).
These are mirrored to other backup servers in ...
1
vote
2answers
51 views
MySQL: Adding Routines to a Slave
While setting up the MySQL replication, I took the mysqldump (without--opt --routinesoptions) unaware of the fact that in mysqldump, --routines it is NOT enabled by default.
Questions
Is there any ...
3
votes
1answer
84 views
Replication between SQL Server 2005 and Azure database
Is it possible to set up transitional replication between a SQL Server 2005 and a SQL Azure database?
My server is nearing end of life and I would rather migrate to a cloud infrastructure instead of ...
2
votes
1answer
75 views
How can I disable utf8mb4 entirely on MySQL 5.5?
I know you're not supposed to do this, but I have a MySQL 5.5 master and a MySQL 5.1 replication slave. That's supposed to be okay, unless I do something stupid like use utf8mb4 that isn't supported ...
1
vote
3answers
98 views
Anyone want to try a script bash or python?
I need to automate master binary log purging to occur so that purging never goes back further than the last slave has the updated info for.
These slaves are mobile and there are 3 of them, and sync ...
4
votes
1answer
249 views
Is PostgreSQL replication production ready?
How does PostgreSQL native replication compare to MySQL?
I know asynchronous replication has been supported for longer than sync, which is recent. Is synchronous reliable to be used in real projects?
...
0
votes
0answers
55 views
Oracle: Mirror database changes between two databases
I need to keep two whole databases constantly synchronized.
That includes:
Data (of course)
DDL Changes (also changes to stored procedures and pl/sql packages)
All changes need to be propagated ...
3
votes
0answers
98 views
How to replicate from SQL Server 2000 to SQL Server 2008 R2?
I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber.
I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine.
Primary key fields are not ...
1
vote
1answer
151 views
Automatic MySQL Sync from master, where Slave was offline for long period of time
Does anyone here know if there are any tools, not using mysql's built in replication that will sync up two databases when the slave has been inaccessible from the internet for extended periods of ...
0
votes
1answer
73 views
Master Slave Replication in Mysql
I have generated a dump from Master and I have to construct slave and give privileges and binary log position and file name of master for it to obsorb from master. Master is a high transaction OLTP ...
3
votes
1answer
58 views
Cannot delete publication
When attempting to delete a publication, I am getting the error cannot drop publication 'XX' cannot drop article 'XX'.
The subscription has been deleted at the subscriber. Any ideas on how I can ...
1
vote
0answers
211 views
SQL Server Troubleshooting Replication and Long-Running fn_dblog query
I am trying to get (pull) Transactional Replication working again for a subscriber.
Currently, in Replication Monitor I am seeing messages in the Publisher to Distributor tab and the Distributor to ...
1
vote
1answer
89 views
Postgres: Can the archive command for master and standby point to the same directory?
I use streaming replication and PITR (WAL files) in my cluster, currently I have different versions of postgresql.conf for the master and the standby server.
The only difference in the files is the ...
1
vote
1answer
103 views
Master to Slave to Slave Configuration in MySQL
We currently have 3 MySQL Servers running;
the first which contains production data and is due to be retired
mysqld Ver 5.5.28-0ubuntu0.12.04.2 for debian-linux-gnu on x86_64 ((Ubuntu))
mysql> ...
1
vote
0answers
129 views
Transactional Replication Over Domain
I am trying to setup transactional replication in SQL Server 2008 R2 on two servers on separate domains. I am able to create the distributor, create the publication, and create the subscription, ...
4
votes
1answer
73 views
How can I determine the date of a snapshot in SQL Server 2008r2?
I am working on implementing an ETL process to load data into a warehouse.
Part of this process is pulling data from our production server (Server P) to a staging server where the actual load into ...
1
vote
1answer
40 views
How to change the replicate_*_table variable without modifying my.cnf?
what is the syntax of replicate_*_table without having to modify my.cnf file?
and do i need to restart mysqld for changes to be applied
1
vote
1answer
67 views
sp_startpublication_snapshot Parameter(s)
I am creating a stored procedure that:
Restores a DB from a .bak giving the .mdf and .ldf a new name (so we have have several copies of the same DB up
(If specified in the SP's parameter) Creates ...
2
votes
1answer
157 views
replicate-wild-ignore-table does not stop already logged queries on slave
We have a master DB where where multiple queries where fired on a specific table, these queries were taking too long to execute on slave and it was lagging behind and as a result of which queries were ...
1
vote
1answer
120 views
Replication and linked server security
I have three servers: P1, A1, and R1. P1 and A1 are production oltp servers. On each there are two databases that are being replicated down to R1 for olap (mostly SSRS reports). I am working on ...
1
vote
2answers
63 views
Change the Existing Topology of a MySQL Replication Setup
I want to be able to edit the topology of an existing replication, is that possible?
For example if I have a star topology, I want to edit it to make it a ring one.
How can I do that?
I'm thinking ...
1
vote
1answer
86 views
PostgreSQL replication
I have two projects working on different databases. The problem is: I need to replicate changes in the databases only for a few tables. I need it to synchronize the data.
Need an advice how can I ...
1
vote
1answer
236 views
MySQL master/slave replication… structure not being replicated
Edit: I might have answered my own question while going back thru the links for this post. I would still like to get insight from more experienced DBA's and perhaps make the information easier to ...
2
votes
1answer
77 views
Does sp_droparticle @force_invalidate_snapshot=1 invalidate the entire snapshot?
Forgive this simple SQL Server question, but if I just want to remove a single stored procedure from snapshop replication (2008 SQL Server R2), if I call sp_droparticle, will it invalidate the entire ...
2
votes
2answers
344 views
Oneway sync of two SQL Servers via FTP
I need to replicate data from a ‘master’ SQL Server out to a number of replicas. Luckily the data only flows from the ‘master’ to the replicas.
I need to replicate both schema and data. Data size ...
7
votes
0answers
530 views
mysql 5.1.66 SSL connection error ERROR 2026 (HY000)
UPDATE2
Using WireShark I found out the problem string (I hope I did):
28 | 9.582638 | 192.168.18.128 | 192.168.18.129 | MySQL Response Error 1043
And the error is (according to docs):
Error: 1043 ...
2
votes
1answer
238 views
mysql statement based replication - unsafe statements
I have recently set up statement based replication and my error logs are filling up with this error
121231 21:10:55 [Warning] Unsafe statement written to the binary log
using statement format ...
3
votes
1answer
323 views
How does Postgres 9.2's streaming replication handle schema changes, and initial table setup?
I want to set up a backup database on the physical server which sits right under my primary physical database server. I'm using Postgres 9.2, and I want to use synchronous, streaming replication (for ...
0
votes
2answers
510 views
Master - master replication not working
I configured two WAMP servers running on different machines for master-master replication. I am using a linksys router for the network. I created a wireless network, but one of the server boxes ...
0
votes
3answers
446 views
Automatic MySQL Replication Fail-over Strategy
I want to know that if replication is down due to some reason as if master is down then what strategy should be followed so that the replication is up instantly without manually intervening the ...
1
vote
0answers
248 views
SQL Server Database Replication - Master / Slave configuration [closed]
I have a database server, SQL Server 2008, that's inside a private network. Now I need to make a database there available for a web server for my web application so that people don't need to come to ...
6
votes
1answer
719 views
Upgrade SQL Server 2005 to SQL Server 2012
I have a test environment set up with the following:
Virtual Machine (Hyper-V)
Windows Server 2008 R2 SP1(x64-bit)
Windows SQL Server 2005 Developer Edition SP4 (x64-bit)(default instance name)
1 ...
1
vote
1answer
147 views
Mysql database replication (failover solution)
Is there anyone know how to do "mysql database replication" with appfog ? In simple word, just want to use 2 databases sync (2 locations) and set one as master database, and other one as slave. if ...
1
vote
1answer
427 views
MySQL Replication and High Availability
I know this might not be a very good question to be asked in this site, but I really need some helps/hints to be directed to the right path.
I want to have failover strategy for 2 MySQL servers which ...
1
vote
2answers
166 views
Mysql replication - Error No. 1146&1062
short version
In master master replication, How to have one master write data with odd IDs and the other one with even IDs? Is it the way to avoid conflict?
detailed version
I wanted to setup a ...
2
votes
1answer
140 views
What causes Transactional SQL Server Replication to need to be rebuilt/re-initialised
In a company I've recently joined we have two SQL Server instances, connected via transactional replication. I'm a developer and hadn't really come across SQL replication before so am a complete ...
1
vote
1answer
132 views
oracle streams apply: how to get a reason why LCR message was not applied
I've set up bidirectional oracle streams replication (11gR1) using identical scripts on both machines (DB1 and DB2). Although changes from DB1 are being applied to DB2, changes from DB2 to DB1 aren't.
...
1
vote
1answer
266 views
How soon after updating expire_logs_days param and restarting sql will old binlogs get deleted?
MySQL 5.1.x | InnoDB | Windows
My mysql data directory is starting to fill up with bin logs.
I currently have the following settings configured in my windows mysql server:
[mysqld]
log-bin
...
1
vote
1answer
151 views
Set up replication and migrate to InnoDB with low downtime
Current situation is this:
I have a large legacy DB using only MyISAM tables, the size of whole
DB is 4GiB, one of the tables contains over 10 million rows, so it is
pretty large.
The database is ...
1
vote
2answers
88 views
MySQL replication - some values are not being replicated
MySQL Replication issues
I might sound clue less here as i am :) , I am having problem with mysql replication, i.e. replication seems to be missing in some random occasion.
My structure looks like:
...
5
votes
0answers
98 views
9i streams capture doesn't evaluate rules
I have a streams replication set up between two oracle 9.2.0.8 instances as sources and an 11g instance as a destination, processing a small subset of data from each database (let it be one table ...
