11 questions linked to/from Is it safe to use innodb_flush_log_at_trx_commit = 2
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 ...
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, ...
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 ...
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://...
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 ...
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 ...
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 ...
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. ...
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 ...
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 ...
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 ...