SQL Zone is brought to you in partnership with:
  • submit to reddit
Peter Zaitsev10/24/14
1 replies

How to Avoid Hash Collisions When Using MySQL’s CRC32 Function

Percona Toolkit’s pt-table-checksum performs an online replication consistency check by executing checksum queries on the master, which produces different results on replicas that are inconsistent with the master – and the tool pt-table-sync synchronizes data efficiently between MySQL tables.

Rajat Jaiswal10/24/14
0 replies

Grouping Sets: Good to Know Feature TIP# 60

Grouping sets is one of the cool feature came in SQL SERVER 2008. Lets understand here with problem and solution.

Rob Sanders10/23/14
0 replies

Server and Storage Tuning

This week at work, I’ve spent a fair amount of time working in the infrastructure space as we conducted a review of SQL Server and the underlying network infrastructure. As always, it inspired me to take a look at my home configuration – and do some tinkering.

Brian O' Neill10/22/14
0 replies

Sqoop Oracle Example : Getting Started with Oracle -> HDFS Import/Extract

In this post, we'll get Sqoop (1.99.3) connected to an Oracle database, extracting records to HDFS.

Rajat Jaiswal10/22/14
0 replies

Find Last Statistics Updated Date Detail: Maintenance TIP #59

One of the pain points for any SQL engineer is “Performance”. There are various reasons due to which your SQL Server database is slow.

Lukas Eder10/21/14
6 replies

Stop Claiming That You’re Using a Schemaless Database

One of MongoDB’s arguments when evangelising MongoDB is the fact that MongoDB is a “schemaless” database... But it doesn’t mean that there is no schema.

Peter Zaitsev10/20/14
0 replies

MySQL Compression: Compressed and Uncompressed Data Size

MySQL has information_schema.tables that contain information such as “data_length” or “avg_row_length.” Documentation on this table however is quite poor, making an assumption that those fields are self explanatory – they are not when it comes to tables that employ compression.

Joydeep Das10/18/14
0 replies

Understanding of Execution Plan - III - B [ The OPERATORS ]

IN my previous Article we focused on Cluster Index Scan and Clustered Index Seek operators. Continuing my Article series named Understanding of Execution Plan – part III, we are moving on with some other operators.

Joydeep Das10/17/14
0 replies

Understanding of Execution Plan - III - A [ The OPERATORS ]

In this article we are mostly focusing on the Logical and Physical Operators and trying to understand each as it is very important to understand them before understanding the Execution Plan.

Peter Zaitsev10/16/14
0 replies

MySQL Ring Replication: Why It Is a Bad Option

I’ve recently worked with customers using replication rings with 4+ servers; several servers accepting writes. The idea behind this design is always the same: by having multiple servers, you get high availability and by having multiple writer nodes, you get write scalability.

Rajat Jaiswal10/16/14
0 replies

Good to Know SQL JARGON - An interview TIP #56

Hello friends, just wanted to share some technical words here again...

Sayem Ahmed10/15/14
0 replies

JPA Tutorial: Mapping Entities – Part 3

When field access mode is used, JPA directly reads the state values from the fields of an entity using reflection.

Peter Zaitsev10/15/14
0 replies

MySQL Replication: 'Got fatal error 1236' Causes and Cures

MySQL replication is a core process for maintaining multiple copies of data – and replication is a very important aspect in database administration. In order to synchronize data between master and slaves you need to make sure that data transfers smoothly, and to do so you need to act promptly regarding replication errors to continue data synchronization.

Kathiravelu Pra...10/15/14
1 replies

Fault-Tolerant Data Replication and Synchronization with Infinispan

Having multiple instances running over different nodes provide fault-tolerance, as when one node terminates, the other nodes have the backup replica of the partitions stored in the terminated node.

Peter Zaitsev10/13/14
0 replies

Percona XtraBackup 2.2.5 Now Available (Free MySQL Hot Backup Software)

Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime.

Anders Karlsson10/11/14
0 replies

OraMySQL 1.0 Alpha Released - Replication from Oracle to MariaDB and MySQL!!

Now it's time to release something useful! At least I hope so. I have been going through how I came up with this idea and how I came up with the implementation in a series of blog posts, but now it's time for the real deal, the software itself.

G. Ryan Spain10/10/14
1 replies

SQLite - Now 50% Faster!

SQLite developer Richard Hipp posted recently that the database has become 50% faster than it was 16 months ago.

Anders Karlsson10/10/14
0 replies

Replication from Oracle to MariaDB the Simple Way - Part 4

Now it's time to get serious about replicating to MariaDB from Oracle, and we are real close now, right?

Anders Karlsson10/09/14
0 replies

Replication from Oracle to MariaDB the Simple Way - Part 3

In this third installment in this series, I'll explain why the smart solution I described in the previous post actually wasn't that good, and then I go on to explain how to fix it, and why that fix wasn't such a smart thing after all.

Anders Karlsson10/08/14
1 replies

Replication from Oracle to MariaDB the Simple Way - Part 2

The theme for this series of posts is, and indicated in the previous post, "Try and try, again", and there will be more of this now when I start to make this work by playing with Oracle, with PL/SQL and with the restrictions of Oracle Express.

Mark Needham10/07/14
0 replies

PostgreSQL: ERROR: Column Does Not Exist

A short article about the troubles that letter case can cause in PostgreSQL queries.

Anders Karlsson10/07/14
0 replies

Replication from Oracle to MariaDB the Simple Way - Part 1

Yes, there is a simple way to do this. Although it might not be so simple unless you know how to do it, so let me show you how this can be done. It's actually pretty cool.

Peter Zaitsev10/07/14
0 replies

Percona Server, OpenStack and the Tesora DBaaS Platform

The Tesora platform is an enterprise-ready database as a service (DBaaS) platform based on the OpenStack Trove project. Percona Server was certified by Tesora in August as part of their Tesora DBaaS Platform certification program.

Sayem Ahmed10/06/14
2 replies

JPA Tutorial: Mapping Entities – Part 2

How should we override the default table names to match the existing data model?