How to become a DBA on MySQL

Hi,
I'd like to know which are the main tasks for a DBA, so in addition of th=
e on-line tutorial of MySQL, is there anyone telling me whether there exi=
sts some tutorial (better if in PDF) where it's possible to undestand and=
learn all you need for managing the MySQL DB as DBA? I mean I'd like to =
read something explaining what are datafiles, tablespaces, ... and what u=
sually a DBA is asked to do (creating databases, starting up and shutting=
down the database, managing the database's storage structures, making da=
tabase backups and performing recovery, monitoring and tuning performance=
, ...) In other words I'd like to read how to manage a DB as DBA, because=
I've always worked only as developer and not as DBA.
Thanks!


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: How to become a DBA on MySQL

On Tue, Jul 13, 2010 at 6:24 AM, alba.albetti wrot=
e:
> Hi,
> I'd like to know which are the main tasks for a DBA, so in addition of th=
e on-line tutorial of MySQL, is there anyone telling me whether there exist=
s some tutorial (better if in PDF) where it's possible to undestand and lea=
rn all you need for managing the MySQL DB as DBA? I mean I'd like to read s=
omething explaining what are datafiles, tablespaces, ... and what usually a=
DBA is asked to do (creating databases, starting up and shutting down the =
database, managing the database's storage structures, making database backu=
ps and performing recovery, monitoring and tuning performance, ...) In othe=
r words I'd like to read how to manage a DB as DBA, because I've always wor=
ked only as developer and not as DBA.
> Thanks!
>

It really depends on the company. Some DBA's are glorified sys admins,
some are mostly db developers and there is everything in between.

I do work that would be normal for a front end developer, I also
sometimes have to go digging into the C+ guts MySQL and I also deal
with lots non-technical issues. It really depends a lot on the
company.


--=20
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: How to become a DBA on MySQL

On Tue, Jul 13, 2010 at 8:24 AM, alba.albetti wrot=
e:
> Hi,
> I'd like to know which are the main tasks for a DBA, so in addition of th=
e on-line tutorial of MySQL, is there anyone telling me whether there exist=
s some tutorial (better if in PDF)

Sure, the MySQL Reference Manual http://dev.mysql.com/doc/

>where it's possible to undestand and learn all you need for managing the M=
ySQL DB as DBA? I mean I'd like to read something explaining what are dataf=
iles, tablespaces, ... and what usually a DBA is asked to do (creating data=
bases, starting up and shutting down the database, managing the database's =
storage structures, making database backups and performing recovery, monito=
ring and tuning performance, ...) In other words I'd like to read how to ma=
nage a DB as DBA, because I've always worked only as developer and not as D=
BA.


Maybe the Certification: Sun Certified MySQL Database Administrator
(SCMDBA) could help you with that:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.ge tpage?page_id=
=3D333

by the way they recommend the book: MySQL 5 certification study guide
http://books.google.com/books?id=3D0tErAAAACAAJ

> Thanks!

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: How to become a DBA on MySQL

--00163646d43c876191048b45840d
Content-Type: text/plain; charset=ISO-8859-1

The term DBA is very broad and I think most DBA's do at least some
development and if they have *nix platform they probably look after that
too. Some, including myself, get heavily involved in the applications
running on their db.

So long as you can quickly identify and solve database issues, size and tune
servers, backup, restore and manage security effectively then you probably
have the skills used daily by most DBA's.

You'll probably find it helps to know more than one RDBMS though. Few
companies seem to use one database system exclusively!

I'm a MySQL DBA but spend 90% of my time administering MS SQL Server and IBM
Cognos BI tools!

Regards
John
On 13 July 2010 14:55, Rob Wultsch wrote:

> On Tue, Jul 13, 2010 at 6:24 AM, alba.albetti
> wrote:
> > Hi,
> > I'd like to know which are the main tasks for a DBA, so in addition of
> the on-line tutorial of MySQL, is there anyone telling me whether there
> exists some tutorial (better if in PDF) where it's possible to undestand and
> learn all you need for managing the MySQL DB as DBA? I mean I'd like to read
> something explaining what are datafiles, tablespaces, ... and what usually a
> DBA is asked to do (creating databases, starting up and shutting down the
> database, managing the database's storage structures, making database
> backups and performing recovery, monitoring and tuning performance, ...) In
> other words I'd like to read how to manage a DB as DBA, because I've always
> worked only as developer and not as DBA.
> > Thanks!
> >
>
> It really depends on the company. Some DBA's are glorified sys admins,
> some are mostly db developers and there is everything in between.
>
> I do work that would be normal for a front end developer, I also
> sometimes have to go digging into the C+ guts MySQL and I also deal
> with lots non-technical issues. It really depends a lot on the
> company.
>
>
> --
> Rob Wultsch
> wultsch@gmail.com
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=john.daisley@butterflysys tems.co.uk
>
>


--
John Daisley

Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer

Telephone: +44 (0)7918 621621
Email: john.daisley@butterflysystems.co.uk

--00163646d43c876191048b45840d--

