At the March Boston MySQL User Group meeting, Jacob Nikom of MIT's Lincoln Laboratory presented "Optimizing Concurrent Storage and Retrieval Operations for Real-Time Surveillance Applications." In the middle of the talk, Jacob said he sometimes calls what he did in this application as "real-time data warehousing", which was so accurate I decided to give that title to this blog post.
Patrick Galbraith, former MySQL employee who helped write replication, came to the November 2007 Boston MySQL User Group and did a fantastic presentation on replication, including showing how to set up replication and walking us through the steps in real-time, setting up an example server.
The Boston MySQL User Group was successful yet again! I was a bit worried about my presentation, that it would be too basic or folks would have wanted to see actual code and scripts, but it turned out well.
Special thanx to Mike Kruckenberg for taking the video and taking pictures!
Folks who were at the presentation — feel free to let me know what you thought of it. Folks not at the presentation — feel free to watch the video and let me know what you think. You can download the PDF slides here.