Showing entries 23851 to 23860 of 44961
« 10 Newer Entries | 10 Older Entries »
May
11
2010
Crowdsourcing and the challenge of payment
Posted by O'Reilly Radar on Tue 11 May 2010 22:32 UTC
Tags:


An unusual href="http://www.meetup.com/Distributed-Work/calendar/13300733/">Distributed
Distributed Work Meetup was held last night in four different
cities simultaneously, arranged through many hours of hard work by href="http://www.meetup.com/Distributed-Work/members/9584137/">Lukas
Biewald and his colleagues at distributed work provider href="http://crowdflower.com/">CrowdFlower.

With all the sharing of experiences and the on-the-spot analyses
taking place, I didn't find an occasion to ask my most pressing
question, so I'll put it here and ask my readers for comments:

How can you set up crowdsourcing where most people work for free but
some are paid, and present it to participants in a way that makes it
seem fair?


This situation arises all the time, with paid participants such as
application developers and community …

[Read more]
May
11
2010
Why is my database slow?
Posted by Ronald Bradford on Tue 11 May 2010 21:31 UTC
Tags:

Not part of my Don’t Assume series, but when a client states “Why is my database slow”", you need to determine if indeed the database is slow.

Some simple tools come to the rescue here, one is Firebug. If a web page takes 5 seconds to load, but the .htm file takes 400ms, and the 100+ assets being downloaded from one base url, then is the database actually slow? Tuning the database will only improve the 400ms portion of 5,000ms download.

There some very simple tips here. MySQL is my domain expertise and I will not profess to improving the entire stack however perception is everything to a user and you can often do a lot. Some simple points include:

  • Know about blocking assets in your <head> element, e.g. .js files.
  • Streamline .js, .css and images to what’s needed. .e.g. download a 100k image only to resize to a thumbnail via style …
[Read more]
May
11
2010
How to install MongoDB on CentOS 5.4 / RHEL5 and interface with PHP 5
Posted by Matt Reid on Tue 11 May 2010 20:53 UTC
Tags:

If you’ve been reading up on the various NoSQL offerings and have wanted to try out one but don’t know how to get started, this is one of the easiest ways. I chose MongoDB for this example because I’m going to start using it for a project that needs features that MySQL isn’t as fast at: namely denormalized data with billions of rows. MongoDB has plenty of drivers for other scripting and high-level languages but I’ll focus on the PHP driver today. If there is interest I can do a write up on Python usage later. This example is limited to CentOS, Fedora, and Redhat 5 servers that use the yum package management system. For more information you can reference their download page: http://www.mongodb.org/display/DOCS/Downloads

First install the prerequisites:

  • sudo yum install gcc php php-pear

Then install the mogo php extension via …

[Read more]
May
11
2010
OpenSQL (2009 Portland) talk on an Open Storage Engine API
Posted by Tokuview Blog on Tue 11 May 2010 18:32 UTC
Tags:

I just spotted the youtube video of my OpenSQL Camp (Portland 2009) talk on An Open Storage Engine API. I talked about some of technical issues for implementing storage engines across many SQL front ends, not just MySQL.

You can find this talk and other mostly technical material at http://tokutek.com/technology/.

May
11
2010
MariaDB 5.1.44b Released
Posted by Monty Program Group Blog on Tue 11 May 2010 16:08 UTC
Tags:

MariaDB 5.1.44b Linux and Solaris binaries, Ubuntu/Debian/CentOS packages, and source are now available for download.

This is a bugfix/security release of MariaDB 5.1.44.

From the MariaDB 5.1.44b Release Notes:

MariaDB 5.1.44b fixes a buffer overflow that might potentially allow an authenticated user to run arbitrary code inside the server. It also has a fix for MySQL Bug #53371: “Security hole with bypassing grants using special path in db/table names.” In all other respects, it is the same as MariaDB 5.1.44.

See the MariaDB 5.1.44 Release Notes for a summary of the differences between MariaDB 5.1.42 and MariaDB 5.1.44.

A Windows binary is coming …

[Read more]
May
11
2010
Signup for Drizzle Contributor Tutorial Webinar – May 15th
Posted by Jay Pipes on Tue 11 May 2010 15:48 UTC
Tags:

Hi all!

I’ll be giving an online webinar for Drizzle contributors on Saturday, May 15th @ 1am GMT (In the U.S. this is Friday, May14th @ 9pm EDT, 6pm PDT).

Note that the DimDim widget below shows the time as May 14th @ 8pm. The widget is wrong, since DimDim does not account for daylight savings.

Space is strictly limited to 20 people and this will be done via DimDim.com. Please register for the webinar by entering your email address in the widget below and clicking “Sign Up”.

The agenda for this 2-3 hour tutorial will be:

  1. First Steps
    • Getting registered as a contributor for Drizzle on Launchpad
    • Registering your SSH keys with Launchpad
    • Picking up and creating blueprints
    • Basics of Bazaar
    • Setting up a local code repository for …
[Read more]
May
11
2010
Want DRBD in RHEL 6? Make yourself heard!
Posted by Florian G. Haas on Tue 11 May 2010 15:33 UTC
Tags:

The folks over at Red Hat were kind enough to make public bug 585309, an enhancement request to include DRBD in RHEL 6. If you want DRBD on the last major platform that doesn’t include it yet, feel free to comment and make your voice heard!

A valid login on the Red Hat Bugzilla system is required to comment. Don’t have an account? Create one!


…

[Read more]
May
11
2010
MySQLDump from A to B with pipes
Posted by MySQLBoy on Tue 11 May 2010 15:21 UTC
Tags:

Moving your data and tables around comes in many different flavours. The use of mysqldump is common practice to dump your data and schema out to a file. It is also possible to pipe your mysqldump into a 2nd server. Try the code below (adapting the users and passwords!) in a test environment;
$ mysqldump -u UserA -p p455w0rd --single-transaction --all-databases --host=Server1 | mysql -u UserA -p p455w0rd --host=Server2
As you can see from the command we are taking all the databases in a single transaction into Server2 from Server1. If you're not using transactional tables substitute the --single-transaction for --lock-all-tables to ensure you get a consistent copy.

Remember; You must be able to see the 'other' server over the network and there must be permissions set for remote access from your feeding Server. For large databases this technique may not be suitable because of the performance restrictions surrounding …

[Read more]
May
11
2010
MySQL track with free event at Kaleidoscope 2010
Posted by Giuseppe Maxia on Tue 11 May 2010 10:43 UTC
Tags:

The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. The great news this year is that, at popular demand, there will be a MySQL track, organized and manned by the MySQL community.

The even greater news is that, in addition to the general schedule, there are SUNDOWN SESSIONS

Monday, June 28, 5:45 p.m. – 6:45 p.m. (reception immediately following)

Join us on Monday, June 28 for a lively open discussion with Oracle MySQL ACE Directors. In addition to a specific session on MySQL, other Sundown Sessions will address: Middle Tier and Client-Side Development, Database …

[Read more]
May
11
2010
InfiniDB performance with AWS - EC2
Posted by Jim Tommaney of Calpont & InfiniDB Project Team on Tue 11 May 2010 09:37 UTC
Tags:

Recently, we walked through a short list of instructions to get InfiniDB up and running on Amazon Web Services.  Performance falls nicely in line with previous metrics:


Here we see relative performance of an AWS m1.xlarge instance running 4 cores with 15 GB of memory against a Dell 1950 here at Calpont running 4 cores and 16 GB of memory.  The disk infrastruct...

Showing entries 23851 to 23860 of 44961
« 10 Newer Entries | 10 Older Entries »