Re: How to become a DBA on MySQL

--0016364d313f8de210048b4894e2
Content-Type: text/plain; charset=ISO-8859-1

Reference is everywhere, but you need a sort of starting point.

In your case I would say get this
book
and
read:


- Part III
- Part IV-D (quick read)


You will benefit from Part I as well as developer.

In my opinion this book is clear and linear, good to learn MySQL.

When you will be working as DBA keep this
one in
the drawer.


Claudio


2010/7/13 alba.albetti

> Hi,
> I'd like to know which are the main tasks for a DBA, so in addition of the
> on-line tutorial of MySQL, is there anyone telling me whether there exists
> some tutorial (better if in PDF) where it's possible to undestand and learn
> all you need for managing the MySQL DB as DBA? I mean I'd like to read
> something explaining what are datafiles, tablespaces, ... and what usually a
> DBA is asked to do (creating databases, starting up and shutting down the
> database, managing the database's storage structures, making database
> backups and performing recovery, monitoring and tuning performance, ...) In
> other words I'd like to read how to manage a DB as DBA, because I've always
> worked only as developer and not as DBA.
> Thanks!
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
>
>


--
Claudio

--0016364d313f8de210048b4894e2--

RE: How to become a DBA on MySQL

You might want to see if there are any online classes that could get you
started. I usually start by reading a big, thick book -- but I've found that
spending a week or two on an introductory-level online class gives me a big
head start.

"Modern" documentation tends to be lacking (IMNSHO). All too many reference
books are written on the principle of "If you know exactly what you want to
do, here's roughly how to do it." You can wander around for a long time not
knowing what a feature is for.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com


>-----Original Message-----
>From: Claudio Nanni [mailto:claudio.nanni@gmail.com]
>Sent: Tuesday, July 13, 2010 1:56 PM
>To: alba.albetti
>Cc: mysql
>Subject: Re: How to become a DBA on MySQL
>
>Reference is everywhere, but you need a sort of starting point.
>
>In your case I would say get this
>book >DuBois/dp/0672329387/ref=sr_1_1?ie=UTF8&s=books&qid=1279043 056&sr=1-1>
>and
>read:
>
>
> - Part III
> - Part IV-D (quick read)
>
>
>You will benefit from Part I as well as developer.
>
>In my opinion this book is clear and linear, good to learn MySQL.
>
>When you will be working as DBA keep this
>one in
>the drawer.
>
>
>Claudio
>
>
>2010/7/13 alba.albetti
>
>> Hi,
>> I'd like to know which are the main tasks for a DBA, so in addition of the
>> on-line tutorial of MySQL, is there anyone telling me whether there exists
>> some tutorial (better if in PDF) where it's possible to undestand and learn
>> all you need for managing the MySQL DB as DBA? I mean I'd like to read
>> something explaining what are datafiles, tablespaces, ... and what usually
>> a
>> DBA is asked to do (creating databases, starting up and shutting down the
>> database, managing the database's storage structures, making database
>> backups and performing recovery, monitoring and tuning performance, ...) In
>> other words I'd like to read how to manage a DB as DBA, because I've always
>> worked only as developer and not as DBA.
>> Thanks!
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
>>
>>
>
>
>--
>Claudio




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: How to become a DBA on MySQL

On 7/13/2010 9:24 AM, alba.albetti wrote:
> Hi,
> I'd like to know which are the main tasks for a DBA, so in addition of the on-line tutorial of MySQL, is there anyone telling me whether there exists some tutorial (better if in PDF) where it's possible to undestand and learn all you need for managing the MySQL DB as DBA? I mean I'd like to read something explaining what are datafiles, tablespaces, ... and what usually a DBA is asked to do (creating databases, starting up and shutting down the database, managing the database's storage structures, making database backups and performing recovery, monitoring and tuning performance, ...) In other words I'd like to read how to manage a DB as DBA, because I've always worked only as developer and not as DBA.
> Thanks!
>

You probably already have the basic skills you need. You just need to
shift your approach to the problem.

While most "developers" are more worried about putting data into a
database and finding it when they need it, the DBA has a different
philosophy. The DBA is the one entrusted to keep that data safe, to
protect the data from the bad habits of inexperienced programmers, and
to ensure that the whole system (not just the parts the users need to
touch) remain in good working order.

It's the same difference between borrowing a car to drive it and caring
for a car you own while allowing others to drive it from time to time.

Here is a very short and incomplete list of the big things you should be
able to do as a DBA:

1) Understand the backup and restore processes. Be able to perform them
reliably.

2) Understand how the data is stored on the system resources. Be
prepared to relocate data to a different resource.

3) Understand how MySQL permissions work. Create and change accounts as
necessary.

4) Understand how to read the MySQL performance and diagnostic reports.
When something is not working well, these are usually the first place to
look for clues. At the minimum learn how to use and understand the
EXPLAIN results; the SHOW reports; and how to activate, deactivate, and
interpret the InnoDB monitors.

5) Be able to read and understand the Error log.

