Tagged Questions
1
vote
1answer
38 views
mySQL: Slave not able to connect to Master for replication
On my master, I did:
GRANT REPLICATION SLAVE ON *.* TO 'repluser'@'%' IDENTIFIED BY 'mypassword';
On my slave, I see:
mysql> show slave status \G;
*************************** 1. row ...
0
votes
1answer
32 views
Replicate from slaves to master and viceversa
I've a great dilema here and didn't know how to solve it. I need to replicate a few tables from MySQL DB (slaves) to MySQL DB (master). Take as an example this:
MySQL DB (master)
table1
table2
...
0
votes
1answer
72 views
Nagios and MySQL [closed]
We have a system that contains several machines running circle replication (Cross master). One extra machine is connected to one of them and operating as a slave.
Example
M1 -> M2
M2 -> M3
M3 -> ...
2
votes
1answer
203 views
Using Amazon RDS (or similar) as a slave
Officially, RDS instances can't be directly set up to slave non-RDS databases.
My production master is MySQL running on Hetzner and I want an RDS instance to closely follow it for backup purposes, ...
1
vote
1answer
74 views
Backups from MySQL slave server — Good idea or bad?
I'm have one MySQL master and two MySQL slaves set up to replicate. I'm running my database backup process, consisting of an Xtrabakup (via the perl wrapper Innobackupex) backup and an atomic ...
1
vote
1answer
129 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
82 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
...
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 ...
3
votes
2answers
281 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
899 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 ...
0
votes
1answer
369 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
3answers
755 views
How to setup MySQL replication with minimal downtime
Basically we have a large MySQL database and we're looking to do replication to a slave (master slave setup). Do you guys have any step-by-step guide on how to do this with MINIMAL downtime on the ...
1
vote
2answers
350 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 ...
