anybody know best links to learn mysql administration
Moderator: General Moderators
- 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
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.
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
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.
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
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
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
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
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
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
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 thingsraghavan20 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
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
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.
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.
- raghavan20
- DevNet Resident
- Posts: 1451
- Joined: Sat Jun 11, 2005 6:57 am
- Location: London, UK
- Contact:
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