The much-anticipated ability to access MySQL data via a NoSQL solution has been realized. Using HandlerSocket, significant performance gains can be realized for certain workloads. Sound like something you are interested in? Join us for Percona Live London to hear Ryan Lowe, Percona’s Director of American Consulting speak on this subject. In Ryan’s session he will answer the questions like:

• What is HandlerSocket?
• Where does HandlerSocket fit in my application stack?
• Why would I want to use HandlerSocket?
• How do I use Handlersocket?

He’ll walk through relevant configuration & tuning options, and at the end of the presentation attendees will be able to identify candidate use cases within their application to use HandlerSocket.

For a chance to win a free ticket to Percona Live London and get the opportunity to hear Ryan and so many others speak on a number of different …

In an earlier post Connecting to MySQL with Python, we only returned a single result line from a “SELECT VERSION()” query. We will now take a look at returning multiple rows of data from a MySQL database using Python.

You will need to have Python (including the MySQLdb and sys modules) and MySQL installed. We will also use the same database table (address) from a previous post, Inserting Data into MySQL with Perl.

Here is the SQL statement that we used to create the table:

SET NAMES latin1;
SET FOREIGN_KEY_CHECKS = 0;

CREATE TABLE `address` (
  `name_first` varchar(30) NOT NULL,
  `name_last` varchar(30) NOT NULL,
  `address_01` varchar(40) NOT NULL,
  `address_02` varchar(40) NOT NULL, …

"FLUSH TABLES" is generally used for closing all tables by force in MySQL. Its really interesting that how mysql do this. Most of time we are doing this because someone adds new tables outside of MySQL. (Like for MyISAM tables, … Continue reading →

…

This week is all about events - events in MySQL, and calls for papers for 2012 conferences.

Percona Live MySQL Conference & Expo call for papers opens soon. http://www.percona.com/live/mysql-conference-2012/

A session matrix for all of the MySQL sessions at Oracle OpenWorld is at http://bit.ly/oow11mysql.

MySQL Community Reception (free, no need to be registered to Oracle OpenWorld) - Tuesday, October 4, 2011 7-9 pm at the San Francisco Marriott Marquis Foothill G. RSVP for the *free* MySQL Community Reception.

…

We sent out this week the September special edition of the MySQL newsletter, which is focused on Oracle OpenWorld.

If you haven’t received it yet or do not subscribe, you can see it here.

This year we have a very impressive lineup of MySQL activities at OpenWorld, including:

• 14 MySQL sessions put together by the IOUG/MySQL Community on Sunday
• 31 MySQL sessions in the main database track
• 3 Demo Pods
• 1 Hands-on Labs
• Last but not least, the MySQL Community Reception on Tuesday at 7.00 pm at the Marriott Marquis! Wei-Chen blogged about it a couple of days ago and we hope to see you there if you’re attending OpenWorld or if you’re local.

You …

We sent out this week the September special edition of the MySQL newsletter, which is focused on Oracle OpenWorld.

If you haven’t received it yet or do not subscribe, you can see it here.

This year we have a very impressive lineup of MySQL activities at OpenWorld, including:

• 14 MySQL sessions put together by the IOUG/MySQL Community on Sunday
• 31 MySQL sessions in the main database track
• 3 Demo Pods
• 1 Hands-on Labs
• Last but not least, the MySQL Community Reception on Tuesday at 7.00 pm at the Marriott Marquis! Wei-Chen blogged about it a couple of days ago and we hope to see you there if you’re attending OpenWorld or if you’re local.

You …

Oracle users across the globe keep searching for easier ways to accomplish time consuming tasks, or keep searching for the solutions of errors and issues and then often land on valuable blog posts. In quest for this Log Buffer Edition, we also landed upon some chic blog posts across database technologies and hence this Log [...]

In our last episode we started building up our online bookshop database, with tables for publishers, authors, formats and books.  At the moment we only have one book in there, so before we go too far, lets add a few more:

INSERT INTO `book` VALUES
 ( NULL, 'The Big Score', 2, 4, 1, '2007-01-01',  9781741752236, 29.95 ),
 ( NULL, 'Split', 3, 2, 1, '2003-01-01', 0732268133, 29.95 );

So what is this NULL thing, and why have I used it?  If you remember we set the first field to an auto_increment id.  Because we don't want to supply a value for this, but let the database create the next value, we need to give a value that indicates we want this to happen.  For this instance, NULL is the value to use.  We must supply a value because we didn't restrict our insert by supplying a …

Often I think about challenges that organizations face with “Big Data”.  While Big Data is a generic and over used term, what I am really referring to is an organizations ability to disseminate, understand and ultimately benefit from increasing volumes of data.  It is almost without question that in the future customers will be won/lost, competitive advantage will be gained/forfeited and businesses will succeed/fail based on their ability to leverage their data assets.

It may be surprising what I think are the near term challenges.  Largely I don’t think these are purely technical.  There are enough wheels in motion now to almost guarantee that data accessibility will continue to improve at pace in-line with the increase in data volume.  Sure, there will continue to be lots of interesting innovation with technology, but when organizations like …

As Giuseppe Maxia recently posted we released Tungsten Replicator 2.0.4 this week.  It has a raft of bug fixes and new features of which one-line installations are the single biggest improvement.  I set up replicators dozens of times a day and having a single command for standard cluster topologies is a huge step forward.  Kudos to Jeff Mace for getting this nailed down.

So what's next?  You can get see what we are up to in general by looking at our issues list.  We cannot do everything at once, but here are the current priorities for Tungsten Replicator 2.0.5.

• Parallel replication speed and robustness. …