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

0
votes
1answer
29 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
20 views

mysql synchronization databases [migrated]

hello, i have 5 MySQL servers masters each one have mysql slave , and i have to synchronize data from those masters to one other mysql(central mysql who contain the common data : it can be ...
0
votes
0answers
14 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
29 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
29 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. ...
-2
votes
0answers
24 views

MySQL Multi master replication

I have one server on the internet which has MySQL data and other 10 users want to work offline and if they go online they want the data to be synced. So, do I need to make 10 MySQL users for slave ...
1
vote
1answer
44 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
0answers
6 views

MySQL Cluster with no 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
55 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
4 views

Mysql cluster 7.3 giving error while installation [duplicate]

I am installing mysql cluster 7.3 on windows 8. In the last step of installation when i have to "Deploy and start cluster" its giving the error msg "Command [u'net','start','N49'] returned non-zero ...
0
votes
0answers
7 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
21 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
41 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
73 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
0answers
86 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 ...
0
votes
0answers
38 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
21 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
24 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
55 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
13 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
1k 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
65 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
121 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 ...
0
votes
0answers
82 views

mysql Failover using HA PRoxy and mysql-proxy

i am using ubuntu and succeeded to create 2 servers Master-Master using tungsten and its working perfectly, with this setup master1 192.168.1.10 master2 192.168.1.11 proxy 192.168.1.12 i want to add ...
-1
votes
1answer
58 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
1answer
338 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
43 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
136 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 ...
0
votes
0answers
98 views

Can I ignore tables in replication on MySQL on Amazon RDS?

We run large updates on a database semi-weekly which, when replicated to our read slave, destroys any performance gains we get from actually having the read replica to begin with. Since the read ...
1
vote
1answer
31 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
94 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
66 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
92 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 ...
1
vote
1answer
163 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
126 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
0answers
47 views

Switching MySQL replication to new master

Today I've been trying to switch replication from an existing slave to a new master Everything goes okay with setup but I keep getting this error: Got fatal error 1236 from master when reading data ...
0
votes
1answer
60 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
321 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
68 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
99 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
24 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
74 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
112 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
56 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 ...
0
votes
1answer
24 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
425 views

How to stream and record MySQL binlog remotely

For data redundancy goals, I want to record the binlog of a few hundred mysql servers in a central location. To run a full replicator for each stream would require lots of resources (multiple servers) ...
0
votes
0answers
31 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
3answers
751 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
0answers
186 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 ...
1
vote
1answer
89 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 ...