Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).

learn more… | top users | synonyms

1
vote
2answers
1k views

PHP mysqlnd on Debian 6

I've installed php5-mysqlnd via: apt-get install php5-mysqlnd This is a brand new virgin Debian install with just apache2 and php5 via: apt-get install apache2 echo "deb ...
0
votes
1answer
161 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
3answers
136 views

How to proceed setting up a secondary mysql linux slave?

I have a mysql database master and slave in production. I want to setup additional mysql slave. There is around 15 Terabyte of data in the database and there are MYISAM and InnoDB tables in the ...
1
vote
4answers
449 views

greping multiple lines from MySql binlog

I have binlog from MySQL and I need to output certain time frame into a seperate file, how would I do that? here is sample of what binlog file contains: # at 460 #130120 0:09:17 server id 1 ...
1
vote
1answer
378 views

MySQL Data Center Replication [closed]

I have a (possibly not so quick question) about the best way to set up a 'global' MySQL Database. I basically need to set up multiple MySQL servers in separate geographical locations that will all ...
0
votes
2answers
700 views

Synchronisation between MySQL databases on different hosts

I want to solve a data replication/data sync problem between two MySQL server instances. Both of them have the same database structure (databases, tables, columns, everyting ...) but each of them has ...
0
votes
1answer
1k 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. ...
1
vote
1answer
788 views

MySQL error 2003 over ssh tunnel when replicating, not when using client

I am trying to set up replication on a MySQL server over an SSH tunnel. I've set up a port forward on the slave from port 7777 at localhost to port 3306 on the master, and I can connect to my ...
3
votes
1answer
503 views

Add MySQL as a resource to pacemaker

I am trying to enable fail over strategy using pacemaker on a mysql Master-Master replication on two virtual machine running openSUSE 12 created by VritualBox. I managed to complete the mysql ...
1
vote
2answers
575 views

How to check if MySQL replication is using SSL

I have a MySQL (actually mariaDB) install that I just started replicating to another server. I want to ensure that I've setup SSL correctly. The SSL portion of SHOW SLAVE STATUS looks like: ...
1
vote
0answers
47 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?
2
votes
2answers
496 views

How do I handle mysql replication in EC2 using private IPs?

I am trying to set up a mysql master/slave configuration in two EC2 instances. However, every time I reboot an instance, the IP address (and hostname) changes. I could assign an Elastic IP address, ...
1
vote
2answers
77 views

What is the best time to set the IP address for a server headed to a server colocation facility?

What is the best time to set the IP address for a server? I have a server that I am going to install the OS on and then I am going to send it to a server colocation facility. The server is going to ...
0
votes
2answers
1k views

How to use read replica instance for websites? Amazon RDS MySQL

Amazon RDS FAQs stated that it is up my application to distribute traffic to the read replica. My websites have mostly visitors - non-logged in users. So, I suppose most database activities are ...
2
votes
3answers
119 views

MySQL Replication A->B->C

I was setting the MySQL Replication for master -> slave/master -> slave and Replication for master -> slave its works fine but when i have enable this option in my.cnf log-slave-updates=1 for ...
3
votes
1answer
2k views

MySQL slave replication Seconds behind master increasing?

