Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

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

DZone's Guide to

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

· Database Zone
Free Resource

Navigating today's database scaling options can be a nightmare. Explore the compromises involved in both traditional and new architectures.

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:

1. Where Is the Database?

  • I have just watched an interesting conversation between Martin Fowler and Badri Janakiraman about #hexagonalrails, and in particular about the role of databases. The central question in the discussion is whether the database should be considered outside or inside the domain.

2. 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.

3. 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

4. Setting up PHP & MySQL on OS X Yosemite

  • Helpful, step-by-step instructions for setting up PHP and MySQL on OS X Yosemite.

5. Percona Toolkit for MySQL with MySQL-SSL Connections

  • I recently had a client ask me how to use Percona Toolkit tools with an SSL connection to MySQL (MySQL-SSL). SSL connections aren’t widely used in MySQL due to most installations being within an internal network. Still, there are cases where you could be accessing MySQL over public internet or even over a public “private” network.


 

Planning for disaster doesn't have to actually be a disaster. Understand your options for deploying a database across multiple data centers - without the headache.

Topics:

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}