anybody know best links to learn mysql administration

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

anybody know best links to learn mysql administration

Post by raghavan20 »

I am looking for a comprehensive tutorial, which will help manage objects in a mysql database. Have you guys come across a good tutorial that talks about mysql administration. I want to gain enough knowledge to administer databases in a hosting environment.
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

Get a VDS/UML server and have a play around with it. The MySQL manual is incredibly concise too. If you really want to learn some useful administration stuff have a go at clustering and replication if you have access to the hardware to do it... it really quite impressive to make it work in a clustered environment :) Database administration is certainly not the kind of thing you're going to learn from tutorials if you want a job in it.
timvw
DevNet Master
Posts: 4897
Joined: Mon Jan 19, 2004 11:11 pm
Location: Leuven, Belgium

Post by timvw »

What i would like are a couple of tools that allow one to mess up a database ;) Make it go in an inconsistent state... (Not very willing to simply unplug the power cord a couple of times :p)... But i think that you learn most from such disasters.. After that you can write the scenarios for handling such disasters..

Fetching source, compiling, configuring, installing, adding a couple of databases, granting rights, checking out tools that automate this stuff for you or making them yourself are always nice things to spend a day with ;)
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post by raghavan20 »

I would not necessarily want to learn about replication and fault tolerance.
I want a tutorial that deals about the following and topics more relevant to these:
create/delete user
grant/revoke priveleges to user on databases/tables/columns
creating dump and using dump
allowing accessing for users from few selected hosts
locking databases/tables/columns
User avatar
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098
Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia

Post by Chris Corbyn »

raghavan20 wrote:I would not necessarily want to learn about replication and fault tolerance.
I want a tutorial that deals about the following and topics more relevant to these:
create/delete user
grant/revoke priveleges to user on databases/tables/columns
creating dump and using dump
allowing accessing for users from few selected hosts
locking databases/tables/columns
Have you looked at the manual on http://dev.mysql.com ? All that stuff is there and those things are fairly basic procedures on the whole scale of things ;)
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

The manual or most current books from a bookstore will do, especially if you want something in a more user-friendly format.
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post by raghavan20 »

Often, I do forget there is another resource called book. Book is supposedly more user-friendly than all others. I need some kind of book where they progressively walk through all of administrative features of Mysql....thanks
User avatar
m3mn0n
PHP Evangelist
Posts: 3548
Joined: Tue Aug 13, 2002 3:35 pm
Location: Calgary, Canada

Post by m3mn0n »

Hit up Amazon.com reviews, there is always good write ups for most books. If not Amazon, then the publisher site such as the official Wrox site or O'Reilly site or Peach Pit Press site.

You might be able to view the table of contents and get sample chapters, too. So you know what's covered and what sort of writing you're going to get.
User avatar
raghavan20
DevNet Resident
Posts: 1451
Joined: Sat Jun 11, 2005 6:57 am
Location: London, UK
Contact:

Post by raghavan20 »

If university access to safari tech books online...i am now reading...

Code: Select all

MySQL™: The definitive guide to using, programming, and administering MySQL 4.1 and 5.0, Third Edition
By Paul DuBois
...............................................
Publisher: Sams
Pub Date: March 08, 2005
Print ISBN-10: 0-672-32673-6
Print ISBN-13: 978-0-672-32673-8
Pages: 1320
Slots: 1.0
Post Reply