OurSQL Episode 57: Eventual Discovery part 2

This week we continue our series on events. We talk about events and logging, event timing, privileges and runtime behavior.

Feedback
Gazzang is using encryptfs for their encryption. According to their launchpad project page at https://launchpad.net/ecryptfs, "eCryptfs is a POSIX-compliant enterprise-class stacked cryptographic filesystem for Linux".

The main topic is the 2nd part of events:

What events log and where the event logs are
How errors show up in the error log
How events and their actions get logged to the binary logs (aka events and replication), including how the "ignore" and "do" replication limitations work with events. Manual page: http://dev.mysql.com/doc/refman/5.5/en/stored-programs-logging.html

Event timing -- the manual page includes a table of what time values and time zones are used for particular metadata about events - http://dev.mysql.com/doc/refman/5.5/en/events-metadata.html

Privileges needed for events (manual page is at http://dev.mysql.com/doc/refman/5.5/en/events-privileges.html)

Runtime behavior for events (e.g. sql mode, charset, collation, definer)
Event limitations - manual page is at http://dev.mysql.com/doc/refman/5.5/en/stored-program-restrictions.html

Ear Candy
This week's ear candy notes how the description of the buffer for the InnoDB log files on disk has changed in MySQL 5.5 - http://dev.mysql.com/doc/refman/5.5/en/innodb-parameters.html#sysvar_innodb_log_buffer_size

Where you can see us
We will both be at Oracle Open World 2011 from Sunday October 2nd through Thursday, October 6th. We will be speaking and staffing the MySQL Community booth. There are links to a PDF and HTML version of MySQL sessions at Oracle OpenWorld at http://bit.ly/oow11mysql

MySQL Community Reception (free, no need to be registered to Oracle OpenWorld) - Tuesday, October 4, 2011 7-9 pm at the San Francisco Marriott Marquis in room Foothill G. RSVP for the *free* MySQL Community Reception.

Sarah will be at the October Seattle MySQL User Group (http://www.meetup.com/seattlemysql/) on Monday, October 3rd from 7 - 9 pm.

Sheeri will be at the Boston MySQL User Group on Monday, October 10 at 7:00 PM where Ari Weil, Product Manager of Akiban Technologies will present: "Renormalize - Solving Performance Problems in MySQL Without Denormalization".

Sarah will be at the November Seattle MySQL User Group ( http://www.meetup.com/seattlemysql/ ) on Mon Nov 7th from 7 - 9 pm

Boston MySQL User Group on Monday, November 14th at 7:00 PM where Mike Frank of Gazzang will present “MySQL Encryption”.

Feedback
Facebook group
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast