Tag: Table

Feed: The Internet of Things on AWS – Official Blog. Author: Alex Oleynikov. BackgroundClearScale was founded in 2011, with a focus on delivering best-of-breed cloud systems integration, application development, and managed services. We are an AWS Premier Consulting Partner with competencies in Migration, DevOps, Marketing & Commerce, Big Data, and Mobile. Our experienced engineers, architects, and developers are all certified or accredited by AWS. We have a long track record of successful IoT projects and the proven ability to design and automate IoT platforms, build IoT applications and create infrastructure on which connected devices can easily and securely interact with ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Justin De Castri. Connected devices have found their way into a myriad of commercial and consumer applications. Industries have already moved, or are in the process of moving to, operational models that require them to measure broad data points in real time and optimize their operations based on their analysis of this data. The move to smart connected devices can become expensive if expensive components must be upgraded across the infrastructure. This blog post explores how AWS IoT can be used to gather remote sensor telemetry and control legacy ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: JimmyWongMS. To see the Attunity connectors in the SSIS Toolbox, you always have to install the version of the connectors that targets the same version of SQL Server as the version of SQL Server Data Tools (SSDT) installed on your computer. (You may also have earlier versions of the connectors installed.) This requirement is independent of the version of SQL Server that you want to target in your SSIS projects and packages.+ For example, if you’ve installed the latest version of SSDT, you have version 17 of SSDT with a build ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Michael Garcia. Connectivity is a key element to evaluate when designing IoT systems as it will weigh heavily on the performance, capabilities, autonomy of battery powered objects, and cost of the overall solution. There is no one network that fits all scenarios which is why AWS partners with many different network providers. By partnering, you can then choose the most relevant network to satisfy your business requirements. In this blog post, we’ll explore providing LPWAN connectivity to your objects using the Sigfox network. Pierre Coquentin (Sigfox – Software Architect) ... Read More

Feed: The Internet of Things on AWS – Official Blog. Author: Justin De Castri. Connected devices have found their way into a myriad of commercial and consumer applications. Industries have already moved, or are in the process of moving to, operational models that require them to measure broad data points in real time and optimize their operations based on their analysis of this data. The move to smart connected devices can become expensive if expensive components must be upgraded across the infrastructure. This blog post explores how AWS IoT can be used to gather remote sensor telemetry and control legacy ... Read More

Feed: Severalnines. In this blog post, we are going to show you some examples of things that can go wrong in Galera - inexplicable node crashes, network splits, clusters that won’t restart and inconsistent data. We’ll take a look at the data stored in log files to diagnose the problems, and discuss how we can deal with these. This builds upon the previous post, where we looked into log files produced by Galera (error log and innobackup.* logs). We discussed how regular, “normal” activity looks like - from initialization of Galera replication to Incremental State Transfer (IST) and State Snapshot ... Read More

Feed: Severalnines. Requires ClusterControl 1.2.11 or later. Applies to MySQL single instances, replications and Galera clusters. You have created a large database with thousands of tables (> 5000 in MySQL 5.6). Then you want to create a backup using xtrabackup. Or, if it is a Galera cluster, you have to recover a galera node using wsrep_sst_method=xtrabackup[-v2]. Unfortunately it fails and the following is emitted in the Job Logs messages: xtrabackup: Generating a list of tablespaces 2015-11-03 19:36:02 7fdef130a780 InnoDB: Operating system error number 24 in a file operation. InnoDB: Error number 24 means 'Too many open files'. InnoDB: Some operating ... Read More

Feed: Severalnines. Nginx is well-known for its ability to act as a reverse-proxy with small memory footprint. It usually sits in the front-end web tier to redirect connections to available backend services, provided these passed some health checks. Using a reverse-proxy is common when you are running a critical application or service that requires high availability. It also distributes the load equally among the backend services. Recently, nginx 1.9 introduced support for TCP load balancing - similar to what HAProxy is capable of. The one major drawback is that it does not support advanced backend health checks. This is required ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: circle_liu. Hi All, We are pleased to announce that an updated version of SQL Server Integration Services Feature Pack for Azure is now available for download. This release mainly has following improvements: Support for Azure Data Lake Store Support for Azure SQL Data Warehouse Here are the download links for the supported versions: SSIS 2012: https://www.microsoft.com/en-us/download/details.aspx?id=47367 SSIS 2014: https://www.microsoft.com/en-us/download/details.aspx?id=47366 SSIS 2016: https://www.microsoft.com/en-us/download/details.aspx?id=49492 Azure Data Lake Store Components 1.In order to support Azure Data Lake Store (ADLS), SSIS add below two components: Azure Data Lake Store Source: User can use ADLS Source ... Read More

Feed: SQL Server Integration Services (SSIS) Official Blog. Author: DionYe. In 2008, SSIS team posted a blog about loading 1TB data in 30 minutes, and after 8 years, hardware and software are rapidly improved, now we are doing similar experiment with only on two servers which can achieve same performance. In our experiment, we use the latest SSIS 2016 and we can load 1TB data in 30 minutes (1.5TB dataset in 43 minutes). In addition, we also tested data loading into table with column store index and provide the details in end this article Design of this experiment is almost ... Read More