[...] MySQL: An Introduction for Oracle DBAs http://patrickhurley.wordpress.com/mysql-for-oracle-dba/ [...]

To launch an app there was a tried and true process. The process in the past was to rent a server in a managed hosting facility. Get a few more as you grow, then build a model showing that it would be cheaper to get your own cage and finance servers. If the app continues to grow, build a model showing it would cost cheaper and allow for more rapid growth if you built your own datacenter after multiple requests for more power, space and moving to larger spaces with more power.  Now we have a new Step. If Step 1 is managed hosting then Step 0 is putting your application in the cloud i.e. Amazon's EC2.
When an app grows cost grows at a multiple in EC2. To offset these costs, take periodic looks at your architecture to see if there is anything you can do to reduce overall cost. Let's look at a tier that is easy to scale. Let's look at application memory caching on Memcache as an example to illustrate reducing cost.
…

The SELF 2012 Preliminary Schedule is now available.

Just 43 days left until SELF and it looks like a great MySQL Lineup! A wide array of presenters from the MySQL community will be present, including Oracle Engineers.
On top of that.... You can get in for FREE if you wanted too!
Register here

Join us and support Linux, MySQL and open source technologies over all.


SELECT COUNT(sessions) FROM self_mysql_speakers WHERE year=2012;
20+ rows

Any person with half a brain would see from the error messages below that the MySQL server is not operating optimally, or more specifically the MySQL upgrade has not completely successfully and let users can go happily use the website. It amazing me when web hosting providers tell their paying client that an upgrade has been performed yet they did not have the intelligence to actually look at the error log for confirmation. Got a mysql> prompt, it’s all good. One of the first things I check is the error log.

When will people learn the MySQL error log is a valuable resource both for what it contains, and what it should not contain.

120426 17:36:00 [Note] /usr/libexec/mysqld: Shutdown complete

120426 17:36:00 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120426 17:36:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120426 17:36:00 [Note] Plugin 'FEDERATED' is disabled.
/usr/libexec/mysqld: …

As most people still do I learned to read using books. WhooHoo!

Books are nice. Besides reading them they are also a nice decoration on your shelf. There is a brilliant TED talk by Chip Kidd on this subject.

But sometimes books have drawbacks. This is where I have to start the comparison with vinyl records (Yes, you're still reading a database oriented blog). Vinyl records look nice and are still being sold and yes I also still use them. The drawback is that car dealers start to look puzzeled if you ask them if your new multimedia system in your car is able to play your old Led Zeppelin records. The market for portable record players is small, and that's for a good reason.

The problem with books about databases is that they get old very soon. …

In the last few weeks I’ve been caught off guard by the number of people who’ve told me they have been evaluating Percona XtraDB Cluster (link), and even more surprised at the projects they’re considering it for. Yesterday alone I spoke to several people who have been evaluating it for large, mission-critical enterprise deployments. Some new, some to replace existing systems that use standard MySQL replication. What was interesting is that some people said they’ve been putting it through its paces for months — before we even released it as GA.

Another person said he was evaluating it and tried a bunch of things like killing nodes, and it “just worked.” He sounded like he’d been suspicious: had it REALLY worked? But then, on further investigation, he was able to confirm that yes, it had just worked. The node went away; the cluster as a whole …

Last day of Collaborate 2012 and Scott Spendolini, Sumneva, gave a great presentation on APEX. Only caught the beginning Jan Visser’s Perl presentation because of the distance to the Luxor from the Mandalay South Conference Center and anticipated queuing time for checkout.

We can now look forward to Collaborate 2013 in Denver, Colorado.

Back to observing and working with code, here’s a nice article from MacWorld on how you set up a WebDAV on the Mac. While I’m mentioning Mac OS X and development, there’s still no firm upgrade window for the missing text editing tool – TextMate, and WWDC 2012 tickets sold …

MySQL Connect will be held this September before Oracle Open World and time is running out for you to submit your presentation. There are tracks on Application Development, Architecture and Design, Cloud Computing, Database Administration, High Availability, and Performance & Scaling.

You’ll need between 15-40 slides for an hour presentation (sixty minute session, leave ten or so minutes for Q&A). The submission software lets you stop and save before submission, just in case you need to do some research while create your submission. And once you submit, you can go back and edit so that you can include the latest and greatest information. But May 6th is the last day submissions will be accepted.

…

This has been an interesting week. I have been told over the past year that the Collaborate conference was more Oracle focused and little interest in MySQL. While the conference is Oracle focused, MySQL and open source technologies do have people's interest. I was informed that the MySQL sessions all had larger attendees than last year overall. I did meet some great people here and a big thank you to the IOUG, OAUG, QUEST for this event.

Some typical comments I heard from attendees about MySQL while at Collaborate:
“SQL Server just does not have the throughput, I know MySQL can do it.”
“Depending on what your application is, MySQL is just better and faster.”

The biggest hurdle for MySQL this week was how to pronounce it: “MySQL” …

Following a brief list of what I have found more interesting during the last two weeks. Up to now, April has being a great month for MySQL. MySQL Conference  – Percona conference 2012 The Percona MySQL 2012 conference, has seen the MySQL community, interact as it was doing many years ago, re-creating the dynamic and creative [...]