Who uses MySQL and why?

There are tons of MySQL installations. But, I think most of them are
for very light-weight applications: blogs, small time ecomm, CMSes.

I have read that mysql is used by telecoms. What is there about mysql
that telecoms like? Is it just cost? Why don't they use postgresql?

Is there likely to be much adoption of mysql for heavy-weight, highly
secure, applications, like financial and/or medical applications? If
not, why not?

In article
<8c133c2c-87a6-4435-9910-f6a735a427de@f24g2000prh.googlegroups.com>,
walterbyrd <walterbyrd@iname.com> wrote:

> There are tons of MySQL installations. But, I think most of them are
> for very light-weight applications: blogs, small time ecomm, CMSes.

Wikipedia runs on top of MySQL. According to the latest stats, it's got 10
million articles, 1.7 billion words, 684 million visitors per year,
20-45,000 pages per second. That's hardly a lightweight application.

On Apr 26, 9:56 am, Michael Vilain <vil...@NOspamcop.net> wrote:
> In article
> <8c133c2c-87a6-4435-9910-f6a735a42...@f24g2000prh.googlegroups.com>,

> Since Walter posted from a Linux box, I'm guessing there's some Fanboy
> agenda going on here. What problem are you trying to solve? Or are you
> just trying to provoke controversy?

I don't think it's fair to suggest that I am trolling. I am posting
from a Linux box, but my questions are sincere, and not at all flame-
bait.

I do sysadmin work. I have been looking for a new job since February
when my contract at Sun ended (the department was offshored to
Argentina). I am not happy with the sysadmin jobs that I'm seeing
advertised these days. I have thought about getting more into DBA
work.

I have some experience with databases, both development and admin. But
not enough to be considered a DBA. I have thought about getting the
MySQL certs, and seeing if could get started with that.

I know, only experience matters, certs don't mean anything . . . But,
come on, everybody has to start somewhere. And certs might help me get
my foot in the door.

I have mixed feeling about MySQL and it's future. I wonder where MySQL
is going. Two years from now, will MySQL still be used primarily for
light-weight web-apps? Or, will MySQL be seen as an enterprise capable
RDBMS?

On Apr 26, 9:56 am, Michael Vilain <vil...@NOspamcop.net> wrote:
> In article
> <8c133c2c-87a6-4435-9910-f6a735a42...@f24g2000prh.googlegroups.com>,

> I imagine anyone trying to get
> away with doing multi-million row databases on the cheap will get what
> they pay for if they use MySQL. If you want to put your SAP database on
> MySQL, I'd wonder about the CIO considering such a thing.

I can hardly imagine such a thing either. But, MySQL was just
purchased by Sun. So maybe - just maybe - in the not-so-distant
future, we will see the enterprise edition of MySQL running on a
cluster of Solaris servers, and supported by Sun. Running SAP on
something like that might not seem so insane to a CIO.

> AFAIK, it's
> not free for commercial use.

My understanding is that MySQL is free for commercial use, as long as
you don't embed MySQL code in a binary product, and then distribute
that product. However, for serious commercial use, I would expect
companies to use the enterprise edition.

> you have to shutdown MySQL to ensure database integrity.

I thought that replication, and clustering, were ways to get around
that limitation.

Michael Vilain wrote:
> In article
> <8c133c2c-87a6-4435-9910-f6a735a427de@f24g2000prh.googlegroups.com>,
> walterbyrd <walterbyrd@iname.com> wrote:

> Mostly, what are you trying to accomplish? How familiar are you with
> databases and their care and feeding? I imagine anyone trying to get
> away with doing multi-million row databases on the cheap will get what
> they pay for if they use MySQL. If you want to put your SAP database on
> MySQL, I'd wonder about the CIO considering such a thing. AFAIK, it's
> not free for commercial use. Postgres at least offers transactions
> which MySQL 4 lacks. MySQL 5 isn't all out there yet in the small,
> shared webhosting environments where the Apache/php/MySQL/perl combo is
> so popular for small-to-medium web sites.

MySQL 4 was rather basic, but MySQL 5, with InnoDB tables, is serious.
We now have atomic transactions, rollback, and database replication.
So the system scales up to reasonably large size operations.

John Nagle

On Apr 26, 8:36 am, walterbyrd <walterb...@iname.com> wrote:
> There are tons of MySQL installations. But, I think most of them are
> for very light-weight applications: blogs, small time ecomm, CMSes.
>
> I have read that mysql is used by telecoms. What is there about mysql
> that telecoms like? Is it just cost? Why don't they use postgresql?
>
> Is there likely to be much adoption of mysql for heavy-weight, highly
> secure, applications, like financial and/or medical applications? If
> not, why not?

It occurs to me that the best people to answer this question may well
be the sales people at the MySQL offices. They ought to know all of
this, because that's exactly the kind of information that helps sell
the product.

walterbyrd a écrit :
> There are tons of MySQL installations. But, I think most of them are
> for very light-weight applications: blogs, small time ecomm, CMSes.
>
> I have read that mysql is used by telecoms. What is there about mysql
> that telecoms like? Is it just cost? Why don't they use postgresql?
>
> Is there likely to be much adoption of mysql for heavy-weight, highly
> secure, applications, like financial and/or medical applications? If
> not, why not?
================================================== =====================
Hello !!

I've begun with MySQL in 1995. The applications used were: web, but many
databases made for Nuclear Labs, Télécom Labs, Research Labs.

When MySQL 3.23 and 4.x arrived, some big market actors industries
(cars, army, nuclear, pharmaticals, medical, finance and so on,..) have
adopted this new database for prices, performances, simply to use.

With MySQL 5.x, it's revolution. This BDD is on top and is concurrent
with MS, Oracle, Sybase ....

MySQL is provided with commercial (MySQL Enterprise) or no commercial
(MySQL Community).

MySQL can be use for for heavy-weight, highly secure, applications, like
financial and/or medical applications, nuclear, spacial, aeronautics,
embedded in noteads, pdas, smartphones, .... Some characteristics are
replication, cluster, scalability, ..., business intelligence.

For Telecom industries, it's a really business: in all new Alcatel PABX,
MySQL is present with an OS named BSD (embedded licences is a very
good thing for them, with volume). See case Utel Telecom.

And the future version 6.0 with Falcon Engine and Maria Engine (code
name), it will be a very good product.

Postgresql is not on the same line. This BDD is an Oracle like. So, most
heavy, less known but solid too.

Regards,
Forums