I registered yesterday for Oracle OpenWorld 2013, and I’ll look forward to seeing friends there. Having worked in the Oracle 12c beta for a year, I’ll be interested in the presentations. Also, hearing more about Java 7 at JavaOne. On the downside, I’m missing MySQL Connect this year.

Cloud computing offers many possibilities, and container and pluggable databases are a great solution. We’ve two new acronyms with the Oracle 12c release. A containerized database is a CDB, and a pluggable database is a PDB. I’m looking forward to seeing more about the provisioning of PDBs during the conference. If you’re new to the changes, check out CDBs and PDBs in Chapter 17 in the …

What programming languages and platforms do you use for large-scale projects in your organization?

If something is missing from the list please leave a comment and share your story. Thanks!

Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.

The post Poll: What programming languages and platforms do you use? appeared first on MySQL Performance Blog.

“We went down the path of building Oracle NoSQL database because of explicit request from some of our largest Oracle Berkeley DB installations that wanted to move away from maintaining home grown sharding implementations and very much wanted an out of box technology that can replicate the robustness of what they had built “out of [...]

Many MySQL users are familiar with using slow query logs and tools such as mysqldumpslow to identify poor-performing SQL commands, and MySQL 5.6 introduces new powerful tools in PERFORMANCE_SCHEMA.  Both allow you to identify the date/time and the user account from which the command was issued, which is helpful – but if you’re using MySQL Enterprise Monitor (MEM), you can immediately identify the actual line of code responsible for the SQL command in question.  This happens to be one of my favorite and powerful features of MEM, but it’s frequently overlooked by new and experienced MEM users alike, so I’m writing the post to highlight it.

MySQL Enterprise Monitor, of course, is a commercial product that’s part of the MySQL Enterprise subscription.  But it’s freely-available under 30-day trial terms for evaluation from Oracle Software Delivery Cloud – if …

The MySQL for Developers course teaches you the knowledge, skills, tools and issues involved in writing applications with the MySQL database server. It forms the core of the MySQL Developer learning path.

During this 5-day course, you will perform lab work with Java and PHP, connecting to MySQL databases and executing queries and stored routines. Enrolling in this course will simultaneoursly help you prepare for the Oracle Certified Professional, MySQL Developer certification.

You can take this instructor-led course as a:

• Live-virtual event: Take this class live, from your own desk. No travel required. You can choose from a wide selection of events on the schedule to suit different timezones.
• In-class event: …

MySQL Connector/J 5.1.25 has been released, and is available in Community and Enterprise flavors on dev.mysql.com and My Oracle Support, respectively.  I’ve already noted the addition of support for connection attributes for MySQL 5.6 – 5.1.25 adds this functionality.  This release also includes a fix for Bug#68733, which caused the special light-weight ping operation to execute only against the master and currently-selected slave, rather than …

Get the most out of your MySQL environment by learning to develop your new applications cost-effectively using MySQL with different languages such as Java and PHP.

The MySQL for Developers course is a 5 day, live, instructor-led course where you learn to:

• Use MySQL tools to connect to databases.
• Examine database structure and contents.
• Generate database structure diagrams.
• Execute complex queries and stored routines.
• Manipulate numeric, text, spatial and temporal data.
• Execute complex subqueries and joins.

You can take this course as a:

• Live-Virtual Event: Take this course from your own desk - no travel required. Choose from one of the many events already on the schedule to suit different timezones. Delivery is …

Introduced in 5.6.6, connection attributes haven’t been mentioned in any of the many overviews of new 5.6 features that I’ve seen.  You might not have even known they exist – there’s not really a “feature page” in the documentation that tells you what this is all about.  The best documentation is found in the description of the PERFORMANCE_SCHEMA tables which expose these connection attributes:

As of MySQL 5.6.6, application programs can provide key/value connection attributes to be passed to the server at connect time, using the mysql_options() and mysql_options4() C API functions. The Performance …

The MariaDB Java Client 1.1.0 has been released. You can download it here.

This version focused on fixing all known database metadata bugs and ConnnectorJ incompatibilities. Specific fixes include:

• Consistent, compatible with ConnectorJ handling of JDBC catalogs vs schemas vs databases
• Implementation of several missing methods in DatabaseMetaData
• Better handling of statement timeouts
• OSGi-specific entries have been added to MANIFEST.MF so it can be used in OSGi environments
• Added support for dumpQueriesOnException=true in the JDBC URL
• Added support for IPv6 addresses in the connector
• Added SSL support
• and more…

See the Release Notes and …

The authentic MySQL for Developers course will introduce you to tools used by MySQL development professionals and you get the opportunity to work through examples specific to Java and PHP development cases.

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 live-instructor course via these two delivery methods:

• Live-Virtual Class: Take this class from your own desk by choosing from the many events already on the schedule.
• In-Class: Travel to a training center to take …