Guest.Visitor
03-13-2001, 04:55 AM
<DIV><FONT face=Arial size=2>Richard,</FONT></DIV> <DIV><FONT face=Arial size=2></FONT></DIV> <DIV><FONT face=Arial size=2>We use mySQL here for development and training only. I asked around and the consensus was mySQL wasnt appropriate for a production environment.</FONT></DIV> <DIV><FONT face=Arial size=2></FONT></DIV> <DIV><FONT face=Arial size=2>The limitations mentioned were:</FONT></DIV> <DIV><FONT face=Arial size=2>1. no transaction control (ie no commit/rollback) support</FONT></DIV> <DIV><FONT face=Arial size=2>2. no support for subselects</FONT></DIV> <DIV><FONT face=Arial size=2>3. no stored procedures or triggers</FONT></DIV> <DIV><FONT face=Arial size=2>4. no foreign keys.</FONT></DIV> <DIV><FONT face=Arial size=2>5. not as scalable as heavyweight databases like db2 or oracle - also no highavailability support or cluster support.</FONT></DIV> <DIV><FONT face=Arial size=2></FONT></DIV> <DIV><FONT face=Arial size=2>The mysql documentation probably has a more extensive list.</FONT></DIV> <DIV><FONT face=Arial size=2></FONT></DIV> <DIV><FONT face=Arial size=2>The consensus here is that you might use mySQL in a very simple environment or where only very lightweight persistance is required.</FONT></DIV> <DIV><FONT face=Arial size=2></FONT></DIV> <DIV><FONT face=Arial size=2>Having said that, there are some articles on the internet showing that some companies have chosen to live with the limitations and have used mySQL in a production environment.</FONT></DIV> <DIV><FONT face=Arial size=2></FONT></DIV> <DIV><FONT face=Arial size=2>Alex Garrison</FONT></DIV> <BLOCKQUOTE dir=ltr style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <DIV>"Richard Shaler" <shaler@home.com> wrote in message news:ef1f9e9.-1@WebX.WawyahGHajS...</DIV>Does anyone use mySQL on a Linux server in a production environment? I'm evaluating mySQL and wondering if it's viable in for production applications.</P></BLOCKQUOTE>