Tagged Questions
0
votes
0answers
8 views
MySQL Err 1032 on only 1 Slave
I'm getting a very strange error on one of my MySQL servers and I'd appreciate some help.
The Setup
I have a separate environments.
Environment 1 consists of the Master Server and 1 Slave.
...
3
votes
1answer
36 views
Best strategies to have a backup of an RDS MySQL database
I have an AWS RDS MySQL database. I'm not a DBA, so my knowledge is limited.
I wish to design strategies to have zero data loss in case of a failure, in terms of replication or data backup.
I know ...
3
votes
1answer
23 views
Will creating a view on a MySQL replication slave break the replication?
We need to run some very ugly queries on a MySQL replication cluster.
Does anyone know if creating a view directly on the slave will break the replication of the other, otherwise untouched data ...
2
votes
1answer
20 views
Percona Node fails to join: Operation not permitted
Joining a new Percona node fails with:
130521 7:15:44 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group ...
1
vote
1answer
43 views
Which one to use? InnoDB Replication or MySQL Cluster?
I am building a url shortener and I use InnoDB as the storage engine for link data. I will start with a single VPS containing both application instance and MySQL database instance on the same Virtual ...
0
votes
2answers
55 views
MySQL Master/Slave. Actual use of Slave Machine
We have a MySQL server running in a mobile production trailer. The trailer is out on the road for weeks at a time. We have cell internet and wifi access is nearly all of our locations. Our office ...
0
votes
4answers
33 views
Master/Slave without populating tables
So I have some Zabbix instances which are using MySQL for their backends. What I would like to do is, for DR purposes, backup the DBs for each instance using a Master/Slave configuration, with the ...
1
vote
0answers
26 views
How to sync mysql remote database daily ?
I have a database that contains orders , products ..etc. I have another system that generates reports based on this database. Due to heavy load i want to separate those systems Where i have the master ...
0
votes
2answers
56 views
mysql replication successful but slave not replicating
I have created a mysql master-slave configuration and things look fine .
the " show master status;" on slave doesnt show any error . this is the output
Slave_IO_State: Waiting for master to send ...
1
vote
1answer
58 views
SQL Server-MySQL master-master replication
We are looking into setting up a master-master replicated MSSQL database and I am interested to hear of any potential pitfalls that we may run into along the way and generally any advice that you ...
0
votes
1answer
40 views
MySQL Replication and Triggers
I have stumbled upon an interesting MySQL Error message that I do not really know how to interpret.
The setup:
There are two tables A and B.
When data is written or updated in the table A, then a ...
2
votes
2answers
50 views
Does MySQL 5.6 support fan-in replication?
I've known for quite awhile that Continuent's Tungsten Replicator supports fan-in replication (example).
By fan-in replication I mean combining multiple datasources into a single instance (like a ...
1
vote
2answers
60 views
How to avoid lagging when enabling log-slave-updates?
Master:
48GB RAM
16-core
my.cnf: https://clbin.com/hlkUo
Slave:
64GB RAM
24-core
my.cnf: https://clbin.com/viLm0
Both are running 5.5.28.
For the incremental backup purpose, I need to enable ...
1
vote
1answer
123 views
Master updates Slave but not Master itself
I have a setup master/slave in which applications are pointed only to master. Yesterday Master had got crashed due to "multi bit error on dimm detected" in Front indication panel in orange color.
...
2
votes
2answers
130 views
MySQL replication: most important config parameters for performance on slave server?
I'm setting up a mysql master-slave configuration, where slave is located on a much weaker sever.
Since, if I understand correctly, slave only works on updates/inserts, what are the most critical ...
1
vote
2answers
59 views
Is it safe to delete mysql-bin files?
I have MM Replication in mysql, and I want to squeeze some free space in the box be deleting unnecessary files, I came across these mysql-bin files inside /var/db/mysql/ There are hundreds of those ...
0
votes
1answer
29 views
mysql replica ignoring server-id [closed]
I've setup a mysql replica slave a couple months ago. After a couple hickups lately, I've decide to restore it from a clean master export.
I'm trying to start my mysql instance with this command :
...
0
votes
0answers
15 views
Setting master user not working in MySQL [closed]
I am follow these instructions to set up a master user in MySQL:
Log in to your Slave server with root privilege as:
mysql -u root -p
Create a new database named magentodb and import the ...
0
votes
0answers
18 views
Can i use XAMMP mysql server with Percona Xtradb cluster?
I just wanted to know if I can use a normal MySQL server (XAMPP) as part of the cluster on my EC2 Server running Percona XtraDB Cluster.
Can I just change the my.cnf config file on XAMPP with the ...
0
votes
0answers
29 views
MySQL replication is not happening when piping sql into mysql client
Today I noticed a very strange issue where if I cat a SQL file and then pipe it to MySQL client, replication doesn't happen. These MySQL statements aren't also written to the binlog. But replication ...
3
votes
1answer
117 views
Switch MySQL lag slave to new master and keep lagging (5.1)
We have the following scenario:
Set of slaves replicate from the master, separate standby master (a.k.a slave with binlogs) replicates from the same master; lag slave, powered by pt-slave-delay, ...
1
vote
1answer
50 views
MySQL replication — issue with mysql.proc during replication from 5.0 to 5.5 host
We are replicating from a mysql 5.0.45 host to a 5.5.26 host over WAN. Every once in a while one of our databases does not accept a query and halts the replication.
"'Column count of mysql.proc is ...
1
vote
2answers
71 views
Is there a way to stop MySQL Replication on the master?
I want the master to stop replicating data to the slave. I know I can do that on the slave with STOP SLAVE;, but I wonder if there is a way to do it in the master.
One possible solution might be to ...
1
vote
2answers
77 views
Loading data in mysql using LOAD DATA INFILE, replication safe?
I am trying to load data into mysql database form CSV file. I found that we could use LOAD DATA INFILE command to do it. But as per the mysql documentation it is not replication safe. (See here)
Is ...
0
votes
3answers
85 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
22 views
replication breaks after upgrading master
I have a set up of replication with master 5.1.30 and slave 5.5.16
and the replication is working good
Now i have upgraded mysql master to 5.1.47
As far as i know we have to turn off the log bin ...
0
votes
1answer
45 views
MySQL replication using a lot of IO
I'm having big troubles on a database pool I've setup recently.
There is a master, and 4 slaves replicating one DB. All using MyISAM engine.
Thing is, during the replication period (when the slave ...
1
vote
1answer
47 views
MySQL statement-based replication and stored procedure
When you have a MySQL statement-based replication and you create a stored procedure that modify some rows (INSERT, UPDATE, DELETE commands...), What is really replicated on the slave when you call ...
0
votes
0answers
39 views
MySQL failover - Master to Master Replication
My company is trying to implement a MySQL failover mechanism, to achieve higher availability in our webservices tier - we commercialize a SaaS solution. To that end we have some low-end VMs scattered ...
0
votes
1answer
36 views
Syncronize mysql databases between local and hosted servers automatically
We have many website with Development , Staging and Production Server. we have many developers for many projects, we need a solution to synchronize the database with developer database with staging ...
0
votes
1answer
45 views
MySQL: replicating to a different table engine type
According to the replication documentation from MySQL, it is possible to set up replication from InnoDB source tables to MyISAM destination tables. Unfortunately, the documentation has little to say ...
0
votes
0answers
20 views
What is the quickest way to recover from an “Incorrect key file for table” replication error?
I'm trying to figure out the quickest way to recover from a replication error.
The production site replicates to a DR site. There are two databases at each site. So prod_master replicates to ...
0
votes
0answers
27 views
Slave lags ONLY when long running sql runs
I have mysql Master/Slave setup.
Master in 5.0.77 and Slave in 5.5.28.
The Master serves 24/7 with 82.06 inserts/s, 94.39 updates/s, 0.00 deletes/s, 22613.29 reads/s.
They both are in sync every ...
0
votes
2answers
79 views
Should I disable triggers, timestamps in a slave in mysql?
We're using MySQL. We have a master that eventually will have 2 slaves. There are triggers in the db that execute when data changes in certain tables. I am wondering whether to disable the triggers in ...
1
vote
1answer
29 views
After adding a slave to Master - Master configuration, slave syncs from only one master
Futher to my previous question,
Here is what we have
+<------+
| ^
V |
S1<---M1 M2
| ^
V |
+-------+
what happens is Upon ...
2
votes
1answer
118 views
Adding slave to existing master-master config in mysql throws Foreign key constraint failed error
We have two mysql servers running in master - master configuration.
Now we have to add a slave to the existing configuration.
But upon adding the third DB server and starting slave on it, it throws
...
0
votes
1answer
45 views
Circular replication with servers in different locations
My service runs on single machine, and database (mysql 5.1.66) is replicated to 2 other identical slaves (with lesser system resources, mysql 5.1.66) via chained replication. Machines are located in ...
0
votes
1answer
27 views
How to have MySQL Slave Replicate From a Master's Master
We are using the Following:
MySQL 5.1.63-community-log MySQL Community Server (GPL)
OS : Red Hat Enterprise Linux Server release 5.4
We have three servers and all servers are enabled with binary ...
1
vote
1answer
50 views
Will deleting data in master automatically delete data in slave?
I have data replication setup on MySQL. If I delete data on the master, will replication know data was deleted and automatically delete the same data on slave?
0
votes
1answer
288 views
MySQL slave stuck in “Reading event from the relay log”?
5.5.28-log MySQL Community Server (GPL) by Remi
binlog-format=MIXED
My problem is similar to this question.
*************************** 2. row ***************************
Id: 973415
User: ...
2
votes
1answer
63 views
Bi-directional replication for the same MySQL table
AppA stores/retrieves data from dbA.tableA
AppB stores/retrieves data from dbB.tableA
tableA definition is the same across these databases. To start with dbB.tableA was copied from dbA.tableA ...
2
votes
1answer
90 views
mysql second slave not syncying while first slave works fine
I have a master (m) - slave (s1) setup using mysql 5.1.45
When I try to add a second slave (s2) the slave lags behind and never catches up on the sync.
Even after having synced the s2 with the whole ...
0
votes
1answer
43 views
Do I need client certs for mysql ssl replication?
I'm setting up mysql replication using SSL, and have found two different guides.
The first one creates both client and server certs, while the second one only creates server certs.
I don't know ...
0
votes
1answer
33 views
Is it possible to have extra tables in a Slave with MySQL Replication
As my title mention I have a Master and a Slave database.
Master if for operations data and my slave mainly for reporting stuff.
The issue is that I need to create extra tables on reporting that ...
0
votes
0answers
18 views
Retention policy for tmp files created on Mysql slave
What if suppose load data infile is issued in master and I see that it gets replicated to slave first by IO with the infile SQL_LOAD data files and then it triggers its DMLs using SQL Thread.
My ...
0
votes
0answers
11 views
How to replicate some databases from a slave to another slave?
Right now, we have a MySQL 5.5 master which replicates all 10 of its databases to two slave servers, slave1 and slave2. I want to offload some processing to slave1, so I want to move two databases ...
1
vote
0answers
79 views
MySQL 5.1.67 - Replication failure Mysql, Master Log Truncated or corrupted
I have run into some issues with replication
After an in-place upgrade of mySQL from 5.0.77 -> 5.1.67 rel 14.4 Percona
replication between a master and multiple slaves is causing issues. slaves are ...
0
votes
1answer
60 views
MySQL Slave Lagging Almost Daily -Ver 5.5.17 ( Master & Slave )
I am observing this lag in a continuous manner. Investigating in the bin log events, i found
the following information. Slave executing the relay Logs slowly.
1. Changing the Innodb File Format ...
0
votes
2answers
108 views
Does MySQL Replication hamper the performance of my DB?
I am not exactly a 'Qualified' DBA, but yes i am in charge of my own DB which we use in our social app.
I have recently implemented Master/Slave Replication on my Database for obvious reasons.
What ...
0
votes
2answers
96 views
Replication on MySQL server
I had to stop the slave server to test something. After I started the server again there is a problem with replication on MySQL server
On the problematic server
mysql> SHOW SLAVE STATUS\G
...
