Using MySQL as NoSQL

October 25th, 2010

Using MySQL as a NoSQL – A story for exceeding 750,000 qps on a commodity server – how to almost achieve double the Memcached performance using a MySQL UDF that bypasses the SQL layer, talks directly to the InnoDB layer. Wonder if the SQL overhead is similar in Oracle or MS SQL Server, and how you’d work around that there.

Via High Scalability Blog.

Just a quick pointer to the Microsoft SQL Server Migration Assistant (SSMA) Team’s Blog. May come in handy when looking at moving over to SQL Server. Check How To Migrate Oracle’s Sample HR Schema to SQL Server for a run-through with screenshots based on Oracle’s sample schema.

SQL Server Redundancy

September 30th, 2010

Andrew Fryer wrote a reference post about SQL Server Redundancy earlier this month about the pros and cons of clustering and mirroring, so it’s about time I mention it here! His motivation was an internal request at Microsoft:

If there are internal Microsoft staff who don’t know when to use what, then I imagine there must still be confusion in the real world about these two approaches.

Very much so :-) Same principles also apply to Oracle and Sybase, except their integration with Cluster and OS is less tight (yet – probably more to come from Oracle here), and Sybase’s Replication Server doesn’t offer synchronous mirroring.

NoSQL Ecosystem

August 6th, 2010

Jonathan Ellis from the Cassandra project published a fantastic overview of the current NoSQL ecosystem in late 2009. He analyzed 10 popular NoSQL databases along three axes: horizontal scalability, data model and internal persistence design. It’s a great read, and still pretty much valid as of today. I stumbled upon it via Emil Eifrem from Neo4j, who adds some interesting thoughts on scaling to size vs. scaling to complexity. Obviously, scaling is easier for simple stores, but even the complex Graph DBs such as Neo4j scale well beyond what we’re used to see from the RDBMS household names Oracle, Sybase and SQL Server.

Microsoft formally announced its Windows Azure Platform Appliance today, as TechCrunchIT reports.

Dell, eBay, Fujitsu, and HP intend to deploy the appliance in their datacenters to offer new cloud services.

While that’s nice to know, I’m much more interested to hear by when we can get our own appliance, and what the configuration sizes and support requirements are going to be.

On a related note, the SQL CAT team released its SQL Azure Customer Best Practices a while ago.

Check out the SQL Server 2008 R2 Best Practices Analyzer if you’re using SQL Server 2008. Looks to be a handy tool that just came out over the weekend.

  • Gathers information about a Server and a Microsoft SQL Server 2008  or 2008 R2 instance installed on that Server
  • Determines if the configurations are set according to the  recommended best practices
  • Reports on all configurations, indicating settings that differ from  recommendations
  • Indicates potential problems in the installed instance of SQL  Server
  • Recommends solutions to potential problems

The following article also has more info on SQL BPA: Introducing the SQL Server 2008 R2 Best Practices Analyzer (BPA)…