6) Learn the advantages and disadvantages of each storage engine.

7) Learn at least the basic skills about how to navigate within and
maintain the machine that is hosting your MySQL instance.

8) Always keep learning - I cannot stress this on point enough. You must
continue learning to stay ahead of your developers. They can and will
find new and exciting ways to make your MySQL servers run like they are
frozen in mud. Use your development experience to find better ways to
write their queries and to design their tables. Also, some problems may
be due to bugs. By staying current with the state of the MySQL
ecosystem, you will make yourself aware of problems that you may not
have needed to encounter on your own.

The links to the books and other resources that you have been given (see
other responses in this thread) are excellent places to learn these, and
all of the other, skills that you will need to use to become a good DBA.
How good you become is all in the attitude you take.

If you are hands-off and neglectful of your database server, then all of
the databases hosted there may become poorly organized resource hogs. If
you, as a DBA, are diligent, protectful, proactive, and concerned then
you will have a much better chance of achieving amazing performance out
of your servers.

Regards,
--
Shawn Green
MySQL Principle Technical Support Engineer
Oracle USA, Inc.
Office: Blountville, TN

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: How to become a DBA on MySQL

--00c09f99e5491563fe048b49b143
Content-Type: text/plain; charset=ISO-8859-1

there is another suggestion. if you have good/unlimited net connection. Just
explore youtube for MySQL videos.. I remember in my beginning days it helped
me a lot.

On Tue, Jul 13, 2010 at 11:56 PM, Shawn Green (MySQL) <
shawn.l.green@oracle.com> wrote:

> On 7/13/2010 9:24 AM, alba.albetti wrote:
>
>> Hi,
>> I'd like to know which are the main tasks for a DBA, so in addition of the
>> on-line tutorial of MySQL, is there anyone telling me whether there exists
>> some tutorial (better if in PDF) where it's possible to undestand and learn
>> all you need for managing the MySQL DB as DBA? I mean I'd like to read
>> something explaining what are datafiles, tablespaces, ... and what usually a
>> DBA is asked to do (creating databases, starting up and shutting down the
>> database, managing the database's storage structures, making database
>> backups and performing recovery, monitoring and tuning performance, ...) In
>> other words I'd like to read how to manage a DB as DBA, because I've always
>> worked only as developer and not as DBA.
>> Thanks!
>>
>>
> You probably already have the basic skills you need. You just need to shift
> your approach to the problem.
>
> While most "developers" are more worried about putting data into a database
> and finding it when they need it, the DBA has a different philosophy. The
> DBA is the one entrusted to keep that data safe, to protect the data from
> the bad habits of inexperienced programmers, and to ensure that the whole
> system (not just the parts the users need to touch) remain in good working
> order.
>
> It's the same difference between borrowing a car to drive it and caring for
> a car you own while allowing others to drive it from time to time.
>
> Here is a very short and incomplete list of the big things you should be
> able to do as a DBA:
>
> 1) Understand the backup and restore processes. Be able to perform them
> reliably.
>
> 2) Understand how the data is stored on the system resources. Be prepared
> to relocate data to a different resource.
>
> 3) Understand how MySQL permissions work. Create and change accounts as
> necessary.
>
> 4) Understand how to read the MySQL performance and diagnostic reports.
> When something is not working well, these are usually the first place to
> look for clues. At the minimum learn how to use and understand the EXPLAIN
> results; the SHOW reports; and how to activate, deactivate, and interpret
> the InnoDB monitors.
>
> 5) Be able to read and understand the Error log.
>
> 6) Learn the advantages and disadvantages of each storage engine.
>
> 7) Learn at least the basic skills about how to navigate within and
> maintain the machine that is hosting your MySQL instance.
>
> 8) Always keep learning - I cannot stress this on point enough. You must
> continue learning to stay ahead of your developers. They can and will find
> new and exciting ways to make your MySQL servers run like they are frozen in
> mud. Use your development experience to find better ways to write their
> queries and to design their tables. Also, some problems may be due to bugs.
> By staying current with the state of the MySQL ecosystem, you will make
> yourself aware of problems that you may not have needed to encounter on your
> own.
>
> The links to the books and other resources that you have been given (see
> other responses in this thread) are excellent places to learn these, and all
> of the other, skills that you will need to use to become a good DBA. How
> good you become is all in the attitude you take.
>
> If you are hands-off and neglectful of your database server, then all of
> the databases hosted there may become poorly organized resource hogs. If
> you, as a DBA, are diligent, protectful, proactive, and concerned then you
> will have a much better chance of achieving amazing performance out of your
> servers.
>
> Regards,
> --
> Shawn Green
> MySQL Principle Technical Support Engineer
> Oracle USA, Inc.
> Office: Blountville, TN
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=aim.prabhat@gmail.com
>
>


--
Best Regards,

Prabhat Kumar
MySQL DBA
Datavail-India Mumbai
Mobile : 91-9987681929
www.datavail.com

My Blog: http://adminlinux.blogspot.com
My LinkedIn: http://www.linkedin.com/in/profileprabhat

