Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).
3
votes
2answers
115 views
MySQL Replication 'Catchup' UPDATES keep newer record
I've got two MySQL clusters that have Master-Master replication setup between them.
Most tables are log based, with only inserts and selects, so they don't have any problems with the replication.
...
2
votes
2answers
188 views
Mysql cluster Vs basic Mysql db setup(not cluster)
Why mysql cluster requires more ram as compared to basic mysql db setup (no cluster)?
What is the ideal ram requirement for a mysql cluster with 2 mysql servers on 2 different hosts ?
1
vote
2answers
132 views
What is the best way to change the replication scheme of 2 currently replicated slaves?
I have MySQL replication set up in production as follows:
DB1 -> DB2
DB1 -> BAK
Where DB2 and BAK are slaves to DB1. All 3 servers are in sync (0 seconds behind the master) and have 30+ GB of ...
1
vote
2answers
482 views
A few tables are still out of sync after running mk-table-sync
I have 1 master and 2 slaves. I am using MySQL 5.1.42 on all servers. I am attempting to use mk-table-checksum to verify that their data is in sync, but I am getting unexpected results on one of ...
0
votes
2answers
227 views
Keeping two servers in sync - secondary server only to be booted for the backup, or in outage
I've just started a new Software Development job but I've basically been given loads of sysadmin stuff to do because the development team consists of only 2 people + the CTO. I've got pretty much zero ...
0
votes
2answers
118 views
Mysql Replication restart
I have a slave db (db1) that I moved into the master position after my master db (db2) died. I brought up a new slave db (db3) from a day old snapshot of db1, my problem is trying to figure out which ...
0
votes
2answers
397 views
How do I sync a subset of tables between two databases on the same mysql database server
would like to be able to sync a subset of tables between two mysql databases that are running on the same server. One of the databases acts as the master where inserts, updates and deletes can be ...
3
votes
1answer
309 views
Failover strategy for a 4 servers scenario
I am trying to figure out how to set up replication & failover in a scenario with 4 servers (2 per location) where any server may assume the Master role. My initial scenario is the following one:
...
2
votes
1answer
57 views
MySQL replication and UPDATE prioritisation
I have a master server, where I want modify operations such as UPDATEs to be LOW_PRIORITY so that they don't block SELECTs etc. This is better for end-user visible behaviour.
I have a slave server, ...
2
votes
1answer
202 views
Replication stops
I have 2 CentOS 5.5 servers runnig Mysql 5.5, configured as master-master replication.
When on one server i have network problems, on another i see messages in log:
111105 2:38:30 [Note] Stop ...
2
votes
1answer
38 views
MySQL slave attaches production database name to new views
I have a slave database that bears a different name than it's production counterpart. (We are using the replicate-rewrite-db option.)
When I run a mysqldump from the slave (which I do for making dev ...
1
vote
1answer
25 views
syncing specific tables between two already-replicating MySQL clusters
I have a circularly replicating MySQL cluster, and a newer cluster of Percona XtraDB instances that we're in the process of moving to. During the move, we're running some projects on the old cluster ...
1
vote
1answer
256 views
2 servers, high availability and faster response
I recently bought a second webserver because I worry about hardware failure of my old server. Now that I have that second server I wish to do a little more then just have one server standby and ...
1
vote
1answer
85 views
Failed to Attach DB on replicated SAN
We currently have a clustered SQL Server 2005 which has replicated SAN disks for our DR solution, to test DR we break the SAN synch and then attach the various DB's on the DR server.
Our web servers ...
1
vote
1answer
49 views
maybe stupid question: If a single java app on a separate server is causing 23Gigs of Binlogs to be sent to the db replica
does this mean there is 23gb of traffic (or more ) moving between the Java app (server) and the master Mysql server?
this has been bugging me.
The reason why I ask is because we have one server that ...
1
vote
1answer
63 views
MySQL database solution
I have 2 offices that are located around 500km apart and both offices need to access the MySQL database frequently. So to make it faster I am planning to set up two MySQL servers where each office has ...
1
vote
1answer
195 views
Changing MySQL master host on slave and preserving MASTER_LOG_POS, MASTER_LOG_FILE
Folks, my master MySQL server got an additional NIC used for local networking and now I want all slave servers to use the new local IP of the master server.
I know I can achieve this using "CHANGE ...
1
vote
1answer
467 views
Migrating master-slave MySQL database servers to 2 new servers, any tips or suggestions?
I'm setting up 2 new database servers that will be replacing a current master-slave setup. All boxes are running / will be running MySQL on RHEL.
Our current naming conventions:
db1 - master ...
0
votes
1answer
20 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?
0
votes
1answer
192 views
MariaDB Galera Cluster
I ma trying setup MariaDB in cluster but looks like I stuck on this error:
#mysqld -u mysql
130407 21:36:24 InnoDB: The InnoDB memory heap is disabled
130407 21:36:24 InnoDB: Mutexes and rw_locks use ...
0
votes
1answer
39 views
MySQL Slave Not Replicating
I had a deleted some data on the master mysql. Looking at the slave status, it shows this:
mysql> show slave status \G;
*************************** 1. row ***************************
...
0
votes
1answer
29 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
127 views
MySQL replication lag increasing
I have simple master-slave replication setup. Everything worked with no problems for more than a year.
Few days ago replication lag started to rise and it's still rising with no obvious reason.
...
0
votes
1answer
73 views
mysqlbinlog does not continue to last log
I am using the following command to start reading mysqlbinlog.
mysqlbinlog -t -v -v --base64-output=DECODE-ROWS -h my_host -ppasswd -R mysql-bin.000960 -j 1052323996
I would expect the output to ...
0
votes
1answer
135 views
Mysql Replication— restricting drop database statements
we have a master-slave mysql replication setup.
The master has multiple databases and they get created and dropped, fairly often.
I would like to restrict the slave to not drop the databases. I ...
0
votes
1answer
325 views
MySQL Master-Master replication using MMM on Linode
Linode allows you have multiple IP's assigned to your node but I'm trying to setup MySQL Master-Master Replication with MMM following the guide on http://mysql-mmm.org/mmm2:guide.
One part I don't ...
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 ...
2
votes
0answers
199 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, ...
2
votes
0answers
579 views
HAProxy + MySQL Slaves, random lost connections
The Setup
Right now I've got set up 3 MySQL Servers (5.1.x, on RHEL5), one Master and two Slaves. Last week I added a load balancer (HAProxy) for some services, and thought I'd experiment with using ...
1
vote
0answers
31 views
MySQL Replication Monitoring for OS X Server
I have a CentOS 5 MySQL 5.0 server running that I need to replicate. I will setup MYSQL on OS X (Mac mini), but what tool should I use to monitor the replication that runs on OS X?
1
vote
0answers
42 views
Mysql Master-ColdMaster
I explain my case:
I'm at Amazon AWS and I want to be fault tolerant on a entire region failure. My basic problem is to have the db in sync with 2 regions.
My options:
Master-Master (high lag)
...
1
vote
0answers
122 views
MySQL master-master replication: “Lock wait timeout exceeded”
I am setting up master-master replication with MySQL.
Writes are done only to Master1. Master2 is slave of Master1 and is replicating perfectly. When I set Master1 as slave of Master2, I get lots of ...
1
vote
0answers
465 views
MySQL Replication: Slave I/O thread constantly dying and starting back up
I have MySQL running on Debian 5 (Lenny) between two MySQL databases. The data is being transferring between the two machines, but one of them is logging the fact that it's slave I/O thread is ...
1
vote
0answers
163 views
MySQL Master silently drops slave thread, replication will not restart
We have a very active (high rate of change) MySQL master / slave. After the slave was offline for a few hours (over a million binlog entries missed) the slave will not start replication again. When ...
0
votes
0answers
27 views
How to do replication of data on mysql?
i am trying to do mysql replication for my site database. i searched on internet but did not get proper solution for replication. i am looking to do replication on same server.
0
votes
0answers
48 views
Mysql Replication Not Working
I setup Mysql Master Slave Replication but on my slave server I am continously getting below error, I tried all possibles but no luck. FYI I am using Percona Mysql 5.0.92-50-log
130405 5:36:54 ...
0
votes
0answers
32 views
MySql master to master replication doesn't sync properly from one Master
I did Master to Master MySQL Replication in Windows Server 2008. It is working fine, as I can following command after I check from both master.
mysql> show slave status \G;
...
0
votes
0answers
41 views
mysql cluster replication is applied only when I create db other wise delete db ,create table are not replicated
I've just setup mysql cluster on Ubuntu system ,my 3 Ubuntu 12.04 vmware machines env are as follows:
mysql management node.
mysql node1
mysql node2
I can create database on one of the 2 nodes ...
0
votes
0answers
39 views
MySQL proxy HA with no need to reconnect after node failure
I use MySQL with Galera wsrep to get synchronous replication, that part it's up and running
I need to setup a kind of proxy to handle client connections. Since any node in cluster can fail, clients ...
0
votes
0answers
65 views
MySql doesn't start after changing bind-address in Windows Server 2008
Actually I am working on Master to Master Replication MySQL on Windows Server 2008. My Master 1 is not able to connect with Master 2 whereas Master 2 is able to connect and it does telnet too. After ...
0
votes
0answers
263 views
MySQL binlog cache usage
I've got MySQL master server with two slaves.
I've noticed that the Master server is using temporary file to store the changes from the transaction so I've increased the value for binlog_cache_size ...
0
votes
0answers
156 views
Using SSIS to Replicate a MSSQL Dataview to MySQL
I am wondering what the best approach would be to replicate a dataview or query using SSIS 2012 on a windows machine to a MySQL database server running linux.
I installed the MySQL odbc connector ...
0
votes
0answers
96 views
MySQL replication keeps resulting in foreign key constraints after my.cnf updates
I'm curious if any of the following changes to the my.cnf file could result in issues with native MySQL replication, resulting in numerous random foreign key constraint issues. Obviously these aren't ...
0
votes
0answers
54 views
Replicate mysql server with networking disabled
I like having network disabled on mysql, but now I need to replicate one table across two servers. That is, the table will be updated on one server and then I need a copy of that table to be ...
0
votes
0answers
138 views
MySQL Replication not working on binlog-do-db
I set up MySQL master-master replication on my 2 Ubuntu VM. Configuration and connection done correctly according to this guide. Here is my problem.
I print the master status on master 1 and it ...
0
votes
0answers
128 views
MySQL Replication delays INSERT queries
I am setting up MySQL master-master replication using Ubuntu and MySQL 5.0.51.
I have two servers, which I will call Master 1 and Master 2.
Master 1 is the master where clients connect to. About 50 ...
0
votes
0answers
70 views
MySQL replication for scalability
Consider the following hypothetical scenario: A Web application receives 25% write traffic and 75% read traffic. Given that this application can tolerate reads that slightly stale, an easy way to ...
0
votes
0answers
344 views
problems with MySQL replication over SSL and reconnecting IO threads
We have a master/slave MySQL configuration within our cluster (MySQL-server-5.5.9-1.rhel5 on CentOS 5 x64 boxes). Most of the time the slaving works as advertised. Every so often, our replication ...
0
votes
0answers
213 views
Problem while Installing mysql cluster
I downloaded latest mysql cluster file 64 bit (mysql-cluster-gpl-7.1.9-linux-x86_64-glibc23) from mysql site. Ran following command to install mysql server.
...
