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 ‘Intermediate’ 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
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 [...]
Automating MySQL access with expect and bash scripting
Posted: 8th February 2010 by Darren Cassar in Databases, Intermediate, OS, UncategorizedTags: access, automation, bash, expect, MySQL
If you have multiple database servers with strange names, or if you have to hop over multiple machines to connect to any mysql database server, then you know what a pain it can be to administer such a setup. Thanks to some scripting, you can automate such tasks as follows: Create an expect script: /path/to/sshmysql.exp [...]