As noted in a previous post, MySQL Connector/Java supports multi-master replication topographies as of version 5.1.27, allowing you to scale read load to slaves while directing write traffic to multi-master (or replication ring) servers. The new release of version 5.1.28 builds upon this, allowing live management of replication host (single or multi-master) topographies. This parallels functionality that has long existed for load-balanced connections, and enables users to add or remove hosts – or now promote slaves – for Java applications without requiring application restart. This post aims to …[Read more]
We are announcing the new MySQL for Developers course. This training:
- Takes advantage of both SQL and NoSQL
- Shows you how to plan, design and implement applications
- Brings you realistic examples, interactive instruction and hands-on exercises using Java and PHP
- Covers MySQL 5.6 features including optimizer improvements
- Helps you prepare for the MySQL 5.6 Developer certification.
You can take this course as a:
- Live-virtual event: Take this course from your own office; no travel required. You can choose from a selection of events on the …
MySQL Connector/Java has long had support for replication-aware deployment, allowing a single logical Connection object to effectively “pool” connections to both a master and (potentially multiple) slaves. This allowed scale-out of read load by distribution of read traffic to slaves, while routing write load to the master. The JDBC specification provides a nice hook to know what’s read-only traffic – Connection.setReadOnly(). When a boolean value of true is passed, a ReplicationConnection will route further commands a selected slave instance, while values of false trigger routing to the master. This is sufficient for many simple replication topographies, but not all – most notably, it …[Read more]
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, …
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
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 [...]