--00c09f99e5491563fe048b49b143--

RE: How to become a DBA on MySQL

Jerry,

Do you know of any reputable online classes that you could point me to?

Keith

On Tue, 2010-07-13 at 14:25 -0400, Jerry Schwartz wrote:
> You might want to see if there are any online classes that could get you
> started. I usually start by reading a big, thick book -- but I've found that
> spending a week or two on an introductory-level online class gives me a big
> head start.
>
> "Modern" documentation tends to be lacking (IMNSHO). All too many reference
> books are written on the principle of "If you know exactly what you want to
> do, here's roughly how to do it." You can wander around for a long time not
> knowing what a feature is for.
>
> Regards,
>
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
> E-mail: jerry@gii.co.jp
> Web site: www.the-infoshop.com
>
>
> >-----Original Message-----
> >From: Claudio Nanni [mailto:claudio.nanni@gmail.com]
> >Sent: Tuesday, July 13, 2010 1:56 PM
> >To: alba.albetti
> >Cc: mysql
> >Subject: Re: How to become a DBA on MySQL
> >
> >Reference is everywhere, but you need a sort of starting point.
> >
> >In your case I would say get this
> >book > >DuBois/dp/0672329387/ref=sr_1_1?ie=UTF8&s=books&qid=1279043 056&sr=1-1>
> >and
> >read:
> >
> >
> > - Part III
> > - Part IV-D (quick read)
> >
> >
> >You will benefit from Part I as well as developer.
> >
> >In my opinion this book is clear and linear, good to learn MySQL.
> >
> >When you will be working as DBA keep this
> >one in
> >the drawer.
> >
> >
> >Claudio
> >
> >
> >2010/7/13 alba.albetti
> >
> >> Hi,
> >> I'd like to know which are the main tasks for a DBA, so in addition of the
> >> on-line tutorial of MySQL, is there anyone telling me whether there exists
> >> some tutorial (better if in PDF) where it's possible to undestand and learn
> >> all you need for managing the MySQL DB as DBA? I mean I'd like to read
> >> something explaining what are datafiles, tablespaces, ... and what usually
> >> a
> >> DBA is asked to do (creating databases, starting up and shutting down the
> >> database, managing the database's storage structures, making database
> >> backups and performing recovery, monitoring and tuning performance, ...) In
> >> other words I'd like to read how to manage a DB as DBA, because I've always
> >> worked only as developer and not as DBA.
> >> Thanks!
> >>
> >>
> >> --
> >> MySQL General Mailing List
> >> For list archives: http://lists.mysql.com/mysql
> >> To unsubscribe:
> >> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
> >>
> >>
> >
> >
> >--
> >Claudio
>
>
>
>

Keith J. Clark


Business Manager Owner
The Bookworm Waterloo Hosting
Quality Used Books Complete Web Hosting Provider
www.k-wbookworm.com www.waterloohosting.com
sales@k-wbookworm.com sales@waterloohosting.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: How to become a DBA on MySQL

--002215b02f52c2b409048b4a9038
Content-Type: text/plain; charset=ISO-8859-1

Oreilly <%20http://www.oreillyschool.com/?73235> (the people who host the
MySQL Conference & Expo) run the Oreilly School of
Technology<%20http://www.oreillyschool.com/?73235%20>and do online
MySQL DBA courses at reasonable prices.

Not sure if its still valid but you used to be able to get an extra 30% off
the course prices if you use the
Oreilly<%20http://www.oreillyschool.com/?73235%20>User Group discount
code 'ORALL1' at
*http://www.oreillyschool.com/?73235 *<%20http://www.oreillyschool.com/?73235>



On 13 July 2010 20:58, Keith Clark wrote:

