MySQL gurus

From: Aaron Welch 
------------------------------------------------------
Anyone have any nuts and bolts MySQL folks they know?  Looking for redundancy and performance experience.

-AW

=============================================================== From: David White ------------------------------------------------------ I haven't architected, but have certainly maintained, MySQL replication environments for high-traffic sites when I worked for Acquia for about 6 months up in Boston. I could certainly take a look and provide some guidance...

=============================================================== From: Dan Lyke ------------------------------------------------------ We had a Percona guy in last summer to talk about optimizing MySQL. The presented material wasn't anything earth-shattering to me, but it was clear that the presenter had other course material, and could go as deep into the internals of InnoDB or whatever replication solutions and what-not as we wanted to dive. So I'd toss in a good word for Percona. And they seem to be doing good things for the MySQL community. Dan

=============================================================== From: Ed King ------------------------------------------------------ semi hijack=0A=0AAs part of my job at Hamilton County, I was sent to an Ora= cle Performance class in Atlanta back around year 2000 (thanks to all the t= axpayers for paying for my Oracle training)=0A=0AHaven't touched Oracle db = since I left the County so the only thing I remember from the class was a c= ontroversial statement by the instructor:=A0=A0=A0 most performance problem= s are in the application, not the database=0A=0Alet the debate begin=0A=0A= =0A=0A=0A=0A

=============================================================== From: Eric Wolf ------------------------------------------------------ The biggest problem I've seen is MySQL gets used simply as persistent storage by PHP coders who have no concept of SQL. I got fantastic performance improvements by replacing text fields with enums and making sure the indices actually indexed what the coder wanted. I could see arguing that the problem was in the application but it took some DB tuning knowledge to fix it. I have been fighting constant battles in the current gig around MySQL. The PHP coders insist that I should never talk directly to the database and, instead, use their JSON-RPC API. I keep insisting "MySQL has an API and it supports ad hoc queries". They also insist it is impossible to get any sort of replication working with MySQL. Bleh... I've also learned that Oracle shops pretty much ALWAYS have a DBA. I suspect it's in the license agreement that you have to hire at least one certified Oracle DBA. And nothing goes into the database without the DBA ensuring the simple stuff is covered. -Eric

=============================================================== From: Mike Harrison ------------------------------------------------------ Ed: Agreed. How many SQL statements do you have with > 1 join in them or selection criteria across more than 1 table at a time? Do you have indexes on the things to select and join by? Also, I hear you may be using a MySQL Cluster Server which is a different beast with a different intended purpose than a Cluster of MySQL servers in a MasterMasterMaster configuration. NDB Clusters are not intended for general purpose DB use. http://docs.oracle.com/cd/E17952

=============================================================== From: Mike Harrison ------------------------------------------------------ Eric: Having a serious DBA that sanity checks the bro/programmers is probably the biggest thing an Oracle/DB2/... shop has over a seat of the pants bunch of coders abusing a MySQL or NoSQL server. But when you pay big $$$$ for a db engine, the salary of a DBA is a small part of the annual support contract and an important part.