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

2
votes
1answer
32 views

MySQL replication slowing master

We are currently running MySQL 5.1 Quick Overview We use 5 web servers ( Apache ) all connected to 1 DB server ( MySQL ) hosted on the cloud. The DB server running on the cloud ( Master ) ...
0
votes
0answers
31 views

How to fix MySQL replication on one table

I have a rather large MySQL database with a handful of replicating slaves. Recently I ran the percona toolkit checksum and found a couple of tables out of sync. What is the best way to get them back ...
0
votes
1answer
56 views

MySQL Master-Master Replication Issue

I have two databases that sync data through Master-Master replication. The setup was created using the following guide: ...
0
votes
0answers
20 views

MySQL Cluster replication: NDB$MAX_DELETE_WIN() changes always applied in primary

I am building TWO mysql clusters (A & B) with master-master replication: A --> B --> A I followed the official MySQL doc to setup conflict resolution. Eventually we may have more than 2 ...
1
vote
1answer
34 views

Unable to start MySQL server while configuring MySQL Cluster using its auto installer GUI?

We are trying to configure MySQL Cluster using its Auto Installer GUI. When we click on 'Deploy and Start MySQL Cluster' button, it showing a small popup with progress. Once it is reached at 57%, ...
2
votes
1answer
123 views

High Mysql Connections

Having a challenge discovering why results are as they are. Perhaps missing something obvious. Sorry this isn't very specific. But if anyone has an pointers on areas to focus on that would be very ...
0
votes
1answer
39 views

Mysql database restore

My mysql backup is running everyday at 4 am & accidently my database got corrupted at 7am. Now how to restore data updated between time period of 4am & 7am
1
vote
1answer
172 views

AWS RDS. Upgrade MySQL from 5.5 to 5.6, external replica and Access denied

I want to create external read replica for my RDS instance using this doc: http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Exporting.NonRDSRepl.html My old instance is running ...
0
votes
2answers
71 views

MySQL - Does the change in MySQL master db password affect on slave db?

I want to change the MySQL DB password on the master db. My question is: do we have to care for the slave DB when changing the master database password?
1
vote
0answers
19 views

Concurent access on a replicated table in mysql [closed]

I have 2 servers with MySQL master-master replication set. I also have 2 identical bash scripts connecting every 100ms to the DB to fetch a new record with Status=0. Upon fetching a new row the ...
0
votes
0answers
42 views

MySQL replication, slave don't connect

I try in mi LAN with 2 VM a master-to-master replication, configure: #bind-address = 127.0.0.1 server-id = 2 auto_increment_increment = 2 auto_increment_offset = 2 log_bin = ...
0
votes
1answer
293 views

PowerDNS Master Slave Transfer method

I would like to know which is the better option to transfer the domains & their updates between a master & slave PowerDNS server. I have seen many old posts from 2006 saying using the MySQL ...
0
votes
1answer
113 views

update and insert MySQL DB on AWS RDS with local MySQL DB

I have created an RDS database and have used mysqldump to send all my local data to that remote database using the following commands: $ mysqldump -u root fishDB > localDB.sql $ mysql -h ...
0
votes
0answers
60 views

best logic to Load balancing YiiFramework web app

I'm going to launch a Yii framework app next days, and i'm currently searching the best way to deploy it in order to scale and support high traffic. I use Amazon RDS to host the DB, and 2 Memcached ...
0
votes
1answer
47 views

MySQL Replication across two mounts on AWS Amazon Linux

Recently we took advantage of the SSD instance stores available on AWS. While these are great, they obviously get deleted when the instance dies. Obviously the performance of non Provision IOPS is ...
0
votes
1answer
861 views

MySQL replication error: Error_code: 1032

I setup MySQL read replica that is read only. Both master and slave are running MySQL 5.6. The slave never gets written to directly, but I can't seem to keep it synced for more than an hour or two. ...
1
vote
1answer
228 views

Duplicating data between two Percona Xtradb clusters using MySQL replication

We currently have a 3 node Percona Xtradb cluster running in a single data center. We want to add fault tolerance in case of disaster to prevent reliance on a single data center and synchronize our ...
0
votes
1answer
25 views

MySQL Cluster with no access to Data Nodes

I'd like to set up a MySQL Cluster for HA, but the client of the data cannot yet use ClusterJ. I would like create 2 SQL Nodes and access only them from the client. i.e. No access to the NDB Data ...
1
vote
2answers
71 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
0answers
10 views

MySQL Server Not starting on Windows OS with Arabic

I have a MySQL server (The MySQL version is 5.5.25) that I packages with my software that I run on my Windows XP/7/8/Server, the MySQL server is starting up and running as required on the Windows OSes ...
1
vote
0answers
23 views

Mysql Master to Master Configuration Steps

In our project currently we are using Mysql Master to Master replication, both mysql server version is mysql 5.1. we are going to upgrade the replication then our requirement is one mysql server ...
2
votes
1answer
116 views

MySQL Master-Master Replication Slave Thread Issue

I'm currently trying to set up Master-Master MySQL replication between 2 servers, but I'm encountering an unusual issue. I'm getting this error on my MySQL log: Slave: Table 'phpmyadmin.pma_recent' ...
0
votes
1answer
86 views

What is wrong with this iptable for Mysql Replication

I'm not quite used to IPTables and I'm trying to run an iptables script to allow only ssh connection from all and connection to mysql server only from specified IPs. I made a bash script for this, ...
3
votes
1answer
124 views

Restore database by files from broken Ubuntu server

I'm pretty lost right now. The RAID controller auf my server broke and all attached hard drives were corrupted. Luckily I copied the plain files off the server right before the crash (phew). I set ...
-1
votes
0answers
71 views

