mysqlguy.net

Feed aggregator

Lemme give you a little advice

Yodel Anecdotal - May 28, 2008 - 3:54pm

What do you do if you’re the CEO and president of a company that’s become the preoccupation of the business section and you’re about to go on stage in front of hundreds of tech moguls, investors, and journalists at “D: All Things Digital” for a chat with the Wall Street Journal’s Walt Mossberg? You cue the video!

Here’s a short video prelude we pulled together for Jerry Yang and Sue Decker to help pull the elephant squarely into the middle of the room this afternoon at the 6th annual D conference in Carlsbad, Calif. It’s a parody of the vast quantities of advice that both execs have been receiving about Yahoo! in recent months. And we got a little help from our friends — Berkshire Hathaway’s Warren Buffett, Sequoia Capital’s Mike Moritz (our first investor), PBS’ Charlie Rose, Sony’s Howard Stringer, Intel’s Paul Otellini, Dell’s Michael Dell, Cisco’s John Chambers, and Facebook’s Mark Zuckerberg and Sheryl Sandberg.

For Yodel Anecdotal readers, we’re posting a special version with an exclusive Buffett outtake at the end. It’s clear why Warren was invited to cameo on “All My Children.”

Yahoo! will be filing a definitive proxy statement and accompanying WHITE proxy card with the SEC in connection with the solicitation of proxies for its 2008 annual meeting of stockholders. Stockholders are strongly advised to read Yahoo!’s 2008 definitive proxy statement when it becomes available because it will contain important information. Stockholders will be able to obtain copies of Yahoo!’s 2008 definitive proxy statement and other documents filed by Yahoo! with the SEC in connection with its 2008 annual meeting of stockholders at the SEC’s website at www.sec.gov or at the Investor Relations section of Yahoo!’s website at yhoo.client.shareholder.com. Yahoo!, its directors, and certain of its officers may be deemed participants in the solicitation of proxies from stockholders in connection with Yahoo!’s 2008 annual meeting of stockholders. Information concerning Yahoo!’s directors and officers is available in its preliminary proxy statement filed with the SEC on May 22, 2008.

(Incidentally, this video is the dog that ate my homework and is the reason why you loyal readers found last week’s content a bit sparse. I’m a multi-hat operation.)

Photo by Asa Mathat/AllThingsD.com

Categories: Yahoo

Weekly Falcon Test Overview 2008-05-23

Planet MySQL - May 28, 2008 - 2:31pm

It has been a while since the last Weekly Falcon Test Overview, also called WFTO.

Our Falcon team was with the Falcon Developers Meeting in London last week. Other than that, I updated my workstation running the WFTO test suite from RHEL4 to RHEL5. This caused some delay in the weekly reporting.

The WFTO test suite now contains RHEL5 64-bit (native), Ubuntu 32-bit (vm), Windows 2003 Server 64-bit (vm), and Mac OS X/PPC 32-bit (native).

We have one new test case falcon_bug_36294 and three tests are not failing anymore.

News for these weeks:
  • Jim Starkey fixed
  • Kevin Lewis fixed
    • Bug#36097 Be sure the highWater index is set to zero when a record is thawed
    • Bug#36636 Move fsync out of the #ifdef HAVE_PREAD scope so that it works in either case.
    • Bug#36603 Adjust age group values to uint32
  • Vladislav Vaintroub fixed
    • Bug#36467 Falcon assertion in ha_partition.cc: virtual int ha_partition::extra()
  • Christopher Powers fixed
    • Bug#36330 Falcon DBT2 crash in Transaction::needToLock
  • Sergey Vojtovich fixed
    • Bug#33607 Falcon allows two mysqld instances to share a tablespace
    • Bug#33404 Falcon ignores partition-level TABLESPACE option
  • Hakan Küçüky?lmaz fixed
    • Bug#36486 Falcon compilation fails on Solaris 10/x86
    • Bug#36400 Compiling Falcon on Solaris 10/x86 fails with Sun Studio 12
What about you?

We are interested in you! Where do you use Falcon? What do you do with Falcon? Are there any features you want to see in Falcon? You can test Falcon and get famous by providing valuable bug reports or even test cases for Falcon!

Resources:
Categories: MySQL

The MySQL community is counting its ranks

Planet MySQL - May 28, 2008 - 10:00am

The MySQL Community is taking charge of counting its own ranks, by means of a survey with the purpose of measuring the usage of the world most popular open source database.

The proposal comes from Keith Murphy, editor of the MySQL Magazine, which should host the results in July.

