0
votes
0answers
17 views

Mysql - best setup for 4 replication databases and another standalone

we would like to merge on one server 2 mysql databases coming from 2 different server : 4 databases which are replicated from a master 1 database which will be standalone What do you think is a ...
0
votes
1answer
26 views

how to use mysql database replication to backup a single database

Suppose I want to replicate a single database in mysql on my slave, the master might be creating and writing to multiple databases. is this possoible? or does the replication slave have to replicate ...
0
votes
0answers
74 views

MySQL replication across availability zones in AWS resulting in lag

I have 3 EC2 instances, each running MySQL. 2 are slaves replicating from the master. The master is located in the availability zone eu-west-1b. One of the slaves is in the same zone, and the other ...
0
votes
1answer
52 views

MySql Replication Stored to Central Database

Hi I maybe looking with the wrong terminology. But i have a situation where i need to replicate / copy data to a centralized database. Shop1.dbshop - > Central.dbshop1 Shop2.dbshop - > ...
1
vote
0answers
50 views

What can be done to prevent “failed to flush master info” in MySQL replication?

I have two MySQL 5.1 servers setup with master/slave replication. I was previously using 5.1.41 for several years without issue. However, since I've upgraded to 5.1.72 (and did some other tweaks ...
1
vote
2answers
173 views

Check if MySQL Replication is in sync

The MySQL documentation about CHECKSUM TABLE is very minimalistic. My question: Is CHECKSUM TABLE a good way of checking if a MySQL Slave Table is in sync with the master? In other words: Can i use ...
0
votes
1answer
78 views

MySQL: Does sync_binlog 0 delay replication?

If we set sync_binlog to 0, which can delay the OS syncing the binary log to disk, does that introduce any lag into the time it takes for slaves to replicate those binary logs? In other words, are ...
1
vote
2answers
78 views

MySQL Replication threeway

We have MySQL Multi-Master replication setup between two servers ( A & B ). It has been working for a few years now and life is good. The management tool in our office connects directly to ...
0
votes
1answer
45 views

MySQL Dual-Primary Replication

I have 2 identical up to date dedicated MySQL servers and I just configured dual-primary replication on both, everything works as expected but the problem is that I have a lot of BIN files with very ...
0
votes
1answer
91 views

How to translate from statement-based to row-based replication in MySQL

I have a production system that uses MySQL statement based replication for hot failover should a master database die. Running version 5.5 Percona. I have to use statement based replication for reasons ...
0
votes
3answers
98 views

Remote access forbidden (HY000) to specific mysql client

A MySQL server is located at central.hwcharts.com; it is the master of a basic master-slave replication which replicates toward host0.hwcharts.com, located on a different physical machine which ...
-2
votes
2answers
150 views

Is it possible to do mysql replication with one server in internet and another in a intranet?

I have a server in internet that must have all data synced (dont need to be in realtime) from a server from a intranet (obviously has internet connection). Is it possible? How about sync both sides, ...
0
votes
1answer
40 views

MySQL Replication fix after server shutdown/start

Server1 is Master Server2 is Slave Both are in our AWS testing env and we stop them once done with our work. When start again, Master rotates/creates new binary log file but slave keep looking for ...
0
votes
0answers
20 views

Logging Apparently Not Working - Can't Set Configure Replication

I'm using a tutorial to set up a master (single) slave setup. When I run the command show master status; I get Empty set (0.00 sec). I have done a lot of research and believe that the log file I have ...
1
vote
1answer
26 views

re-enabling a table for mysql replication

We were able to setup mysql master-slave replication with the following version on both master/slave: mysqld Ver 5.5.28-29.1-log for Linux on x86_64 (Percona Server (GPL), Release 29.1) One day, ...
0
votes
1answer
59 views

How to run a safe, responsible, fast MySQL backup

I've been tasked with assorted maintenance of a DB. I have very little experience with MySQL, so pardon any ignorance :) Two (well, four) related questions: The DB is supposed to be replicated to a ...
0
votes
1answer
35 views

Mysql Db replication

I have the following setup: 3 servers, B1, B2, B3. A database from B1 is being replicated to B2. B1 is master and B2 is slave. Now, I want an another database from B2 to be replicated to B3. I need ...
1
vote
1answer
404 views

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
0
votes
2answers
191 views

MySQL geographic replication cloud

I currently have a standard local LAMP setup, (2 web servers, master/slave MySQL, load balancer). This is severing me well locally, but my global users experience slowness. I want to setup some ...
1
vote
1answer
209 views

What are the options for any SQL Multi Master Master replication?

I am looking for a proper way to do Multi Master Master replication. I am currently using MySQL but open to switching to Postgres or Oracle if needed. So far the only solution I find is ...
1
vote
1answer
413 views

MariaDB replication not auto reconnecting

I've got a simple master-slave replication setup amongst two MariaDB 5.5 servers. The connection between the servers is somewhat flaky, causing disconnections every now and then. However ...
1
vote
0answers
191 views

MYSQL master master replication show master status show empty record