mysqlnd_ms + PLESK + MYSQL connect fails // replication split read/write failed

I am running a centos 6.4 server with plesk panel. I have successfully installed mysqlnd. php -i shows that its correctly using it. I have also installed pecl mysqlnd_ms to split reads/writes. I have ...
1
vote
1answer
23 views

mySQL 'Stop Slave' on Server Reboot

Is there a way in mySQL to issue a 'stop slave' command when the server is rebooted to prevent the replication from getting out of sync? I haven't been able to find anything definitive on this.
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, ...
1
vote
1answer
114 views

MySQL replication hung after slave goes offline and comes back online again

I have a master server and several slave servers replicating a single database. I am using in MySQL 5.0 in SLES 11. During fault tolerance testing I found that when the slave's network connection ...
0
votes
1answer
22 views

MySQL keeps starting logger and constantly restarts?

Alright, I have updated version 5.1 to version 5.6 without uninstalling the old one by using update-alternatives. This works just fine on our production/master server, but our replication slave seems ...
0
votes
2answers
2k views

Slave SQL Thread not running

My replication suddenly went offline. SHOW SLAVE STATUS shows me that I/O Thread is running, while SQL thread is not. I have error message: Fatal error: Found table map event mapping table id 0 ...
0
votes
1answer
111 views

MySQL Replication Stale

I had some interesting problems with Maria DB. 1st I have max_connections in config under section [mysqld] but the value is always 214 (default) after restart. So the problem is I can't defined the ...
1
vote
1answer
178 views

Fail safe SSH tunnel Ubuntu (always up)

I need your advise for a very important technical issue on our project. We need to have a SSH tunnel always up between our two servers. We have a MySQL database replication process going between those ...
-1
votes
1answer
79 views

Mysql MariaDB replication broken

I have a primary DB and two replicates. replicate1 became corrupted when the linux server was rebooted without stopping mysqld. I want to load replicate1 with a dump I've taken from replicate2 with ...
1
vote
2answers
762 views

MySQL Replication Over SSH - Last_IO_Errno: 2003 - error connecting to master

I have MySQL MASTER/SLAVE replication working on two test boxes (Centos 6.4 / MySQL 5.5.32) over LAN. Securing the connection over ssh causes connection problems from the SLAVE machine: (Sample of ...
3
votes
1answer
67 views

Is it safe to lock tables on a mysql replica slave?

I have a master mysql database where the application writes and read production data, and then I setup a slave database just in case something goes wrong with the master database server (and I can do ...
1
vote
1answer
195 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
32 views

MySQL replication and replicating MySQL users

I have a MySQL Main Server and a slave server which replicates the main server. My question is, the new MySQL users added to the Main Server do not get replicated to the slave server. How can I make ...
1
vote
1answer
116 views

MySQL Master-Slave Replication

I am trying to set up highly-available master-slave MySQL replication. I plan to have two servers on different networks with one running as master and the other running as slave like so: A ...
1
vote
0answers
82 views

How to prevent bad queries from breaking replication?

For my personal experience, mysql replication is fragile. I know that there area many things not to do beacuse they could break replication, but we are humans and an error could always occur. So I ...
0
votes
3answers
133 views

mysql master-master setup as a way to simply master-slave promotion

I'm trying to see if the following plan is viable. Goal here is to be able to do HA (uptime) and not necessarily for load -- writes are fine on one MySQL 5.5 server (with innodb) but not really ...
2
votes
1answer
1k views

MySQL slave server not removing old relay binlogs

I have a MySQL server with slave replication on another host. Today I stumbled across the high disk usage of the slave host and invastigated what takes up all the space. As it turns out this space is ...
1
vote
0answers
160 views

mysql cluster node lost connection shutdown

I'm testing a mysql cluster with VirtualBox using several virtual machines: Each virtual machine (2 in total) has a mysqld and ndbd node. Plus there's a vm for the ndb_mgmd to manage the cluster. I ...
0
votes
1answer
86 views

MySQL Slave not processing relay logs fast enough

I have a Master-Master cluster with 2 Percona 5.5.30 servers. (Lets name them 1 & 2) The OS is FreeBSD 9.1 I have an issue that server 2 is not processing the relay log fast enough. I know that ...
0
votes
2answers
503 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 ...
1
vote
1answer
75 views

How to properly migrate mysql server?

Currently I am dealing with server migration. I have mysqldump --all-databases dump, which contains also mysql and might be information schema databases. All I need is somehow safely and fast ...
0
votes
0answers
147 views

MySQL replication & logrotate

I'm using MySQL Master-Slave replication for backup purposes (for a few days). Today after changing to expire_logs_days = 3 on master and slave I got this message (from slave): ...
1
vote
0answers
29 views

Mysql Multi slave replication

Hi I have a master Mysql server from where i am replicating other 2 slaves. The issue is one of the slave stops with an error frequently. The error message is below. Error 'Duplicate entry ...
0
votes
1answer
90 views

Is there a log to see when a user is trying to access file/directory that he doesn't have permission?

My database is failing to replicate and the only clue in the error log is Operation Not Permitted, which I am guessing is file access permission failure either on donar or joiner. Is there any file ...
1
vote
1answer
236 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 ...
-1
votes
1answer
74 views

MySQL won't start if I set the log_bin

[mysqld] datadir=/db_vol/datadir socket=/var/lib/mysql/mysql.sock port=3306 server_id=1 log-bin=/db_vol/log/mysql-bin.log binlog-do-db=mydb When I try to start MySQL, I get an error that says MySQL ...