As mentioned in my summary of MySQL announcements at Oracle OpenWorld, we announced last Monday new MySQL Enterprise Certifications with Oracle Secure Backup and with a number of offerings within the Oracle Fusion Middleware product family.

Many Oracle customers use MySQL for their web-based, departmental and embedded applications. The MySQL Enterprise Oracle certifications make it faster and easier for them to deploy and manage MySQL within their existing environment.

Certified integrations between MySQL and other Oracle products include:

• Oracle Secure Backup: provides an integrated, easy-to-use centralized backup-to-tape management solution enabling users to secure their Oracle and MySQL database …

• AQL (aka push down join)
  Further improvements and refinements compared to 7.2.0 from April
• Index statistics
  A long over due feature, that aims to reduce(minimize) need of manual query tuning that previously has been essential for efficient SQL usage with ndb.
• memcache access support
• Active-Active replication enhancements
• Various internal limits has been increased
  - Max row-size now 14k (previously 8k)
  - Max no of columns in table now 512 (previously 128)
• Rebase to mysql-5.5 (7.2.1 is based on mysql-5.5.15)
• Improved support for geographically separated cluster
  (note: single cluster...i.e not using asynchronous replication)

Brief introduction to AQL (aka join pushdown)Basic concept is to evaluate joins down in data-nodes instead(in addition to) of in mysqld.
Ndb will examine query plan created by …

[...] material I didn’t get a chance to complete there. presentation slides demo code  MySQL Read the full post on Planet MySQL… Share [...]

As mentioned in my summary of MySQL announcements at Oracle OpenWorld, we announced last Monday new MySQL Enterprise Certifications with Oracle Secure Backup and with a number of offerings within the Oracle Fusion Middleware product family.

Many Oracle customers use MySQL for their web-based, departmental and embedded applications. The MySQL Enterprise Oracle certifications make it faster and easier for them to deploy and manage MySQL within their existing environment.

Certified integrations between MySQL and other Oracle products include:

• Oracle Secure Backup: provides an integrated, easy-to-use centralized backup-to-tape management solution enabling users to secure their Oracle and MySQL database backup …

In my last post I described the motivation for the new NDB$EPOCH conflict detection function in MySQL Cluster. This function detects when a row has been concurrently updated on two asynchronously replicating MySQL Cluster databases, and takes steps to keep the databases in alignment.

With NDB$EPOCH, conflicts are detected and handled on a row granularity, as opposed to column granularity, as this is the granularity of the epoch metadata used to detect conflicts. Dealing with conflicts on a …

Earlier today I asked on this blog and everywhere else people to fill in a simple survey of how do they use MySQL, which one and what should I focus on. I already have more than 30 answers (don’t stop answering, keep providing more) so I will have to publish the results and do something with them. But first I’ll let the survey run for at least a week Oh, and even though I write MySQL, this post is general about all MySQL variants (MariaDB, MySQL Cluster, … (not counting Drizzle)).
Now what is behind this survey? Well, I have a lot of stuff to do and MySQL is not my only responsibility. And I know that sometimes it can use some extra hands. Sometimes I get lucky and we have new beta packaged same day as it …

I’ve uploaded both the presentation materials and demo code used in my JavaOne and Silicon Valley Code Camp presentations. Since I ran out of time at JavaOne, I’ll be writing blog posts later this coming week to cover the material I didn’t get a chance to complete there.

• presentation slides
  

• demo code

UPDATE:  I’ve started adding posts fleshing out the presentation materials, which I will index below:

• Extension points – lifecycle …

I went to EuroBSDcon in Maarssen, the Netherlands. It was a great conference and I might write another blog about it.

I the conference bag there was a copy of the dutch Linux Magazine. The magazine is very nice and covers a broad range of topics.

One article about LogicalDOC caught my attention. The LogicalDOC software uses a MySQL database. and the magazine listed some SQL code about how to create the database user:
create user logicaldoc;
set password FOR logicaldoc@´%´=
PASSWORD('wachtwoord´);
grant all privileges on logical-
doc.*
to logicaldoc@´%´ identified by 
'wachtwoord´;
create database logicaldoc;
flush privileges;

These statements won't work as some of the quotes are wrong. But let's ignore that.


After executing the first line the grant is like …

This is not really a blog post. I just would like to know you opinion on state of MySQL at openSUSE and openSUSE Build Service. But I’m interested in your feedback even if you are not using openSUSE or even if you are not using packages I provide. As my TODO is quite long and I can’t do everything, I would like to know what should I pay the most attention to. Later I will publish a post about the current state of MySQL and how you can participate

Download PDF
Presentation

Learn how the experts would design and architect a MySQL system to able to scale seamlessly. This presentation covers the necessary principles including:

• System Architecture
• Data Availability
• Best Practices
• Being proactive
• Preparing for a disaster
• Planning for success

Presenter: Ronald Bradford

You can view the video from SF MySQL Meetup – September 2010. View …