Tags | Domains | Searches | Statistics | Options | Advanced Search
|
Tags | Domains | Searches | Statistics | Options | Advanced Search |
5 hours ago
Recently I had an interesting issue crop up. Due to an unfortunate migration incident in which involved master/master replication and not checking to see if replication was caught up, we ended up with an infinite …
Tagged: binary, replication, mysql, awk, group blog posts, mysqlbinlog, binary log, server id
Oct 10, 2008
The 118th edition of Log Buffer , the weekly review of database blogs, has been published on Ward Pond’s SQL Server blog. Log Buffer is the only platform-neutral, distributed, human-edited article on database blogs …
Tagged: sql server, oracle, mysql, postgresql, non tech articles, log buffer
Oct 9, 2008
In many parts of the world times are uncertain. I live in the United States and we are in the middle of a financial meltdown that many fear may be as bad as the Great Depression. Because the world’s economies are so …
Tagged: employment, mysql, recession, market penetration, non tech articles
Oct 9, 2008
This is a post about SYSDATE() and NOW() and CURRENT_TIMESTAMP() functions in MySQL. Firstly, note is that of these three, only CURRENT_TIMESTAMP() is part of the SQL Standard. NOW() happens to be an alias for …
Tagged: time, replication, now, mysql, timestamp, deterministic, datetime, sysdate
Oct 9, 2008
Quite often we need to perform a so-called “MySQL instance audit”. This common DBA procedure should give you a general view of the MySQL environment. You may be interested in a basic understanding of what kind of …
Tagged: mysql, audit, show status, mysqltuner