219 reputation
112
bio website debiki.com
location Gothenburg, Sweden
age 34
visits member for 2 years, 8 months
seen Jul 6 at 10:46

Software developer. On my spare time I'm sometimes building a hopefully better discussion system for blogs and forums:

About: http://www.debiki.com
Demo: http://www.debiki.com/demo/-71cs1-demo-page-1

All original source snippets that I post on StackOverflow and StackExchange sites are licensed under Creative Common's CC0 (in addition to the license prescribed by StackOverflow.)


Jun
27
comment MongoDB: Manual failover and failback between two datacenters?
Thanks for your reply :-) 1) I cannot see any single point of failure? Please note that the members in DC2 have prio 0; if DC1-M1 fails, DC1-M2 would be elected as the new primary. 2) An arbiter in a third DC is a good suggestion, thanks. I've read about that setup elsewhere and I like it, and it's what the MongoDB employees recommend. 3) Our application is an internal admin application only, it's not customer facing. A few hours in read only mode if a DC goes down is not a big issue in our case.
Jun
26
asked MongoDB: Manual failover and failback between two datacenters?
May
20
awarded  Popular Question
May
1
awarded  Popular Question
Apr
11
awarded  Yearling
Apr
11
comment MySQL master master replication, safe to delete rows on both masters?
We use mixed binary log format, which seems to mean that MySQL defaults to statement based, but switches to row based according to the rather many rules outlined here: dev.mysql.com/doc/refman/5.1/en/binary-log-mixed.html — it seems too complicated to determine what MySQL will actually do, so I suppose we'll simply allow only one single master to delete old log data.
Apr
11
accepted MySQL master master replication, safe to delete rows on both masters?
Apr
11
comment MySQL master master replication, safe to delete rows on both masters?
@DerekDowney It would be a bit simpler for us to have the same configuration on both masters. Also, the script would be a little bit less complex if it didn't need to think about if it runs on the active master or the passive master. — We do have one active master however, when it comes to other kinds of write requests, and one passive master (that writes nothing), as standby.
Apr
10
asked MySQL master master replication, safe to delete rows on both masters?
Apr
10
awarded  Informed
Apr
4
awarded  Tumbleweed
Mar
28
asked MySQL 5.1 replication broken after crash, duplicate key error, why? No redo log corruption
Nov
25
comment MySQL relay log corrupted, how do I fix it? Tried but failed
Thanks @Michael-sqlbot, then I think that if this problem happens again, I'll do SET GLOBAL sql_slave_skip_counter = 1; START SLAVE; and skip one event on the slave, and hope that helps — does that make sense? If it doesn't help (if there's still a PK error), I'll import a dump with --master-data again.
Nov
25
comment MySQL relay log corrupted, how do I fix it? Tried but failed
Hi @Michael-sqlbot, I updated the question with the exact version number, which is 5.1.61 on both master and slave. Thanks for your comment, I'm actually interpreting it as a little indication that what I did ought to have worked :-) :-(
Nov
25
revised MySQL relay log corrupted, how do I fix it? Tried but failed
Clarify exact version number.
Nov
25
revised MySQL relay log corrupted, how do I fix it? Tried but failed
added 37 characters in body
Nov
25
asked MySQL relay log corrupted, how do I fix it? Tried but failed
Oct
18
comment Consistent logical backup of databases that use MyISAM and InnoDB engines
This answer says that if one uses mysqldump and specifies --lock-all-tables then the backup will be consistent, right? And one needs to run mysqldump only once: it'll be safe for both InnoDB and MyISAM at the same time, right?
Oct
11
comment mysql wont start after increasing innodb_buffer_pool_size and innodb_log_file_size
I think one shouldn't delete the log files, but rather move them elsewhere, and delete them a while later when you've successfully changed the log file size. Otherwise, you'd be in trouble if MySQL crashed before you ran service mysqld stop.
Aug
6
awarded  Popular Question