Page 1 of 1

anybody know best links to learn mysql administration

Posted: Thu Jan 12, 2006 6:41 am
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.

Posted: Thu Jan 12, 2006 4:07 pm
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.

Posted: Thu Jan 12, 2006 5:11 pm
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 ;)

Posted: Fri Jan 13, 2006 6:02 am
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

Posted: Fri Jan 13, 2006 7:15 am
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 ;)

Posted: Fri Jan 13, 2006 9:17 am
by m3mn0n
The manual or most current books from a bookstore will do, especially if you want something in a more user-friendly format.

Posted: Fri Jan 13, 2006 1:29 pm
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

Posted: Fri Jan 13, 2006 3:29 pm
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.

Posted: Fri Jan 13, 2006 3:46 pm
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