Linked Questions

4 votes
4 answers
19k views

MySQL:How to correct a corrupted MySQL binary log on Master server?

We are using MySQL DB with one master and one slave. We are using this setup for months now. The slave sync stopped today and the error we got was: Last_IO_Errno: 1236 Last_IO_Error: Got ...
Ruchit Rami's user avatar
6 votes
2 answers
9k views

Binlog has bad magic number

I keep getting this error whenever I start MySQL. 121028 1:38:55 [Note] Plugin 'FEDERATED' is disabled. 121028 1:38:55 InnoDB: The InnoDB memory heap is disabled 121028 1:38:55 InnoDB: Mutexes and ...
laggingreflex's user avatar
1 vote
1 answer
8k views

Should I increase my key_buffer_size?

I have 4 node and database has InnoDB tables. my key_buffer_size is 128M. Should i increase it in my system? My innodb_buffer_pool_size is 75G and innodb_log_buffer_size = 256M. Mem: 96688 ...
Melih's user avatar
  • 284
2 votes
1 answer
7k views

MySQL Master 5.5 - Slave 5.6 - unknown system variable 'binlog_checksum', Error_code: 1193

I see the below warning on the my slave server: 2016-11-18 22:48:03 12808 [Warning] Slave SQL: If a crash happens this configuration does not guarantee that the relay log info will be consistent, ...
Berlin's user avatar
  • 189
4 votes
2 answers
2k views

MySQL replication with 5.7 master and 5.5 slave

I'm trying to setup a MySQL replica with the master on 5.7 and the slave on 5.5. On the master I have disabled the binlog_checksum. After import a dump of the database, change the master and start ...
Ezequiel Biavaschi's user avatar
2 votes
2 answers
3k views

Should master and slave have same mysql version?

I have a master database running mysql 5.5.11, and I am planning to setup a new slave. I am planning to use the 5.5.30 as it is the latest version. For setting up new slave, I am copying files from ...
Boolean's user avatar
  • 611
1 vote
1 answer
2k views

MySQL 5.5 Replication to Galera/Percona XtraDB Cluster

We are currently investigating moving our current MySQL 5.5 Master > 5 x Slaves (with Statement Based Replication, apx 250GB data and growing) to a HA clustering option. Mainly to provide greater ...
IGGt's user avatar
  • 2,126
2 votes
1 answer
3k views

MySQL 5.6 Slaves Fail to Reconnect to older MySQL server when it goes down for backups

I have an existing replication setup with Masters and Slaves running MySQL 5.0. A long existing script runs at night which restarts MySQL on the master with skip-networking, runs a backup, and then ...
Dosdecader's user avatar
1 vote
2 answers
2k views

What does MySQL mean by "Major Version", and is MySQL replication supported between 5.1 and 5.6?

I am migrating from some MySQL 5.1 servers to MySQL 5.6 servers. The MySQL docs are a bit unclear if replication is supported between a 5.1 master and a 5.6 slave, and MySQL's documentation is unclear ...
Stefan Lasiewski's user avatar
1 vote
2 answers
1k views

mysql master slave replication scenario

We are creating a new mysql slave, but for dump we are taking from a backup server which is a slave of current master. Now to enable replication we want to connect it with the master so should I take ...
roger moore's user avatar
1 vote
2 answers
871 views

Importing tablespace files - Length mismatch error for DATETIME field

We are currently trying to import some old historic data tables. Unfortunately, the data is in exported tablespace files (.ibd and .cfg) - there are no dump files available and the server they came ...
SystemParadox's user avatar
2 votes
1 answer
480 views

Sync two MySQL servers data, while changing the Engine in the slave

I'm running a MySQL server 5.5.44, and I'd need to sync its data to a new server running MySQL 5.7.13 using master-slave. The idea is to bring both DBs synced until we migrate to the second, newer ...
Sergi Juanola's user avatar
2 votes
1 answer
419 views

Chain replication M1 (5.1) -> S1 (5.5) -> S2 (5.6) to limit downtime for an upgrade 5.1 to 5.6

I have to upgrade a production server from 5.1 to 5.6 version. The favourite option would be to dump the database from 5.1 and import on 5.6 but this operation has been estimated to 2 hours on my ...
Guillaume's user avatar
0 votes
1 answer
416 views

enable log_bin_use_v1_row_events in mysql 5.6

I have a MYSQL master with two slaves also running MYSQL 5.6. I want to create another slave and that needs to be MYSQL 5.5. I was wondering if replication will work smoothly. I have ...
roger moore's user avatar
2 votes
2 answers
122 views

What are some known hazards with cyclical replication between two MySQL master servers?

If I were to set up cyclical replication between a MySQL 5.6 master server and a MySQL 5.1 master server, what are some things that could potentially go wrong? Also, the 5.6 MySQL does not have GTID ...
user1805458's user avatar

15 30 50 per page