m MySQL Workbench
- jim mason
Owned by jim mason
Key Points
- MySQL client for admin, dev, modeler
- has admin, schema, developer views
- round trip modeling - create model > generate sql > build > reverse engineer db > create sql > create model from sql
- good performance hot spot analysis tools
- can connect multiple databases on different connections concurrently and share data
- scales very well
- supports all data models- SQL, NoSQL json, wide column db denormalized, graph databases
- event streaming support
- very widely used
- small change from MySQL to other DBS - Oracle, DB2, Postgres, SQL Server
References
| Reference_description_with_linked_URLs_____________________ | Notes____________________________________________________________ |
|---|---|
| https://dev.mysql.com/doc/ | |
| https://dev.mysql.com/ | downloads for devs |
| https://dev.mysql.com/downloads/ | |
| https://dev.mysql.com/doc/workbench/en/wb-develop-sql -editor-history.html | Workbench output windows |
Key Concepts
MySQL Local install
admin = root ( default )
set admin/ pwd
Install MySQL db
start mysqld to run as daemon
Install MySQL workbench
run exe to open workbench
connection on localhost:3306 to db from workbench - test connections
can import / export SQL
can generate model from DB
can generate DB from model
Potential Value Opportunities
Potential Challenges
Candidate Solutions
Step-by-step guide for Example
sample code block