TheBestoftheWeek(May16):SQLZone_MySQL

来源：动视网责编：小采时间：2020-11-09 19:19:46

TheBestoftheWeek(May16):SQLZone_MySQL

TheBestoftheWeek(May16):SQLZone_MySQL:Make sure you didn't miss anything with this list of the Best of the Week in theSQL Zone(May 16 to May 22). Here they are, in order of popularity:1.The PostgreSQL Datatypes You Aren't UsingYou're probably not using all the datatypes availab

推荐度：

点击下载本文 文档为doc格式

导读TheBestoftheWeek(May16):SQLZone_MySQL:Make sure you didn't miss anything with this list of the Best of the Week in theSQL Zone(May 16 to May 22). Here they are, in order of popularity:1.The PostgreSQL Datatypes You Aren't UsingYou're probably not using all the datatypes availab

Make sure you didn't miss anything with this list of the Best of the Week in theSQL Zone(May 16 to May 22). Here they are, in order of popularity:

1.The PostgreSQL Datatypes You Aren't Using

You're probably not using all the datatypes available to you in PostgreSQL - there are actually quite a few. And that's not to say you should be using all of them, but it's always interesting to know what's out there, and to that end, Craig Kerstiens has made a list with descriptions and warnings.

2.Errant Transactions: Major Hurdle for GTID-Based Failover in MySQL 5.6

The author previously written about the new replication protocol that comes with GTIDs in MySQL 5.6. Because of this new replication protocol, you can inadvertently create errant transactions that may turn any failover to a nightmare. Let’s see the problems and the potential solutions.

3.SQL Server Trick: Circumvent Missing ORDER BY Clause

SQL Server is known to have a very strict interpretation of the SQL standard. In this article, the author discusses a number of ways to handle ORDER BY clauses in SQL Server.

4.High Availability with MySQL Fabric: Part I

Today, the author will review MySQL Fabric’s HA concepts, and then walk you through the setup of a 3-node cluster with one Primary and two Secondaries, doing a few basic tests with it.

5.Mobilize and Restify your SQL Data

Full-featured back-office Mobile apps in minutes, with RESTful APIs for front-office apps. Declarative logic and security - simple and powerful as a spreadsheet. JavaScript for complex logic and integration. Here’s two new technologies that make it possible.