The ISV Engineering team at Sun has released 3 new documents giving important MySQL implementation and performance advice on Solaris Containers, Java technology, and SugarCRM.
The first is another great publication in the Sun BluePrint™ Series called Running MySQL Database in Solaris Containers by Ritu Kamboj and Giri Mandalika. Solaris Containers are a Sun unique virtualization option that let applications run on the same server in isolation from each other. This allows easier workload resource management, maintenance of service levels, and superior performance compared to other virtualization methodologies. The paper discusses the various requirements & options when installing MySQL into this environment.
The second paper is an article on the Sun Developer Network (SDN) called Using MySQL With Java Technology by Giri Mandalika (a prolific ISV Engineering writer). He covers these four key areas:
- Accessing MySQL With Java/JDBC
- MySQL Connector/J JDBC Driver
- Installing MySQL Connector/J
- Testing the MySQL Database Connectivity Using the Connector/J JDBC Driver
While not specifically concentrating on MySQL, Satish Vanga's presentation to SugarCon 2009 presents best practices for getting the best performance out of the SugarCRM open source relationship management application. After showing where the bottlenecks in the implementation architecture can occur, Satish lays out the Solaris, PhP, and SugarCRM considerations before starting spending some time on MySQL InnoDB and DTrace around page 10. There is also a pointer to the Sun BluePrint™ Optimizing MySQL Database Application Performance with Solaris Dynamic Tracing. by Jenny Chen of ISV Engineering.
