Useful Dynamic Management View (DMV) resources
Free SQL Server DMV Starter Pack
A free eBook that describes 28 different ways that DMVs can be used with SQL Server
http://www.bradmcgehee.com/2010/07/free-sql-server-dmv-starter-pack/
The Periodic Table of DMVs
http://www.brentozar.com/dmvs/
Performance Tuning with SQL Server Dynamic Management Views by Louis Davidson and Tim Ford
http://www.simple-talk.com/books/sql-books/performance-tuning-with-sql-server-dynamic-management-views/
Scripts
http://www.simple-talk.com/redgatebooks/davidsonford/dmv_code.zip
Recap of April 2010 DMV a Day Series
http://sqlserverperformance.wordpress.com/2010/05/02/recap-of-april-2010-dmv-a-day-series/
Chaos, complexity, curiosity and database systems. A place where research meets industry
Welcome
Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP
"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein
"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein
Thursday, 22 September 2011
Wednesday, 21 September 2011
MySQL Clustering
For MySql clustering a few useful articles about providing high availability are below
MySQLCluster 7.1
http://www.mysql.com/products/cluster/
Information on MySQL Cluster and MySQL Replication blog
http://www.clusterdb.com/
MySQL Cluster Manager 1.1.2 – creating a Cluster is now trivial
http://www.clusterdb.com/mysql-cluster/mysql-cluster-manager-1-1-2-creating-a-cluster-is-now-trivial/
MySQL Cluster 7.1 Cheat Sheet
http://www.clusterdb.com/mysql-cluster-7-1-cheat-sheet/
MySQL Cluster 7.2: NoSQL, Key/Value, Memcached
http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.2.html
This provides a new option for multi-site clustering.
MySQL Cluster 7.2.1 is integrated with MySQL Server 5.5. You have all the benefits of an ACID RDBMS, combined with the performance capabilities of Key/Value store.This allows schema-less data storage.
Oracle University Free Summer learning on MySQL Part I
http://www.oracle.com/uk/education/eblast/uk-mysql-training-230811-ol-459574-en-gb.html?sc=WWOU11036077MPP003C015
Oracle University Free Summer learning on MySQL Part II
http://www.oracle.com/webapps/dialogue/ns/dlgwelcome.jsp?p_ext=Y&p_dlg_id=9799792&src=7297607&Act=8
ScaleBase shatters MySQL for scalability
The article explains "it is a proxy server that sits in front of the actual database and in this case, the tool breaks a monolithic relational database into chunks and spreads it out across multiple physical servers. "
http://www.theregister.co.uk/2011/08/16/scalebase_database_sharding/
MySQLCluster 7.1
http://www.mysql.com/products/cluster/
Information on MySQL Cluster and MySQL Replication blog
http://www.clusterdb.com/
MySQL Cluster Manager 1.1.2 – creating a Cluster is now trivial
http://www.clusterdb.com/mysql-cluster/mysql-cluster-manager-1-1-2-creating-a-cluster-is-now-trivial/
MySQL Cluster 7.1 Cheat Sheet
http://www.clusterdb.com/mysql-cluster-7-1-cheat-sheet/
MySQL Cluster 7.2: NoSQL, Key/Value, Memcached
http://dev.mysql.com/tech-resources/articles/mysql-cluster-7.2.html
This provides a new option for multi-site clustering.
MySQL Cluster 7.2.1 is integrated with MySQL Server 5.5. You have all the benefits of an ACID RDBMS, combined with the performance capabilities of Key/Value store.This allows schema-less data storage.
Oracle University Free Summer learning on MySQL Part I
http://www.oracle.com/uk/education/eblast/uk-mysql-training-230811-ol-459574-en-gb.html?sc=WWOU11036077MPP003C015
Oracle University Free Summer learning on MySQL Part II
http://www.oracle.com/webapps/dialogue/ns/dlgwelcome.jsp?p_ext=Y&p_dlg_id=9799792&src=7297607&Act=8
ScaleBase shatters MySQL for scalability
The article explains "it is a proxy server that sits in front of the actual database and in this case, the tool breaks a monolithic relational database into chunks and spreads it out across multiple physical servers. "
http://www.theregister.co.uk/2011/08/16/scalebase_database_sharding/
Wednesday, 7 September 2011
Research Question Revised
After various iterations my research question stands as
How can the complex interactions, both extrinsic and intrinsic to the database, lead to a better understanding of database systems and their management?
In what ways could this lead to the emergence of improvement and innovation?
How can the complex interactions, both extrinsic and intrinsic to the database, lead to a better understanding of database systems and their management?
In what ways could this lead to the emergence of improvement and innovation?
Subscribe to:
Posts (Atom)