If you're using Innodb and transactions with JDBC and your MySQL application, you should know about a couple of debugging features that made their way into MySQL Connector/J 5.1.15.
First, by adding "includeThreadNamesAsStatementComment=true" to your JDBC URL, you will get the current Java thread's name that is executing SQL on a given connection as a statement comment, visible in SHOW FULL PROCESSLIST output:
mysql> show full processlist; +------+------+-----------------+------+---------+------+----------+------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+------+-----------------+------+---------+------+----------+------------------------------------------------------+ ...[Read more...]
This is your Developer Week in Review, I'm Casey Kasem. Our first letter comes from a software developer in New England who writes, "Dear Casey. My wife just got accepted into the Experimental Psych doctoral program at UNH, and I'd like you to play something appropriate for the occasion." Well, going out especially for you, here's "I'll be Proofreading Your Papers for the Next Five Years, 'Cause I'll Never Split (Our Infinitive)" (Seriously, congratulations Bonnie!)
What's the matter, pal? You say you had your heart set on going to Google I/O, but the tickets sold out in[Read more...]
VMware grows 41%. Evidence of Java infringement disputed. And more.
# VMware announced full year revenue growth of 41% to $2.9bn.
# Alleged evidence of infringing Java code in Android disputed.
# Oracle nominated SouJava, the Brazilian Java User Group, to a seat in the JCP Executive Committee.
# The Document Foundation launched LibreOffice 3.3.
# JasperSoft[Read more...]
Amazon's EC2 and its sister S3 service have been indisputable leaders in IaaS for a long while now and GlassFish and more generally J2EE/JavaEE took advantage of it starting in 2008 (see here and here), with documented how-to's and significant production references.
Just yesterday, AWS's Evangelist Jeff Barr announced[Read more...]
For a few years, I've tried to recap here some events I've found notable over the past year and offering some guesses on what might be ahead of us. I'm somewhat late on these things this year, due to being busy with other stuff, but I didn't want to break the tradition, no matter how silly my wrong guesses might seem later. And again, others have covered generals, so I'll try to focus on specifics, in particular as they relate to what I do. For a look at what we achieved for Habbo, see my recap post on the Sulake blog.
This time last year Oracle still had not successfully completed the Sun acquisition due to some EC silliness, but that finally happened over the 2010. It seems to be[Read more...]
Topics for this podcast:
*Oracle, Java, the Apache Software Foundation and open source
*An update on some open source database and data management players
*CorraTech grows with support for open source application alternatives
*Red Hat-Makara acquisition analysis and impact
*Linux kernel report shows strong support, but what now for Novell?
Rapid Application Development (RAD) is a way of developing computer software applications with less effort than the traditional means.
RAD tools focus on providing code generation and automated testing capabilities with the use of convention over configuration to provide a streamlined workflow to create applications.
Even with the most advanced and easiest to use RAD tools, there are times which the traditional enterprise and the business software development vendors which are having their own implementations and in-house built frameworks are continuously refusing to adopt them.
Most of the misconceptions on the RAD are based on FUD (Fear, Uncertainty[Read more...]
If you live in the U.S., this is the week to gorge on turkey. I wondered out loud last night to my wife if Thanksgiving is the day of the year when the most people eat the same meal. Can any of our overseas readers add to the conversation? Is there a holiday in your country where everyone eats pretty much the same thing? Anyway, before American brains shut down from an overdose of stuffing, here's some developer news you can use.
The Java language has continued to evolve over the years, adding features such as Generics. There's an ambitious wishlist of things that developers would like to see in Java 7, but apparently not enough time to do it all and still get a timely release out. As a result, the JCP has decided to forego[Read more...]
Here's what's new for the trendy developer this week:
Last week, it looked like Apple was all "You're not welcome here, Java." In the changeable world that is Jobsland, this week Apple was offering to marry the language, reiterating their support for Java in OS X, and indicating that they would be supplying code and resources to the OpenJDK project.
As I've noted before, this makes sense for Apple, because it gets them out of the JVM business, and makes Oracle the one-stop shopping solution for all your JDK and JRE needs. It also means that the Mac can be added as a regression-tested target for a new version of Java, hopefully[Read more...]
The Apache Software Foundation’s latest statement on the Java Community Process highlights continued dissatisfaction and dissent from Oracle’s stewardship and involvement in open source software.
This comes after some ups and downs for Oracle and its oversight of Java and other open source software that was previously under the auspices of Sun Microsystems. Oracle started off on a rough path when it sued Google over its implementation of Java in Android without preemptively or clearly stating that it was not attacking open source. At about the same time, it let OpenSolaris die a slow, somewhat confusing[Read more...]
JCP election results. Funding for Acquia and Continuent. Fedora 14. And more.
# The Java Community Process election results are in.
# Continuent appointed Robert Hodges CEO and confirmed details of $5m funding from Aura Capital.
# Red Hat announced the[Read more...]
Microsoft sues Motorola. Oracle says no to LibreOffice. Time to fork Java? And more.
# Microsoft is suing Motorola over alleged Android patent infringements.
# Oracle confirmed to SJVN that it will not be working with the Document Foundation on LibreOffice.
# Sean Michael Kerner reported that Red Hat has settled an alleged patent infringement case with IP firm Acacia Research.
# Greg Luck asked if it[Read more...]
Oracle OpenWorld 2010 is over! While I had to leave early Tuesday (the paying job takes precedence over the volunteer job), there are many things to talk about that happened while I was at OpenWorld this year. I’ll attempt to cover a few of them in this posting.
Saturday Night, the ODTUG Board and YCC staff got together to discuss our plans and obligations for the week. With Sunday User Forum, MySQL Sunday, and Oracle Develop to attend to during the week, along with many other meetings, this was an important start to the week. It was nice for everyone to see everyone again, and to recharge and energize for the tasks ahead during the week. Below is a picture of fellow Board Members Barbara Morris and Monty Latiolais at the dinner at Annabelle’s Bar and Bistro.[Read more...]
Oracle launches Unbreakable Kernel, updates MySQL and Java plans. And more.
# Oracle launched its Unbreakable Enterprise Kernel.
# Oracle announced the release candidate of MySQL 5.5.
# Novell and SAP have collaborated on SUSE Linux Enterprise Server for SAP applications.
# Mozilla[Read more...]
I'm the boards of two companies (Pentaho, Revolution Analytics) that are starting to see a lot of customer traction around Big Data. More and more companies in media, pharma, retail and finance are doing advanced analysis, reporting, graphing, etc with massive data sets. It made me wonder what other areas of the technology stack might evolve with the trend towards Big Data. Obviously, there's new middleware layers like Hadoop and Map Reduce, and we're also seeing the emergence of[Read more...]
We continue to see more evidence of the themes we discuss in our latest CAOS special report, Seeding the Clouds, which examines the open source software used in cloud computing, the vendors backing open source, the cloud providers using it and the impact on the industry.
First, as usual, we are seeing consistencies between our own research — which indicates open source is a huge part of today’s cloud computing offerings from major providers like Amazon, Google, Rackspace, Terremark and VMware — and that of code analysis and management vendor Black Duck. In its analysis of code that runs the cloud, Black Duck also found a preponderance of open source pieces, in many cases the same projects we profile in our report.
Indeed, open source software is an[Read more...]
Have you seen error messages similar to the following:
Communications link failure – Last packet sent to the server was X ms ago.
Generally speaking, this error suggests that the network connection has been closed. There can be several root causes:
MySQL Connector/J has a useful feature which executes a lightweight ping against a server (or, in the case of load-balanced connections, all active pooled internal connections that are retained) to validate the connection. As you might guess, this feature is useful for Java apps which use connection pools, so that the pool can validate the connection. Depending on your connection pool and configuration, this can be done at different times:
So, if you want to use this magic light-weight ping process, here’s how you do it:
Specifying a “validation query” in your connection pool that starts with “/* ping */” _exactly_ will cause the
There are many questions that arise out of Oracle’s copyright and patent infringement complaint against Google regarding its use of Java in Android. There are several things that make the suit significant to the entire industry: it centers not just on software copyright, but also software patents (an increasingly and hotly debated issue), the quickly-expanding smartphone market and open source software. The first question is: what is Oracle doing?
Many are speculating that this is simply an effort to further and more effectively monetize Java, a storied program language that has move more toward openness and survived several supposed death sentences as newer languages arrived. Still, with all of the open source parts — GlassFish application server, MySQL database, OpenOffice.org suite — is Java the most significant to Oracle? It may be, but regardless of what[Read more...]
Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or master-master replication deployments, but until version 5.1.13, managing such deployments frequently required a service outage to redeploy a new configuration. Given that ease of scaling out by adding additional MySQL Cluster (server) instances is a key element in that product offering, which is also naturally targeted at deployments with very strict availability requirements, we had to add support for online changes of this nature. It’s also critical for online upgrades – the other option is to take a MySQL Cluster server instance down hard, which loses any in-process transactions and generates application exceptions, if any application is trying to use that particular server instance.
Mark Matthews[Read more...]
In a previous blog post, I wrote about Connector/J’s failover policies, I described three triggers which cause Connector/J to re-balance (potentially selecting a new physical connection to another host):
Those conditions fit most needs very well, but there are situations where people are running with[Read more...]
SugarCRM. Funding for EnterpriseDB and Morphlabs. Even more core. And more
# OStatic asked whether SugarCRM has violated open source principles.
# Larry Augustin clarified SugarCRM’s approach to open source and openness.
# Savio Rodrigues advised anyone considering SugarCRM not to get hung-up on source code availability.
# EnterpriseDB has reportedly raised $7.5m of a planned $12m round of funding.
There are signals of continued problems and dysfunction — namely lack of support, organization and communication — in the OpenSolaris community. This follows on a deterioration of the OS leadership and support since Oracle bought Sun Microsystems, including the elimination of OpenSolaris CDs, one of the things that made the open source version of Solaris more like Linux.
We had speculated on the fate of Sun open source software under Oracle and while we acknowledged Oracle’s participation in, contribution and commitment to and opportunity from open source software, we[Read more...]
Shortly after I wrote my last post regarding some advanced Connector/J load-balancing properties, Anirudh published a post describing configuration of RHEL LVS for load-balancing and failover of MySQL Cluster SQL nodes. It’s an interesting post, and I admit I know very little about RHEL LVS, but it reminded me of problems I experienced when trying to set up load-balanced ColdFusion(!) servers at my last job, years back. We ended up with a nice hardware load-balancer sitting in front of multiple ColdFusion web servers. The problems we found were that our application depended upon session state, which was stored (of course) on a single web server. The load-balancer allowed us to define sticky sessions, which is what we did, but it cost us.
Connector/J provides a useful load-balancing implementation for Cluster or multi-master deployments. As of Connector/J 5.1.12, this same implementation is used under the hood for balancing load between read-only slaves with ReplicationDriver. When trying to balance workload between multiple servers, though, the driver has to decide when it’s safe to swap servers – doing so in the middle of a transaction would not make applications very happy. Many of the same principles which apply to autoReconnect also apply here – you don’t want to lose important state information.
As a result, Connector/J will only try to pick a new server when one of the following happen:
Several things to think about in the next 10 days leading up to Kaleidoscope.
1. The Marriott Wardman Park is out of rooms. If you’re attending and haven’t reserved a room yet, you may get lucky with a cancellation, but there are several hotels on the Metro line that should have openings. The conference and location is very popular, and while I wish we could accommodate everyone, it’s not going to be possible. Here’s a good suggestion: when next year’s conference dates and location are announced, register and reserve your room as soon as possible (hint – these announcements will be made at our general session on Monday, June 28 starting at 8:30 AM).
2. The[Read more...]