LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > General
User Name
Password
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!

Notices

Reply
 
LinkBack Search this Thread
Old 09-19-2006, 12:54 PM   #1
msound
Member
 
Registered: Jun 2003
Location: SoCal
Distribution: CentOS
Posts: 465

Rep: Reputation: 30
MySQL DBA Question


Lately I've been getting a lot of calls from job recruiters for MySQL DBA positions in a LAMP environment. I've been running a few different mysql databases for a little over 2 years now and to be honest I never really found it that difficult. The sites I've administered were all fairly low traffic, but aren't the admin concepts still the same? I used mysql administrator to monitor performance, phpmyadmin to create and modify DB's and Tables, and I used a mysqldump shell script which ran every night via crond to backup the DB's data. I also designed a lot of the db backends for web apps still being used by my former employer. I understand normalization and I'd consider myself to be pretty darn good at designing DB's. I haven't got into server clustering, and I'm just wondering what else is involved with enterprise level MySQL database administration.

I guess my real question is, with the experience I've listed, would you think that I'm ready to take a full time mysql dba position or do I still have a lot to learn?
 
Old 09-19-2006, 01:01 PM   #2
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 194Reputation: 194
I would say so or at least shouldn't have a hard time picking up things. I've taken on a new position where we have zero DBA's and we are almost a 100% MySQL DB environment, quite a drastic change coming from Oracle DB backends. But as a system administrator, it is quite easy to administer. My only suggestions would be to look further into performance tuning, InnoDB and learning more of the administration from the command line instead of using GUI tools.
 
Old 09-19-2006, 10:04 PM   #3
J.W.
LQ Veteran
 
Registered: Mar 2003
Location: Milwaukee, WI
Distribution: Mint
Posts: 6,642

Rep: Reputation: 69
There will *always* be something new to learn but I think you've probably got the right skill-set for the position. The real question is whether or not you are happy with your current position, and if moving to another company would be to your advantage. Unless you consider your current gig to be the ideal setup for you for the foreseeable future, I'd suggest at least going in for the interview.

Worst case: you and the company are not a good fit for one another, you don't get an offer, and you end up staying with your current company. In other words, no change.
Best case: they make you an amazing offer, with higher pay, better assignments, etc, and your career gets a major boost. I'd say go for it
 
Old 09-20-2006, 07:42 AM   #4
msound
Member
 
Registered: Jun 2003
Location: SoCal
Distribution: CentOS
Posts: 465

Original Poster
Rep: Reputation: 30
thanks for the feedback guys! I'll definitely start doing more administration from the command line and I'll probably pick up a book on advanced mysql administration. I bought an entry level book way back when I first starting using mysql and it really helped out a lot. Thanks again!
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: DB2 for Linux DBA Checklist LXer Syndicated Linux News 0 08-15-2006 12:54 PM
LXer: Aqua Data Studio 4.7 ships with Oracle DBA Tools LXer Syndicated Linux News 0 05-21-2006 06:54 PM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
changing sys and dba password anirudh Programming 5 10-08-2004 06:44 AM
Attention to PostgreSQL / MySQL (DBA) leshka_uk Linux - Software 1 02-10-2003 12:48 PM


All times are GMT -5. The time now is 04:36 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration