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 [...]
Archive for the ‘MySQL’ Category
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 [...]
MySQL stored procedure debugging, can I sue for going insane?
Posted: 23rd August 2010 by Darren Cassar in Advanced, MySQLTags: debugging, mysq, procs, stored procedure, stored procs
Lets paint the picture: Scenario part 1 : Migrating a couple thousand stored procedures from database technology X to mysql Scenario part 2 : Legacy system where the people who wrote it left a long time ago Scenario part 3 : Developers sure can get real creative and invent all kinds of ways to get [...]