dveeden's blog

Empty transactions can be dangerous

Sat, 2014-07-05 11:09 — dveeden
Taxonomy upgrade extras: 

Inserting an empty transaction can be dangerous. Another server might request that transaction from that server and then it gets an empty transaction with the same GTID as the original one. So this is only safe for slaves which will never become a master or if all possible slaves already have processed this gtid.

Intelligent load balancer check

Mon, 2013-09-02 20:13 — dveeden
Taxonomy upgrade extras: 

I’ve setup an F5 to actually do a select and check wsrep_ready. F5 BigIP has an builtin mysql client. For more details see this article on f5 devcentral.

Feature differences between InnoDB FTS and MyISAM FTS

Tue, 2013-03-12 11:58 — dveeden
Taxonomy upgrade extras: 

There are some important differences between InnoDB FTS and MyISAM FTS. For example parser plugins won’t be used (but can be configured) (Bug #62004) and some defaults are not the same (InnoDB fulltext search in MySQL 5.6 part 2 at MySQL Performance Blog)

Tricky

Sun, 2012-12-02 15:41 — dveeden
Taxonomy upgrade extras: 

It’s a nice but tricky solution.
 

  1. If the procedure is dropped, so are the grants (doesn't happen if you drop the database 'tracking')
  2. If the init_connect fails the user is denied access.
 
It would be nice to let the user know the last login ts. I tried to do this by adding a SELECT at the start of the login_trigger procedure, but this doesn't work.
Subscribe to RSS - dveeden's blog