RE: mysql - OT

  • From: "Goulet, Dick" <DGoulet@xxxxxxxx>
  • To: <RMohan@xxxxxxxxxxx>, <ORACLE-L@xxxxxxxxxxxxx>
  • Date: Mon, 11 Apr 2005 10:25:55 -0400

I agree, PostGreSql is much superior to MySql.  So I'd propose changing
out LAMP (Linus, Apache, MySql, PHP) for LAPP(Linus, Apache, PostGreSql,
PHP).  Makes a lot more sense as it'll take MySql at least another
decade to catch up.=20

-----Original Message-----
From: Mohan, Ross [mailto:RMohan@xxxxxxxxxxx]=20
Sent: Thursday, April 07, 2005 1:12 PM
To: ORACLE-L@xxxxxxxxxxxxx
Subject: RE: mysql - OT

echoing Walt "Dream" Weaver, this was a fun read.=3D20

I liked the bits about surfing pr)n the best. Consider=3D20
serializing that in future "MyPost" emails, I would.=3D20

I am just dipping toe into Postgres stuff, but it's
been around for almost two decades, has SQL compliance
and is ACID, and matches MySQL on speed at all but
the highest ranges, while superceding it on file
corruption/protection issues, and far superceding it
on stable features. Of course, MySQL is adding features
all the time.=3D20

I have to say the postgres install went very very smoothly,=3D20
and the pl/sql=3D3D=3D3D>pl/pgsql transition looks to be very
fast, too. Massive addition bennies to being able to
do perl, java, python, c, etc function directly in
database. neat. Also, in a single user, massive
streaming mode, PG keeps up very well with Oracle 9ir2.
We get about 120K direct path rows loaded per sec in
each. Not too shabby.

I hope this PG stuff pads out my rez, since there's nothing=3D20
like adding "Niche Opensource Database Dude" to de-commoditize
oneself. And at my "older than dirt" age, anything to keep
a leg up on you intelligent, energetic, single and rich
young'uns is worth its weight in fool's gold.=3D20

-- Ross

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =3D
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ellis R. Miller
Sent: Thursday, April 07, 2005 12:37 AM
To: weaver1308@xxxxxxxxx; 'oracle_l'
Subject: RE: mysql

This is a couple years old but still interesting benchmarking regarding

MySQL 5.0 now supports stored procedures, triggers, and views, in =3D
particular, and as someone else already mentioned PostgreSQL these =3D
features as well as a host of other advanced RDBMS features for many =3D

In the spirit of LAMP (Linux, Apache, MySQL, and PHP) I would embrace =
MySQL and consider the learning experience a healthy
smoking or surfing for pornography on Saturdays while the wife is at the
=3D both cases 45 minutes a week and one cigarette afterwards =
so what's the big deal. =3D20

I have developed a couple of LAMP applications and found they are =3D
infinitely less complex thus infinitely simpler to maintain and secure =
and in those cases MySQL and the LAMP solution, overall, offered a darn
stable, cheap, and homogenous (runs on Solaris or Linux, for example) =
alternative to Access (please reference Star Trek "The trouble with =3D
Tribbles" with regard to Access propagating itself to your enterprise =
LAN) or MS SQL Server. Further, MySQL serves and is often recommended as
the backend database to various open source applications such as Snort =
IDS (Intrusion Detection System). In that sense, it is worth installing,
configuring, and administrating at least one MySQL database as it is =3D
often coupled with other various open source tools & applications such =
as sniffers, intrusion detection systems, web log analyzers, source code
management, etc.=3D20

On a more practical note, since I am forever flirting with the IT job =
market while secretly earning my MTA truck driving certification (don't
tell my wife it's going to be surprise) I have noticed an increased =3D
demand for Oracle DBA experience as a primary skill and MySQL as a =3D
secondary one which still only accounts for around 3 contracts over the
past couple months where I have actually answered the phone (usually I =
just turn up the volume on Windows Media Player), spoken with a "person"
or an IT "I Am Sorry I Am Not Technical" Recruiter. The third most =3D
popular skill is the ability to work feral children hopped up on back =
pain medication and ready to swing on that kid whose basketball went in
their IT flower garden back in 1976, the same year that handsome Bruce =
Jenner won the gold in the decathlon. It's like he was poured into those
1970's running shorts.=3D20

On a side note, when I purchase a new car I approach the dealership =3D
under the assumption the middle-aged guy with the singular forehead =3D
sheen from too much Brylcreem whose smoking a cigarette and drinking =3D
coffee in the middle of the showroom whilst polishing his high school =
state football championship ring isn't actually the head of Engineering
for General Motors...he's just there to sell yet oddly enough he knows =
virtually all of the primary features and cool acronyms from the glossy
brochure despite never owning his own wrench. If someone has them the IT
recruiters of America need the Solaris and Oracle RDBMS glossy colored =
brochures...I am working on the one entitled "The Java and You."=3D20

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =3D
On Behalf Of Walt Weaver
Sent: Monday, April 04, 2005 4:03 PM
To: oracle_l
Subject: Re: mysql

On Apr 4, 2005 12:54 PM, stephen booth <> =3D
> On Apr 4, 2005 7:11 PM, David <thump@xxxxxxxxxxxxxxxx> wrote:
> > What are the largest pros and cons involved in discussing mysql=3D20
> > versus Oracle?
> MySQL doesn't have the recoverability features of Oracle, you lose
> disk and you've lost everything since the last backup.

Not true. MySQL binlogs are similar to Oracle redo logs and can be used
for point-in-time recovery. We have over 200 MySQL databases running 4.x
with binlogs and replication and have experienced no data loss from =3D
server crashes.

> MySQL scaling is a joke.

It certainly isn't in Oracle's league as far as scalaility is concerned.

> Stephen
--Walt Weaver
   Bozeman, Montana


Other related posts: