LinuxQuestions.org
Visit the LQ Articles and Editorials section
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 04-19-2013, 11:25 PM   #1
jitendra.sharma
Member
 
Registered: Mar 2013
Location: ahmedabad
Distribution: CentOS, Ubuntu, Debian
Posts: 92
Blog Entries: 1

Rep: Reputation: Disabled
Want to know more about mysql...


Very Common question i want ask to all of you..
i knew the configuration, installation of mysql database with apache, mailserver and monitoring tools.
But still i have a some confusions....
==> Why we use mysql database?
==> Which type of information is stored in database with apache, mailserver and monitoring tools?
 
Old 04-19-2013, 11:34 PM   #2
jdkaye
Guru
 
Registered: Dec 2008
Location: Westgate-on-Sea, Kent, UK
Distribution: Debian Testing Amd64
Posts: 5,136

Rep: Reputation: Disabled
DuckDuckGo is your friend. Have you looked here?
https://www.mysql.com/why-mysql/
jdk
 
Old 04-20-2013, 12:32 AM   #3
jitendra.sharma
Member
 
Registered: Mar 2013
Location: ahmedabad
Distribution: CentOS, Ubuntu, Debian
Posts: 92
Blog Entries: 1

Original Poster
Rep: Reputation: Disabled
Thank you for reply But i don't want theory dear i want simple logical idea...
 
Old 04-20-2013, 03:32 AM   #4
jpollard
Senior Member
 
Registered: Dec 2012
Location: Washington DC area
Distribution: Fedora, CentOS, Slackware
Posts: 2,823

Rep: Reputation: 720Reputation: 720Reputation: 720Reputation: 720Reputation: 720Reputation: 720Reputation: 720
Formerly, MySQL had the right price, performance and capabilities desired. Now that Oracle has taken it over, some other capabilities have been lost - test suites, updates, and bad behavior from Oracle.

Many distributions are moving to either MariaDB (a fully GPL version of MySQL), or Postgres (a completely different database).

Your second question is a bit of a "What?" as you can store whatever data you want. Mixing in specifically applications like Apache, Mailservers, and monitoring tools don't make sense. You can store any data you get from them. Now identifying what data you WANT from them might take a lot of time. Some of them already have data base interfaces (some monitoring tools for instance), but it depends on which ones (Nagios has a database interface, log files from either Apache or the various mail servers can be parsed for some data) and what data you want.
 
1 members found this post helpful.
Old 04-20-2013, 07:40 AM   #5
Habitual
Senior Member
 
Registered: Jan 2011
Location: Pelican Bay Correctional
Distribution: I can't wait for Linux to be 'underground' again.
Posts: 4,016
Blog Entries: 1

Rep: Reputation: Disabled
Quote:
Originally Posted by jitendra.sharma View Post
Thank you for reply But i don't want theory...
and yet your signature quotes Stallman..."To understand the concept,"

Last edited by Habitual; 04-20-2013 at 07:42 AM. Reason: s/declares/quotes
 
Old 04-20-2013, 11:03 AM   #6
PrinceCruise
Member
 
Registered: Aug 2009
Location: /Universe/Earth/India/Pune
Distribution: Slackware64 14.1/Current, CentOS 6.5/7.0
Posts: 798

Rep: Reputation: 121Reputation: 121
Quote:
Originally Posted by jitendra.sharma View Post
Very Common question i want ask to all of you..
Don't mean to discourage you, but you won't get a helpful answer to this 'very generic information seeking' type question. Rather if you grok in a working MySQL environment and post your doubts and questions with problem detail, I'm pretty sure a number of people will join to help you.

Regards.
 
Old 04-20-2013, 12:34 PM   #7
jdkaye
Guru
 
Registered: Dec 2008
Location: Westgate-on-Sea, Kent, UK
Distribution: Debian Testing Amd64
Posts: 5,136

Rep: Reputation: Disabled
Quote:
Originally Posted by jitendra.sharma View Post
Thank you for reply But i don't want theory dear i want simple logical idea...
Maybe if you stated your requirements more clearly, dear, you would get the kind of answers you are looking for.
jdk
 
Old 04-20-2013, 02:15 PM   #8
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 15,855

Rep: Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957
Quote:
Originally Posted by jitendra.sharma View Post
Very Common question i want ask to all of you..
i knew the configuration, installation of mysql database with apache, mailserver and monitoring tools.
But still i have a some confusions....
==> Why we use mysql database?
==> Which type of information is stored in database with apache, mailserver and monitoring tools?
Your questions make no sense at all.

You want to know WHY you would use a database?? You tell me...I know why *I* would use a database, and why others use them. You can use it for whatever you want to. And it's not limited to MySQL...it goes for Postgresql, NoSQL, Oracle, Sybase, or any other database you can name. You use it if you need it, for what you need it for, same as with any tool.
What type of information? That's like asking "What kind of information can be sent over email??". You can put whatever you want in it....have one table or 200,000; two fields or 10,000....that's up to you.
 
1 members found this post helpful.
Old 04-21-2013, 08:38 PM   #9
chrism01
Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.6, Centos 5.10
Posts: 16,419

Rep: Reputation: 2085Reputation: 2085Reputation: 2085Reputation: 2085Reputation: 2085Reputation: 2085Reputation: 2085Reputation: 2085Reputation: 2085Reputation: 2085Reputation: 2085
As with all of the above, you can put any kind of info you want in a DB.
Try their website http://dev.mysql.com/doc/refman/5.1/en/

Or be more specific...
 
Old 04-22-2013, 06:20 AM   #10
jitendra.sharma
Member
 
Registered: Mar 2013
Location: ahmedabad
Distribution: CentOS, Ubuntu, Debian
Posts: 92
Blog Entries: 1

Original Poster
Rep: Reputation: Disabled
Thanks to all of you specially jpollard thanks dude
actually i got the idea its uses raw and tables for storing data in systematic in organize manner.
Data like errors, user info, system generated queries etc..
Am i right?
 
Old 04-22-2013, 08:17 AM   #11
TB0ne
Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 15,855

Rep: Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957Reputation: 2957
Quote:
Originally Posted by jitendra.sharma View Post
Thanks to all of you specially jpollard thanks dude
actually i got the idea its uses raw and tables for storing data in systematic in organize manner.
Data like errors, user info, system generated queries etc..
Am i right?
No, you're not, and I have no idea where you got that idea. AGAIN...you can store ANYTHING in a database.

A small bit of research on how databases work via a Google search can tell you what you need to know.
 
Old 04-22-2013, 10:05 AM   #12
Ruby On Rails
LQ Newbie
 
Registered: Apr 2013
Posts: 1

Rep: Reputation: Disabled
Post mysql database usages

mysql database is used mainly for the following reasons: Robust Transactional Support,Web and Data Warehouse Strengths,Scalability and Flexibility,Strong Data Protection,Comprehensive Application Development,Lowest Total Cost of Ownership.
 
1 members found this post helpful.
Old 04-22-2013, 10:53 AM   #13
vmccord
Member
 
Registered: Jun 2012
Location: Lawrence, KS
Distribution: Mostly CentOS
Posts: 61
Blog Entries: 26

Rep: Reputation: Disabled
1. MySQL came with my web hosting. If my web hosting had come with PostgreSQL, I'd be using it instead. I suspect most partnering works the same way. If "apache, mailserver and monitoring tools" are using MySQL, that partnership was likely the result of a business decision that may not have been based in technical considerations.

2. As to what those applications are storing in MySQL, you'll probably have to poke through the tables and hope the field names make sense.
 
1 members found this post helpful.
  


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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can MySQL log on via SSH/bash? mysql:x:27:101:MySQL Server:/var/lib/mysql:/bin/bash Ujjain Linux - Newbie 2 04-24-2009 02:21 PM
yum install php-mysql fails with mysql 5.1 - "Error: mysql conflicts with MySQL" rebelde Linux - Software 2 03-13-2009 10:32 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. SpellChainz Linux - Newbie 1 06-23-2007 03:35 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


All times are GMT -5. The time now is 09:10 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