Quick start of MySQL

marrowyung
marrowyung used Ask the Experts™
on
Dear all,

Any good ebook/link to start learn mySQL:

1)type of index, how many clustered index it can define
2) any execution plan.
3) what is the HA and DR solution.
4) What is the tools to tune it? workerbench?

DBA100.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi try these articles:


 MySQL Functions Reference

At Tutorials Point you will find references on all important built-in MySQL functions.
 
http://www.tutorialspoint.com/mysql/mysql-useful-functions.htm
 

 
A collection of MySQL Database Sites and Books is given at this page.
 
http://www.tutorialspoint.com/mysql/mysql-useful-resources.htm
 
Tuning the Database System
 
Few points for Database Administrator to fine tune a database performance.
 
http://www.tutorialspoint.com/mysql/mysql-database-tuning.htm

 
MySQL Tutorial in PDF
 
Download a quick MySQL tutorial in PDF format.
 
http://www.tutorialspoint.com/mysql/mysql_pdf_version.htm
hey,

here are some video tutorials...this might give you an idea about mySQL.

Understanding Indexing, by Zardosht Kasheff of Tokutek
http://www.youtube.com/watch?v=AVNjqgf7zNw

SQL Tutorial - 03 - Create - Database, Table, Index
https://www.youtube.com/watch?v=iwxwmUMadOg

MySQL Tutorial for Beginners - 1 - Creating a Database and Adding Tables to it
http://www.youtube.com/watch?v=FAXhXI2Gxdc

MySQL For Beginners - Tutorial 1 - Introduction to Basics
http://www.youtube.com/watch?v=X7WBmlK8GLo

MySQL Tutorial 2 - Inserting entries into database
http://www.youtube.com/watch?v=mLqg2sL0svM

MySQL SQL Statements Tutorial 1
http://www.youtube.com/watch?v=WV04VAaQVRA

Video Tutorial 1 SQL in english. Install MYSQL and first SQL queries with MySql Workbench
http://www.youtube.com/watch?v=5SmyLhgrtnc

Video Tutorial 3 SQL in english. Tables (create, alter, drop table) with mysql workbench
http://www.youtube.com/watch?v=9AZJ4aS56dE
marrowyungSenior Technical architecture (Data)

Author

Commented:
how about the type of index for MysQL and the DR solution for it?

right how the point on using mySQL is that there are no need to buy expensive hardware for cluster, as it is design to cluster within the memory/hard disk and the instance on other node can take up the loading ,right?

But it has to work with mySQL 5.1?

Any SAN replication designed for it? any geographic replication solution for it?
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Theo KouwenhovenApplication Consultant
Commented:
For your second query (DR site)
Read this article on Open Source Replication And Clustering Solution For MySQL:

http://forums.mysql.com/read.php?83,290570,290570

Go through this site as well: http://www.continuent.com/
marrowyungSenior Technical architecture (Data)

Author

Commented:
murphey2,

I want to focus on mySQL and something like the different between MysQL and other DB is a good direction.

I am a MSSQL guy so just want to know something new.

as Oracle buy MySQL, I am not sure if the feature will be >50% the same.

hafeezmca,

It seems the MySQL do not, out of the box, has any DR solution, right? any built in capability on this area? what version has it?
marrowyungSenior Technical architecture (Data)

Author

Commented:
Any method on my SQL to relocate individual data file or index to other file ?
marrowyungSenior Technical architecture (Data)

Author

Commented:
it seems that Tungsten Community Edition is gone and we can only buy enterprise edition ?
marrowyungSenior Technical architecture (Data)

Author

Commented:
Anyone know if MySQL can only has 1 clustered index per table? but DB2 can have at most 2.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial