Databases

!http://www.sun.com/bigadmin/home/images/bigadminHeaderWikiThumb.jpg!

{section:border=false}
{column:width=20%}

{include:TOC for Tech Tips}

{column}

{column:width=55%}

*Table of Contents*
{toc}

h4. General Database Resources
* Sun BluePrints (registration required):
** [Accelerating Databases with the Sun Storage F5100 Flash Array|https://www.sun.com/offers/details/821-0473.xml]
** [Sun's Reference Architecture for Next for Generation Data Backup|http://mapping.sun.com/profile/offer.jsp?id=38063590]


h4. MySQL Resources

* [MySQL resource center for sys admins|http://www.sun.com/bigadmin/topics/mysql/] on BigAdmin
* MySQL articles on BigAdmin:
** [MySQL 5.1 Database Deployment Over CIFS Using Sun Storage 7000 Unified Storage System|http://www.sun.com/bigadmin/features/articles/7000_mysql_cifs.jsp]
** [Sizing Study for Pentaho Open Source Business Intelligence Suite on Sun Platforms|http://www.sun.com/bigadmin/features/articles/pentaho_sizing.jsp]
** [Pentaho Business Intelligence and MySQL on Sun Storage 7000 Unified Storage System|http://www.sun.com/bigadmin/features/articles/pentaho_7000.jsp]
** [Sun Storage J4400 Array as Disk Storage for Zmanda Recovery Manager for MySQL Database|http://www.sun.com/bigadmin/features/articles/zrm_mysql_j4400.jsp], (April 2009)
** [Setting Up MySQL Cluster Software Using Solaris Zones Partitioning Technology|http://www.sun.com/bigadmin/features/articles/mysql_cluster_zones.jsp]
** [Using Sun Java System Web Server With Sun Identity Manager and MySQL Software|http://www.sun.com/bigadmin/features/articles/idm_web_mysql.jsp]
** [Installation of MySQL 5.1 Cluster Software on the Solaris 10 OS for x64 Platforms|http://www.sun.com/bigadmin/features/articles/mysql_install_stor.jsp]
** [Using Sun Fire X4540 Server With Zmanda Recovery Manager 2.2 for MySQL Database|http://www.sun.com/bigadmin/features/articles/zrm_mysql_sfx4540.jsp]
* [Database Resource Collection |http://www.sun.com/bigadmin/collections/database.html] on BigAdmin
* Sun BluePrints (registration required):
** [Open Network Systems for Internet Infrastructure, MySQL Edition|https://www.sun.com/offers/details/820-7893.xml]
** [High Availability MySQL Database Replication with Solaris Zone Cluster|http://wikis.sun.com/display/BluePrints/High+Availability+MySQL+Database+Replication+with+Solaris+Zone+Cluster]
** [Improving MySQL Database Scalability|http://wikis.sun.com/display/BluePrints/Improving+MySQL+Database+Scalability]
** [MySQL Guide for Sun Storage 7000 Unified Storage System|http://wikis.sun.com/display/BluePrints/MySQL+Guide+for+Sun+Storage+7000+Unified+Storage+System]
** [Running MySQL Database in Solaris Containers|http://wikis.sun.com/display/BluePrints/Running+MySQL+Database+in+Solaris+Containers]
** [MySQL Database Scale-out and Replication for High Growth Businesses|http://wikis.sun.com/display/BluePrints/MySQL+Database+Scale-Out+and+Replication+for+High+Growth+Businesses]
** [Optimize MySQL Server on Sun x64 Servers and Storage|http://wikis.sun.com/display/BluePrints/Optimize+MySQL+Server+on+Sun+x64+Servers+and+Storage]
** [Deploying MySQL Database in Solaris Cluster Environments for Increased High Availability|http://wikis.sun.com/display/BluePrints/Deploying+MySQL+Database+in+Solaris+Cluster++Environments]
** [Optimizing MySQL Database Application Performance with Solaris Dynamic Tracing|http://wikis.sun.com/display/BluePrints/Optimizing+MySQL+Database+Application+Performance+with+Solaris+Dynamic+Tracing]
* wikis.sun.com resources:
** [Deployment Example - Installing MySQL in the Non-Global Failover Zone|http://wikis.sun.com/display/SunCluster/Deployment+Example+-+Installing+MySQL+in+the+Non-Global+Failover+Zone]
** [Deployment Example - Installing MySQL in the Global Zone|http://wikis.sun.com/display/SunCluster/Deployment+Example+-+Installing+MySQL+in+the+Global+Zone]
** [Deployment Example - Installing MySQL in a Non-Global Zone|http://wikis.sun.com/display/SunCluster/Deployment+Example+-+Installing+MySQL+in+a+Non-Global+Zone]
* Third-party resources
** [SQL Buddy - Free, Open Source, Web-based MySQL Administration|http://www.sqlbuddy.com]
** [Useful MySQL Scripts|http://faemalia.net/mysqlUtils/]
* [Developing MySQL Database Applications With PHP (Series of 4 Articles)|http://developers.sun.com/databases/articles/mysql_php1.html] on SDN


h4. Oracle Resources

** [Deploying Oracle Siebel CRM on Sun Storage 7000 Unified Storage Systems|http://wikis.sun.com/display/BluePrints/Deploying+Oracle+Siebel+CRM+on+Sun+Storage+7000+Unified+Storage+Systems]
** [Best Practices for Running Oracle Databases in Solaris Containers|http://wikis.sun.com/display/BluePrints/Best+Practices+for+Running+Oracle+Databases+in+Solaris+Containers]
** [Configuring Sun Storage 7000 Systems for Oracle Databases|http://wikis.sun.com/display/BluePrints/Configuring+Sun+Storage+7000+Systems+for+Oracle+Databases]

h4. PostgreSQL Resources

* Sun BluePrints document (registration required): [Optimizing PostgreSQL Application Performance with Solaris Dynamic Tracing|http://mapping.sun.com/profile/offer.jsp?id=382]
* White paper: [How to Configure and Run PostgreSQL on Solaris 10|https://www.sun.com/offers/details/postgresql_howto.html] (login or registration required)
* [Build your own PostgreSQL for OpenSolaris|http://wikis.sun.com/display/DBonSolaris/BuildingPostgreSQL]
* [PostgreSQL on Solaris|http://wikis.sun.com/display/DBonSolaris/PostgreSQL]
* [Backing Up a PostgreSQL Database to a Remote Server With the Solaris 10 OS|http://www.sun.com/bigadmin/content/submitted/backup_db_auto.jsp] on BigAdmin

h4. DB2 Resources

* Sun BluePrints document (registration required): [Deploying DB2 Database on the Sun Storage 7000 Unified Storage System|http://wikis.sun.com/display/BluePrints/Deploying+DB2+Database+on+the+Sun+Storage+7000+Unified+Storage+System]

{column}

{section}