More attention to this survey is coming from Lenz Grimmer MySQL Community Manager for EMEA, and Mark Schoonover, who is co-author of the survey. I also chimed in.

Categories: MySQL

MONyog 2.05 Has Been Released

Planet MySQL - May 28, 2008 - 9:12am

Bug fixes:

*  OS monitoring issue in Fedora Core 6 Zod was fixed

Downloads: http://webyog.com/en/downloads.php
Purchase: http://webyog.com/en/buy.php

Categories: MySQL

Real-time stock quotes on the house

Yodel Anecdotal - May 28, 2008 - 8:59am

Stock quotes have always been the core piece of the financial information we provide on Yahoo! Finance. In fact, Yahoo! Finance originally launched under the name “Yahoo! Quotes” back in 1996, offering what now seems like the most basic of all financial data. In the process, we helped change the way average investors make financial decisions, and even took some of the weight out of your daily newspaper.

Now, 12 years later, our name has changed and our site has expanded, but our focus on providing the most reliable and timely market information has stayed the same. Today, we’re pleased to bring free real-time quotes back to Yahoo! Finance. As of today, unlimited access to the most current U.S. stock quotes, as of the last trade, are available to all of our users.

It’s a concept we’ve offered before, and one we’ve been focused on bringing back to our users since free real-time quotes were removed from Yahoo! Finance in 2006 when marketplace consolidation made obtaining this information virtually impossible.

We know how important this data was to your financial decisions because you told us, we listened, and we found a solution. Today we begin a partnership with BATS Trading, the electronic communication network and industry leader in free real-time market data. BATS is providing real-time U.S. quotes to Yahoo! Finance at no cost, and we in turn, provide it to you.

What does this mean for you? Business as usual — only better. As you check your stocks on Yahoo! Finance, your free real-time quote will stream right onto your quote summary page.

Check it out for yourself in real time, and check back as we roll real-time data features into new areas of Yahoo! Finance.

Mark Interrante
VP and GM of Yahoo! Finance

Categories: Yahoo

2008 MySQL Magazine Survey Breaks 100 Responses!

Planet MySQL - May 28, 2008 - 8:58am
Within 36 hours of launching, the 2008 MySQL Magazine Survey has over 100 responses from around the globe. Join the community and let us know how you use MySQL.

Have you surveyed?

2008 MySQL Magazine SurveyMySQL DBA & Programming Blog by Mark Schoonover
Categories: MySQL

Piercing the fog

Planet MySQL - May 28, 2008 - 6:30am

There have been many surveys on MySQL, but usually not as deep as this one launched by Keith Murphy, editor of the MySQL Magazine and Mark Schoonover.
I have seen some turmoil lately, with talks of forking the code base and organizing a community conference. The community seems restless, and this initiative could be an attempt of counting their ranks to see how much they can dare.
I welcome this initiative of seeing through the fog. If a survey was needed, rather than waiting one to fall from the sky (or from the Sun :-) ), the industrious bloggers have started their own. I will be curious to see the results.
Inside MySQL, we have been talking about creating a phone home feature to do a live count of the user base, but as you can see there is no such thing yet. So this survey could provide the data that the missing phone home feature has failed to bring back. The user base measuring itself: that's an interesting thought.
If you can spare 10 minutes, I recommend taking the survey.
Categories: MySQL

APAC Memcached Talk

Planet MySQL - May 28, 2008 - 6:23am
You can find some photos and such on the APAC blog for MySQL about
mine and Mixi's Toru-san's Memcached talk in Japan:
Blog Entry Link (UTF8, may not work for all browsers)

I'd post more Japanese here, but Planet MySQL cannot handle the UTF8 :)


Categories: MySQL

MySQL Workbench 5.0.22 released

Planet MySQL - May 28, 2008 - 4:09am

After some glitches - mainly introduced by switching to the new source control system - we are presenting a new release of version 5.0 (built right out of our shiny new bazaar repository). This release has another 17 bugs fixed (along with some additional adjustments to improve usability). While we are already working in parallel at version 5.1 we are constantly fixing the remaining bugs in our present release version.

Categories: MySQL

451 CAOS Links - 2008.05.27

Planet MySQL - May 27, 2008 - 11:59pm

SourceForge announces quarterly earnings. Linux server growth strong, says analyst firm. Talend adds support for MaxDB. (and more)

SourceForge Reports Third Quarter Fiscal 2008 Results, SourceForge (Press Release)

Worldwide Server Market Shows Resiliency with Solid First Quarter Results, According to IDC, IDC (Press Release)

