LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-07-2014, 04:23 AM   #1
James0806
Member
 
Registered: Jul 2014
Posts: 30

Rep: Reputation: Disabled
Why Linux Admin Need mysql,sql knowledge


Why companies ask for mysql,oracle sql knowledge when there is a separate team for that and what is the work of system administrator on the databases like mysql and sql

Last edited by James0806; 08-07-2014 at 04:36 AM.
 
Old 08-07-2014, 05:24 AM   #2
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6 / 7
Posts: 2,166

Rep: Reputation: 751Reputation: 751Reputation: 751Reputation: 751Reputation: 751Reputation: 751Reputation: 751
It is extremely beneficial for a systems admin to have at least a working knowledge of the applications that are running on the servers they are administering.

A basic knowledge of things like which port MySQL runs on, how to check that the server is running, how to run simple queries, how to install and secure a MySQL installation are things I'd consider essential when hiring. The same for apache.

Even if companies have "teams" for these it is highly desirable to have a sysadmin that can understand when these teams talk about MySQL master/slave replication, circular replication, or apache name based virtual hosting and IP based virtual hosting.
 
Old 08-07-2014, 05:27 AM   #3
kirukan
Senior Member
 
Registered: Jun 2008
Location: Eelam
Distribution: Redhat, Solaris, Suse
Posts: 1,272

Rep: Reputation: 148Reputation: 148
May be as an Admin,
1. Update new patches
2. Troubleshoot the issues
3. Fine tune the server performance
4. Grant permission to users/clients
5. Manager cluster resources
6. Manage the backup/ restore the backup
7. Logging the slow queries
8. Mainly DB team think about to build database
9. As an Admin need to think about day to day management and High availability of the DB server
10. Etc..
 
1 members found this post helpful.
Old 08-07-2014, 05:33 AM   #4
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6 / 7
Posts: 2,166

Rep: Reputation: 751Reputation: 751Reputation: 751Reputation: 751Reputation: 751Reputation: 751Reputation: 751
Think of it like a car, you don't need to know how to build an engine to drive a car but you should know if it uses petrol or diesel and also where to put these in!
 
Old 08-07-2014, 10:00 AM   #5
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 7,177

Rep: Reputation: 2209Reputation: 2209Reputation: 2209Reputation: 2209Reputation: 2209Reputation: 2209Reputation: 2209Reputation: 2209Reputation: 2209Reputation: 2209Reputation: 2209
Even though "DBAs Are Gods,™" those Gods do need to be able to talk to Mortals who have a vague notion of what they are doing. And also, "one does not wish to bother The Gods for trivial matters." Therefore, to the degree that "day-to-day administration of the platform" logically involves routine activities regarding the databases, or routine diagnosis of problems (say, in TCP/IP connections) as they crop up from time to time, a sysadmin needs to have a fair amount of understanding of this stuff. (Which understanding must also include "knowing where the deep water starts" and having the lack-of-hubris needed to stay out of there.)
 
Old 08-07-2014, 10:03 AM   #6
szboardstretcher
Senior Member
 
Registered: Aug 2006
Location: Detroit, MI
Distribution: GNU/Linux systemd
Posts: 3,811
Blog Entries: 1

Rep: Reputation: 1346Reputation: 1346Reputation: 1346Reputation: 1346Reputation: 1346Reputation: 1346Reputation: 1346Reputation: 1346Reputation: 1346Reputation: 1346
Quote:
Originally Posted by TenTenths View Post
Think of it like a car, you don't need to know how to build an engine to drive a car but you should know if it uses petrol or diesel and also where to put these in!
For the americans: he means gas/gasoline.

As a Sysop, I want to know how to administer anything that runs on my machines. Anything that has a config file, log file and init.d startup script is something that I go out of my way to know about for the inevitable day that it breaks.
 
Old 08-07-2014, 01:17 PM   #7
James0806
Member
 
Registered: Jul 2014
Posts: 30

Original Poster
Rep: Reputation: Disabled
Best Way to install Mysql in linux

Mysql can be installed using packages in the cd or we can download the rpm from the website why do we need to do that when we have mysql rpm in the dvd
 
Old 08-07-2014, 01:50 PM   #8
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 17,944

Rep: Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693Reputation: 3693
Quote:
Originally Posted by James0806 View Post
Mysql can be installed using packages in the cd or we can download the rpm from the website why do we need to do that when we have mysql rpm in the dvd
...and....
Quote:
Originally Posted by James0806
Why companies ask for mysql,oracle sql knowledge when there is a separate team for that and what is the work of system administrator on the databases like mysql and sql
These questions would seem to indicate that you're either a brand-new systems administrator, or you haven't yet got a job as one.

Companies can ASK for whatever they want...if they want you to have a doctorate degree in ancient Greek, you'd better have one. Why? Because they WANT IT, that's why. Some other reasons, which an administrator with experience would point out would be:
  • Your servers may be running MySQL...shouldn't you be able to troubleshoot the software ON the server?
  • Managing MySQL may be part of your job.
  • The DBA 'team' may consist of one person at some companies, and 50 at another...who knows?
  • Many applications use MySQL as a back end for data, so the DBA's won't be touching it...just the systems administrators.
...which goes to your next question, about why you would install it from a website/repository. If MySQL has 10 updates between when the DVD is released and the time you've installed your new server with it, wouldn't you WANT the latest package???
 
Old 08-07-2014, 06:22 PM   #9
jpollard
Senior Member
 
Registered: Dec 2012
Location: Washington DC area
Distribution: Fedora, CentOS, Slackware
Posts: 4,604

Rep: Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241Reputation: 1241
It can also help to identify the idiots that want to break the systems security just because "they need to get their work done"...

It helps when the DBA is throwing crap at the system and the system quits - and blames the admin for their failings.

Always know more than you need - you never know when it will save your ass.
 
Old 08-07-2014, 06:42 PM   #10
Smokey_justme
Member
 
Registered: Oct 2009
Distribution: Slackware
Posts: 534

Rep: Reputation: 203Reputation: 203Reputation: 203
Let me put it this way.. It's not a system admins job to fix bugs, but it is partially his job to find some of those bugs...

Here's why: A sysadmin doesn't only install stuff, but it makes sure everything works together and when they don't (and trust me, they ussualy don't) it's his job to find out why (and if he can, to fix it -- if he can't, to report it).. You can't debug something without knowing nothing about it..

Here's another example: How will you update your DB server not knowing SQL? Just running the provided scripts? Pff.. Sure, databases and queries never brake :P Hell, a sysadmin will probably know more about the database software than most of the developers..

Last edited by Smokey_justme; 08-07-2014 at 06:44 PM.
 
  


Reply

Tags
linux, mysql


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
[SOLVED] Converting SQL Scripts for MS SQL Server to Postgresql or MySQL markush Programming 4 09-12-2013 03:09 PM
about more knoledge in linux saiju Linux - Newbie 15 12-02-2012 11:17 PM
[SOLVED] Importing an MS sql dbase into Mysql - linux linx win Debian 6 06-07-2010 04:53 AM
DB Admin & SQL tools? JurgyMan Linux - Software 1 04-18-2009 10:43 AM
LXer: The DB2 SQL-based Admin Task Scheduler for Linux and UNIX LXer Syndicated Linux News 0 09-23-2008 05:10 PM


All times are GMT -5. The time now is 10:59 AM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration