204 reputation
110
bio website debiki.com
location Oslo, Norway
age 34
visits member for 2 years, 4 months
seen Apr 14 at 7:05

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.)


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
Jul
13
comment Fulltext search limiting users possibilities
@JonSeigel You're correct. Now I edited/fixed my answer. (I was searching for PostgreSQL and had only PostgreSQL in my mind)
Jul
13
revised Fulltext search limiting users possibilities
Strike out section.
Jul
13
answered Fulltext search limiting users possibilities
Jun
21
awarded  Teacher