Talend Announces Data Integration for MaxDB, Talend (Press Release)

How everyone wins with open source software, Linux.com, Lisa Hoover (Article)

How open source is losing the charity battle, ZDNet Australia, Angus Kidman (Article)

Open Source, Open Strategy: The SpringSource Manifesto, SpringSource Team Blog, Rod Johnson (Blog)

Subscription vs. license: When do you take your profit?, CNET - The Open Road, Matt Asay (Blog)

SCO Updates its “Legal Update” Page, Groklaw, Pamela Jones (Blog)

Categories: MySQL

Memcached Webinar - 420 Registrants and Counting!

Planet MySQL - May 27, 2008 - 10:26pm
Regarding my earlier post on memcached webinar, I was informed today that more than 420 registrants have signed up. Space is limited and filling up fast so if you are interested in memcached and haven't registered yet, click on the following link to register now!

Designing and Implementing Scalable Applications with Memcached and MySQL (June 29)
Categories: MySQL

Installing MySQL on Solaris

Planet MySQL - May 27, 2008 - 9:12pm
Categories: MySQL

German State Nordrhein-Westfalen Leverages MySQL Enterprise Unlimited

Planet MySQL - May 27, 2008 - 7:59pm
Sun Microsystems, Inc. today announced that the Nordrhein-Westfalen Data Centre for Finance Management (RZF) is relying on MySQL Enterprise™ to deliver its database applications. Following a very successful test period for its custom-built financial applications, RZF plans to deploy additional MySQL™-based database applications in the future.
Categories: MySQL

First B2B Processes More Than Two Million Complex Transactions Using MySQL Enterprise

Planet MySQL - May 27, 2008 - 7:59pm
Sun Microsystems, Inc. today announced that First B2B Ltd, one of the leading providers of business-to-business electronic trading, is now processing more than 2 million complex transactions a year with Sun's MySQL™ database software. With MySQL as the 'central plank' of its business, First B2B is able to support the trading transactions of more than 400 companies throughout the UK, and its entire operations are now based upon a MySQL Enterprise™ database subscription.

Categories: MySQL

Webinar:The Essential MySQL Backup & Recovery Solution ? ZRM 2.2 Overview

Planet MySQL - May 27, 2008 - 4:31pm

MySQL databases are increasingly used by high volume, high transaction applications
that support businesses running full throttle 24-hours a day, seven days a week.
Backup and recovery operations need to be conducted in such as way that is non-disruptive
to users and applications. The latest release of Zmanda Recovery Manager (ZRM) 2.2 provides
Continuous Data Protection (CDP) as well as instant point-in-time recovery for MySQL.
In this webinar, we will demonstrate the latest ZRM enhancements so that you can use ZRM
to build a robust, flexible, and easy to use backup and recovery solution.

When: Thursday May 29, 2008, 10:00am Pacific / 1:00pm Eastern

Categories: MySQL

Chaining Proxies

Planet MySQL - May 27, 2008 - 4:30pm
If you need to combine two scripts with MySQL Proxy you have three choices.
  • You can manually rewrite the two scripts (good luck!)
  • you can use the load-multi module to load scripts on demand;
  • or you can use the proxy chaining technique.

To chain two proxies, you need to start one Proxy with the first Lua script, pointing at the real backend, listening to a non-standard port. Then you start the second Proxy with the second Lua script, having the first proxy as a backend, and listening to the standard proxy port.
It's a difficult and error prone procedure. You would forget about it, unless there were an easy workaround. And indeed you can have such a workaround. Just use the chain_proxy script from MySQL Forge and use it with this simple syntax:
$ chain_proxy first_script.lua second_script.luaWhen I made this script, I had the problem of handling the standard output for each proxy instance. The brute force solution is to start each instance in a separate terminal window, but that is less than optimal. It would be almost as much work as doing things manually.
Considering that usually I need the output of a Proxy session only for debugging and that I am a frequent user of GNU screen, I made this arrangement:
The script starts each proxy inside a separate screen. At the end, it gives the list of screens being used, and creates a customized script in /tmp/ to kill the chained proxies and remove the screens.
$ chain_proxy digits.lua loop.lua
proxy started on screen "second_proxy" using script "loop.lua" - pid_file : /tmp/proxy1.pid
proxy started on screen "first_proxy" using script "digits.lua" - pid_file : /tmp/proxy_chain1.pid
stop script is /tmp/proxy_chain_stop
There are screens on:
21257.first_proxy (Detached)
21258.second_proxy (Detached)
2 Sockets in /tmp/uscreens/S-gmax.
In this example, the two proxies are started in sequence, and the script gives information on what is going on. The output of "loop.lua" is in the "first_proxy" screen. To see it, I only need to do
$ screen -r first_proxy
When I am finished using the chained Proxy, I type
$ /tmp/proxy_chain_stop
There are screens on:
21257.first_proxy (Detached)
21258.second_proxy (Detached)
2 Sockets in /tmp/uscreens/S-gmax.