> Jerry,
>
> Do you know of any reputable online classes that you could point me to?
>
> Keith
>
> On Tue, 2010-07-13 at 14:25 -0400, Jerry Schwartz wrote:
> > You might want to see if there are any online classes that could get you
> > started. I usually start by reading a big, thick book -- but I've found
> that
> > spending a week or two on an introductory-level online class gives me a
> big
> > head start.
> >
> > "Modern" documentation tends to be lacking (IMNSHO). All too many
> reference
> > books are written on the principle of "If you know exactly what you want
> to
> > do, here's roughly how to do it." You can wander around for a long time
> not
> > knowing what a feature is for.
> >
> > Regards,
> >
> > Jerry Schwartz
> > Global Information Incorporated
> > 195 Farmington Ave.
> > Farmington, CT 06032
> >
> > 860.674.8796 / FAX: 860.674.8341
> > E-mail: jerry@gii.co.jp
> > Web site: www.the-infoshop.com
> >
> >
> > >-----Original Message-----
> > >From: Claudio Nanni [mailto:claudio.nanni@gmail.com]
> > >Sent: Tuesday, July 13, 2010 1:56 PM
> > >To: alba.albetti
> > >Cc: mysql
> > >Subject: Re: How to become a DBA on MySQL
> > >
> > >Reference is everywhere, but you need a sort of starting point.
> > >
> > >In your case I would say get this
> > >book > > >DuBois/dp/0672329387/ref=sr_1_1?ie=UTF8&s=books&qid=1279043 056&sr=1-1>
> > >and
> > >read:
> > >
> > >
> > > - Part III
> > > - Part IV-D (quick read)
> > >
> > >
> > >You will benefit from Part I as well as developer.
> > >
> > >In my opinion this book is clear and linear, good to learn MySQL.
> > >
> > >When you will be working as DBA keep this
> > >one in
> > >the drawer.
> > >
> > >
> > >Claudio
> > >
> > >
> > >2010/7/13 alba.albetti
> > >
> > >> Hi,
> > >> I'd like to know which are the main tasks for a DBA, so in addition of
> the
> > >> on-line tutorial of MySQL, is there anyone telling me whether there
> exists
> > >> some tutorial (better if in PDF) where it's possible to undestand and
> learn
> > >> all you need for managing the MySQL DB as DBA? I mean I'd like to read
> > >> something explaining what are datafiles, tablespaces, ... and what
> usually
> > >> a
> > >> DBA is asked to do (creating databases, starting up and shutting down
> the
> > >> database, managing the database's storage structures, making database
> > >> backups and performing recovery, monitoring and tuning performance,
> ...) In
> > >> other words I'd like to read how to manage a DB as DBA, because I've
> always
> > >> worked only as developer and not as DBA.
> > >> Thanks!
> > >>
> > >>
> > >> --
> > >> MySQL General Mailing List
> > >> For list archives: http://lists.mysql.com/mysql
> > >> To unsubscribe:
> > >> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
> > >>
> > >>
> > >
> > >
> > >--
> > >Claudio
> >
> >
> >
> >
>
> Keith J. Clark
>
>
> Business Manager Owner
> The Bookworm Waterloo Hosting
> Quality Used Books Complete Web Hosting Provider
> www.k-wbookworm.com www.waterloohosting.com
> sales@k-wbookworm.com sales@waterloohosting.com
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=john.daisley@butterflysys tems.co.uk
>
>


--
John Daisley

Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer

Telephone: +44 (0)7918 621621
Email: john.daisley@butterflysystems.co.uk

--002215b02f52c2b409048b4a9038--

RE: How to become a DBA on MySQL

Sorry, I wish I did.

I've used courses at lvsonline.com for all kinds of things (programming,
graphics, etc.), but I didn't see anything about MySQL DBA. All of the courses
I took there were good. They all had lab work that you submitted to the
instructor.

DBA might not lend itself to that.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com


>-----Original Message-----
>From: Keith Clark [mailto:keithclark@k-wbookworm.com]
>Sent: Tuesday, July 13, 2010 3:58 PM
>To: Jerry Schwartz
>Cc: 'Claudio Nanni'; 'alba.albetti'; 'mysql'
>Subject: RE: How to become a DBA on MySQL
>
>Jerry,
>
>Do you know of any reputable online classes that you could point me to?
>
>Keith
>
>On Tue, 2010-07-13 at 14:25 -0400, Jerry Schwartz wrote:
>> You might want to see if there are any online classes that could get you
>> started. I usually start by reading a big, thick book -- but I've found
>> that
>> spending a week or two on an introductory-level online class gives me a big
>> head start.
>>
>> "Modern" documentation tends to be lacking (IMNSHO). All too many reference
>> books are written on the principle of "If you know exactly what you want to
>> do, here's roughly how to do it." You can wander around for a long time not
>> knowing what a feature is for.
>>
>> Regards,
>>
>> Jerry Schwartz
>> Global Information Incorporated
>> 195 Farmington Ave.
>> Farmington, CT 06032
>>
>> 860.674.8796 / FAX: 860.674.8341
>> E-mail: jerry@gii.co.jp
>> Web site: www.the-infoshop.com
>>
>>
>> >-----Original Message-----
>> >From: Claudio Nanni [mailto:claudio.nanni@gmail.com]
>> >Sent: Tuesday, July 13, 2010 1:56 PM
>> >To: alba.albetti
>> >Cc: mysql
>> >Subject: Re: How to become a DBA on MySQL
>> >
>> >Reference is everywhere, but you need a sort of starting point.
>> >
>> >In your case I would say get this
>> >book >> >DuBois/dp/0672329387/ref=sr_1_1?ie=UTF8&s=books&qid=1279043 056&sr=1-1>
>> >and
>> >read:
>> >
>> >
>> > - Part III
>> > - Part IV-D (quick read)
>> >
>> >
>> >You will benefit from Part I as well as developer.
>> >
>> >In my opinion this book is clear and linear, good to learn MySQL.
>> >
>> >When you will be working as DBA keep this
>> >one in
>> >the drawer.
>> >
>> >
>> >Claudio
>> >
>> >
>> >2010/7/13 alba.albetti
>> >
>> >> Hi,
>> >> I'd like to know which are the main tasks for a DBA, so in addition of
>> >> the
>> >> on-line tutorial of MySQL, is there anyone telling me whether there
>> >> exists
>> >> some tutorial (better if in PDF) where it's possible to undestand and
>learn
>> >> all you need for managing the MySQL DB as DBA? I mean I'd like to read
>> >> something explaining what are datafiles, tablespaces, ... and what
>> >> usually
>> >> a
>> >> DBA is asked to do (creating databases, starting up and shutting down
>> >> the
>> >> database, managing the database's storage structures, making database
>> >> backups and performing recovery, monitoring and tuning performance, ...)
>In
>> >> other words I'd like to read how to manage a DB as DBA, because I've
>always
>> >> worked only as developer and not as DBA.
>> >> Thanks!
>> >>
>> >>
>> >> --
>> >> MySQL General Mailing List
>> >> For list archives: http://lists.mysql.com/mysql
>> >> To unsubscribe:
>> >> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
>> >>
>> >>
>> >
>> >
>> >--
>> >Claudio
>>
>>
>>
>>
>
>Keith J. Clark
>
>
>Business Manager Owner
>The Bookworm Waterloo Hosting
>Quality Used Books Complete Web Hosting Provider
>www.k-wbookworm.com www.waterloohosting.com
>sales@k-wbookworm.com sales@waterloohosting.com





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: How to become a DBA on MySQL

