Re: Seriously Disruptive DBA

[Mark Schoonover]

Jonathan,

On 8/24/07, Jonathan G. Lampe <[EMAIL PROTECTED]> wrote:
>
> Hello,
>
>Here's 4 easy steps that show how you too can be a "Seriously
> Disruptive" DBA:
>
> 1) Sign on to MySQL as "root"
> 2) Perform a "show databases;"
> 3) For each entry you see, issue a "drop database X;" command
> 4) Sign out and disavow any knowledge of your actions
>
> At 03:22 PM 8/23/2007, james benjamin wrote:
> >We are, like, totally down with recruiting a "Seriously Disruptive" MySQL
> DBA.
> >...hardcore MySQL DBA with contributions to the code base...
>
> Now seriously...I was a bit confused here: many MySQL "DBAs"
> (certainly the ones chasing the MySQL certificates) just want to
> master the latest production-rated edition of MySQL; they aren't
> really interested in coding.  In fact, I was a bit surprised to see
> that there was no mention of the MySQL cert program in Mr. Benjamin's
> advertisement looking for a "MySQL DBA" - wouldn't that pool of
> certified MySQL DBAs seem like a better place to start?





Regards,
> - Jonathan Lampe
> - Standard Networks, Inc.
> - http://www.standardnetworks.com
> - [EMAIL PROTECTED]


I don't think a blanket description of MySQL DBAs works in all cases. I for
one, am a CMDBA, and interested in coding. I code more client software than
contributing to the MySQL codebase. I don't know if that classifies me as
"Seriously Disruptive DBA" or not. I think having both skills as an asset
any company can take advantage of. I guess it all depends on what you
believe, being more general or specific in a set of skills.

I see contributing to the code base leaning towards being a software
engineer instead of a DBA. A software engineer can learn to be a DBA, but
I'm not exactly sure if the reverse is true.

Just my $.02USD.

-- 
Mark Schoonover, CMDBA
[EMAIL PROTECTED]
http://marksitblog.blogspot.com
Cell: 619-368-0099

Database Administration * System Engineering * Software Development *

RE: MySQL: Problem Installing on RH 7.3

[Mark Schoonover]

At first blush it looks like it's a rights problem. Need to have the
/var/lib/mysql owned by mysql.mysql... If you're starting mysql as the user
mysql...

HTH

.mark

> -Original Message-
> From: Richard Fox [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 18, 2002 8:44 AM
> To: Noamn; [EMAIL PROTECTED]
> Subject: Re: MySQL: Problem Installing on RH 7.3
> 
> 
> The mysqld.log file says:
> 
> 020717 13:05:05  mysqld started
> 020717 13:05:05  /usr/local/libexec/mysqld: Can't find file:
> './mysql/host.frm' (errno: 13)
> 020717 13:05:05  mysqld ended
> 
> But I do see the host.frm file:
> 
> -rw-rw1 root root 8958 Jul 17 13:04
> /var/lib/mysql/mysql/host.frm
> 
> How did you fix this problem?
> 
> I do have the /var/lib/mysql/mysql.sock file...
> 
> Thanks
> Rich
> 
> > I'm near enough in the same position as you are. Check the file
> > /var/log/mysqld.log to see what the problem is. I had a 
> problem accessing
> > the file './mysql/host.frm', but I think that I've fixed this now.
> >
> > What happens when you try the 'mysql' command? I get the response
> > "can't connect to local MySQL server through socket
> > '/var/usr/mysql/mysql.sock'"
> > And indeed there is no such file.
> > Do you have this file?
> >
> > -Original Message-
> > From: Richard Fox [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 17, 2002 10:41 PM
> > To: [EMAIL PROTECTED]
> > Subject: MySQL: Problem Installing on RH 7.3
> >
> >
> >
> > The MySQL daemon does not run. I installed the binary RPM's 
> from the RH
> cd,
> > MySQL 3.23.49. I run mysql_install_db, outputs some text 
> and appears to
> > execute correctly. The I run safe_mysqld &, and I get:
> >
> > [root@thor rfox]# /usr/bin/safe_mysqld &
> > [1] 2212
> > [root@thor rfox]# Starting mysqld daemon with databases from
> /var/lib/mysql
> > 020717 15:21:28  mysqld ended
> >
> > That's it! I tried both the rpm and compiling it myself 
> from source with
> > BOTH gcc 2.96 and gcc 3.0.4. Exact same behavior
> >
> > I just need a little hint, please! How do I troubleshoot this?
> >
> > Thanks,
> >
> > Rich
> >
> > sql
> >
> >
> > 
> -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> > <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: 
> http://lists.mysql.com/php/unsubscribe.php
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Access to MySQL

[Mark Schoonover]

Take a look at MyODBC...

.mark

> -Original Message-
> From: Oladejo, Tokunboh [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 16, 2002 10:48 AM
> To: [EMAIL PROTECTED]
> Subject: Access to MySQL
> 
> 
> Hi All,
> 
> Does anyone knows of any easy way/short cut of exporting 
> Microsoft access
> tables into MySql database.
> 
> Thanx
> All
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
> 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php