Instructor: Eric Wong
Email: eric@exitcertified.com

This text file will be kept and available at the end of class.



Welcome to MySQL for DBAs!

Yes, this class IS taught on Windows.


Please settle in, relax... we'll attempt to start around 09:00 PDT
however being Monday, we'll wait until quorum is achieved


Name/Role
Years with MySQL?  Other DBs (which ones)?
Where are you based out of?
What platform are you working with MySQL on?
Have you received your eKit?
Why are you here?
Non-IT?





Administrator/cangetin








10:15 Break
10:30 Continue class


Please sign in to the class before lunch:
http://education.oracle.com/eattendance.html
ClassID: 2609044

Please make sure your name/email is correct; this is essential
for your completion certificate and proof of attendance.




You can find my shared files at this location:
\\10.12.152.156\share

Please follow the class demonstration to install/configure MySQL



In windows: my.ini
In Unix: /etc/my.cnf <- Default location for option file (pfile)
it could be named anything you please...


12:45 Continue class - Chapters 1 through 3
14:30 Break
14:45 Continue chapters 3, 4 and 5
15:30 Lab time


Lab 1A PDF-42 (optional)
Lab 1B PDF-44 (Install MySQL)
Lab 1C PDF-45 (Install "world.sql")
Lab 2B PDF-58 (optional)
Lab 3A PDF-72
Lab 3B PDF-78
Lab 4A PDF-98 - If done, must complete to the very end
Lab 4C PDF-117 (optional)
Lab 5A PDF-125 
Lab 5B PDF-136


Percona -> Forked MySQL XtraDB
MariaDB -> Monty's thing... Monty Program AB
Drizzle -> Complete fork, stripped down MySQL 6.0

MaatKit -> AKA MySQL ToolKit



09:15 Start Class
10:15 Break
10:30 Continue

Hadoop -> Elephant..

12:00 Lunch
13:00 Continue class


"Answers" are in the back of 2nd PDF

Lab 6-A PDF-153
Lab 6-B PDF-165
Lab 6-C PDF-175
Lab 6-D PDF-183

Lab 7-A PDF-199
Lab 7-B PDF-207
Lab 7-C PDF-213

Lab 8-A PDF-227
Lab 8-B PDF-233
Lab 8-C PDF-237
Lab 8-E PDF-260






Wednesday

11:20 Continue Class

12:45
	Labs for Chapter 13 and 15
	PDF2 pages 31, 36, 78, 82, 89

13:30 Continue with material...
	Chapters 13 or 15?

14:20 Break

14:35 Chapter 11

Practices:
PDF1 - 332
PDF1 - 337



Thursday Chapters 12, 14, 17

PDF #2
Page 9, 16, 54, 64, 70, 114, 120

\\10.12.152.156\share

To "install" my5.1, unzip mysql into c:\my51
	mkdir c:\my51
	unzip mysql into c:\my51

	When you're done, you should have a
	c:\my51\bin, c:\my51\lib, etc...


To create instance 1:
	mkdir c:\data1
	mkdir c:\log1
	Create c:\my1.cnf - notepad


Break until 10:45

cd \my51\bin
mysqld --defaults-file=c:\my1.cnf --skip-grant-tables

install mysql
	create database mysql;
	use mysql;
	source ... 3 scripts.








14:00 Continue with Replication
	- Apply Lag -> mk-slave-delay
	- 3rd Instance as a slave of 2nd
	- Backup and Recovery to carve off slave
	- Filtering?


















Friday Chapters 3, 18

09:15 Expect anyone who wishes to do the hands-on
	labs to be present.

Review "mysql" tables

09:30 Guided hands-on replication etc...



"Grant tables"
	 user - Login time
	 db - "use" time
	 tables_priv - "statement" time
	 columns_priv - "statement" time
	 procs_priv - "statement" time
	 host

Misc Tables:
 event - Holds "events", AKA Jobs
 proc - Stored Procedures and Functions
 general_log - Optional table for "general" log
 slow_log - Optional table for "slow" log

Online Help Tables:
 help_category
 help_keyword
 help_relation
 help_topic

Optional TimeZone tables for translating TZ offsets:
 time_zone
 time_zone_leap_second
 time_zone_name
 time_zone_transition
 time_zone_transition_type


Really Misc Tables:
 func - User Defined Functions (NOT stored Functions)
 ndb_binlog_index - Cluster rep. for storage
		    engine NDB
 plugin - Defines the list of "plugins" as of 5.1
		Plug-in storage engines
		Plug-in parsers
 servers - List of "DB Links" which we call FEDERATED