Howskinp

Three Approaches to MySQL Applications on Dell PowerEdge Servers
Enterprise Product Group (EPG)
2nd Legal ad #59957744

Dell White Paper
By Dave Jaffe and Todd Muirhead

August 2005

Contents
Executive Summary.................................................................................................................... 4Introduction................................................................................................................................. 5 DVD Store Application Architecture ..................................................................................... 6 The Web Pages ............................................................................................................................ 7 The MySQLDatabase................................................................................................................ 9 The Database Schema ......................................................................................................... 9 InnoDB Tables, MyISAM Tables and Indexing .......................................................... 10 The PHP Application............................................................................................................... 11 PHP5 Setup.......................................................................................................................... 11 Using PHP with MySQL................................................................................................... 11
MySQL Connection.................................................................................11 MySQL Stored Procedure Call...............................................................11 MySQL Transaction.................................................................................12

The ASP.NET Application...................................................................................................... 13 ASP.NET Setup.................................................................................................................. 13 Using ASP.NET with MySQL ......................................................................................... 13
MySQL Connection .................................................................................13 MySQL Stored Procedure Call...............................................................14 MySQLTransaction.................................................................................14

The JSP Application................................................................................................................. 16 About JSPs, JVMs, JConnector and Tomcat.................................................................. 16 Using JSP with MySQL.................................................................................................... 16
MySQL Connection .................................................................................17 MySQL Insert ...........................................................................................17 MySQL Transaction.................................................................................17

Conclusions............................................................................................................................... 19 Appendix A. Appendix B. mysqlds2 Build Script ................................................................................ 20 mysqlds2 Index Creation Script ............................................................... 23

August 2005

Page 2

Dell Enterprise Product GroupAppendix C.

NEW_CUSTOMER Stored Procedure ..................................................... 25

Figure 1: DVD Store Application Architecture........................................................................................ 6 Figure 2: DVD Store Purchase Page.......................................................................................................... 7

Table 1: DVD...