Posts Categorized: Technical Blog
Larry Wall gave another of his unique keynote addresses at the first day of YAPCEU 2010 here in sunny Pisa (yes the place with the tower) This year was a little diversion from his usual pattern as Larry was assisted by his better half and his demon seed. Larry told us as a language designer his life is one of siting on the fence, not making up his mind until that one little voice in one ear (his better half) and that other little voice in the other ear (his demon seed) work it out somehow.
Welcome to Log Buffer, a weekly review of the database industry. This week’s issue Log Buffer #198 is generously published by Sam DeFilippis, who manages Oracle Notes blogs, with latest postings on Oracle GoldenGate.
The first non-development version of XML::XSS has been released on CPAN. The big delta since the last blog entry (XPathScript Reborn) is the re-introduction of templates, and a generous slathering of overloaded shortcuts for stylesheet definitions.
Log Buffer #197 marks the middle of summer, and the fact that we’re a mere two weeks away from our 200th edition.
Today marks my last day at Pythian. I have been at Pythian for almost three years. In those three years, Pythian’s already thriving MySQL practice has grown even more. I have worked with big and small clients alike, across many industries, managed a team of up to 4 DBAs, and learned a lot not just about MySQL, but what my goals are in general.
I’ll be giving a webinar about Exadata implementation, where I’ll be talking about Exadata features and how best to use them. I’ll also be sharing some lessons learned from my own implementation experience. The webinar will be on Wednesday August 11 at high noon eastern time. Note that this is a change from the previous date.
Dynamo: Amazon’s Highly Available Key-value Store” is a high level description of a data store, written by Amazon to solve the problem of a system where updates must never ever fail and must take less than a specific amount of time in 99.99% of the cases. No matter what happens to the servers or the network, updates to the system must continue as usual, and they emphasize that they deal with hardware and network failures nearly constantly.
After covering hardware components of Sun Oracle Database Machine in part 1, our grand tour continues with a look at the software side. With the prominent exceptions of the Exadata storage server software and the Oracle database itself, the software stack is based on well-known and widely used open source products.
IOUG has a free series of three webinars on upgrading MySQL. Each webinar is an hour long, and it starts with a webinar by me tomorrow at 12 noon Central time (GMT-5) on “Why and How to Upgrade to MySQL 5.1″. The webinar assumes you are upgrading from MySQL 5.0 to MySQL 5.1, and talks a little bit about the new features, server variables, and what you need to know when upgrading to MySQL 5.1.
One common question I get is how to use partitioning instead of MERGE tables. The process I use involves using stored procedures to create and drop partitions. This article will go over the stored procedures I use; special thanks to Roland Bouman for taking a look and giving great feedback to optimize this process.