There was once a big hooplah about the MySQL Storage Engine Architecture and how it was easy to just slot in some other method of storage instead of the provided ones. Over the years I’ve repeatedly mentioned how this[Read more...]
|Showing entries 1 to 30 of 30|
One of the most complicated aspects of putting together our database landscape map was dealing with the growing number of (particularly NoSQL) databases that refuse to be pigeon-holed in any of the primary databases categories.
I have begun to refer to these as “multi-model databases” in recognition of the fact that they are able to take on the characteristics of multiple databases. In truth though there are probably two different groups of products that could be considered “multi-model”:
True multi-model databases that have been designed specifically to serve multiple data models and use-cases
FoundationDB, which is being designed to
451 Research’s 2013 Database survey is now live at http://bit.ly/451db13 investigating the current use of database technologies, including MySQL, NoSQL and NewSQL, as well as traditional relation and non-relational databases.
The aim of this survey is to identify trends in database usage, as well as changing attitudes to MySQL following its acquisition by Oracle, and the competitive dynamic between MySQL and other databases, including NoSQL and NewSQL technologies.
There are just 15 questions to answer, spread over five pages, and the entire survey should take less than ten minutes to complete.
All individual responses are of course[Read more...]
One of the leading performance gurus, Kellyn Pederson is letting us know how she is finding the initial months at Pythian and she rightly praises her fabulous team mates Mark Brinsmead, Paul Logan, and Andy Klock.
The famous Oracle Database Junkie – Arup Nanda, blogs more about Interested Transaction Lists.
Universal Connection Pool, Oracle’s next[Read more...]
Brief pause of that Sudoku series : I’m working on my object-relational mapping framework code-named Eth.
It’s vaguely similar to Glorp but much simpler and not as intelligent as Glorp. This time, the resurrection of my framework is more like… a rewrite from scratch. It all started on VAST, then I ported it to Dolphin then Squeak and now Pharo. Hopefully, now I will spend more time writing it than porting it! Also, it will exclusively support Pharo. I also decided to write some SUnit tests to make sure I can properly handle PostgreSQL, MySQL and Interbase for the first version. But I am also planning on supporting SQL Server, Oracle, DB2,[Read more...]
Welcome to Log Buffer, the weekly news update of happenings in the database world.
A big shout out to Pythian team members Andrey, Gwen, Fahd, and Don for their submissions. We have lots of news and recommended reading this week so let’s get going with Log Buffer #209.[Read more...]
I’m back in the blogosphere!
This blog will focus on Smalltalk (mostly Pharo, Squeak, Dolphin, VAST and VW), databases (usually MySQL, PostgreSQL, SQL Server, DB2, InterBase and Firebird), algorithms and open source tools. I’ll throw in some literature, music and mathematics occasionally.
Requirements to enjoy this blog : an interest in problem solving, a database and a Smalltalk environment!
A very warm welcome to the Log Buffer, the premier medley of fresh information culled from the blogs related to the technology which stores the world, yes, the databases.
In this edition, the Log Buffer #205, we have yet again found the pulse of the industry.
It’s always very informative and exciting to know about internals of RAC Stuff like what actually is maintained in the Voting Disk . Riyaj has it[Read more...]
Welcome to Log Buffer, the weekly roundup of happenings in the database world.
Lots to cover this week, so let’s get on with Log Buffer #204. Enjoy!
Pythian’s Gwen Shapira dabbles with MySQL and explores MySQL troubleshooting for the Oracle DBA.[Read more...]
This is the 182nd edition of Log Buffer, the weekly review of database blogs. Make sure to read the whole edition so you do not miss where to submit your SQL limerick!
This week started out with me posting about International Women’s Day, and has me personally attending Confoo (Montreal) which is an excellent conference I hope to return to next year. I learned a lot from confoo, especially the blending nosql and sql session I attended.[Read more...]
Hello and welcome to Log Buffer #180. Time’s a-wastin’, so let’s go!
There was so much Oracle stuff this week that I’ve decided to cram a little more of it into Log Buffer by providing a little less context than usual.
Jonathan Lewis shares an explication of aliases: “I was asked the following question recently: ‘Does the use of table aliases affect performance?’ To which the best answer is probably ‘Yes, though in general you probably won’t notice the difference and there are reasons more imporant [sic] than performance for using table aliases.’”
Doug Burns continues his most recent series:[Read more...]
Welcome to the 160th edition of Log Buffer, the weekly review of database blogs.
Blame it on MyISAM, says Mark Callaghan of High Availability MySQL, on considering sql_mode and type coercion. “I think that MyISAM has its place,” writes Mark. “It does fast table scans, but InnoDB is much faster on just about everything else. I am just not thrilled with the impact it has had on MySQL.”
Not that those other engines are without flaw. Peter Zaitsev reports on an InnoDB performance gotcha with larger[Read more...]
This is the 158th edition of Log Buffer, the weekly review of database blogs.
Simon Sabin has a TSQL Challenge – counting non zero columns. He says, “I’m working on a project where I need to cycle a flag amongst a set of columns. To achieve this I am storing a position value in each column which allows me to cycle them . . . So the challenge is to find out the how many non zero columns there are, the twist is to use as little code as possible.”
On a cue from Simon, Aaron[Read more...]
Welcome to the 154th edition of Log Buffer, the weekly review of database blogs. Let’s dive right in, shall we?
On Radio Free Tooting, Andrew Clarke says, “No SQL, so what?” taking as his keynote something Nuno Souto said: “ . . . Google, Facebook, Myspace, Ning etcetc, and what they do as far as IT goes, are absolutely and totally irrelevant to the VAST majority of enterprise business.”
On The Dutch[Read more...]
This is the 153rd edition of Log Buffer, the weekly review of database blogs.
Let’s start by revisiting a perennial issue with Craig Mullins addresses with the question, Are DBAs Obsolete? “Before we go any further, let me briefly answer the question posed in the title of this blog entry: ‘No Way!’,” writes Craig. “Every time I hear this it makes me shake my head sadly as I regard just how gullible IT publications can be.” He argues that an Internet-paced attitude regarding the work of the DBA may be the first culprit in the devaluation of the DBA’s work.
Dion Cho, the[Read more...]
Welcome to the 151st edition of Log Buffer, the weekly review of database blogs. We’re going to take a fast tour through the best blogs from the week gone by, beginning this time, with Oracle.
Jonathan Lewis writes, “It occurred to me recently that I might be making casual use of terms that weren’t necessarily very well known to the less experienced user. So I’ve decided to build a glossary of terms – and I’ll try to add to it from time to time whenever I have a few minutes.”
Jonathan might want to add “Method R” to the glossary. Cary[Read more...]
This is the 150th edition of Log Buffer, the weekly review of database blogs. Someone accidentally left Dave Edwards‘ cage unlocked, and he escaped, thus leaving me with the pleasurable duty of compiling the 150th weekly Log Buffer.
Many people other than Dave are finding release this week. Giuseppe Maxia explains some details of MySQL’s New Release Model. Andrew Morgan announces a New MySQL Cluster Maintenance Release. Aleksandr Kuzminsky of the MySQL Performance Blog releases[Read more...]
CREATE TABLE `people` (
`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY,
This is the 148th edition of Log Buffer, the weekly review of database blogs. Welcome.
Since PGCon ‘09 has concluded not long ago (and not far away), let’s start with Postgres stuff, much of which has to do with the convention.
Josh Berkus was there, of course, and he sends two detailed[Read more...]
Welcome to the 147th edition of Log Buffer, the weekly review of database blogs.
Let’s start this week, with blogs from the SQL Server world, where a number of excellent technical posts appear. Alexander Kuznetsov surprises his readers with this assertion: without ORDER BY, there is no default sort order. “Sounds trivial? Right, but different flavors of this myth still persist. . . . Because apparently many visitors agreed with this myth, I decided to post a repro script which demonstrates that this is simply not true.”
That assumes that Oracle will allow the development of MySQL to stagnate, either deliberately or through neglect - something that we have expressed our doubts about, but even if that were the case it appears that the GPL (or more to the point MySQL’s dual licensing strategy) may restrict the potential for MariaDB.
Curt Monash recently raised the question of whether closed-source storage engines can be used with MySQL (and, by[Read more...]
A year ago, the outline was being written. A lot of work was crammed into the intervening months, and I am happy and proud to announce that the MySQL Administrator’s Bible has been published, and is sitting on the shelf at many major booksellers already. The official publication date is today — Monday, May 11th, 2009 — although some stores have had copies for a week, including Amazon.com.
The MySQL Administrator’s Bible, published by Wiley Press (available on Amazon.com at http://www.amazon.com/MySQL-Administrators-Bible-Sheeri-Cabral/dp/0470416912/, fully covers how to administer MySQL 5.1. It is suitable for people new to MySQL, although as an experienced MySQL DBA I can say that I learned a lot while researching and writing this book, and I believe that even veteran[Read more...]
Welcome to the 145th edition of Log Buffer, the weekly review of database blogs.
Since MySQL was surely the belle of the bloggers’ ball this week—why, everyone was talking—let’s begin with it.
Baron Schwartz started something with his post examining why MySQL might not benefit from having a mother ship. Dean Ellis of niflheim responded, arguing that everyone needs the MySQL mothership. And that got Sheeri’s Cabral’s attention—she took[Read more...]
This edition of Log Buffer is my first article on the Pythian Blog. It seems appropriate that, as I start a new chapter of my life in Canada and am looking to the future, a lot of the blogs this week are doing the same.
After the shock of the Oracle takeover the MySQL community is full of hope. Mark Callaghan has written about the new storage engines for MySQL and also suggestions for what the MySQL community could be doing while they wait to hear what Oracle has planned.
Kaj Arno has looked to the future and he thinks he has found some answers.[Read more...]
This is the 143rd edition of Log Buffer, the weekly review of database blogs.
So . . . Anything happen while I was away?
Okay, so I heard the big news. And just in case you haven’t, here it is from Sheeri Cabral: Oracle Buys Sun. This is a sea-change in the hi-tech world, and the DB part of it will also get rocked, Sun being the home of MySQL. There’s lots of comment in Sheeri’s post, and indeed, all over the database blogging world. I will try here to cover the best of it.
First, Monty Says:[Read more...]
Oracle buys Sun. Sun previews MySQL update, makes GlassFish Portfolio, OpenSSO and OpenDS available on EC2. Numerous partner announcements from the MySQL conference. Red Hat maps open source adoption. And more.
Follow 451 CAOS Links live @caostheory
Oracle to acquire Sun
Unless you’ve been living under a rock (or like me you decided to take a few inappropriately-timed days off) you probably noticed that Oracle announced an agreement to acquire Sun this week. Jay delivered our assessment on Oracle’s open source credentials, while I followed up with some
This is the 140th edition of Log Buffer, the weekly review of database blogs. Welcome.
Let us begin with Oracle this week. Dan Norris illustrates how to start database services automatically after instance startup. He says, “Services are an essential component for managing workload in a RAC environment. If you’re not defining any non-default services in your RAC database, you’re making a mistake.”[Read more...]
Welcome to the 139th edition of Log Buffer, the weekly review of database blogs. Let us begin with a look at the best from the Oracle ’sphere.
Many of you might be considering some more training or certification. Coskan Gundogar has already been there, and has returned with the tale to tell, What I learned during Oracle SQL Expert Exam Study Part-1.[Read more...]
Welcome to the 138th edition of Log Buffer, the weekly review of database blogs. If you aren’t aware of who I am, my name is Nick and I am a Senior DBA at The Pythian Group. This is my second run at hosting Log Buffer, and I hope you will enjoy it as much as I did creating it.
Sticking with IBM, I thought[Read more...]
Welcome to the 135th edition of Log Buffer, the weekly review of database blogs.
How about a little DB2 news to whet the palette? On IT, Life, DB2 pureXML, House Construction, Henrik Loeser Friedrichshafen has an item about Organic Food and pureXML. Completely unrelated! In the on-topic second part of this duo, Henrik relates the news: “I am happy to tell you that the so far separately priced pureXML feature will now be included in the core DB2 for Linux, UNIX, and Windows.” And relevant links are included in this blog.
On the DB2PORTAL Blog, Craig[Read more...]
|Showing entries 1 to 30 of 30|