[UPHPU] DB experience

Smith, Jeff jeff.smith at hollycorp.com
Wed Apr 28 12:45:27 MDT 2004


Oracle will win hands down if properly tuned and maintained.  I like comparing Oracle to an exotic sports car.  Great peformance, but if something goes wrong you need to have a specialist take care of it.  You cannot tinker with it yourself.  

-----Original Message-----
From: Scott Barber [mailto:scott.barber at tonservices.com]
Sent: Wednesday, April 28, 2004 12:17 PM
To: UPHPU List
Subject: [UPHPU] DB experience


All,

I know I'm throwing out potential flame-bait here, but have any of you
guys done / know of any good comparisons of Postgres, MySQL and Oracle
(performance-wise)?

I'm looking into the latest versions of each - we're going to be
building a big nasty cluster of one of the three and still in decision
mode.

Also - does php work better with any of the three with the native db
connectors it uses?

Looking for any experience you "gurus" may have had.

Thanks!


On Wed, 2004-04-28 at 10:54, Mac Newbold wrote:
> For those of you who were interested in getting the most out of your MySQL
> server, there's a new O'Reilly book out that talks about it.
> 
> Maybe we can get a copy or two to review/give away?
> 
> Mac
> 
> --
> Mac Newbold		MNE - Mac Newbold Enterprises, LLC
> mac at macnewbold.com	http://www.macnewbold.com/
> 
> ---------- Forwarded message ----------
> Date: 27 Apr 2004 23:15:03 GMT
> From: "Frederick Noronha (FN)" <fred at bytesforall.org>
> Newsgroups: comp.os.linux.announce
> Subject: "High Performance MySQL" Released by O'Reilly (fwd)
> 
> 
> ---------- Forwarded message ----------
> 
> Advanced Tools and Techniques for Running MySQL
> O'Reilly Releases "High Performance MySQL"
> 
> Sebastopol, CA--Always popular in Linux and open source communities,
> MySQL has also made significant inroads into the commercial sector, its
> rapid adoption owing primarily to its reputation for being fast, easy to run,
> and cost-effective. As a consequence, many MySQL users and administrators
> will tend to slide into using it: they find themselves working with MySQL
> without much forethought, training, or other preparation.  As Jeremy
> Zawodny and Derek Balling observe in "High Performance MySQL" (O'Reilly,
> US $39.95), "They hear its benefits, find that it's easy to install on
> their systems (or better yet, comes pre-installed), and read a quick book
> on how to attach simple SQL operations to web sites or other applications."
> 
> And, in fact, MySQL's repute is well earned; in the beginning, at least,
> administering it can be relatively unchallenging.  But as Zawodny and
> Balling explain, "Real-life use of MySQL requires forethought and care--
> and a little benchmarking and testing. This book is for the MySQL
> administrator who has the basics down but realizes the need to go further.
> It's a good book to read after you've installed and learned how to use
> MySQL but before your site starts to get a lot of traffic, and the dragons
> are breathing down your neck."  The problems may first surface in many
> forms. Perhaps one particular web page seems to take forever to load, or a
> system failure corrupts a database and makes recovery difficult. When
> these problems occur during a critical service, note the authors, one's
> fellow workers and friendly manager start to take on decidedly dragon-like
> appearances.
> 
> "More and more companies are beginning to build serious, mission critical
> applications or web sites on top of MySQL," adds Zawodny. "As they do
> this, they're likely going to have questions not answered in introductory
> MySQL books. Whether it's configuring replication, choosing among MySQL's
> storage engines, or implementing load-balancing, we wrote this book to
> help answer those questions."
> 
> "High Performance MySQL" helps readers understand the factors that affect
> MySQL performance and apply that knowledge to their own servers.  The
> authors explain MySQL indexing and optimization in depth so readers will
> be better able to use these key features. The book then covers practical
> replication, backup, and load-balancing strategies, exploring available
> tools in detail with additional discussions of the issues surrounding
> their use in real-life environments.  Finally, readers will learn the
> supporting techniques they need to carry out these tasks, including
> advanced configuration, benchmarking, and investigating logs.
> 
> Topics covered in the book include:
> -Configuration and setup options
> -Storage engines and table types
> -Benchmarking
> -Indexes
> -Query Optimization
> -Application Design
> -Server Performance
> -Replication
> -Load-balancing
> -Backup and Recovery
> -Security
> 
> "Now more than ever, MySQL is being used in larger and more visible
> roles," says Zawodny.  "Bigger applications demand the kind of performance
> and reliability that MySQL can provide--if you apply it correctly. This
> book helps developers understand what it takes to make MySQL work in
> larger and more critical environments."
> 
> Additional Resources:
> 
> Chapter 7, "Replication," is available online at:
> http://www.oreilly.com/catalog/hpmysql/chapter/index.html
> 
> For more information about the book, including table of contents, index,
> author bios, and samples, see:
> http://www.oreilly.com/catalog/hpmysql/
> 
> For a cover graphic in JPEG format, go to:
> ftp://ftp.ora.com/pub/graphics/book_covers/hi-res/0596003064.jpg
> 
> High Performance MySQL
> Jeremy D. Zawodny and Derek J. Balling
> ISBN 0-596-00306-4, 276 pages, $39.95 US, $57.95 CA
> order at oreilly.com
> 1-800-998-9938
> 1-707-827-7000
> http://www.oreilly.com
> 
> About O'Reilly
> O'Reilly Media is the premier information source for leading-edge computer
> technologies. The company's books, conferences, and web sites bring to
> light the knowledge of technology innovators. O'Reilly books, known for
> the animals on their covers, occupy a treasured place on the shelves of
> the developers building the next generation of software. O'Reilly
> conferences and summits bring alpha geeks and forward-thinking business
> leaders together to shape the revolutionary ideas that spark new
> industries. From the Internet to XML, open source, .NET, Java, and web
> services, O'Reilly puts technologies on the map. For more information:
> http://www.oreilly.com
> 
> # # #
> 
> O'Reilly is a registered trademark of O'Reilly Media, Inc. All other
> trademarks are property of their respective owners.
> 
> ##########################################################################
> # Send submissions for comp.os.linux.announce to: cola at stump.algebra.com #
> # PLEASE remember a short description of the software and the LOCATION.  #
> # This group is archived at http://stump.algebra.com/~cola/              #
> ##########################################################################
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: list-unsubscribe at uphpu.org
> For additional commands, e-mail: list-help at uphpu.org
-- 
Scott Barber
UNIX SysAdmin
TON Services, Inc.
801.624.4572
scott.barber at tonservices.com




---------------------------------------------------------------------
To unsubscribe, e-mail: list-unsubscribe at uphpu.org
For additional commands, e-mail: list-help at uphpu.org






More information about the UPHPU mailing list