Environment: Windows 2008 R2, MySQL 5.051b Two servers: server1: 192.168.2.8 server2: 192.168.2.9 server1 > my.ini [mysqld] server-id = 1 auto-increment-increment = 2 auto-increment-offset = 1 ...
0
votes
1answer
50 views

MySQL replication as both master and slave (replication loop?)

I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current ...
0
votes
2answers
539 views

MySql server master-master seconds_behind_master jumps

I'm running a 4 servers master-master cluster of MySql. (2 servers version 5.1, and 2 version 5.5) While checking the slave status, i see the seconds_behind_master at 0, and half a second after i see ...
0
votes
1answer
68 views

How to arrange a replication in mysql?

Here is my problem. I have a busy Drupal site struggling under high load. After applying all caches I see that, no surprisingly, database is the bottleneck. I have two servers to handle the site: A ...
0
votes
1answer
67 views

Migrating MySQL from one server to another via master-master replication

OS is Linux. I imagine that the process is something like the following: Set up master-master replication between old and new servers. Cut over the db ip on my app server from the source db to the ...
1
vote
2answers
54 views

Slave with more databases than master

I have two servers. Lets called ServerA and ServerB each has their own database server and web server. Those two servers are used to run different website. ServerA data is more important because it ...
1
vote
2answers
245 views

Is it possible to create a mysql slave from start of masters binlog without copying data first?

info: my tables are all innodb. i know i can create a mysql slave by copying the data from master to slave and noting the position in the binlog and set that on the slave. thus the slave should be ...
0
votes
2answers
366 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
362 views

MySQL replication re-sync

I'd like to set up a zero-maintenance hands-off MySQL replication regimen for backup purposes. It's been my experience, though, that these things inevitably eventually get out of sync. Perhaps it's ...
1
vote
1answer
581 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 ...
2
votes
1answer
153 views

Why is MySQL writing hundreds of 125 byte binary log files?

My MySQL Master (with no connected slaves right now) writes out a 125 byte file every minute or so: -rw-rw---- 1 mysql mysql 125 2012-12-28 16:46 snapshot-mysql-v2-bin.004876 -rw-rw---- 1 ...
4
votes
1answer
190 views

MySQL Master - Master Broken

I've Inherited a Mysql master master system, I've noticed the second master (lets call it slave from now on as it's running on a 'slave' machine) stopped getting its db's updated. I saw that Master: ...
2
votes
3answers
107 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 ...
2
votes
5answers
280 views

Master - Slave MySQL setup on a VMWare Cloud — Is it needed?

We currently are in the research phase of building a "Master" database for our e-commerce business that will centralize all data, including product information, vendor information, Magento ...
1
vote
2answers
3k views

What can I really do with percona toolkit's pt-table-sync?

I have been looking for a tool to synchronize tables from 2 different databases and found pt-table-sync. I read the documentation and got confused: they mostly use examples referring to a replicated ...
1
vote
1answer
1k 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 ...
0
votes
1answer
375 views

How to enable telnet with port 3306 during Master to master replication on MySQL Server

I am trying to do Master to Master Replication in Windows Server 2008. I am successfully able to replicate all the database of Master 1 to Master 2. But I am unable to replicate the changes made on ...
1
vote
1answer
312 views

Cloning a VM to add a new MySQL Slave

I am in the process of adding a new slave to a replicated MySQL setup. I'm proposing the following process: clone one of the nodes to a new VM start it with no networking stop mysql change the ...
0
votes
1answer
114 views

Move MySQL master

I currently have a master db server (lets call it db1) and 6 slaves (slave1-6). I've setup a new server (db2) as a slave of db1 and it's in sync. I want to change all the slaves to use db2 instead of ...
0
votes
1answer
60 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 ...
2
votes
1answer
700 views

How to install Percona XtraDB Cluster on x86 server?

I'm going to migrate from MySQL replication to Percona XtraDB Cluster. The problem I'm facing is one node is running on x86, and I cannot install Percona-XtraDB-Cluster-server from the Percona repo ...
0
votes
3answers
130 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 ...
1
vote
1answer
54 views

Any pitfalls for replicating MySQL to a remote server

Are there any pitfalls or gotchas for replicating (master->slave) MySQL DB to a remote server about 100ms ping away?
5
votes
4answers
588 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 ...
1
vote
2answers
432 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
223 views

maakit: mk-table-sync issue with index

Trying to re-sync a slave, I run into troubles with some of my tables which do not have a auto-increment primary index, but a primary unique ID (not auto-increment). I run the re-sync with ...
3
votes
1answer
165 views

System Requirements of a write-heavy applications serving hundreds of requests per second

NOTE: I am a self-taught PHP developer who has little to none experience managing web and database servers. I am about to write a web-based attendance system for a very large userbase. I expect ...
12
votes
3answers
3k views

MySQL Replication Performance

I'm having a serious issue with MySQL 5.5 replication performance between two machines, mostly myISAM tables with statement based replication. The binary logs and mysql data directory are both located ...
2
votes
1answer
362 views

Queries Stuck on the 'Connect' Command

So, little back story. We have a master-slave set-up and multiple times per day, we see something like this on the slave database, trying to replicate whats come from the master Id User ...