MySQL Cluster (NDB Storage Engine) is a shared-nothing distributed in-memory database with support for disk-data tables as well. It provides a DB environment with high availability, near-linear scalability, realtime performance, automatic and user defined data partitioning, load balancing and transparent failover.
The data is distributed using a partitioning key (hash calculated on primary key as default) so the performance is especially great for primary key lookups and parallel data access.
UPDATE developer_day_signup SET name=YOU! WHERE (attending_mysql_uc=True OR attending_percona_conference=True) AND shape_future_database=True;
A rotten little apple by Ashley Harding
Apple has had a nasty Safari bug since December which breaks SmugMug, Facebook, Gmail, and lots of US banks.
3 months later, it’s still not fixed. Your only option is to use Firefox if you’re affected.
Apple’s known about the problem since December, and has lots of internal bugs on the issue (30+ I last heard). (For my Apple readers, here’s our bug on …
[Read more]
Alpha version 5.08 of the BLOB streaming engine for MySQL has
been released. You can download the source code from www.blobstreaming.org/download. The documentation
has also been updated.
What's new in 5.08:
Yes, I've changed my counting... I'm having keeping track of
which day is which so better to use the UC as my end point I
figured. So Day 24 to the UC it is...
London, Ontario, in a coffee shop poaching wireless... Well, I
hoped to report that Kingston, Ontario had welcomed me with open
arms last night and was a giant success. I was hoping for
pictures of students running after me as if I was a long-lost
Beatle, or perhaps Kaj. However, that was not to be the case.
Unfortunately the event had to be cancelled. Not an auspicious
beginning to the trip for sure.
However, we are now 24 days to the MySQL Users Conference and I
am 4,250km from San Francisco. So what are the highlights from
the upcoming conference?
First I'd like to point out, as so many others have done so, that
this year we will have a MySQL Camp run by your very own MySQL …
I am passing this along — I am not sure if most folks reading this can make it, as it is last-minute and in the Boston area, but I figured I’d let people know that the New England Database Society exists. It’s free, sponsored by Sun (and has been for years, long before Sun bought MySQL), and is hosted by my college database professor, Mitch Cherniack. (To that end, I should probably make sure to promote the Boston User Group here more often! I keep forgetting…)
You can find information on how to be a part of the mailing list at http://www.cs.brown.edu/sites/neds/
The next New England Database Society will be held on Friday, March 27 and the speaker is Christian Jensen of Aalborg University.
===================================================================
[N]ew [E]ngland [D]atabase …
As you probably now if you reading this blog, MySQL does not support SQL sequences. Logically, it is very easy to implement something equivalent to a sequence using transaction with InnoDB with a simple 2 columns table, name and value. The only problem is that a sequence update is usually composed of two SQL statements, a SELECT to read the value and an UPDATE to increment it. Fairly you would say, use a transaction to wrap the 2 statements together but then, you are probably aware that you cannot manage transactions in a function with MySQL. A clean sequence function seemed out of reach up to recently, when Brian Morin showed me a trick that solves the issues. Here how to create a get_next_val function to a sequence.
delimiter // drop function if exists true_function // create function true_function(p_param int) returns int deterministic sql security invoker return true // drop function if exists get_next_value// create …[Read more]
Encouraged by Baron Schwartz tip on result set comparison, here are a few more, on
the same vein.
First, you can send a result set to a file. Probably you
will say "yeah, I know, using SELECT INTO OUTFILE". Correct.
Except that you can't rewrite to an existing file, if you want
to, and you will get a raw output, not the well formatted one
that you usually see on the command line. For example:
mysql > select 1 into outfile '/tmp/f1.txt';
mysql > \! cat /tmp/f1.txt
1
mysql > select 1 into outfile '/tmp/f1.txt';
ERROR 1086 (HY000): File '/tmp/f1.txt' already exists
BTW, \! command is a handy shortcut for executing a
shell command.
Let's see what happens with the alternative …
At the March Boston MySQL User Group meeting, Jacob Nikom of MIT’s Lincoln Laboratory presented “Optimizing Concurrent Storage and Retrieval Operations for Real-Time Surveillance Applications.” In the middle of the talk, Jacob said he sometimes calls what he did in this application as “real-time data warehousing”, which was so accurate I decided to give that title to this blog post.
The slides can be downloaded in PDF format (1.3 Mb) at http://www.technocation.org/files/doc/Concurrent_database_performance_02.pdf. The 54 minute video can be downloaded (644Mb) at http://technocation.org/node/693/download or streamed directly in your browser at http://technocation.org/node/693/play. …
[Read more]
Hi again!
As a sidekick for my previous post, I came up with a snippet of
code that generates the Google
Chart URL to visualize table size for the current database.
For example, for the sakila sample database, we get URL's like
this:
…[Read more]