Linked Questions

11 votes
2 answers
37k views

Dynamic change to innodb_flush_log_at_trx_commit

This is related to this question. It does help to get better performance for InnoDB tables. According to MySQL manual, innodb_flush_log_at_trx_commit is a global dynamic variable. Thus, I can change ...
Sithu's user avatar
  • 347
3 votes
2 answers
7k views

MySQL Master-Master Replication not syncing

SETUP: I have a WAMP MySQL Master-Master replication setup on 2 machines with sync_binlog=1 for safety. Machine config: Windows Azure Standard 2: 2 core, 4GB RAM, Windows Server 2008, MySQL 5.6.12, ...
bob's user avatar
  • 51
1 vote
1 answer
5k views

Fastest way to do a mysqldump restore on Amazon RDS?

We need to restore a database from a 7-Gb mysqldump file to a RDS Amazon instance. The full restore takes between 3 and 4 hours (probably because of network latency since the dump has to reside on a ...
dr_'s user avatar
  • 1,314
3 votes
1 answer
3k views

Database replication without locking tables

I've been asked to setup replication between master and slave database. The aim is not to lock any tables while dumping database. I've never setup replication but I have found this guide: https://...
LukeJ's user avatar
  • 43
1 vote
2 answers
2k views

Mysql sync_binlog = 50 and innodb_flush_log_at_trx_commit = 2 with replication

I'm looking into sync_binlog = 50 and innodb_flush_log_at_trx_commit = 2 to improve write performance. There is this question, but it doesn't address the specific problems with replication. I have an ...
Halfgaar's user avatar
  • 191
2 votes
1 answer
2k views

innodb_flush settings on Amazon RDS

Setting innodb_flush_log_at_trx_commit = 2 improves my application performance considerably on my local development environment. The response time and number of requests per second on a 40 concurrent ...
Pedro Werneck's user avatar
0 votes
1 answer
861 views

Mysql Percona 5.6 slave lags gradually

I have got into slave lag gradually say every minute it lags around 5secs on slave. So it started morning 10AM the Seconds_behind_master was 13. Now at 4:30 PM it has reached to 560. No variable ...
Mannoj's user avatar
  • 1,551
1 vote
1 answer
617 views

MySQL 8.0.20 - Master Replica scheme, increasing delay between Source and Replica

We have a Source Database of about 1TB, and a Replica on another server (similar architecture). We have setup Master Slave replication and delay between Master and Slave is always growing since. ...
user1458792's user avatar
0 votes
1 answer
425 views

what is the best configuration for innodb_flush_log_at_trx_commit?

There are 3 different configuration is available for innodb_flush_log_at_trx_commit innodb_flush_log_at_trx_commit = 0 innodb_flush_log_at_trx_commit = 1 innodb_flush_log_at_trx_commit = 2 Which ...
Manivannan's user avatar
2 votes
1 answer
291 views

Using innodb_flush_log_at_trx_commit = 2 with RDS MultiAZ - Safe?

I understand the downsides of using the parameter setting innodb_flush_log_at_trx_commit = 2 If you want to know more, look at another answer, for example Is it safe to use ...
Matt The Ninja's user avatar
2 votes
1 answer
102 views

Which hardware you suggest?

I'm completely new to buying a database hosting and I would greatly appreciate your opinion about the following situation. I just created an App and I want to go live this weekend. I want to be ...
Kevin Vermaat's user avatar