No Sockets found in /tmp/uscreens/S-gmax.
This script can also be implemented by redirecting the output of each proxy to a different file. YMMV. I like the screen solution better.

I will be speaking about this feature (and more) during my MySQL University session on advanced Lua scripting.
Categories: MySQL

InnoDB map: bulk inserting

Planet MySQL - May 27, 2008 - 2:50pm

So, what does InnoDB do while you’re loading the data in parallel?
It looks something like this:

Click on image for larger (8MB) version, if you dare, have efficient browser and lots of spare RAM (7k*10k canvas). Generated by:

opreport | Gprof2Dot | dot
Categories: MySQL

InfoWorld Digest

Planet MySQL - May 27, 2008 - 1:34pm

Since I've been doing most of my blogging lately over at InfoWorld, I thought I'd provide a short digest of some of the top posts in recent months. I share the blog with Savio Rodrigues from IBM, but other than some overlap at the occasional conference, we blog independently.  (Yes, it's an old photo.)  Enjoy!

Typically I try to write 3-4 posts per week over at InfoWorld and then post things that are more MySQL-related here on this blog. But I admit, it's getting harder and harder to maintain two three different blogs.

Categories: MySQL

A week in Washington, D.C.

Yodel Anecdotal - May 27, 2008 - 12:05pm

Last Tuesday, I testified at a hearing on Internet Freedom before a U.S. Senate subcommittee chaired by Senator Richard Durbin (webcast is here). The hearing was tough but timely. With the Beijing Olympics approaching, companies like ours expanding into emerging markets, and a general sense that companies should push hard for a collective human rights code of conduct, the hearing gave us a chance to share the Yahoo! vision for a path forward.

I tried to convey this simple message: We believe in the power of information and in global engagement, we were an industry pioneer in international markets, we take responsibility for our actions, we’ve learned valuable lessons, and we’re taking concrete steps on our own and collectively to be leaders in the field of business and human rights. You can read my testimony here.

The following day, I presented at the U.S. Department of State on a panel on Business & Human Rights. Sitting next to three other global companies in entirely different industries, I emphasized our commitment at Yahoo! to the principles of free expression and privacy and to working collectively with technology companies and others to create industry standards to guide companies in the world’s most challenging markets. I also discussed our collaboration with the State Department through its Global Internet Freedom Taskforce and our other efforts, including Jerry’s letter earlier this year to Secretary Rice.

At the Senate hearing, Senator Tom Coburn used an expression we’ve often heard and used at Yahoo!: Information is power. We continue to believe in that simple axiom. Information is empowering to ordinary citizens across the globe. Yahoo! is built on the power of information, and we’ll continue to harness that power for good.

Michael Samway
VP & Deputy General Counsel

Categories: Yahoo

GSoC Updates: Start your engines

Planet MySQL - May 27, 2008 - 10:08am

MySQL is featured on the Google Open Source Blog
Just after leaving JavaOne, Leslie pinged me on IRC to inform me that the MySQL project was featured on the Google Open Source blog. Go on, read Moments of Inspiration.

In other news from mentors, Colin Charles, former mentor and 2008 organization administrator for MySQL dropped a note to let us know that their Community Bonding period is moving along swimmingly. So well, in fact, that their students are already delivering weekly status reports. Colin mentioned that their student Filippo Bollini had crafted a particularly well written update; it’s worth checking out for mentors wondering what sorts of information to collect from students or for students wondering what kind of details are most useful to their mentors.

Congratulations Filippo. I expect great things from you (as does Brian.)

Start your engines!
Students, and mentors alike, this is the week that the Summer of Code starts! Well, coding anyway. Its very encouraging to see all the weekly reports flow in, and once I catch a breath, I’ll be summarising them for all to see and keep up with how the MySQL SoC students of 2008 are doing.

Categories: MySQL

MySQL

Yahoo

Recent comments

About Me

Jay Janssen
Yahoo!, Inc.
jayj at yahoo dash inc dot com

MySQL
High Availability
Global Load Balancing
Failover

View Jay Janssen's LinkedIn profileView Jay Janssen's Facebook profile

User login

Friends

Links