Showing entries 31 to 40 of 322
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: Java (reset)
Live reconfiguration of replication topography in Connector/Java

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]
MySQL, Best of Both Worlds with SQL and NoSQL

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 …
[Read more]
Multi-master support in MySQL Connector/Java

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]
MySQL Connector/J with Fabric Support

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 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 …

[Read more]
Develop Next Generation Web Applications with MySQL

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 …
[Read more]
ConFoo: The conference for web developers is looking for speakers.

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, …
[Read more]
Speaking at MySQL Connect

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]
Practical P_S: Fixing gaps in GLOBAL STATUS

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, …

[Read more]
MySQL Connector/J 5.1.26 has been released

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 …
[Read more]
Big Data from Space: the “Herschel” telescope.

” 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 [...]

Showing entries 31 to 40 of 322
« 10 Newer Entries | 10 Older Entries »