« PHP Quebec Winds Down | Main | PHP Quebec MySQL Cluster Slides »
March 31, 2006
PHP Quebec for MySQL Folks
I haven't tagged my series of posts from PHP Quebec as MySQL because there's a lot of non-MySQL stuff that may or may not be of interest to MySQL folks. They are the previous seven posts in the "Technology" category for anyone that's interested.
A few items worthy of note for MySQL folks:
- A *very* high percentage of PHP folks use MySQL. Based on what I saw with the developers in Quebec, you can almost assume that a person developing in PHP is using MySQL on the backend. Is that a suprise? Does that not sound right?
- Attended a presentation on PostgreSQL which was a pretty good introduction to how to get that database up and running. Liked some of the shortcuts you can do in Postgres to show things like a list of available functions. Did not like the jabs at MySQL, although the comments about why MySQL is more populare than Postgres seemed pretty honest. Sensitive folks had to look away at the end because Sakila was disrespected on the last slide.
- Found it interesting that Rasmus Lerdorf's "how to improve performance of a PHP page" included a section where he swapped out Postgres and in MySQL to get a huge boost in pages/second.
- Benchmarking seems to indicate that using mysqli only gives 1% performance increase over PDO.
- MySQL Cluster is pretty exciting. I heard someone in the crowd say "man, that is so awesome" when I was doing a demo of a running cluster and flipping between nodes in the cluster inserting and selecting data to demonstrate the syncronous replication. Got a few ideas for demoing it even better (and making the session more interesting) if there's ever another chance to do a session on the cluster.
- The theory and documentation for MySQL Cluster is different from the real-world experience. It looks good on paper and when getting it set up, but when you run it for awhile it sounds like the picture gets less rosy. Met some nice folks who sat in on my session about MySQL Cluster who had great insight to their experience running the cluster in production over a period of time. Mixed feelings about having committed to the cluster.
- Quebec techie folks are very nice, and love to explore ideas (I suspect this is true of most techie folks coming to a conference). Had a few conversations about scaling MySQL, and others about replication, performance tuning, what's happening with Oracle and InnoDB, MySQL certification, cluster and more
- Zak Greant's session on Copyright, Contracts, Licenses and more was a good session for anyone that deals with software from a consumer or producer angle.
- If Rasmus Lerdorf is speaking at a PHP conference, don't schedule other sessions during his. Make his a keynote or something so the other presenters at that slot don't have to compete (glad it wasn't me in that slot).
Just a few highlights, was a great conference and trip.
Posted by mike at March 31, 2006 11:27 PM
Hard Drive Recovery Group offers hard disk data recovery services for RAID, laptops and servers. Complete clean room and hard drive repair service.Trackback Pings
TrackBack URL for this entry:
http://mike.kruckenberg.com/mt/mt-tb.cgi/806