SQL Zone is brought to you in partnership with:
  • submit to reddit
Gen Furukawa11/26/14
0 replies

How (And Why) Make Read-only Versions of Your SQL and MySQL Databases

Of course, there are as many reasons to set a database to read-only -- temporarily or permanently -- as there are databases. Here's a rundown on the ways to lock the content of a SQL or MySQL database while allowing users to access its contents.

Lisa Schultz11/25/14
0 replies

Say What? RDBMSs are Not Legacy Technology

Someone’s been saying that relational database management systems (RDBMSs) are “legacy technology”. We wholeheartedly disagree, so we’re taking the time to exercise our first amendment rights as well, chiming in on the topic.

Lukas Eder11/21/14
4 replies

Don't Migrate to MariaDB Just Yet. MySQL Is Back!

Now that I have your attention, I’d like to invite you to a critical review of where we’re at in the MySQL vs. MariaDB debate.

Gen Furukawa11/20/14
0 replies

Morpheus Lessons: Best Practices for Upgrading MySQL

Thinking about upgrading your MySQL database? When performing an upgrade, there are some factors you need to consider and some best practices that can be followed to help ensure the process goes as smoothly as possible.

Andreas Kollegger11/19/14
0 replies

Neo4j + Docker + CoreOS, a (Gentle) Guided Introduction

I’d like to share with everyone how awesome CoreOS is for leveraging Docker. We use this set up for our search proxy here at Swig (a community for drink enthusiasts for iOS and Android). Neo4j is used as our database and as stated in my previous blog post, it works brilliantly as a startup-friendly (read: flexible) database.

Peter Zaitsev11/18/14
0 replies

Data Inconsistencies on MySQL Replicas: Beyond pt-table-checksum

Percona Toolkit’s pt-table-checksum is a great tool to find data inconsistencies between a MySQL master and its replicas. However, you may want to know which exact rows are different to identify the statements that created the inconsistency.

Lukas Eder11/15/14
0 replies

Have You Ever Wondered About the Difference Between NOT NULL and DEFAULT?

When writing DDL in SQL, you can specify a couple of constraints on columns, like NOT NULL or DEFAULT constraints. Some people might wonder, if the two constraints are actually redundant, i.e. is it still necessary to specify a NOT NULL constraint, if there is already a DEFAULT clause?

Pat Shaughnessy11/14/14
0 replies

Following a Select Statement Through Postgres Internals

This post is an informal journal of my trip through the guts of Postgres. I’ll describe the path I took and what I saw along the way. I’ll use a series of simple, conceptual diagrams to explain how Postgres executed my query.

Peter Zaitsev11/14/14
0 replies

Percona Live London 2014 Wrap Up

The 2014 edition of Percona Live London brought together attendees from 30 countries to hear insightful talks from leaders in the MySQL community. The conference kicked off on Monday with a full day of tutorials followed by the very popular Community Dinner featuring a double decker bus shuttle from the conference to the event.

Peter Zaitsev11/14/14
0 replies

Percona Live MySQL Conference Call for Proposals Closes Nov. 16

Submit your speaking proposals now for tutorials or breakout session on the Percona Live conference website. Accepted speakers receive a full conference pass and the sincere gratitude of attendees who will eagerly await your presentations.

Peter Zaitsev11/12/14
0 replies

How to Deal with MySQL Deadlocks

A deadlock in MySQL happens when two or more transactions mutually hold and request for locks, creating a cycle of dependencies. In a transaction system, deadlocks are a fact of life and not completely avoidable.

Vlad Mihalcea11/11/14
2 replies

An Entity Modelling Strategy for Scaling Optimistic Locking

Optimistic locking discards all incoming changes that are relative to an older entity version. But everything has a cost and optimistic locking makes no difference.

Lukas Eder11/11/14
3 replies

Painless Access from Java to PL/SQL Procedures with jOOQ

PL/SQL is one of those things. Most people try to stay clear of it. Few people really love it. I just happen to suffer from stockholm syndrome, since I’m working a lot with banks.

G. Ryan Spain11/10/14
0 replies

The Best of the Week (Oct. 31): SQL Zone

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (October 31 - November 07). Including Hibernate Collections Optimistic Locking, MySQL full text search Q&A, and an interview with Facebook MySQL DB engineers.

Val Huber11/10/14
0 replies

Why Use REST for Data Access

In the last two blogs, we tackled the issue of how REST is a solution to a connected enterprise. In this blog, we will discuss the reasons for REST emerging as the default standard for data access. There are various reasons for adopting REST as the underlying layer for data access.

Peter Zaitsev11/08/14
0 replies

Backup and Restore of MySQL to OpenStack Swift

MySQL database usage is popular in OpenStack. Core OpenStack services for Compute (Nova), Storage (Cinder), Neutron (Networking), Image (Glance) and Identity (Keystone) all use MySQL database.

Gen Furukawa11/07/14
0 replies

How to Handle Huge Database Tables

There's more than one way to 'split' a table.

Joydeep Das11/07/14
0 replies

Understanding the Execution Plan [When Table JOIN Occurs Part-III]

Continuing our journey here we see some others operators exist in our execution plan. Here is the query and Execution Plan that we are working from couple of weeks.

Abishek Baskaran11/06/14
0 replies

Back to Learning Grammar with ANTLR

This post is going to be about language processing. Language processing could be anything like an arithmetic expression evaluator, a SQL parser or even a compiler or interpreter. Many times when we build user facing products, we give users a new language to interact with the product.

Joydeep Das11/05/14
0 replies

Understanding the Execution Plan [When Table JOIN occurs Part-II]

Continuing my previous article Understanding Execution Plan [ When Table JOIN occurs Part – I ], here we are describing the other process of Execution Plan.

Vlad Mihalcea11/04/14
0 replies

Hibernate Collections Optimistic Locking

Hibernate provides an optimistic locking mechanism to prevent lost updates even for long-conversations.

Peter Zaitsev11/04/14
0 replies

Facebook MySQL database engineers ready for Percona Live London 2014

I spoke with Facebook database engineers Yoshinori “Yoshi” Matsunobu and Shlomo Priymak about their upcoming sessions along with what’s new at Facebook since our last conversation back in April.

Joydeep Das11/03/14
0 replies

Understanding the Execution Plan [When Table JOIN occurs Part-I]

In my previous article we are just using a single table as per our example is concern, Now in this article we are going to see the different table join each other’s and make a single data set by using JOIN.

G. Ryan Spain11/02/14
0 replies

The Best of the Week (Oct. 24): SQL Zone

Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone (October 24 - October 31). Here they are, in order of popularity.

Peter Zaitsev10/31/14
0 replies

MySQL 5.6 Full Text Search Throwdown: Webinar Q&A

Yesterday (Oct. 22) I gave a presentation titled “MySQL 5.6 Full Text Search Throwdown.” If you missed it, you can still register to view the recording and my slides. Thanks to everyone who attended, and especially to folks who asked the great questions. I answered as many as we had time for during the session, but here are all the questions with my complete answers