Tag: query

Feed: CDH – Cloudera Engineering Blog. Author: Adam Smieszny. Several weeks ago, I set about to demonstrate the ease with which Solr and Map/Reduce can be integrated. I was unable to find a simple, yet comprehensive, primer on integrating the two technologies. So I set about to write one. What follows is my bare-bones tutorial on getting Solr up and running to index each word of the complete works of Shakespeare. Note: Special thanks to Sematext for looking over the Solr bits and making sure they are sane. Check them out if you’re going to be doing a lot of ... Read More

Feed: Percona Database Performance Blog. Author: Borys Belinsky. Borys Belinsky  | July 28, 2017 |  Posted In: Events and Announcements, MySQL PREVIOUS POST Percona is glad to announce the GA release of Percona Server for MySQL 5.7.18-16 on July 28, 2017 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.7.18, including all the bug fixes in it, Percona Server for MySQL 5.7.18-16 is the current GA release in the Percona Server for MySQL 5.7 series. All of Percona‘s software is open-source and free, and you can find all the release details in the 5.7.18-16 milestone at Launchpad Please note that RHEL 5, CentOS 5 and Ubuntu versions 12.04 and ... Read More

Feed: What's New. Kinesis Analytics is the easiest way to process streaming data in real time with standard SQL without having to learn new programming languages or processing frameworks. Kinesis Analytics enables you to query streaming data or build entire streaming applications using SQL, so that you can gain actionable insights and respond to your business and customer needs promptly. Kinesis Analytics is available in US East (N. Virginia), US West (Oregon), and EU (Ireland) regions. Customers can use AWS CloudFormation to create templates that easily create or update Kinesis Analytics applications. Typically, a template is used as a way ... Read More

Feed: Clustrix Blog. Author: Dave Anselmi. ClustrixDB is a MySQL-compatible ACID RDBMS that linearly scales out both writes and reads. Clustrix has created many architectural innovations over the years that have made this possible. This week we will focus on one of these innovations, the ClustrixDB Rebalancer, that automatically distributes and balances data across nodes while ensuring high availability. Before we go into the details, let’s put this into context. With last week’s blog, we started exploring how ClustrixDB accomplishes horizontal scaling of both writes and reads without sharding. Why is this important? Because other MySQL scaling strategies have challenges with ... Read More

Feed: Google Cloud Big Data and Machine Learning Blog. Author: Google Cloud Big Data and Machine Learning Blog Team. Innovation in data processing and machine learning technology Friday, July 28, 2017 By Reza Rokni, Solutions Architect A common pattern in banking, media and life sciences is the running of “embarrassingly parallel” workloads. In these environments, a large number of compute nodes form a cluster, with nodes independently carrying out processing tasks. In this post, I’ll explain how Google Cloud Dataflow, used in conjunction with other Google Cloud Platform (GCP) services, can unlock these workloads for Google Cloud customers. As these ... Read More

Feed: CDH – Cloudera Engineering Blog. Author: Basier Aziz. Earlier today, Cloudera proudly released the Cloudera Connector for Tableau. The availability of this connector serves both Tableau users who are looking to expand the volume of datasets they manipulate and Hadoop users who want to enable analysts like Tableau users to make the data within Hadoop more meaningful. Enterprises can now extract the full value of big data and allow a new class of power users to interact with Hadoop data in ways they priorly could not. The Cloudera Connector for Tableau is a free ODBC Driver that enables Tableau ... Read More

Feed: Big Data Made Simple - One source. Many perspectives.. Author: Baiju NT. In today’s ultra-competitive business environment, you need all the tools you can get to have that edge over your rivals. And in this respect, BI takes on a very important role. Modern business and organizations strive on data. We’re talking of data that accumulates day in and day out, and that becomes what many call big data. On its own, data that keeps growing everyday has no tactical or strategic benefit to a business. But when that data is processed and analyzed to unravel trends, patterns and ... Read More

Feed: R-bloggers. Author: hrbrmstr. It’s no secret that I’m a fan of Apache Drill. One big strength of the platform is that it normalizes the access to diverse data sources down to ANSI SQL calls, which means that I can pull data from parquet, Hie, HBase, Kudu, CSV, JSON, MongoDB and MariaDB with the same SQL syntax. This also means that I get access to all those platforms in R centrally through the sergeant package that rests atop d[b]plyr. However, it further means that when support for a new file type is added, I get that same functionality without any ... Read More

Feed: Planet PostgreSQL. Citus is Postgres that scales out horizontally. We do this by distributing queries across multiple Postgres servers—and as is often the case with scale-out architectures, this scale-out approach provides some great performance gains. And because Citus is an extension to Postgres, you get all the awesome features in Postgres such as support for JSONB, full-text search, PostGIS, and more. The distributed nature of Citus gives you new flexibility when it comes to modeling your data. This is good. But you’ll need to think about how to model your data and what type of database tables to use ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; MySQL Group Replication: who is the primary master – updated! – lefred's blog: tribulations of a MySQL Evangelist Some time ago I wrote this article explaining how to find which node was the Primary Master in a MySQL Group Replication cluster running in Single-Primary Mode. In the latest release of Group Replication, MySQL 8.0.2 dmr, Jaideep improved the visibility of Group Replication extending the performance_schema tables (see his article). Thanks to these improvements, it’s now very easy to find which host is acting a Primary-Master. This is the query you can use: mysql-sql> SELECT ... Read More