Blog
Your Code, Your Community, Your Cloud… Project Kenai
Following the opening keynote announcement about Kenai I ventured into a talk on Project Kenai . With today’s economy, the drive is towards efficiency is certainly a key consideration, it was quoted that dedicated hosting servers only run at 30% efficiency.
Read moreEverybody is talking About Clouds
From the opening keynote at CommunityOne East we begin with Everybody is talking About Clouds. It’s difficult to get a good definition, the opening cloud definition today was Software/Platform/Storage/Database/Infrastructure as a service.
Read moreCommunityOne East – An open developer conference
With an opening video from thru-you.com – an individual taking random you-tube video and producing video mashup’s, the CommunityOne East conference in New York, NY beings. The opening introduction was by Chief Sustainability Officer Dave Douglas.
Read moreHurting the little guy?
Today I come back from the dentist, if that wasn’t bad enough news, I get an email from Google AdWords titled Your Google AdWords Approval Status. In the email, all my AdWords campaigns are now disapproved, because of:
Read moreUnderstanding the various MySQL Products & Variants
The MySQL marketplace today is far more complex then simply choosing between a particular version of MySQL that Sun/MySQL produces. The MySQL server product in general is released under the GNU General Public License (GPL) v2 , however you should carefully review the MySQL Legal Policies {#s0rl} as a number of exceptions and different license agreements operate for companion tools such as MySQL Cluster, MySQL client libraries and documentation for example.
Read moreBeginner CSV Engine issues
I’ve just started using the CSV engine for a practical application and I’ve come across a few subtle and unexpected issues/limitations. First, you can’t create any columns in your CSV table nullable.
Read moreInfobright Community Edition(ICE) – It’s Free
The March NY MySQL Meetup featured a presentation from Infobright , a data warehousing solution built on the MySQL Product. With a pitch of “Simplicity, Scalability and low TCO” I became more impressed with the capability to delivery on these as the presentation proceeded.
Read moreIdentifying Bad Memory
I was having problems recently with a dedicated production server, that runs my MySQL Server and a number of websites. It’s most annoying when your system crashes without any reporting in /var/log/messages
Read moreTesting your system
I have raised this specific topic 3 times this week alone, twice in a MySQL setting. The fundamental philosophy of testing is NOT to verify features of your product that work, it is to BREAK your system.
Read moreConfiguration management concepts for database objects
Correctly managing your MySQL database objects such as schemas, tables, indexes, base data etc, is critical to the success of a 24×7 online website. I rarely encounter a robust working solution as part of my consulting so I would like to share my experience in identifying the best practices you should be adopting whether your an existing organization or just an individual with a simple website.
Read morePlanet MySQL at a new URL
Did anybody notice that http://planetmysql.org now redirects to http://planet.mysql.com ? Curious to know the reason why, perhaps an official MySQL person can give us some details. Also it’s a 302 redirect, not a 301 redirect, interesting?
Read moreEliminating unnecessary internal temporary tables
I can’t stress enough that people look at SQL statements that are being executed against your production MySQL database, and you optimize queries when you can. Often it’s the improvement to the large number of similar queries executed that can optimize resources.
Read moreAnnouncing “MySQL Essentials” Training
Are you having problems getting up to speed on MySQL? Are you asking yourself “Is there a hands-on training course we can send a developer/system admin to learn MySQL?”. In response, at 42SQL we have put together two new training courses, MySQL Essentials and MySQL Operations.
Read more