1
vote
0answers
29 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
70 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
47 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
64 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
47 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
81 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
89 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
28 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
18 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
25 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
52 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
294 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
159 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 ...
0
votes
0answers
98 views

Push Replication of Local MYSQL Databases to Web Server - Or Similar, for Website Speed Improvement

I have two MYSQL databases on a client machine. Both are read by my remote, hosted, web server for displaying content to my site visitors. Database A is used by an application on the local client ...
1
vote
1answer
158 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
298 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
125 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
48 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
410 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
66 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
64 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
201 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
222 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
300 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
476 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
148 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
158 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
97 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
253 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
2k 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
962 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
322 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
274 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
88 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
55 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
676 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
120 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
51 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
477 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
337 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
194 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
156 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
2k 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
334 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 ...
0
votes
1answer
408 views

Monitoring MySQL replication through HAProxy Xinetd service

I have have set up MySQL multi-master replication with HAProxy as a load balancer following Alex Williams' tutorial found here; ...
1
vote
3answers
1k views

MySQL per-database replication?

So, my problem is interesting: we want to migrate from one server to another. We made a master-slave replication, but my boss came with the idea to make migration one database at a time. So he asked ...
2
votes
2answers
373 views

Checksumming mysql replicas over ssl

After hours of struggling to understand the way percona toolkits (2.1) pt-table-checksum works, I try to try you. Situation Running MySQL replication (Master-active:Master:passive) Slave user is ...