Requirement 3 of the PCI DSS v1.2 is: “Protect Stored Cardholder Data” As vague as that sounds, the PCI DSS enumerates exactly what that covers: Data Element Storage Permitted Protection Required PCI DSS Req 3.4 Primary Account Number Yes Yes Yes Cardholder Name* Yes Yes No Service Code* Yes Yes No Expiration Date* Yes Yes [...]

This release of Workbench has shown some major improvements. Especially in looks and feel, so I want to thank the team for those improvements at this time. I would like to take the opportunity though to point out some short commings or inconsistencies – at least in my oppinion. These are not bugs per say – for those see the bug reporting system – but just things that make using WB not as much pleasure as it could be.

1.) Triggers: Why can’t the handling of triggers be consistent with the way MYSQL stores/handles triggers. Namely each trigger as its own entity. Currently triggers just roll together in the sample as shown below in an example that does nothing but is just used to describe the problem

– Trigger DDL Statements
DELIMITER $$

USE `test`$$CREATE DEFINER=`admin`@`%` TRIGGER `beforeinsert`
BEFORE INSERT On table1
FOR EACH ROW
…

At the UC 2010 I will have a session on MySQL Cluster Performance Tuning. This session will address a lot of the most common performance problems I see in my day to day job with Cluster. A small excerpt of the talk is below here and many other things will be addressed in the session (JOINs, schema optimization, batching, indexes, parameter tuning etc). I hope to see you there!

First a bit on ndb_autoincrement_prefetch_sz and then blobs!

ndb_autoincrement_prefetch_sz

One thing is contention on auto_increments, which can really slow down performance.
By default the ndb_autoincrement_prefetch_sz=1. This means that the mysqld will cache one auto_increment number and then go down to the data …

Thanks to the efforts of the Debian HA Maintainers team, the complete Pacemaker cluster stack is now available in Debian GNU/Linux. Packages are currently included only in Debian unstable (“sid“), but we expect them to make their way into squeeze (and lenny, via backports.org) relatively soon.

See the following links in the Debian package database for details:

• http://packages.debian.org/cluster-glue ( …

I’m excited to share the news that Oracle ACE program has been extended to cover MySQL community now and Pythian’s Sheeri Cabral has become the very first Oracle ACE Director in MySQL expertize area. It’s a special privilege for me to blog about it because I had a pleasure to nominate Sheeri in the first place. Being an Oracle ACE Director myself and knowing what’s involved, I believed that if Oracle ACE program is extended to MySQL, Sheeri must be the number one candidate.

It’s impossible to overestimate Sheeri’s role in the MySQL community — her advocacy for the technology and commitment to building and supporting the community. She’s been presenting about MySQL …

If you build your own MySQL binaries then it is a good idea to test them with the MySQL regression test framework. mysql-test-run contains many tests for MyISAM, some for InnoDB, a few for archive and heap and no tests for PBXT. But this post isn't about the need for a storage-engine independent test suite. It is about running regression tests for the InnoDB plugin.

You can also run the test suite if you install from binaries or an RPM as long as mysql-test has been included.

The test framework is slowly getting better at supporting the InnoDB plugin. Now that InnoDB and MySQL are in the same company I expect this to get much better and I hope to stop spending time on this. I filed several bugs to improve support. I even provided a few patches, but my changes to the test framework are frequently incorrect. Blame it on Perl.

First, …

Requirement 2 of the PCI DSS v1.2 is: “Do not use vendor-supplied defaults for system passwords and other security parameters” Understanding that we’re limiting the discussion solely to MySQL (OS, Network Devices, and other software will no doubt apply to overall compliance), we can do this easily. The vendor-supplied default MySQL 5.1.43 (they’re similar across [...]

If you are planning to take a certification exam at the MySQL Users conference next week, please bring a laptop with WiFi and plan to come early! Testing will be in the Magnolia Room by the escalators in the Hyatt Lobby from 8:30 AM to 3:00 PM starting Tuesday.

The exams are online which means you will need a laptop.

And this year there is a limit of 250 exams total. Once that hard limit is reached, there will be no more exams given at the UC in 2010. So do not wait to the last minute to finish off that certification.

Allow Your Applications To Access The XAMPP MySQL Server Directly

If you want to have a full featured "LAMP" server with one step you can use "XAMPP", it's easy and fast but you can't access its MySQL database server using the regular "mysql" client (/usr/bin/mysql), you have to use its own client (/opt/lampp/bin/mysql) to do that.

As announced previously, our MySQL/Replication/Pacemaker webinar is on tomorrow (Wednesday April 7) at 1500 UTC. A few seats are still left; you may want to register quickly.

…