A few weeks ago we announced New MySQL Enterprise Oracle Certifications making it easier and faster for Oracle customers to deploy & manage MySQL within their existing environment.

As we regularly get questions from customers about using Oracle GoldenGate with MySQL, we put together a “Spotlight On” document briefly presenting the products and the most common use cases.

For those less familiar with Oracle GoldenGate, organizations can leverage it to move transactional data in real time between MySQL and other systems without impacting the performance of source or target systems.

You can find the "Spotlight On" document here (under "Brochures & Data Sheets") along with additional information about …

A few weeks ago we announced New MySQL Enterprise Oracle Certifications making it easier and faster for Oracle customers to deploy & manage MySQL within their existing environment.

As we regularly get questions from customers about using Oracle GoldenGate with MySQL, we put together a “Spotlight On” document briefly presenting the products and the most common use cases.

For those less familiar with Oracle GoldenGate, organizations can leverage it to move transactional data in real time between MySQL and other systems without impacting the performance of source or target systems.

You can find the "Spotlight On" document here (under "Brochures & Data Sheets") along with additional information about …

I found Dennis the Menace, he now has a job as system administrator for a hosting company. Scenario: client has a problem with a server becoming unavailable (cause unknown) and has it restarted. MySQL had some page corruption in the InnoDB tablespace.

The hosting provider, being really helpful, goes in as root and first deletes ib_logfile* then ib* in /var/lib/mysql. He later says “I am sorry if I deleted it. I thought I deleted the log only. Sorry again.”  Now this may appear nice, but people who know what they’re doing with MySQL will realise that deleting the iblogfiles actually destroys data also. MySQL of course screams loudly that while it has FRM files it can’t find the tables. No kidding!

Then, while he’s been told to not touch anything any more, and I’m trying to see if I can recover the deleted files on ext3 filesystem (yes there are tools for that), he goes in again and puts an ibdata1 file back. No, …

From time to time, organizations want to know if there are any users that are not used.  For clients using MySQL 5.1 and up, that can handle a 1% overhead for general logging, we will enable the general log for a period of time and analyze the users that connect.

Note: we have some extremely busy clients, and we very rarely have a problem turning the general log on, other than making sure we're rotating and compressing logs so we do not run out of disk space.

Once we have the logs, I run this little perl tool I made -- I call it genlog_users.pl:

#!/usr/bin/perl

my $infile=$ARGV[0];

my %seen=();

my @uniq=();

open (INPUT, "<$infile");

while (<INPUT>) {

  my $line=$_;

  if ($line=~/Connect/) {

    if ($line=~/(\S*@\S*)/) { push(@uniq, $1) unless $seen{$1}++; }

…

This week, Gerry Narvaja guest hosts and we talk about star and snowflake schemas, as a follow-up to last week's podcast on Data Warehousing 101.

News
FOSDEM has a call for papers open until Sunday, November 6th. FOSDEM is one of the largest free and non-commercial open source events, taking place in Brussels, Belgium on February 4th and 5th. There will be a Developer’s room that's near and dear to our hearts called "MySQL, MariaDB and friends".

read more

There are moments in history that become like signpost that everyone remembers the rest of their lives. Like where were you when you heard the news that JFK had been shot, or those 9/11 planes hit the WTC twin towers. If you work with MySQL and high-availability, then this week will be remembered as such. And if you're a European MySQL geek, you will remember that we were at the Percona Live UK conference when Galera clustering 1.0 was announced. Btw, the conference itself was also historical, at least for European MySQL users. I will have to write a separate blog post about the conference, because it was a great one, and I have to post slides of my 2 talks too. But this blog post is dedicated to the stable release of Galera.

…

CFEngine is both the oldest and the newest of the popular tools for automating site administration. Mark Burgess invented it as a free software project in 1993, and years later, as deployments in the field outgrew its original design he gave it a complete rethink and developed the powerful concept of promise theory to make it modular and maintainable. In this guise as version 3, CFEngine stands along with two other pieces of free software, Puppet and Chef, as key parts of enterprise computing. Along the way, Burgess also started a commercial venture, CFEngine AS, that maintains both the open source and proprietary versions of CFEngine.

Diego Zamboni has recently taken the position of Senior Security Advisor at CFEngine AS and is writing a book for O'Reilly on CFEngine 3. I talked to him this week about the recent new …

Topics for this podcast:

*Opscode Chef extends to Windows for more enterprise devops
*Black Duck continues growth, gains new funding
*Cloudant expands NoSQL database focus, customers
*New open source Web server and vendor Nginx arrives
*The downside of Microsoft’s Android dollars

iTunes or direct download (27:35, 4.7MB)

This is the first in a series of postings on the MySQL Enterprise tools. I know most of you reading are dedicated community server users but you may have wondered ‘What do you get when you buy MySQL Enterprise server?’

Well, first of all, you can try the Enterprise Server for free for thirty days. Point your browser to Oracle Software Delivery Cloud and download. Hopefully you can following along with me as I try the various Enterprise tools starting with MySQL Enterprise Backup.

Data backups have long been a part of my professional life. My ‘first real’ job was backing up data on a DEC Tops-10 system that ran the University of San Diego. Much of my working time at night was spent loading, unloading, and monitoring reel tapes as the data from the washing machine sized disk drives was spread over magnetic oxide bonded to plastic …

Percona Live London 2011 is over and it was a wonderfull event. Thanks to Percona for this quality event in Europe.
And thanks to all speakers for their outstanding performances.

I just want to share with you some words about PLUK2011, these few words reflect my technical feelings after the event :
(This is the live transcript of my notes during the conference in random order)

• MySQL is not dead !
• Sharding is a good way for write scalability
• It’s difficult to find a real HA solution for MySQL
• MHA rocks !
• IO are more than ever our enemies (and we must get into their privacy)
• Where is Oracle ?!
• Glad to see SkySQL there
• We probably need new références for SSD
• Keep in mind the operability of the proposed solutions
• Handler socket is …