Loading ...Scenario: Master-Master replication Description: Master A is the active db server whilst Master B is a read only swappable db server hence both are creating binary logs. During backup I run “FLUSH LOGS” in order to have a simpler point in time recovery procedure if that case arises. Problem: Flush logs is mean mean command [...]
Posts Tagged ‘MySQL’
Do you use MySQL replication? Do you use “FLUSH LOGS”? If yes you might want to read this.
Posted: 31st August 2010 by Darren Cassar in Intermediate, MySQLTags: binary log, error log, flush logs, MySQL, replication
4
Rediscovering the roots.
Posted: 28th August 2010 by Darren Cassar in MySQLTags: dolphin, logo, MySQL, sakila
Do you ever stop and think? It happens to me all the time, random subjects kick in and I end up searching (aka googling) and today I wondered … Why is MySQLs logo a dolphin? Shame on me it took me so long to ask the question but as the saying goes, better late than [...]
Getting a return code from a stored procedure
Posted: 26th August 2010 by Darren Cassar in Intermediate, MySQL, UncategorizedTags: MySQL, stored procedure, stored procedures
Sometimes we have some special need for a stored procedure to call another to do something. That is fine, but what if the second stored proc failed for some reason? Maybe you want to halt the first stored procedure (the caller) and not proceed with the work until the problem is verified and resolved. So [...]
Securich 0.3.0
Posted: 19th August 2010 by Darren Cassar in MySQL, UncategorizedTags: conference, froscon, grants, MySQL, roles, securich, security
Around these days last year I presented `securich` for the first time. It was at froscon 2009, barely knowing anybody, spending my 27th birthday in a hostel in Germany fixing some bugs before the actual presentation on a 10 inch netbook (my mac had some problems at the time but thats another story :)). I [...]