Tagged Questions

2
votes
2answers
906 views

--log-slave-updates is OFF but some updates are still logged to the slave binary log?

MySQL version 5.5.14 According to the document, by the default, slave does not log to its binary log any updates that are received from a master server. Here are my config. on the slave: # egrep ...
3
votes
2answers
624 views

How to slave real-time data from two MySQL sources merging in to one MySQL destination?

I have two different MySQL instances that I would like to 'slave' to a third instance. (so I can do easy joins on the third instance) eg. mysql1> show databases db1 db2 mysql2> show databases ...
1
vote
1answer
128 views

making slave server as master for another server

I have three servers, Server X, Y, and Z. I have the main mysql DB on X (innodb DB). now I have created Master-Slave from X to Y. everything is working fine here. and now i set Y as a master for Z. ...
0
votes
2answers
79 views

MySQL Master Slave Replication Not Working

I setup MySQL master slave replication, but none of the databases, tables, and data is being copied over to the slave from the master. Here is the relevant configuration on the master: server-id=1 ...
1
vote
1answer
252 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 ...
0
votes
0answers
298 views

Error 'Unknown table engine 'InnoDB'' on query. after restarting mysql

I have mysql DB on server S1 (mysql version 5.1.41-3ubuntu12.7-log), i have created master-slave for this DB on server S2 (mysql version 5.1.54-1ubuntu4-log). the DB on S1 was using one data file ...
3
votes
2answers
318 views

Online Schema Change Strategies for Large MySQL Tables

I'm curious to hear strategies and methods people use for performing alters on very large tables in MySQL. Large could be any number of rows or size that would be impacting to alter. For the sake of ...
1
vote
3answers
403 views

MySQL slave reporting incorrect values for Seconds_Behind_Master

I have a MySQL slave that when it is 0 seconds behind the master, it correctly reports 0 Seconds_Behind_Master. However, if it gets even 1 seconds behind, it reports 14401 Seconds_Behind_Master (which ...
4
votes
2answers
2k views

MySQL slave replication reset with no Master Downtime (using MyISAM)

Root of the issue: In all instructions for creating a slave on a running master requires flush tables with read lock. We use MyISAM, so we can't just use --single transaction to get consistent table ...
1
vote
1answer
161 views

Erratic Seconds_Behind_Master

One of my MySQL slaves will at one moment, report 57 seconds behind master, and the next will show 0. I am also monitoring with mk-heartbeat which shows an average of less than 1 second. MySQL and ...
0
votes
1answer
28 views

mysql - replicating to db with a different name

Can a mysql db named statsDb on server1.example.com be replicated to a db named newNameDb on server2.example.com ? server2.example.com already has a statsDb. Thanks for your help.
0
votes
1answer
88 views

High Availability MySQL question

So I'm currently testing a new DB topology before moving it into a production environment, and I've run into a rather odd problem. The current setup is as follows: 5 server instances. 2 are MySQL DBs ...
0
votes
1answer
28 views

add additional mysql master

I currently have 2 mysql servers running, 1 as master and 1 as slave as in the mysql manual http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html master->slave What I want to do is add a new ...
3
votes
2answers
276 views

Why does MySQL replication break on missing row, then continue after “START SLAVE”?

The title is a bit confusing, but I can't think of a better one. What I have is a simple vanilla MySQL replication, with the slave occasionally failing, with this error: Error 'Can't find record in ...
3
votes
2answers
894 views

mk-table-sync in a master-slave scenario: Changes not replicated to the slave

I have being employing mk-table-sync to synchronise tables from a master to slave on mysql 5.1. Unfortunately, while differences are correctly detected, modifications done on the master ...
4
votes
3answers
5k views

Automated failover strategy for master-slave Mysql replication - why would this not work?

I'd like some feedback about this failover strategy for a couple of MySQL servers I'm speccing up for a cluster, and I want to check if there's something obvious I'm not missing here. One app server ...
3
votes
1answer
4k views

MySQL simple replication problem: 'show master status' produces 'Empty set'?

I've been setting up MySQL master replication (on Debian 6.0.1) following these instructions faithfully: http://www.neocodesoftware.com/replication/ I've got as far as: mysql > show master ...
0
votes
2answers
312 views

MySQL Incremental backups with Master-Slave replication

we have a MySQL system in Master-slave replication mode. Currently we are doing full backups with mysqldumps to a remote disk server. I think is best to do one full dump and many small incremental ...
1
vote
2answers
102 views

Mysql leave slave 1 hour behind

Is it possible to leave the mysql slave 1 hour behind? I would like to create an script wich stops the slave when I markup some hacks such as big drop tables and stuff, to make this work I would like ...
0
votes
1answer
365 views

Promote MySQL master-slave to master-master replication

I'll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I'm attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import ...
0
votes
0answers
288 views

Promote MySQL master-slave to master-master replication

I'll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I'm attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import ...
0
votes
1answer
248 views

Setting up MySQL Linux slave with a Windows master

I'm running a MySQL 5.0 database server on Windows Server 2008. The total size of the database is about 1Gb. I make daily backups, but I'd like to step up to having a slave server for extra ...
1
vote
3answers
1k views

How to find slave's IP address and user name from Master server?

I am writing a code to extract the ip address and username of slave server in a MySQL replication environment. Does anyone know any function, variable, or something that I can run on the console and ...
6
votes
4answers
2k views

Is it possible to use an EC2 RDS MySQL instance as a slave to an external master?

I have a master MySQL instance running on our local network, but I was wondering if I can get an EC2 RDS instance to replicate the master or is this locked down by amazon?
6
votes
4answers
2k views

Modifying columns of very large mysql tables with little or no downtime

I periodically need to make changes to tables in mysql 5.1, mostly adding columns. Very simple with the alter table command. But my tables have up to 40 million rows now and they are growing fast... ...
0
votes
1answer
126 views

MySQL master-slave replication with more than 1 server

Is it possible to setup replication for database_A from master_A and database_B from master_B server? It looks like I can only set one master-host in MySQL configuration file. Thanks in advance.
1
vote
2answers
346 views

Replicate MySQL database with “non-permanent” write

I'm working with a production MySQL database and I would like to: Create a read-only slave copy of the database that gets updates from the master. The master is the only one that can be written ...