At the event, MySQL co-founder David Axmark talked through some of the history of the …[Read more...]
|Showing entries 1 to 10 of 16||6 Older Entries|
Joe Stump, Lead Architect, Digg. Slides should make its way at Joe’s website soon enough.
Mainly works on the backend, makes sure its scalable, can all the Digg buttons be served, et al.
Application layer is loosely coupled from your data. Whole point of SOA? You can put a service in front of the DB, and move between DB’s if required.
They do use MySQL, but its pretty vanilla.
Old habits die hard
- Data requests are sequential (I need foo, bar, bleh, ecky)
- Data requests are blocking (When you need foo, …
Baron Schwartz gave a most interesting talk about EXPLAIN. You will definitely want to read his slides (filled with detail), when they make their way online. These notes are very sparse, just bits that I didn’t see in the slides, that Baron mentioned verbally. Plenty of good questions, and plenty of interaction.
EXPLAIN only works for SELECT queries.
How does MySQL execute queries? Optimisation happens even as the query is being executed. As the query is being optimised, some execution happens as well. Execution Plan is a data structure, not bytecode.
When EXPLAIN’s output is generated, MySQL actually executes the query. It just …[Read more...]
Download the PDF: http://www.mysqlfulltextsearch.com/full_text.pdf
Default search by relevance, default sort is by relevance
Boolean search is also popular. cats AND dogs. No default sorting, so you need to order the results yourself
MySQL Full Text Index, only available with MyISAM, and it supports natural language and Boolean search. ft_min_word_len - 4 characters per word by default is indexed. Frequency based ranking, doesn’t count distance between words
SELECT * FROM articles WHERE MATCH (title,body) …[Read more...]
Ahead in the Cloud - The power of Infrastructure as a
CTO Amazon.com, Dr. Werner Vogels
Pretty much everyone in the audience uses Amazon!
Announced: Persistent Storage for Amazon EC2.
Hitting one page, might actually go to 250 different services, before the page is generated for you. Shows the use of a tool (Amazon internal), that graphs it.
SaaS: Develop -> Test -> Operate
Hardware costs? Software costs? Maintenance? Load balancing? Scaling? Utilisation? Idle machines? Bandwidth management? Server hosting? Storage management? High availability? All this is the …[Read more...]
I wish I had better notes, but I was enthralled by Jonathan Schwartz’s (CEO, President, Sun Microsystems) keynote. It was truly, very amazing an influential. He’s a great speaker, and very motivated (and I think he’s motivated a lot of the audience).
What is Sun’s Agenda?
Similar values, cultures, and similar dysfunction’s like any family.
The Texas Advanced Computing Center - 500 teraflop “open” super-comptuing facility.
“Computational science is the third mode of discovery, complementing physical experimentation and theory” — Daniel Atkins III, Director, Office of …[Read more...]
Live blogging from Marten Mickos’ (SVP Database Group) keynote at the MySQL Conference and Expo 2008.
Why did Sun acquire us?
The culture and the vision. Biggest match with Sun. “Network is the computer” and “Best Online Database”. Great affinity.
Its a 1 billion dollar vote for the LAMP stack.
Integrating better with OpenOffice.org, run better with Glassfish, and so on. Now, performance and scaling is number one, to make databases run faster. It will take time, but it will be very positive.
This conference itself is just as big as LinuxWorld was seven years ago.
An …[Read more...]
2008 MySQL Application of the Year
Social Network - MySQL powered with over 70 million active users (Facebook)
Mobile operator - Highly available LAMP platform at the heart of SMS, mobile and CRM applications (Virgin Mobile France)
eCommerce site - Built caching tier using MySQL for 4 billion transactions per day (eBay)
2008 MySQL Partner of the Year
Open source backup solution (Zmanda)
Expanding support for open source (Microsoft)
Leading reseller (Computercenter)
2008 MySQL Community Member of the …[Read more...]
In-between Marten’s keynote, Rich Green, EVP Software, Sun Microsystems, comes up on stage, and here’s my live-blog.
He talked about the famous dinner last year, for buying MySQL. Autonomy reigns supreme in MySQL. MySQL continue at their same course and speed. The plan is the plan, until there is a new plan - and there is no new plan.
Sun has a heterogeneous platform. Many partners, including Dell, IBM, Intel, and so on. Lots of open source in terms of software. The cultures, discourse, intellectual arguments, its an excellent mash up, this Sun and MySQL. Don’t Panic! There is no change for what has been an incredibly successful …[Read more...]
I first decided to try how things were in Windows Vista land, the moment I was told during a talk of mine that MySQL refused to install on Vista. I gave it a twirl (after disabling User Account Control - UAC) and found that I got a rather quaint error message from the MySQL Server Instance Config Wizard (MySQLInstanceConfig.exe) [this after it failed to start once the installer was complete]:
The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more details.
I hopped over to the event log (Event Viewer), and the error displayed was:
|Showing entries 1 to 10 of 16||6 Older Entries|