Help answer threads with 0 replies.
Go Back > Forums > Non-*NIX Forums > General
User Name
General This forum is for non-technical general discussion which can include both Linux and non-Linux topics. Have fun!


  Search this Thread
Old 09-19-2006, 12:54 PM   #1
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
LQ Guru
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 235Reputation: 235Reputation: 235
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
LQ Veteran
Registered: Mar 2003
Location: Boise, ID
Distribution: Mint
Posts: 6,642

Rep: Reputation: 85
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
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!


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

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 > Forums > Non-*NIX Forums > General

All times are GMT -5. The time now is 07:30 AM.

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