SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Guest editorial: Reasons to be Cheerful


Guest editorial: Reasons to be Cheerful

Author
Message
Chris Harshman
Chris Harshman
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10421 Visits: 4629
dphillips (2/4/2009)
One must understand that MySQL is a "plugin" architecture, where the SQL service engine is a layer over potentially many different types of engines (15+ types). This is a feature and a bug. Only one of these engines was advertised as ACID compliant (INNODB), and MySQL did not even own that engine.


To counter Oracle's purchase of INNODB, MySQL hired Jim Starke to help them develop the Falcon engine for MySQL 6. Alpha versions of this have had some performance issues though. I wonder how much effort was taken away from the 5.1 product line to help build 6.0? I can't imagine that's a 1 man job to create a new database engine plugin that's expected to be enterprise class.

While there may be some people who move from MySQL to SQL Server, I imagine people in that area would be more likely to move towards PostgreSQL, Firebird, or one of the other open source databases out there. Both of those are full featured databases that have ACID compliance, enterprise capabilities, and SQL Standards for years that MySQL has only recently gained. They also both run on many platforms, so if you're running MySQL on Linux, BSD, or Solaris, you're more likely to move to a different database that can run on the same hardware/OS you already have.
DPhillips-731960
DPhillips-731960
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1586 Visits: 801
Chris Harshman (2/5/2009)
dphillips (2/4/2009)
One must understand that MySQL is a "plugin" architecture, where the SQL service engine is a layer over potentially many different types of engines (15+ types). This is a feature and a bug. Only one of these engines was advertised as ACID compliant (INNODB), and MySQL did not even own that engine.


To counter Oracle's purchase of INNODB, MySQL hired Jim Starke to help them develop the Falcon engine for MySQL 6. Alpha versions of this have had some performance issues though. I wonder how much effort was taken away from the 5.1 product line to help build 6.0? I can't imagine that's a 1 man job to create a new database engine plugin that's expected to be enterprise class.

While there may be some people who move from MySQL to SQL Server, I imagine people in that area would be more likely to move towards PostgreSQL, Firebird, or one of the other open source databases out there. Both of those are full featured databases that have ACID compliance, enterprise capabilities, and SQL Standards for years that MySQL has only recently gained. They also both run on many platforms, so if you're running MySQL on Linux, BSD, or Solaris, you're more likely to move to a different database that can run on the same hardware/OS you already have.


I completely agree with the first paragraph. I wonder about Sun's efforts to continue this?

On the second paragraph, it does put in perspective where MySQL really is in the pecking order. However, having used most of those other systems, I wouldn't call them enterprise replacements. There is huge gulf between the class, features, and bugs of products, even amongst the ones listed here.
Gift Peddie
Gift Peddie
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16050 Visits: 14456
Microsoft is looking for a few good BI developers to help with the next version of BI toolset.

This study starts on February 6 and runs till July 31. It will be a remote study and is open to all U.S.-based participants. We are looking for developers who are familiar with ETL, data warehousing, OLAP cubes, and MDX. We will be offering all participants a gratuity option in appreciation of your time. If you are interested in participating in this study please e-mail us at itusable@microsoft.com with "BI Developer" in the subject line.

Kind regards,
Gift Peddie
Gift Peddie
Gift Peddie
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16050 Visits: 14456
I just read some news that Sun is back to it old Solaris tricks again so MySQL founder quit that is not good. Sun needs the Linux and Windows running web hosting and developing users.

http://tech.yahoo.com/news/pcworld/20090205/tc_pcworld/mysqlcofounderquitssun

Whistling

Kind regards,
Gift Peddie
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search