This TOTD (Tip Of The Day) shows how to create a Persistence Unit (PU) for a MySQL database using NetBeans IDE. This PU can then be used in any of Java EE artifacts (JSP, Servlet, EJB, ...) for database interaction.

1. In NetBeans IDE, create a new project
   1. Create a new NetBeans Web project and enter the values ("Autocomplete") as shown:
      
      
      
      and click on "Next".
   2. Choose GlassFish v2 as the deployment server and then click on "Finish".
2. Set up the database
   1. Start the database as:
      
      

      ~ >sudo mysqld_safe --user root Password:<YOUR …

Brian Aker was at the Sun booth today, in a premier slot, where there must have been about 50-60 people, huddled around, to listen to him talk about Drizzle. The project motivations, what’s behind it, what its not aimed to be, and so much more. Check the video out (21 minutes long)!

The Birds of a Feather (BoF) session in the night, was well attended, and there was lots of large discussion on what’s next. I think the important message to take away is that Drizzle doesn’t aim to be MySQL, and there are no plans to “merge” things back (fixes where the code-base is shared though, might make sense). Its also important that the design is for the future, i.e. multi-core machines. It was great to see Brian say that this …

Some likely and unlikely candidates snap up SourceForge Community Choice Awards READ MORE

As there were many requests for Debian binary packages in our announcement of MySQL releases with custom patchsets, we decided to play with it and built .deb, which you can find there:
http://www.mysqlperformanceblog.com/mysql/debian/

You can also add the following repositories into your sources.list:

deb http://mysqlperformanceblog.com/mysql/debian/5.0/ binary-amd64/
deb http://mysqlperformanceblog.com/mysql/debian/5.0/ source/
deb http://mysqlperformanceblog.com/mysql/debian/5.1/ binary-amd64/
deb http://mysqlperformanceblog.com/mysql/debian/5.1/ source/

Also we have generic RPMs for x86-64 architecture:
…

This DBA course day is in part based on info from Peter Zaitsev's earlier explorations (thanks Peter), and of course new insights from the High Performance MySQL book (there's a lot of Baron in there, all credit to his great work!), wisdom from Mark Callaghan, with my own teach approach and style thrown in to turn it into a good yet fun educational day!

Just like with other topics, extending this to a full day allows the issue to be explored much better rather than getting skimmed over as a small part of a much bigger course. After all, if you understand the tool, how it does things and why, you can utilise it more optimally. The skimming …

I remember the day I got "the" call. It was in January, 2001 and I was working as a part of an engineering team developing an online, web-based customer billing system for Louisville Gas & Electric. The app was being developed using VB.net on a Windows DNA (distributed network app) architecture that would eventually be served up under IIS. Cutting edge stuff for the day, ancient by today's standards. The call came from my current boss, Robin Schumacher, who wanted me to join him in something call "Product Management" with Embarcadero Technologies. Overall the move has been a good one, but to be completely honest, I miss getting elbows deep in technical details. Along the way, I have had the opportunity to work with some of the best database management tools on the market. I was fortunate to manage Embarcadero's flagship Rapid SQL and DBArtisan products during my 4+ year tenure and had the great …

The presentation about MySQL Proxy at OSCON 2008 is over.

Here are the slides.

Thanks to my co-presenter Ronald Bradford and to all the participants. If you have more questions about the session, please use this blog's comments.

Good news for everyone interested in MySQL looking to connect to fellow MySQL'ers and all opensource enthusiasts! We are organizing MySQL Camp in Bangalore on coming 29th July 2008. This is a free event open to all, so invite your friends and every one... Here is the details ... I have been circulating the following contents to every one so that it will be easier for them to forward by e-mail. Feel free to forward these contents:

What : MySQL Camp With Kaj Arno

When : 29th July 2009, 4PM - 7PM

Where : Hi-Tech Seminar Hall,
DES Block (Dept of Electrical Science)
M S Ramaiah Institute of Technology
Near MS Ramaiah hospital
MSR Nagar, Bangalore - 560054

Location Map: http://tinyurl.com/msrit-bangalore

RSVPs and Details are …

Disclosure: I am on the advisory board for MindTouch.

Double disclosure: I really, really like the latest release of MindTouch Deki (formerly "Deki Wiki").

MindTouch has always thought that a wiki should be about more than simply creating basic web pages. With its new "Kilen Woods" release, the company has significantly bent the rules as to what constitutes a wiki, and just which data sources can feed into a wiki.

LinkedIn? Yep. Salesforce.com? Sure. SugarCRM. Uh-huh.

MindTouch Deki enables businesses to connect and mashup the growing number of application and data silos that exist across an enterprise - including legacy systems, CRM and ERP applications, databases, and Web 2.0 applications....For example, MindTouch Deki can visualize content from a Microsoft SQL Server or Microsoft Access databases and mash it up with …

Today I presented with Giuseppe Maxia of Sun Microsystems Inc at OSCON 08 on “MySQL Proxy: From Architecture to Implementation”. I was surprised to find that MySQL has a strong showing with a number of presentations this week.

Our talk covered the basics of MySQL Proxy, what’s coming in future features, and a number of examples of how I have used Proxy in consulting engagements to improve the information retrieval particularly for identifying performance problems.

Download Presentations Slides