Tag: SQL

Feed: Recent Announcements. The read replicas feature is supported on SQL Server Enterprise Edition in the Multi-AZ configuration using Always On Availability Groups. This feature allows RDS SQL Server customers to offload their read workload from the primary DB instance to the replica, and also supports the scalability of read-heavy workloads over a farm of up to five read replicas. Read replicas can also render another level of availability by allowing you to promote a given read replica as a new standalone database, in the event of a failure of the primary DB instance.  Read replica is billed as a ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Sanjay Nighojkar. By Suraj Nathani, Sr. Solutions Architect at Mactores CognitionBy Anil Patel, Data Engineer at Mactores CognitionBy Sanjay Nighojkar, Manager, Partner Solutions Architect at AWSSeagate Technology is a United States-based data storage company with worldwide manufacturing facilities that generate huge amounts of manufacturing and testing data. With petabytes of data accumulated over 20 years, and more being generated each day, it was imperative for Seagate to have systems in place to ensure the cost of collecting, storing, and processing data did not exceed their return on investment (ROI). Seagate’s on-premises big data ... Read More

Feed: Planet MySQL; Author: Continuent; In this blog post, we talk about the basic function and features of the Tungsten Connector.The Tungsten Connector is an intelligent MySQL proxy that provides key high-availability and read-scaling features. This includes the ability to route MySQL queries by inspecting them in-flight. Connector Basics Understanding the Two Key Features The most important function of the Connector is failover handling. When the cluster detects a failed master because the MySQL server port is no longer reachable, the Connectors are signaled and traffic is re-routed to the newly-elected Master node. Next is the ability to route MySQL ... Read More

Feed: R-bloggers. Author: Unknown. [This article was first published on Deeply Trivial, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. For the letter C, we’ll talk about the coalesce function. If you’re familiar with SQL, you may have seen this function before. It combines two or more variables into a single column, and is a way to deal with missing data. When you give it a list of variables, it selects the first ... Read More

Feed: IBM Big Data & Analytics Hub - All Content; Author: kip-yego; As data proliferates, the need to efficiently undertand, process, and act quickly for competitive advantage continues to increase. Applications must be able to use data swiftly and adapt as needs change by the week or even the day. Developers also require places to store their data that can handle multiple formats and use cases. In order to manage these growing data needs, drive innovation and increase agility via modern application development, enterprises are turning to open-source-based solutions and technologies. The State of Enterprise Open Source report by Red Hat ... Read More

Feed: Planet PostgreSQL. Everybody should to know PostgreSQL's stats views: pg_stat_user_tables, pg_stat_database. There are lot of interesting values. For better interpretation we need a difference of these values in some time. It is impossible to get previous value with clean SQL, but in Postgres we can use PLpgSQL, and we can use custom configure variables as session variables. I wrote function buffer, that returns difference between current value and buffered, and save current value to buffer:CREATE OR REPLACE FUNCTION public.buffer_dif(text, bigint) RETURNS bigint LANGUAGE plpgsql AS $function$ DECLARE r bigint; BEGIN r := $2 - current_setting($1, true)::bigint; PERFORM set_config($1, $2::text, ... Read More

Feed: Recent Announcements. Apache Kafka enables you to perform real time analytics on your data to get insights faster than you would normally see with other data stores. With DMS adding support for Apache Kafka as a target, you don’t need a self-managed streaming data connector and your software development teams can focus more on innovation. For example, you can use DMS to aggregate ongoing change logs and metrics from applications that use multiple data stores such as Oracle, SQL Server, Aurora, MongoDB and many more to produce centralized operational data feeds and monitor everything in one place ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; My previous post related on how to install WordPress on Oracle Cloud seemed to be very popular. To continue the exploration of OCI, today we will install Drupal. This time, even if it’s possible to use the Free Trier like in the WordPress post, I will use a pay account to have the possibility to split the Web Server and the Database into two different subnets. Both instances will have their own subnet and only the Webserver will be reachable directly from the Internet. MySQL will be installed on a private subnet that could ... Read More

Feed: AWS Big Data Blog. Customers use Apache Hive with Amazon EMR to provide SQL-based access to petabytes of data stored on Amazon S3. Amazon EMR 6.0.0 adds support for Hive LLAP, providing an average performance speedup of 2x over EMR 5.29, with up to 10x improvement on individual Hive TPC-DS queries. This post shows you how to enable Hive LLAP, and outlines the performance gains we’ve observed using queries from the TPC-DS benchmark.Twice as fast compared to Amazon EMR 5.29.0 To evaluate the performance benefits of running Hive with Amazon EMR release 6.0.0, we’re using 70 TCP-DS queries with ... Read More

Feed: MemSQL Blog. Author: Floyd Smith. Analyst firm 451 Research has come up with new research that sees a bright future for HOAP – hybrid operational and analytical processing. The report is titled 451 Perspective: A HOAP-ful future for hybrid operational and analytical processing. This new type of processing has received several different names, from different analyst firms and consultancies: By any of these names, this new style of data processing – which unifies transactions and operational analytics, including many data warehousing-type functions – is widely believed to have a bright future. And MemSQL is right in the middle of ... Read More