--------------040001060106050604090905
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Below link might be help you.

http://forge.mysql.com/wiki/MySQL_University


regards,
Nilnandan

Jerry Schwartz wrote:
> Sorry, I wish I did.
>
> I've used courses at lvsonline.com for all kinds of things (programming,
> graphics, etc.), but I didn't see anything about MySQL DBA. All of the courses
> I took there were good. They all had lab work that you submitted to the
> instructor.
>
> DBA might not lend itself to that.
>
> Regards,
>
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
> E-mail: jerry@gii.co.jp
> Web site: www.the-infoshop.com
>
>
>
>> -----Original Message-----
>> From: Keith Clark [mailto:keithclark@k-wbookworm.com]
>> Sent: Tuesday, July 13, 2010 3:58 PM
>> To: Jerry Schwartz
>> Cc: 'Claudio Nanni'; 'alba.albetti'; 'mysql'
>> Subject: RE: How to become a DBA on MySQL
>>
>> Jerry,
>>
>> Do you know of any reputable online classes that you could point me to?
>>
>> Keith
>>
>> On Tue, 2010-07-13 at 14:25 -0400, Jerry Schwartz wrote:
>>
>>> You might want to see if there are any online classes that could get you
>>> started. I usually start by reading a big, thick book -- but I've found
>>> that
>>> spending a week or two on an introductory-level online class gives me a big
>>> head start.
>>>
>>> "Modern" documentation tends to be lacking (IMNSHO). All too many reference
>>> books are written on the principle of "If you know exactly what you want to
>>> do, here's roughly how to do it." You can wander around for a long time not
>>> knowing what a feature is for.
>>>
>>> Regards,
>>>
>>> Jerry Schwartz
>>> Global Information Incorporated
>>> 195 Farmington Ave.
>>> Farmington, CT 06032
>>>
>>> 860.674.8796 / FAX: 860.674.8341
>>> E-mail: jerry@gii.co.jp
>>> Web site: www.the-infoshop.com
>>>
>>>
>>>
>>>> -----Original Message-----
>>>> From: Claudio Nanni [mailto:claudio.nanni@gmail.com]
>>>> Sent: Tuesday, July 13, 2010 1:56 PM
>>>> To: alba.albetti
>>>> Cc: mysql
>>>> Subject: Re: How to become a DBA on MySQL
>>>>
>>>> Reference is everywhere, but you need a sort of starting point.
>>>>
>>>> In your case I would say get this
>>>> book >>>> DuBois/dp/0672329387/ref=sr_1_1?ie=UTF8&s=books&qid=12790430 56&sr=1-1>
>>>> and
>>>> read:
>>>>
>>>>
>>>> - Part III
>>>> - Part IV-D (quick read)
>>>>
>>>>
>>>> You will benefit from Part I as well as developer.
>>>>
>>>> In my opinion this book is clear and linear, good to learn MySQL.
>>>>
>>>> When you will be working as DBA keep this
>>>> one in
>>>> the drawer.
>>>>
>>>>
>>>> Claudio
>>>>
>>>>
>>>> 2010/7/13 alba.albetti
>>>>
>>>>
>>>>> Hi,
>>>>> I'd like to know which are the main tasks for a DBA, so in addition of
>>>>> the
>>>>> on-line tutorial of MySQL, is there anyone telling me whether there
>>>>> exists
>>>>> some tutorial (better if in PDF) where it's possible to undestand and
>>>>>
>> learn
>>
>>>>> all you need for managing the MySQL DB as DBA? I mean I'd like to read
>>>>> something explaining what are datafiles, tablespaces, ... and what
>>>>> usually
>>>>> a
>>>>> DBA is asked to do (creating databases, starting up and shutting down
>>>>> the
>>>>> database, managing the database's storage structures, making database
>>>>> backups and performing recovery, monitoring and tuning performance, ...)
>>>>>
>> In
>>
>>>>> other words I'd like to read how to manage a DB as DBA, because I've
>>>>>
>> always
>>
>>>>> worked only as developer and not as DBA.
>>>>> Thanks!
>>>>>
>>>>>
>>>>> --
>>>>> MySQL General Mailing List
>>>>> For list archives: http://lists.mysql.com/mysql
>>>>> To unsubscribe:
>>>>> http://lists.mysql.com/mysql?unsub=claudio.nanni@gmail.com
>>>>>
>>>>>
>>>>>
>>>> --
>>>> Claudio
>>>>
>>>
>>>
>>>
>> Keith J. Clark
>>
>>
>> Business Manager Owner
>> The Bookworm Waterloo Hosting
>> Quality Used Books Complete Web Hosting Provider
>> www.k-wbookworm.com www.waterloohosting.com
>> sales@k-wbookworm.com sales@waterloohosting.com
>>
>
>
>
>
>
>

