Friday Oct 03, 2008

High Availability With MySQL

I will be talking on the topic of "High Availability with MySQL" at SiliconIndia Web Development Conference being held on October 4, 2008 in Bangalore. The conference url is http://www.siliconindia.com/webdev

This is an exciting topic to talk about. More over, I am looking forward to listen to other talks as well. Another Sun Speaker, Praveen Chandrasekharan will be talking about Web applications with Open Solaris Web Stack.

You can download slides from here

Here is my updated report after the conference :

We had good amount of crowd (over 600) for the event. It was also partially because it was combined as Job Fair + conference. The other companies who were present were Adobe, Ingres, Webyog, Aztec software, Microsoft and few others.

My talk was well received, and people seem to be keen on knowing about high availabiity aspects. I had just 30 mins, so I had to fastforward few slides and stick to high level concepts only. After the talk I met with few different people who had many questions about MySQL configurations and I offered them different suggestions and I hope they found it useful.

The other Sun speaker Praveen presented about opensolaris webstack. We had demo of open solaris webstack at our booth and many were interested in knowing Dtrace support for apache, MySQL, etc in open solaris. This is one of the main things which provided unique value for attracting them to try opensolaris. It was good to see many people around sun booth.

Thursday Apr 24, 2008

Database SQL standards

The SQL standards are unlike most other standards -- virtually no database vendor could claim full conformance of the latest standards. Often innovations and new extensions happen even before the standards are in place. Also it is common for vendors not to implement certain features depending on the returns Vs other factors.

National Institute of Standards and Technology (NIST) used to develop SQL conformance tests. NIST stopped developing SQL conformance tests since 1996. You can download the conformance test for SQL-92 from their SQL Test Suite Download page

Currently there is no international body which has developed conformance test for the latest standards SQL:1999 and SQL:2003. Neverthless, it pays to understand the history and high level understanding of the spec, if you are in the business of developing database or writing non-trivial database applications.

Here is the latest SQL:2008 draft standard if you like to take a look.

Here are some more interesting links :

About

thavaa

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today