What do you do when you're in a situation where you REALLY need your
favorite Maatkit tools, but are not allowed to load software on the
server running MySQL, AND you're not allowed to install software on the
provided workstation, especially a workstation that's running software
from a large corporation in Redmond? Portable Maatkit to the rescue!

DISCLAIMER:
I've only tested a few maatkit tools, namely mk-find and
mk-query-digest, but not completely. Some features and some tools may
not function, such as mk-audit. Use your best judgment. I'm not
responsible if your workstation or server looses all your data, your
USB key bursts into flames, or your significant other leaves you. YMMV,
use at YOUR OWN RISK!

Strawberry Perl
has been out for some time now, and recently, a portable version of
…

What do you do when you're in a situation where you REALLY need your
favorite Maatkit tools, but are not allowed to load software on the
server running MySQL, AND you're not allowed to install software on the
provided workstation, especially a workstation that's running software
from a large corporation in Redmond? Portable Maatkit to the rescue!

DISCLAIMER:
I've only tested a few maatkit tools, namely mk-find and
mk-query-digest, but not completely. Some features and some tools may
not function, such as mk-audit. Use your best judgment. I'm not
responsible if your workstation or server looses all your data, your
USB key bursts into flames, or your significant other leaves you. YMMV,
use at YOUR OWN RISK!

Strawberry Perl
has been out for some time now, and recently, a portable version of
…

Introduction

The MySQL database has become the world's most popular open source database because of its consistent fast performance, high reliability and ease of use. MySQL is used on every continent – yes, even in Antarctica! – by individuals, Web developers, as well as many of the world's largest and fastest-growing organizations such as industry leaders Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube and others to save time and money powering their high-volume websites, business-critical systems, and packaged software.

As most products do, MySQL comes "ready-to-work" out of the box. Usually, security is not a major consideration when installing this kind of product. Often, the most important issue is to get it up and running as quickly as possible so that the organization can benefit. This document is intended as a quick security manual to help you bring an installed MySQL database server into conformity with best security …

I’m very pleased to announce that the FINAL 1.0 version of the InfiniDB Community Edition database is now available for use. I’d like to thank all of you who helped get us through the alpha, beta, and RC cycles to the 1.0 release of InfiniDB.

You can now download the 1.0 InfiniDB Community Edition binaries and source code and start creating fast running data warehouses, marts, or any other read-inteRead More...

I’m very pleased to announce that the FINAL 1.0 version of the InfiniDB Community Edition database is now available for use. I’d like to thank all of you who helped get us through the alpha, beta, and RC cycles to the 1.0 release of InfiniDB.

You can now download the 1.0 InfiniDB Community Edition binaries and source code and start creating fast running data warehouses, marts, or any other read-inteRead More...

Introduction

I don't know about you, but I can't imagine doing my PHP development without an IDE with a debugger anymore.

It autocompletes for me, it lets me step through each line of code, jumping around the project, execute and change the code flow on the fly, and does many other things that make me feel cozy, comfortable, and efficient at PHP development (as opposed to, say, CPP which makes me feel cold and lonely).

There are many PHP IDEs out there and I've tried most of them (including the free PHPEclipse and PDT for Eclipse) but kept coming back to NuSphere's PHPEd every time. The other ones just don't do as good of a job and don't have the array of features PHPEd does. Did you know Dmitri, the author of PHPEd, …

Thank you for attending the Sun Startup Essentials webinar on Security for Web Applications, here is a list of useful links to learn more about and start implementing the different technologies that were covered during the presentation:

•  ZFS triple parity
• Securing Apache using SSL
• Securing MySQL in production
• Using virtualization to secure MySQL in a chrooted environment
• DTrace scripts to trace TCP …

When MySQL Cluster data nodes start they need to go through a process of determining roles in the cluster, copying the data back into RAM and synchronising everything up.  This can take longer than expected and the process is not always very verbose.  So in this post I will outline a simplified version of what MySQL Cluster is doing in each start phase so that you can see why it can take time.

You can see the last completed start phase by following the management logs or you can see the current start phase by doing 'x status' in ndb_mgm where 'x' is the node ID of the data node you want the information for.

Start Phase 0

This is part of the basic initialisation, and the configuration is received.  If this is an initial start then the node's file system is created.

Start Phase 1

All the blocks that are not already running are initialised in this phase.  Connections to other data …

Thank you for attending the Sun Startup Essentials webinar on Security for Web Applications, here is a list of useful links to learn more about and start implementing the different technologies that were covered during the presentation:

•  ZFS triple parity
• Securing Apache using SSL
• Securing MySQL in production
• Using virtualization to secure MySQL in a chrooted environment
• DTrace scripts to trace …

Thank you for attending the Sun Startup Essentials webinar on Security for Web Applications, here is a list of useful links to learn more about and start implementing the different technologies that were covered during the presentation:

•  ZFS triple parity
• Securing Apache using SSL
• Securing MySQL in production
• Using virtualization to secure MySQL in a chrooted environment
• DTrace scripts to trace …