10,813 reputation
11229
bio website
location Cincinnati, OH
age 44
visits member for 2 years, 6 months
seen 18 hours ago

I am a professional MySQL Database Administrator and Amazon Web Services infrastructure specialist.

My services are available when time permits; please feel free to contact me, michael at sqlbot dot net for rates, availability, and other information.

When you're browsing the Stack Exchange sites, and find something useful, helpful or just interesting, please take a moment to vote... Your votes on our questions, answers, and even comments that you found helpful, accurate, and informative are important -- and it's really not because of the reputation scores. Every time you vote, the person whose contribution you voted on gets an unobtrusive and anonymous little notification message to remind us that the hours we invest in this community are helpful and valuable.


Oct
20
comment Dealing with Mysql Replication and Functions
On the other hand, the number of read-only slaves you can deploy is virtually unlimited, since slaves can cascade from other slaves, as well as from the master.
Oct
20
comment Dealing with Mysql Replication and Functions
@jcho360 there's not really a meaningful limit. You'd have to stay below 255 masters to avoid collisions in UUID_SHORT() and below 65,535 masters to avoid problems with auto_increment_offset and _increment but those are all unreasonably large numbers of master servers. Avoiding consistency issues becomes almost exponentially complex as master server count rises. If you need more than 2, look at Galera in MariaDB or Percona server, both MySQL compatible, for synchronous replication.
Oct
20
comment MySQL: #126 - Incorrect key file for table '/tmp/#sql_9dc_1.MYI'; try to repair it
Try observing your free disk space with df -k while the view is opening. If the view needs to build a temporary table while it's opening, you could be running out of free space. The space will be used up, then freed again, as the space consumed by the failed temporary table creation attempt will be freed almost immediately when the error is returned, if this is your problem.
Oct
17
comment Rows are not getting deleted from MySQL Table
On the InnoDB server, SELECT @@global.autocommit;... shows 1 or 0? Is this a new problem, or did you have a working system that stopped working? Can you update or insert from the Federated side?
Oct
17
comment MySQL has gone away with two connections
SET GLOBAL LOG_WARNINGS = 2; and try again? Then check the MySQL error log...
Oct
16
reviewed Close MySQL keeps inserting new rows automatically
Oct
16
reviewed Approve
Oct
16
reviewed Approve
Oct
16
answered Dealing with Mysql Replication and Functions
Oct
13
comment MySQL Binlog Dump process stops after net_write_timeout
Interesting. But mysql client run on db01 connecting to db01 is fine, right? Also, connections from other machines to db01 using mysql client are fine, too? Have you tried connecting to db01 from elsewhere with mysqlbinlog? Are the two server machines on the same subnet, same lan, or...?
Oct
13
answered MySql MBRCONTAINS not accurate
Oct
13
comment returning the number of columns in a row that are zero in mysql
@Kondybas ... "returns NOT NULL if operand is NULL" ...? Negating null is still null.
Oct
12
reviewed Close Saas MySQL Multiple Databases or One Database
Oct
12
reviewed Close Get player count per match on a matchmaking server
Oct
11
comment MySQL 5.6 replication causes 'waiting for table lock'
SELECT @@BINLOG_FORMAT; on the master. If it's STATEMENT, consider changing to ROW or perhaps MIXED.
Oct
11
comment Sync 8 tables of differents databases on same server
@Jacques-AlexandreBossu I inadvertently omitted the keyword AS before SELECT in the view definition. Updated.
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