I started a MySQL slave using innobackupexand the Read_Master_Log_Pos: and the Relay_Log_Pos: are updating however the seconds behind master keeps on increasing (it's at Seconds_Behind_Master:496637 ...
2
votes
1answer
340 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, ...
3
votes
1answer
546 views

MySQL master-slave lag replication

Our company is using TokuDB on production and we are having a lot of problems trying to mitigate lag on our slave. Is very strange, because we're talking about very few rows... but with a few data it ...
0
votes
2answers
341 views

Setting up MySQL database replication [without restarting mysql]

I'm trying to setup MySQL db replication, it seems pretty straight forward. I was using this tutorial: http://www.howtoforge.com/mysql_database_replication Now I run a rather large MySQL database ...
1
vote
1answer
2k views

MySQL replication - rapidly growing relay bin logs

Morning all, I've got a really strange situation here this morning much like a reportedly fixed MySQL bug. http://bugs.mysql.com/bug.php?id=28421 My relay bin logs are rapidly filling with an ...
1
vote
1answer
325 views

mysqld - master to slave replication using rsync innodb, sequence number issues

I've read several of the related topics posted here, but I have not been able to avoid this innodb error. The steps I've taken to replicate data from a Slackware server - 5.5.27-log (S) to a FreeBSD ...
2
votes
3answers
261 views

MySQL specific database replication (Master - Master)

We have a MySQL server at one location, replicating to another in a Master->Slave configuration. There are about 5-7 different databases on this server. We are wanting to do this... We have a second ...
2
votes
3answers
1k views

Mysql dump of slave w/o missing Master data

I am fairly new to the whole replication process of mysql so this may be an easy question to answer. I have a master and and slave. I need to set up another slave so obviously I will need to make the ...
0
votes
1answer
173 views

MySQL replication ignore data changes but not table structure changes

Is there a way to setup MySQL replication so that CREATE TABLE and ALTER TABLE statements get replicated but INSERT, DELETE and UPDATE statements do not? I've got replication working fine and have ...
0
votes
1answer
76 views

Preparing a server for mysql replication and use it as standalone

I want to host an application on a single server running MySQL server. To get the best performance I plan on using a UNIX socket connection (to avoid TCP overhead). Later, I would like to scale up by ...
1
vote
3answers
312 views

Replicate between mysql 5.0.xx community and enterprise edition over ssh

I'm trying to setup a mysql replication over an SSH tunnel. The odd thing about this setup is that I have one master with mysql 5.0.60sp1-enterprise-gpl-log and one slave with mysql ...
1
vote
1answer
540 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 ...
0
votes
1answer
1k views

Percona XtraDB Cluster - Node Won't Join

I am trying to add a node to a new cluster but am met with the following log entries: 120915 16:47:32 [Warning] WSREP: error executing 'SET GLOBAL innodb_disallow_writes=1': 1193 (Unknown system ...
0
votes
1answer
318 views

How to take mysql replication backup

I have a MySQL master-master replication setup with a slave for each master(only one master used for read/writes at a time) on Ubuntu server. Wondering what would be the best way to schedule backup of ...
0
votes
3answers
140 views

MySQL replicate multiple places

Very trick task to find a good title for this question, but here goes the q: I have a few development machines, where I develop my PHP applications on, and testing via a local webserver. This works ...
2
votes
3answers
281 views

Rebuild mysql slave from scratch

I'm having a master/slave mysql setup. This night I had some problems with the master. I needed to recreate all databases again because they were corrupt. Now I stopped my mysql slave but want to ...
1
vote
1answer
113 views

Migrate to mysql replication server without interuption

I have a 3 apache2 / tomcat servers in a load balanced setup. Each tomcat server is connecting to a MySQL v5.0 database (all 3 share it). I created on the same network a MySQL v5.5 semisynchronus ...
2
votes
1answer
2k views

MySQL 5.5 replication setup on ubuntu 12.04

The following master-master configuration worked on MySQL Server 5.1.x(Ubuntu 10.04). Master1(192.168.2.80) ################################## #MySQL Replication ################################## ...
5
votes
4answers
1k views

Testing MySQL Database Replication / Synchronization

I'm setting up a MySQL Master database which replicates to a few Slave databases. My question is what are the best practices to monitor and / or test that the slave databases are up-to-date, and that ...
0
votes
1answer
106 views

In MySql how to replicate specific tables with two different databases? [closed]

We have a situation in which we need to have two separate databases, DB1 has X number of tables and DB2 has 4 tables in which 3 of them must be synced with DB1, so that no matter we update these 3 ...
0
votes
1answer
394 views

Would Sphinx be a good solution to solve server getting bogged with heavy MySQL reads?

I'm working on a site that I believe gets about 70k visits a day and it makes use of a lot of queries which uses UNION's over about 45 different tables, these tables generally range from about 15k ...
0
votes
1answer
34 views

managing web traffic by replicating that website into cloud [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Web Sites Can we manage traffic on a website by replicating that into a cloud after the highest possible load on ...
3
votes
1answer
496 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
3answers
420 views

MySQL HA Solutions

I am evaluating the options to build MySQL HA and found the below solutions Percona XtraDB Cluster, Tungsten Replicator, and MySQL Cluster. Could you please help me to choose the best one with ...
0
votes
1answer
2k views

install MySQL Server 5.0 on CentOS 6.3

How can I install MySQL version 5.0.x to CentOS 6.3. The MySQL in CentOS 6.3 is version 5.1. The MySQL 5.0.x is required to run a slave database of a master database server running MySQL 5.0.x
1
vote
2answers
722 views

mysql master slave “table already exists” but table not exists

I have 1 master mysql process, and 2 slave. Today on both slaves i see : Error 'Table 'bgbilling.contract_status_balance_dump' already exists' on query. Default database: 'bgbilling'. Query: ...
1
vote
1answer
68 views

Find mysql replications diffs patterns

I'm using pt-table-checksum and pt-table-sync to check for differences in my replicas. when I use pt-table-sync with the -print option, I can only see the master values. How can I show the ...
0
votes
1answer
229 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 ...
3
votes
2answers
122 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
635 views

MySQL binary logging

My server is telling my that binary logging is disabled. When I do a mysqladmin variables, I see this: log_bin | OFF. This is my configuration file: [mysqld] ...
1
vote
1answer
2k views

MySQL replication recovery

I can't sync the slave server after master server crashed. Could you please advise if the recovery is possible (without data/transaction lost) or do I have to create a new slave server? Please note ...
0
votes
2answers
5k views

How to reset mysql's replication settings completely, without reinstalling it?

I set up mysql replication by adding references to binlogs, relay logs etc in my.cnf restarted mysql, it worked. I wanted to change it so I deleted all binlog related files including log-bin.index, ...
6
votes
1answer
6k views

MySQL: Pacemaker cannot start the failed master as a new slave?

pacemaker-1.0.12-1 corosync-1.2.7-1.1 I'm going to setup failover for MySQL replication (1 master and 1 slave) follow this guide: ...
4
votes
1answer
4k views

max_binlog_size & log-bin size

I have a problem with full disk -rw-rw---- 1 mysql mysql 1073741982 2012-07-03 18:14 mysql-bin.000034 -rw-rw---- 1 mysql mysql 1073741890 2012-07-04 14:39 mysql-bin.000035 -rw-rw---- 1 mysql mysql ...
1
vote
2answers
279 views

mysql replication 1x master, 1x slave

I have just setup one master and one slave server, but its not working.. On my website I connect to the slave server and I insert some rows, but they do not appear on the master and vice versa.. What ...