--------------040001060106050604090905--

RE: How to become a DBA on MySQL

--_e7899fa4-28b8-45f1-94ca-e1669ea9e980_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


Keith/Jerry/Caludio/Alba

=20

Here are some possible locations where i used to instruct

=20

1)http://www.aictrain.com ..they are primarily boston based not sure if the=
y have any online courses yet

2)http://www.champlain.com=20
Champlain has a a number of online courses..if you have any questions ask p=
rogram coordinator gary his address is=20
savard@champlain.edu

=20

My understanding is that oracle may offer some DBA courses in the future

=20

Keep us apprised
Martin Gainty=20
______________________________________________=20
Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit=
=E9

=20
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng=
er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter=
leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l=
ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin=
dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w=
ir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes=
pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat=
isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e=
ou la copie de ceci est interdite. Ce message sert =E0 l'information seule=
ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d=
onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation=
=2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni=
..



=20

> From: jerry@gii.co.jp
> To: keithclark@k-wbookworm.com
> CC: claudio.nanni@gmail.com=3B alba.albetti@libero.it=3B mysql@lists.mysq=
l.com
> Subject: RE: How to become a DBA on MySQL
> Date: Tue=2C 13 Jul 2010 17:53:31 -0400
>=20
> Sorry=2C I wish I did.
>=20
> I've used courses at lvsonline.com for all kinds of things (programming=
,
> graphics=2C etc.)=2C but I didn't see anything about MySQL DBA. All of th=
e courses=20
> I took there were good. They all had lab work that you submitted to the=20
> instructor.
>=20
> DBA might not lend itself to that.
>=20
> Regards=2C
>=20
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington Ave.
> Farmington=2C CT 06032
>=20
> 860.674.8796 / FAX: 860.674.8341
> E-mail: jerry@gii.co.jp
> Web site: www.the-infoshop.com
>=20
>=20
> >-----Original Message-----
> >From: Keith Clark [mailto:keithclark@k-wbookworm.com]
> >Sent: Tuesday=2C July 13=2C 2010 3:58 PM
> >To: Jerry Schwartz
> >Cc: 'Claudio Nanni'=3B 'alba.albetti'=3B 'mysql'
> >Subject: RE: How to become a DBA on MySQL
> >
> >Jerry=2C
> >
> >Do you know of any reputable online classes that you could point me to?
> >
> >Keith
> >
> >On Tue=2C 2010-07-13 at 14:25 -0400=2C Jerry Schwartz wrote:
> >> You might want to see if there are any online classes that could get y=
ou
> >> started. I usually start by reading a big=2C thick book -- but I've fo=
und=20
> >> that
> >> spending a week or two on an introductory-level online class gives me =
a big
> >> head start.
> >>
> >> "Modern" documentation tends to be lacking (IMNSHO). All too many refe=
rence
> >> books are written on the principle of "If you know exactly what you wa=
nt to
> >> do=2C here's roughly how to do it." You can wander around for a long t=
ime not
> >> knowing what a feature is for.
> >>
> >> Regards=2C
> >>
> >> Jerry Schwartz
> >> Global Information Incorporated
> >> 195 Farmington Ave.
> >> Farmington=2C CT 06032
> >>
> >> 860.674.8796 / FAX: 860.674.8341
> >> E-mail: jerry@gii.co.jp
> >> Web site: www.the-infoshop.com
> >>
> >>
> >> >-----Original Message-----
> >> >From: Claudio Nanni [mailto:claudio.nanni@gmail.com]
> >> >Sent: Tuesday=2C July 13=2C 2010 1:56 PM
> >> >To: alba.albetti
> >> >Cc: mysql
> >> >Subject: Re: How to become a DBA on MySQL
> >> >
> >> >Reference is everywhere=2C but you need a sort of starting point.
> >> >
> >> >In your case I would say get this
> >> >book > >> >DuBois/dp/0672329387/ref=3Dsr_1_1?ie=3DUTF8&s=3Dbooks&qid=3 D127904305=
6&sr=3D1-1>
> >> >and
> >> >read:
> >> >
> >> >
> >> > - Part III
> >> > - Part IV-D (quick read)
> >> >
> >> >
> >> >You will benefit from Part I as well as developer.
> >> >
> >> >In my opinion this book is clear and linear=2C good to learn MySQL.
> >> >
> >> >When you will be working as DBA keep this
> >> >one in
> >> >the drawer.
> >> >
> >> >
> >> >Claudio
> >> >
> >> >
> >> >2010/7/13 alba.albetti
> >> >
> >> >> Hi=2C
> >> >> I'd like to know which are the main tasks for a DBA=2C so in additi=
on of=20
> >> >> the
> >> >> on-line tutorial of MySQL=2C is there anyone telling me whether the=
re=20
> >> >> exists
> >> >> some tutorial (better if in PDF) where it's possible to undestand a=
nd
> >learn
> >> >> all you need for managing the MySQL DB as DBA? I mean I'd like to r=
ead
> >> >> something explaining what are datafiles=2C tablespaces=2C ... and w=
hat=20
> >> >> usually
> >> >> a
> >> >> DBA is asked to do (creating databases=2C starting up and shutting =
down=20
> >> >> the
> >> >> database=2C managing the database's storage structures=2C making da=
tabase
> >> >> backups and performing recovery=2C monitoring and tuning performanc=
e=2C ...)
> >In
> >> >> other words I'd like to read how to manage a DB as DBA=2C because I=
've
> >always
> >> >> worked only as developer and not as DBA.
> >> >> Thanks!
> >> >>
> >> >>
> >> >> --
> >> >> MySQL General Mailing List
> >> >> For list archives: http://lists.mysql.com/mysql
> >> >> To unsubscribe:
> >> >> http://lists.mysql.com/mysql?unsub=3Dclaudio.nanni@gmail.com
> >> >>
> >> >>
> >> >
> >> >
> >> >--
> >> >Claudio
> >>
> >>
> >>
> >>
> >
> >Keith J. Clark
> >
> >
> >Business Manager Owner
> >The Bookworm Waterloo Hosting
> >Quality Used Books Complete Web Hosting Provider
> >www.k-wbookworm.com www.waterloohosting.com
> >sales@k-wbookworm.com sales@waterloohosting.com
>=20
>=20
>=20
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@hotmail.com
>=20
=20
____________________________________________________________ _____
The New Busy is not the old busy. Search=2C chat and e-mail from your inbox=
..
http://www.windowslive.com/campaign/thenewbusy?ocid=3DPID283 26::T:WLMTAGL:O=
N:WL:en-US:WM_HMP:042010_3=

