How this happens or who does it is obviously a larger and more complex conversation however it is better then involving innocent animals.

How is it that trivial $#*! gets voted and has a string of comments I can not explain, however Planet MySQL should have practical MySQL related content. I would vote for the front page and RSS feed to show only moderated content, and content that did not pass the cut (and there is a lot of this) can be available on a less important page if necessary.

Rather then complaining like many open source communities, let us propose a way to improve the system we use.

Every now and then, we have customers who outgrow their single server setup. The next natural step is of course splitting the web layer from the DB layer. So they get another server, and move the database to that.

So far so good! A week or so later, we often get the call “Our page load time is higher now than before the upgrade! We’ve got twice as much hardware, and it’s slower! You have broken it!”
It’s easy to see where they’re coming from. It makes sense, right?

That is until you factor in the newly introduced network topology! Today it’s not unusual (that’s not to say it’s acceptable or optimal) for your average
wordpress/drupal/joomla/otherspawnofsatan site to run 40-50 queries per page load. Quite often even more!

Based on a tcpdump session of a reasonably average query (if there is such a thing), connecting to a server, authenticating, sending a query and receiving a 5 row …

Running a MySQL backup and ensuring it completed successfully and backup files exist is not enough. In my B&R Quiz from Checked your MySQL recovery process recently? one important step is “Do you review your backup logs EVERY SINGLE day or have tested backup monitoring in place?”

This is what I found when reviewing a backup log for a client today.

mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES
mysqldump: Got error: 1142: SELECT,LOCK TABL command denied to user 'root'@'localhost' for table 'cond_instances' when using LOCK TABLES

The backup script was completing, backup files were in place (and are listed in the log file) however these errors were occurring.

Further investigation was less then one minute of …

One MySQL Plug-in customer reported an issue with reports — all charts were displaying an Oracle error and didn’t display any data as if it couldn’t connect to the EM repository. I concluded that this has nothing to do with the plug-in itself since the extensibility framework provides no way of controlling usernames and passwords that are used to access the repository. After opening an SR with Oracle, it turned out that MGMT_VIEW user password has been changed and this causes “ORA-01017: invalid username/password; logon denied” and possibly subsequent “ORA-28000: the account is locked” when policy is set to auto lock an account after certain failed login attempts (default in 11g database).

If you face this issue, follow My Oracle Support Note 374382.1 “Grid Control Repository: How to Change the …

Your boss wanted a quick report from your database but you failed to impress with a text file filled with the output of a ‘SELECT … FROM …’? Then you need to attend one of the following talks. From good looking ad hoc reports or detailed multi-segment reports, there are many BI tools that will make your data look sharper in a printer report, web page, or in a dashboard.

I will speaking three times in April on using Open Source BI Tools (JasperForge, BIRT, Pentaho, etc.) with MySQL. This is a short, faced paced presentation on the subject followed by lots of demos.

Dallas Oracle Users Group, MySQL SIG Free but RSVP Please
Tuesday, April 5, 2011, 4:30 PM in Oracle Office, Frisco Texas, 7460 Warren Parkway Suite 300
Frisco, TX 75034

O’Reilly MySQL Conference
…

A collection of thoughts, quotes, jokes, .. which I posted as status updates on Facebook. My favorites are bold (no pun intended).

They say sucking is a newborn instinct we forget; some people, however, keep sucking their whole lives.

Love has the symbol ♡; what symbol would hate have?

Putting MySQL Cluster on virtual machines and expect it to behave.

If only my wallet was as big as my heart..

If you dwell long enough in shit, you forget it stinks.

A System that is not Intuitive is not a System.

Sometimes it’s better to wait for the fire to see how to actually extinguish it. Standing ready with a bucket of water, just to find out that the flames come out of a frying pan is not productive.

What’s a Miss eating a steak? .. A mistake!

What’s a t-shirt with an issue? .. A tissue!

…

In this guide, we will be exploring how to use the tools which come with OpenVZ and setup a internet facing container/vm. This part of the guide also assumes you have followed part 1 to setup the container already and have a working environment.

In part 1, we setup a CentOS container which we could enter/exit but we didn’t do anything else on the network. What we want to do is set it up so we have the ability to bridge our hosts’ network and define static IP for network interface.


yum install bridge-utils

[root@tooncent ~]# cat /etc/sysconfig/network-scripts/ifcfg-eth0
# Broadcom Corporation NetXtreme BCM5761 Gigabit Ethernet …

I was testing some MySQL puppet modules on my Vagrant box earlier this week and one of them required augeas.
I kept running into "Could not find a default provider for augeas", however all the appropriate augeas , augeas-lib and ruby-augeas packages were installed. I inspected the different ruby directories and the files were perfectly in /usr/lib/ruby/site_ruby/1.8 where I expected them.

With all the files seemd to be in the right place, my next option was to strace a small ruby script that included augeas, guess what that showed ..

1. stat64("/opt/ruby/lib/ruby/site_ruby/1.8/augeas.rb", 0xbfd2af1c) = -1 ENOENT (No such file or directory)
2. stat64("/opt/ruby/lib/ruby/site_ruby/1.8/augeas.so", 0xbfd2af1c) = -1 ENOENT (No such file or directory)
3. stat64("/opt/ruby/lib/ruby/site_ruby/1.8/i686-linux/augeas.rb", 0xbfd2af1c) = -1 ENOENT (No such file or directory)
4. …

Running with Big Data

It’s spring here in Boston, though one could hardly tell (still barely hitting 40°F). So, for those stuck indoors working out on the treadmill, or those lucky enough to do a workout outdoors, we’ve got a great podcast. Our Chief Scientist and co-founder Martín Farach-Colton had the privilege of sitting down with Sheeri Cabral and Sarah Novotny for their weekly MySQL Database Community Podcast (OurSQL Episode 39). In it, he speaks about Tokutek and TokuDB v5.0, which was just released last week (see …

If you're in San Francisco this week, join Monty Program and SkySQL Wednesday, 30 March, at 5:30PM, at the Hotel Rex, for an interactive discussion on what's new in the world of the MySQL database and its ecosystem. Learn about MariaDB and ask yourself: is it New M in LAMP? MariaDB is feature enhanced, backward compatible and community developed. Also, learn how you can get support and services from SkySQL for your MariaDB database.

The focus for the night:

• The MySQL Ecosystem & Landscape
• MariaDB: is it the new M in LAMP?
• SkySQL services, including monitoring solutions from Webyog
• Q&A & Features you want in MariaDB

There will be some great door prizes to be won. As well attendees get two drink coupons for use during the talk.

Register …