Questions tagged [replication]
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
373
questions
8
votes
1
answer
11k
views
MySQL high availability, failover and replication with Latency
We are in the process of implementing a new CMS (Drupal 6.x) that runs on MySQL. We have two data centers -- primary and secondary -- with known latency between them. We're unsure which version of ...
- 1,367
4
votes
3
answers
2k
views
mysql replication master 5.5 slave 5.1 error on create database
I have a replication system where my master has a mysql 5.5 version while the slave is mysql 5.1. I know that this is not supported because the slave version should be greater than the master, but we ...
- 155
15
votes
1
answer
9k
views
SQL Server Many-to-One replication
I have 8 individual SQL Server 2008 R2 machines, each hosting 1 database. Each database has an identical table structure and schema, and entirely unique data.
I would like to establish a reporting ...
- 245
8
votes
1
answer
4k
views
MySQL master binlog corruption
We recently made some changes to our infrastructure and now I can't keep MySQL replication running. The slave complains of a corrupt binlog and resetting it doesn't help. I keep seeing entries like ...
Joseph Yancey
11
votes
3
answers
7k
views
Is MySQL Replication Affected by a High-Latency Interconnect?
We've got a vanilla master and slave MySQL setup that reside in different data centers, and another slave in the same datacenter as the master.
The bandwidth between the datacenter is pretty high (in ...
- 315
7
votes
2
answers
11k
views
Setting Circular Replication in mysql
I have 3 MySQL servers say A,B,C.
What I want to do is that I want to make all of them master as well as slave.If there is update on any of the MySQL Servers it should be replicated to all of the ...
- 9,717
2
votes
3
answers
2k
views
MySql shell command not replicated to slave
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 ','...
Ran
9
votes
1
answer
13k
views
Best solution for cross-datacenter MySQL master-slave replication
We are working on a new system architecture for our company. We have a HPC, which runs in our own data-center and we are planning our front-end and a fallback system on Amazon Web Service.
System ...
- 307
7
votes
1
answer
22k
views
Best way to setup master to multi master replication
ORIGINAL QUESTION:
I have multiple servers that all need to act as masters, as if one fails the next server kicks in and takes over. I'm just wondering what the best way to replicate is. All servers ...
- 171
6
votes
2
answers
5k
views
Scaling Percona datacenters: setup and replication
Since our startup has taken off nicely we are now meeting with some of those issues that you always assumed would NEVER effect you.
We have already scaled alot of our application stack: we offloaded ...
- 300
18
votes
2
answers
3k
views
What can we do in MySQL 5.0 Replication to address bandwidth concerns?
I am developing an application to run on the client PC (Win) which is configured with a MySQL server 5.1 instance that will act as read-only slave to the remote master. The remote master has dozens of ...
- 283
13
votes
3
answers
26k
views
Replication Monitor Information using T-SQL
The image below shows a transaction replication problem that I am currently investigating.
The image comes from the Replication Monitor.
How can I get this information using T-SQL?
- 16.4k
8
votes
1
answer
3k
views
Can I have an InnoDB master and MyISAM slaves with Full-Text for searching?
I'd like to use InnoDB on the master, for its transactional ability, but MyISAM on the slaves for the full-text search ability. Is this possible?
- 8,543
7
votes
3
answers
31k
views
SQL Server replication subscriptions marked as inactive
Is there any way to force SQL Server NOT to mark subscriptions as inactive, ever?
It happens sporadically when there are connection issues and I don't want to have to reinitialize the subscription ...
- 251
5
votes
4
answers
28k
views
Single slave - multiple master MySQL replication
I need to replicate different MySQL databases from multiple servers into a single slave server. How can this be done? is there a way to define multiple master hosts?
Karthik
11
votes
3
answers
20k
views
How do you re-sync the Master MySQL DB with Slave DB changes if the Master goes offline?
MySQL Server 1 is running as Master.
MySQL Server 2 is running as Slave.
With both DBs online, they are in "perfect sync". If Slave goes offline, there's no problem if Master still online; they will ...
Tiago
5
votes
1
answer
1k
views
will replication from 5.5.20 to 5.0.XX server work?
I gave two machines which run on two entire different versions of MySQL server. I want to do the replication from 5.5.20 to 5.0 server. Will that be possible?
Because I remember when I transferred ...
- 565
5
votes
1
answer
2k
views
MySQL Replication : 1 Slave / Multiple Masters
I have a web app with 2 web servers and 2 database servers.
The DBs are setup for multimaster replication. (this is the primary environment)
I also have the exact same setup on a different location ...
- 153
4
votes
1
answer
8k
views
Mysql Master-Master Replication Topologies on >2 machines
I have 3 Mysql servers that I would like to replicate: two (including the main server) are local and one is remote. Let's call my main server A, the secondary server B, and a remote, development ...
- 849
2
votes
2
answers
3k
views
Mysql database replication on different vlan/subnet/another site
Saw the posts for "MySQL high availability, failover and replication with Latency"
Is it possible to work it in a DR site when its not in the same vlan?
- 21
150
votes
4
answers
252k
views
Is it safe to delete mysql-bin files?
I have MM Replication in mysql, and I want to squeeze some free space in the box be deleting unnecessary files, I came across these mysql-bin files inside /var/db/mysql/ There are hundreds of those ...
user18530
21
votes
3
answers
66k
views
What max_allowed_packet is big enough, and why do I need to change it?
I have MySQL (5.5) in master-slave setup and created another slave server.
I stopped the original slave, dumped the data, copied and reimported and it worked fine. I noted the master_log pos of the ...
- 471
13
votes
5
answers
5k
views
Is it unwise to run replication on same physical server?
I'm contemplating setting up a Master-Slave replication for my database. The slave server will be used for redundancy and possibly a reports server. However, one of the biggest issues I'm running into ...
- 23.5k
11
votes
6
answers
98k
views
How to fix a messed up replication on MS SQL Server
I restored a database from a backup. The database uses replication to publish to a different server. Assuming the database restore would break the replication, I tried to delete the replication and re-...
- 371
9
votes
1
answer
4k
views
PostgreSQL Failover - What tools should I use?
Here is the scenario:
There are two machines running CentOS 6.2 - machine0 and machine1
Both have PostgreSQL 9.1 installed.
One of them should be active, as a master system and through asynchronous ...
- 568
9
votes
5
answers
10k
views
One slave, multiple masters MySql
Is it possible to set-up MySql Replication to have one slave listening to two different masters?
- 193
9
votes
2
answers
34k
views
What can cause TRUNCATE TABLE to take a really long time?
I'm running MySQL5.5 with Master/Slave replication (1 master, 2 slaves).
I have a process that runs once a week and truncate a specific table. The table is not large and only has a few thousands ...
- 1,563
7
votes
4
answers
4k
views
MySQL Replication - Introduce new Slave to replication
I've recently taken on a sys admin position managing a group of 20 (or so) servers. One thing I haven't dealt with before (apart from in a test situation), is introducing a new slave to the MySQL ...
- 71
5
votes
1
answer
10k
views
How to setup replication(Master/slave) in MySQL 5.5.20?
I have two servers both running on MySQL 5.5.20 and I want to setup replication, so every update/insert on Master would reflect immediately on Slave machine.
I tried following this tutorial (I used ...
- 565
3
votes
1
answer
7k
views
Fixing tables out of sync as reported by pt-table-checksum, pt-table-sync is not working
I have several tables being reported by pt-table-checksum with CRC_DIFF between my master and slave servers using the following commands:
$ pt-table-checksum h=master,u=user,p=password --empty-...
- 474
1
vote
2
answers
1k
views
mysql master slave replication scenario
We are creating a new mysql slave, but for dump we are taking from a backup server which is a slave of current master. Now to enable replication we want to connect it with the master so should I take ...
- 367
30
votes
2
answers
53k
views
What is the safest way to switch the binlog format at runtime?
Because of the following warning in mysqld.log:
[Warning] Unsafe statement written to the binary log using statement
format since BINLOG_FORMAT = STATEMENT. The statement is unsafe
because it ...
- 1,006
15
votes
3
answers
43k
views
Trying to understand SHOW SLAVE STATUS in MySQL
I have a Master-Slave replication setup and it looks like that it is running fine. Below is a result of SHOW SLAVE STATUS command:
show slave STATUS\G;
*************************** 1. row *************...
- 979
14
votes
2
answers
27k
views
What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?
I am very new to Database Administration.
I face a lot of problems while setting up mysql master-slave replication.
I also face regular mysql replication troubleshooting issues.
Can anybody helps ...
- 9,717
9
votes
3
answers
18k
views
Can we capture only Slave_IO_Running in SHOW SLAVE STATUS in MySQL
I wanted to capture only status/result of Slave_IO_Running and Slave_SQL_Running column values, which I will be using to integrate into our application.
Is there any way to get only the values of ...
- 1,007
6
votes
1
answer
4k
views
Replicate MySQL 5.0 Master to 5.5 Slave?
We're planning out a series of server/software upgrades and were curious.
We have a RHEL5 install running MySQL 5.0 that we'd like to replicate to a new (virtualized) server running CentOS 6 and ...
- 759
6
votes
1
answer
7k
views
MySQL Slave Relay Logging but not logging Binary Log
I have a master slave setup both mysql 5.5, the setup is fine except that the slave won't Binary log to the standard mysql-binlog only to the relay logs. I fear this may be due to my lack of ...
- 63
6
votes
2
answers
23k
views
Set up a MySQL slave using mysqldump to get the initial data
I have a master database which already has some data in it. The tables in the master database include both MyISAM and InnoDB engines. Now I want use mysqldump to dump the initial data of my slave ...
- 2,042
5
votes
3
answers
3k
views
How to resolve the master server shut down/unavailability in mysql with master - slave replication
Let us suppose that we have a master/slave setup and the application is running fine for the time being. All of a sudden the master server suddenly shuts down due to some problem.
Now how can I ...
- 814
5
votes
3
answers
3k
views
With MySQL Replication, what level of resilience is possible?
I've found lots of good material on setting up MySQL replication, but not much on what to do in the event of failures. Understanding the degree of resilience I can achieve is fundamental to designing ...
- 151
5
votes
2
answers
5k
views
How to handle the My SQL DB Master to Master replication when there was a disk space outage
We had master to master replication with two node nodes A & B, both are in virtual environment. Initially there was an outage (diskspace issue) in node A and stopped replication. Application level ...
4
votes
2
answers
3k
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), ...
- 315
3
votes
1
answer
2k
views
Setting up MySQL circular replication in existing replication topology?
I have the following MySQL replication topology set up for fault tolerance/disaster recovery with master server A and slaves B and C:
A replicates to B
A replicates to C
Both B and C are fully up ...
- 63
3
votes
2
answers
2k
views
MySQL 5.6 showing wrong "second_behind_master"
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.10.7.98
...
- 93
3
votes
2
answers
7k
views
Loading data in mysql using LOAD DATA INFILE, replication safe?
I am trying to load data into mysql database form CSV file. I found that we could use LOAD DATA INFILE command to do it. But as per the mysql documentation it is not replication safe. (See here)
Is ...
- 133
2
votes
1
answer
573
views
mysql emits BINLOG rows even though binlog_format=STATEMENT
We have MySQL 5.5 installed, we have the binlog_format=STATEMENT (the default)
According to the MySQL Documentation, the binary log should contain SQL statements only, but we still see BINLOG rows in ...
- 175
2
votes
1
answer
982
views
Maatkit shows the MySQL replication error in one table, but won't fix it
We use MySQL 5.1 with a primary/secondary replication setup. I use mk-table-checksum from Maatkit to generate checksums on the master and perform consistency checks on the replica.
mk-table-checksum ...
- 197
1
vote
2
answers
3k
views
MySQL Community Edition: Can I replicate my entire server with another server in one go?
I need to migrate all the databases from one server to another. There are about 100 databases, and all databases are used daily and updated/inserted too and read through their respective websites.
...
- 143
1
vote
1
answer
2k
views
Native checksum table says there's a difference, pt-table-checksum does not
I was setting up a slave and doing some table checksums to check things were ok before getting them live.
I did a native mysql checksum tables on the slaves after syncing slaving to a stopped point ...
- 5,273
83
votes
7
answers
194k
views
How do I completely disable MySQL replication
I am running dual master MySQL replication and now want to move to a single database with no replication. How do I completely disable replication on both databases?
David Collie