--_e7899fa4-28b8-45f1-94ca-e1669ea9e980_--

Re: How to become a DBA on MySQL

I very much disagree with the suggestion that any sort of training is
needed or useful.

The fastest way (IMHO) to gain the knowledge to become a solid MySQL
DBA is to answer questions on #mysql and to read planet mysql.

There are very few people than understand MySQL well. After 6 months
of trying to help people on #mysql most people will have enough
knowledge that I would suggest hiring them as either junior or full
DBA. In addition it is easy to make contacts that can become
employment opportunities.

--
Rob Wultsch
wultsch@gmail.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: How to become a DBA on MySQL

>-----Original Message-----
>From: Rob Wultsch [mailto:wultsch@gmail.com]
>Sent: Sunday, July 18, 2010 2:57 PM
>To: Martin Gainty
>Cc: jerry@gii.co.jp; keithclark@k-wbookworm.com; claudio.nanni@gmail.com;
>alba.albetti@libero.it; mysql@lists.mysql.com
>Subject: Re: How to become a DBA on MySQL
>
>I very much disagree with the suggestion that any sort of training is
>needed or useful.
>
>The fastest way (IMHO) to gain the knowledge to become a solid MySQL
>DBA is to answer questions on #mysql and to read planet mysql.
>
[JS] That depends upon where you are on the learning curve.

- If you have experience with designing and managing other databases, you are
correct.

- If, on the other hand, you are starting from scratch you'll find many of the
concepts bewildering.

- Even if you have been programming with databases, you might have been
completely isolated from the actual database design and management process.
This is particularly true in large, compartmentalized organizations where the
existing DBAs might not have a clue about programming and the programmers
might not have any clue where the data really comes from. I've observed such
setups in some of my larger clients, where the programmers were not allowed to
construct their own queries.

- A lot of people don't have a suitable test environment. Where I currently
work, my predecessor had no test or development environment at all. He made
all of his changes directly to the production code.

- You might have inherited such a mess that the very idea of "managing" the
database is overwhelming. (See above.)

I've been programming since 1966, and managing databases since before SQL was
a gleam in anybody's eye, and I still prefer to start with a "first steps for
little feet" introduction even if it only takes a couple of hours for me to
blow through it. This is especially true since actual documentation has become
almost a lost art.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com







--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org