As Tomas announced in his keynote at MySQL Connect 2013, we are
working on a brand new product called MySQL Fabric. Along with
this release of MySQL Fabric, we are releasing Connector/J 5.1.26
with Fabric support on labs.mysql.com. This is an alpha-quality
release that adds support for scalability features in MySQL
Fabric. Sharding and read/write splitting are the initial
features supported by Connector/J.
In a setup involving read/write splitting or customized sharding,
we generally have to duplicate knowledge of this configuration in
the client applications. This is done in connection strings
specified in configuration files or directly in code. With MySQL
Fabric, we can express our system-wide configuration of database
servers in a way that it can be accessed by client applications.
In cases where this needs to change (and it always does..), the
configurations affecting client applications no longer need to be
changed. The connector will …
Want to learn to develop next generation web applications on MySQL using languages such as Java and PHP; take the MySQL for Developers course. In this course you will learn to:
- Use MySQL tools to connect to databases.
- Examine database structure and contents.
- Generate database structure diagrams.
- Execute complex queries.
- Manipulate numeric, text, spatial and temporal data.
- Execute complex subqueries and joins.
You can take this 5-day instructor-led course as a:
- Live-virtual event: Take this course from your desk - no travel required. Choose from a wide selection of events on the schedule to suit different time-zones.
- In-class event: Travel to an education …
ConFoo is currently looking for web professionals with deep understanding of PHP, Java, Ruby, Python, DotNet, HTML5, Databases, Cloud Computing, Security and Mobile development to share their skills and experience at the next ConFoo. Submit your proposals between August 26th and September 22nd.
ConFoo is a conference for developers that has built a reputation as a prime destination for exploring new technologies, diving deeper into familiar topics, and experiencing the best of community and culture.
- ConFoo 2014 will be hosted on February 26-28 in Montreal, at the Hilton Bonaventure Hotel.
- We take good care of our speakers by covering most expenses including travel, accommodation, lunch, full conference ticket, etc.
- Presentations are 35min + 10min for questions, …
The MySQL Connect content catalog is published, and I’ll be leading a hands-on lab on MySQL Enterprise Features in Practice [HOL9787]. If you have wondered how to get the most out of the features of MySQL Enterprise subscriptions – whether you are an existing Enterprise customer or not – this lab is for you. We’ll help you understand the benefits of the various components of the MySQL Enterprise subscription as you install, configure, demonstrate and use the …
[Read more]Over three years ago, I noticed that there was no STATUS counter for COM_PING commands – something that is useful for ensuring proper configuration of JDBC connection pools. Mark Leith even provided a patch, but it’s never been incorporated. With the advances PERFORMANCE_SCHEMA makes in MySQL 5.6, that’s OK – a STATUS counter becomes somewhat redundant:
mysql> SELECT SUM(count_star) as pings
-> FROM events_statements_summary_global_by_event_name
-> WHERE event_name = 'statement/com/Ping';
+-------+
| pings |
+-------+
| 12 |
+-------+
1 row in set (0.02 sec)
Not only does PERFORMANCE_SCHEMA provide capabilities which
mirror the STATUS counters, it really goes well beyond what’s
capable there. A global counter is interesting, but …
MySQL Connector/J 5.1.26, a maintenance release of the production
5.1 branch has been released. Connector/J is the Type-IV
pure-Java JDBC driver for MySQL. Version 5.1.26 is suitable for
use with many MySQL server versions, including 4.1, 5.0, 5.1,
5.4, 5.5 and 5.6. It is already available for download on the My
Oracle Support (MOS) website. The eDelivery download will be
available on it's own regular schedule. As always, we recommend
that you check the "CHANGES" file in the download archive to be
aware of changes in behavior that might affect your
application.
MySQL Connector/J 5.1.26 includes the following general bug fixes
and improvements, also available in more detail here
Functionality Added or Changed:
- Added a toString() method to the PreparedStatementWrapper class to help debug prepared …
” One of the biggest challenges with any project of such a long duration is coping with change. There are many aspects to coping with change, including changes in requirements, changes in technology, vendor stability, changes in staffing and so on”–Jon Brumfitt. On May 14, 2009, the European Space Agency launched an Arianne 5 rocket [...]
Idle connections can cause problems both at the application side, increasing the risk of connection timeouts for applications where persistent connections are used, and the server side, where resources remain allocated to idle connections. Any application with persistent connections, such as a JDBC application using a connection pool, will have periods where connections are idle – but it’s good to know how much time is spent idle. Too much idle time might mean connections pools configured to allow too many connections to sit idle in a connection pool, or not properly doing connection pool maintenance.
PERFORMANCE_SCHEMA in MySQL 5.6 makes it trivial to measure
absolute time spent waiting. This will show total, average
and maximum idle times by account:
mysql> SELECT …[Read more]
This is MySQL's Bad Idea #573 (after #384, which I've blogged about before) I've just had a terrible experience with a bug report from the jOOQ User Group, related to escaping of backslashes in string literals in MySQL. First, I thought to myself, whatever. SQL doesn't escape backslashes. The only escape character within a string … Continue reading MySQL Bad Idea #573 →
This article is part of a series. You might also like: 10 More Common Mistakes Java Developers Make when Writing SQLYet Another 10 Common Mistakes Java Developers Make When Writing SQL Java developers mix object-oriented thinking with imperative thinking, depending on their levels of: Skill (anyone can code imperatively)Dogma (some use the "Pattern-Pattern", i.e. the … Continue reading 10 Common Mistakes Java Developers Make when Writing SQL →