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
0
votes
1answer
10 views
Will creating a view on a MySQL replication slave break the replication?
We need to run some very ugly queries on a MySQL replication cluster.
Does anyone know if creating a view directly on the slave will break the replication of the other, otherwise untouched data ...
0
votes
0answers
5 views
Setting master user not working in MySQL
I am follow these instructions to set up a master user in MySQL:
Log in to your Slave server with root privilege as:
mysql -u root -p
Create a new database named magentodb and import the ...
1
vote
1answer
10 views
Percona Node fails to join: Operation not permitted
Joining a new Percona node fails with:
130521 7:15:44 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group ...
2
votes
1answer
11 views
How to schedule PostgreSQL replication?
I was reading postgresql replications solution but, even I just starting understaning how it works, another doubt has arrisen.
I'll be using postgres internal replication solution but as far as I ...
1
vote
2answers
34 views
Replicating schema changes between production and development databases [duplicate]
Not too sure if this would be a good and proper way to go about things, so I apologize if I'm kind of far off.
Currently running Microsoft SQL Server 2005, and in this we have a database for a ...
0
votes
4answers
32 views
Master/Slave without populating tables
So I have some Zabbix instances which are using MySQL for their backends. What I would like to do is, for DR purposes, backup the DBs for each instance using a Master/Slave configuration, with the ...
2
votes
2answers
1k views
MySQL Replication Lag Behaving Erraticly
I've got a vanilla MySQL replication, using "MIXED" mode.
The mysql slave lag calculation behaves very strangely - one moment it is 0 and the one after it it's 3630 seconds (or a similar number), ...
1
vote
0answers
24 views
Which one to use? InnoDB Replication or MySQL Cluster?
I am building a url shortener and I use InnoDB as the storage engine for link data. I will start with a single VPS containing both application instance and MySQL database instance on the same Virtual ...
0
votes
1answer
67 views
MySQL replication between VPS and shared host
I have a VPS where I have ssh access and shared host with CPanel. Both have MySQL.
I need to create a master/slave setup among the two server.
As per this tutorial: How To Set Up Database Replication ...
0
votes
1answer
51 views
MySQL Slaves lag behind master
I have one master and four slaves. Sometimes all my slaves lag behind the master. I have implemented the heartbeat for monitoring replication lag. Now I am trying to find why the slaves are lagging ...
0
votes
2answers
95 views
Replication on MySQL server
I had to stop the slave server to test something. After I started the server again there is a problem with replication on MySQL server
On the problematic server
mysql> SHOW SLAVE STATUS\G
...
0
votes
2answers
36 views
MySQL Master/Slave. Actual use of Slave Machine
We have a MySQL server running in a mobile production trailer. The trailer is out on the road for weeks at a time. We have cell internet and wifi access is nearly all of our locations. Our office ...
0
votes
1answer
44 views
MySQL replication using a lot of IO
I'm having big troubles on a database pool I've setup recently.
There is a master, and 4 slaves replicating one DB. All using MyISAM engine.
Thing is, during the replication period (when the slave ...
0
votes
2answers
65 views
How can I replicate some tables without transferring the entire log?
I have a mysql database that contains some tables with private information, and some tables with public information.
I would like to replicate only the tables containing public information from one ...
0
votes
1answer
34 views
Do I need client certs for mysql ssl replication?
I'm setting up mysql replication using SSL, and have found two different guides.
The first one creates both client and server certs, while the second one only creates server certs.
I don't know ...
0
votes
1answer
22 views
replication breaks after upgrading master
I have a set up of replication with master 5.1.30 and slave 5.5.16
and the replication is working good
Now i have upgraded mysql master to 5.1.47
As far as i know we have to turn off the log bin ...
0
votes
1answer
25 views
distribution.dbo.MSdistribution_history comments explanation
The comment column of distributor.dbo.MSdistribution_history contains comments such as
<stats state="2" fetch="11554" wait="214007" cmds="17898546" callstogetreplcmds="106880">
...
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 ...
2
votes
2answers
340 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 ...
1
vote
0answers
26 views
How to sync mysql remote database daily ?
I have a database that contains orders , products ..etc. I have another system that generates reports based on this database. Due to heavy load i want to separate those systems Where i have the master ...
0
votes
1answer
36 views
Syncronize mysql databases between local and hosted servers automatically
We have many website with Development , Staging and Production Server. we have many developers for many projects, we need a solution to synchronize the database with developer database with staging ...
0
votes
1answer
24 views
How to install and configure Postgres-XC in windows?
Can anybody suggest me any resources of the complete installation procedure of postgres-XC in windows. I've installed postgresql-9.2 in my windows and can use it. Now I need to know the installation ...
0
votes
2answers
51 views
mysql replication successful but slave not replicating
I have created a mysql master-slave configuration and things look fine .
the " show master status;" on slave doesnt show any error . this is the output
Slave_IO_State: Waiting for master to send ...
2
votes
2answers
341 views
MySQL Data Synchronization
I have a user who will be away from the office for a while, but still wants to be able to insert a load of records to our MySQL database. The user will have a laptop, but no reliable internet ...
1
vote
1answer
52 views
SQL Server-MySQL master-master replication
We are looking into setting up a master-master replicated MSSQL database and I am interested to hear of any potential pitfalls that we may run into along the way and generally any advice that you ...
4
votes
1answer
100 views
Installing and enabling both master and slave semisynchronous plugins on same server
I want to run a semisynchronous replication setup, and for simplicity I'd like to not have to INSTALL and UNINSTALL plugins when a slave is promoted to a master. So I'm wondering if I'll experience ...
0
votes
1answer
59 views
Breaking Semisynchronous Replication in MySQL 5.5
I've set up Semisynchronous Replication between two MySQL 5.5 servers running on Windows 7.
My application is running and updating the database of the master server and same is being updated in the ...
1
vote
2answers
148 views
mysql replication delay very serious
We use a ssd disk for master database and SATA disk for slave.
On high write load (300 writes/s), slave delay is very serious. I have set:
innodb_flush_log_at_trx_commit = 0
increased ...
1
vote
1answer
48 views
Merge Statement + Replication difference for SQL Server 2012
We have a SSIS package that will pull from a source database and run a merge statement to put the data into a "Master" database. (Eventually the "Master" database will be the source of truth, but we ...
0
votes
2answers
279 views
How to sync MySQL database between two servers
I need to sync a MySQL database between two servers.
If a new record will be added in server A, then server B fetch new record.
If a new record will be added in server B, then server A fetch new ...
1
vote
1answer
120 views
Master updates Slave but not Master itself
I have a setup master/slave in which applications are pointed only to master. Yesterday Master had got crashed due to "multi bit error on dimm detected" in Front indication panel in orange color.
...
2
votes
2answers
37 views
Modifying replication distributor & publisher
I have a SQL Server 2008 transactional replication setup as follows:
192.168.100.1 <-- Distributor
192.168.100.2 <-- Publisher
192.168.100.3 <-- Subscriber
Our network team want to change ...
0
votes
1answer
37 views
MySQL Replication and Triggers
I have stumbled upon an interesting MySQL Error message that I do not really know how to interpret.
The setup:
There are two tables A and B.
When data is written or updated in the table A, then a ...
3
votes
1answer
72 views
PostgreSQL replication for archiving
I've looked around a bit and haven't found a very clear strategy or method for what I'm trying to do, which is surprising because I would think it would be a fairly common practice.
I currently use ...
0
votes
0answers
14 views
Is it possible to upgrade mongodb cluster without upgrading arbiters?
Is it possible to have running real nodes with version 2.4 and arbiter nodes with 2.0 or 1.8 in the replica set?
Upgrade guides for version 2.2 and 2.4, did not tell anything about upgrading ...
2
votes
1answer
63 views
Bi-directional replication for the same MySQL table
AppA stores/retrieves data from dbA.tableA
AppB stores/retrieves data from dbB.tableA
tableA definition is the same across these databases. To start with dbB.tableA was copied from dbA.tableA ...
2
votes
1answer
56 views
Is replication from SQL Server 2008 to PostgreSql possible?
Is it possible ? Sql Server as publisher(master) and PostgreSql as slave(subscriber) ? Any type of replication really.
1
vote
1answer
168 views
How to run a cold backup with Linux/tar without shutting down MySQL slave?
I run the following before tar-ing up the data directory:
STOP SLAVE;
FLUSH TABLES WITH READ LOCK;
FLUSH LOGS;
However, tar will sometimes complain that the ibdata* and ib_logfiles* files are ...
2
votes
2answers
48 views
Does MySQL 5.6 support fan-in replication?
I've known for quite awhile that Continuent's Tungsten Replicator supports fan-in replication (example).
By fan-in replication I mean combining multiple datasources into a single instance (like a ...
0
votes
0answers
31 views
MM Replication and Zabbix in slave, Error code 1032
I have multi-master replication and using Zabbix for server monitoring. Since the replication is row based, I get this error in slave everytime which also breaks my replication. The error I get is:
...
1
vote
1answer
82 views
Does Pt-table-checksum point out rows that are different from that of the Master
Trying to verify replication integrity of my replica. And I found that pt-table-checksum is one of the best ways of doing it.
I have a simple Master->Slave set up. Have created a sample table with 10 ...
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 ...
2
votes
1answer
89 views
mysql second slave not syncying while first slave works fine
I have a master (m) - slave (s1) setup using mysql 5.1.45
When I try to add a second slave (s2) the slave lags behind and never catches up on the sync.
Even after having synced the s2 with the whole ...
0
votes
0answers
25 views
Oracle to SQL Server DDL replication
We have this customer requirement to do DDL + DML transactional replication from Oracle to SQL Server 2012. The DML part is straightforward. There are multiple options to choose from including the SQL ...
1
vote
2answers
57 views
How to avoid lagging when enabling log-slave-updates?
Master:
48GB RAM
16-core
my.cnf: https://clbin.com/hlkUo
Slave:
64GB RAM
24-core
my.cnf: https://clbin.com/viLm0
Both are running 5.5.28.
For the incremental backup purpose, I need to enable ...
3
votes
1answer
324 views
How to script out push subscription creation at the subscriber?
I'm trying to set up a push subscription to a SQL Server publication from the subscriber.
I could set up the subscription at the publisher using the Replication Wizard in Management Studio. However, ...
1
vote
1answer
71 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 ...
0
votes
1answer
33 views
Is it possible to have extra tables in a Slave with MySQL Replication
As my title mention I have a Master and a Slave database.
Master if for operations data and my slave mainly for reporting stuff.
The issue is that I need to create extra tables on reporting that ...
0
votes
0answers
48 views
PostgreSQL: Slave doesn't replicate the Master's data
I'm using PostgreSQL 9.2.3 on both computers, both of which run Win2008R2. I've setup streaming replication by following this guide: ...
2
votes
2answers
121 views
MySQL replication: most important config parameters for performance on slave server?
I'm setting up a mysql master-slave configuration, where slave is located on a much weaker sever.
Since, if I understand correctly, slave only works on updates/inserts, what are the most critical ...
