9,356 reputation
11025
bio website
location Cincinnati, OH
age 43
visits member for 2 years, 1 month
seen 2 hours ago

If you question or otherwise fail to recognize the superiority of the relational model... you're doing it wrong.


Oct
11
revised Sync 8 tables of differents databases on same server
missing keyword
Oct
11
answered Upgrading from MySQL 5.1.37 to MySQL 5.1.73
Oct
11
reviewed Close Split date/time range into day ranges
Oct
11
answered Sync 8 tables of differents databases on same server
Oct
11
reviewed Close Conditionally updating the columns PHP/MySQL
Oct
11
reviewed Close Very high load avg for MySQL database
Oct
11
comment MySQL Binlog Dump process stops after net_write_timeout
Also, SET GLOBAL LOG_WARNINGS = 2; everywhere, if it isn't, for some slightly increased verbosity in the MySQL error log.
Oct
11
comment MySQL Binlog Dump process stops after net_write_timeout
The version of mysqlbinlog shipped with 5.6 has a handy ability to "spoof" a slave connection to the master and stream the binlog at you in real time, and this should be an ideal test tool. mysqlbinlog -p --user='username with replication slave privilege' --base64-output=decode-rows --verbose --stop-never --host='db01-hostname-or-ip' --read-from-remote-server mysql-bin.001532 (current binlog). Run this actually on db01 pointing to db01, and on db02 pointing to db01, and also maybe from elsewhere on the network. It should reveal something interesting about which component is broken.
Oct
11
answered Calculating difference between consecutive timestamps. Error when i reach the hour mark
Oct
7
comment Create table on a Master - Master config avoiding replication
dev.mysql.com/doc/refman/5.6/en/set-sql-log-bin.html sql_log_bin is a session variable that defaults to 1. If you set it to 0 it disables binary logging of any statements you issue until you disconnect or set it back to 1. The application, here, is to allow you to alter the table without that individual statement getting replicated, because you want the servers to have a table that is identical other than the storage engine.
Oct
7
answered Create table on a Master - Master config avoiding replication
Oct
7
comment Log all table updates for all tables in MySQL
I'm not sure what you mean by "copied" databases.
Oct
6
comment Log all table updates for all tables in MySQL
Have you considered the binary log as a source?
Oct
6
comment MySQL - Checksum won't match between master and slave hosts despite dumping and reloading the table
Granted, the other question does not have a satisfactory answer at all, since the change that occurred between 4.1 and 5.0 should not be impacting you, now... but the question is still the same. I've long-suspected a latent bug in the way CHECKSUM TABLE works. One thing that might be worth trying is doing an OPTIMIZE TABLE on the master to check and see if the checksum remains the same there after the table is rebuilt.
Oct
6
reviewed Close MySQL configuration to connect to multiple local applications
Oct
6
revised Is it possible to modify an existing trigger definition in MySQL?
clarify the question; clearly triggers can be changed with drop/create, but this appears to be asking for an alternative
Oct
6
answered Is it possible to modify an existing trigger definition in MySQL?
Oct
5
comment How to handle too many instances of multiple tables?
Are these tables MyISAM? Are you experiencing a performance issue, now? Are you seeing errors?
Oct
5
comment mysql service takes too much memory
"Persistent connections also cause high CPU usage" ... "may cause sockets to wait for requests, which causes over usage of CPU" ... sorry, these statements are just not accurate when applied to MySQL.
Oct
4
answered How to swap roles of Master-Master?