Tag: JSON

Feed: Planet PostgreSQL. pgBackRest is a well-known powerful backup and restore tool. Relying on the status information given by the “info” command, we’ve build a specific plugin for Nagios : check_pgbackrest. This post will help you discover this plugin and assume you already know pgBackRest and Nagios. Let’s assume we have a PostgreSQL cluster with pgBackRest working correctly. Given this simple configuration: [global] repo1-path=/some_shared_space/ repo1-retention-full=2 [mystanza] pg1-path=/var/lib/pgsql/11/data Let’s get the status of our backups with the pgbackrest info command: stanza: mystanza status: ok cipher: none db (current) wal archive min/max (11-1): 00000001000000040000003C/000000010000000B0000004E full backup: 20190219-121527F timestamp start/stop: 2019-02-19 12:15:27 / ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Richard Elberger. Editor’s note: This is the second of a two-part series on the APN Blog. Read Part 1 >>By Johan Kraft, CEO at Percepio In a previous blog post, we learned how to get started with AWS IoT Core and Amazon FreeRTOS on the NXP OM40007 IoT kit using Percepio Tracealyzer for debugging support. In this post, we will dig deeper into Amazon FreeRTOS and take a closer look at the communication stack for AWS IoT Core. You will also learn how this communication can be analyzed using Percepio Tracealyzer, ensuring your system ... Read More

Feed: Planet PostgreSQL. First off – not trying to kindle any flame wars here, just trying to broaden my (your) horizons a bit, gather some ideas (maybe I’m missing out on something cool, it’s the most used Open Source RDBMS after all) and to somewhat compare the two despite being a difficult thing to do correctly / objectively. Also I’m leaving aside here performance comparisons and looking at just the available features, general querying experience and documentation clarity as this is I guess most important for beginners. So just a list of points I made for myself, grouped in no ... Read More

Feed: Planet MySQL; Author: Severalnines; Migrating from Oracle to MySQL/Percona Server is not a trivial task. Although it is getting easier, especially with the arrival of MySQL 8.0 and Percona announced Percona Server for MySQL 8.0 GA. Aside from planning for your migration from Oracle to Percona Server, you must ensure that you understand the purpose and functionality for why it has to be Percona Server. This blog will focus on Migrating from Oracle to Percona Server as its specific target database of choice. There's a page in the Oracle website about SQL Developer Supplementary Information for MySQL Migrations which ... Read More

Feed: Planet MySQL; Author: Jesper Krogh; The X DevAPI allows you to work with JSON documents and SQL tables at the same time. Furthermore, the CRUD style API is more intuitive than SQL statements for some programmers. Either way, the X DevAPI allows you to mix JSON documents, SQL tables, CRUD methods, and SQL statements to give you the best of all worlds. In MySQL Connector/Python, the X DevAPI is implemented in the mysqlx module. This blog will look at how MySQL Connector/Python handles expressions, and how you in version 8.0.14 and later need to use the mysqlx.expr() method to ... Read More

Feed: DB-Engines.com Blog. Author: Paul Andlinger, Matthias Gelbmann. Blog > Postby Paul Andlinger, Matthias Gelbmann, 19 February 2019Tags: Database models, DB-Engines Ranking, Multi-model DBMSWe recently changed the way we treat the multi-model aspect of database management systems and introduced a new option in the popularity rankings. This article explains the ideas behind. Today, the management, querying and efficient use of vast amounts of structured and unstructured data often requires storing that data with different specialised data models. That may be in tabular form (Relational DBMS), graphs (Graph DBMS), documents in JSON or XML form (Document Stores, XML DBMS), time-series data ... Read More

Feed: AWS Compute Blog. Author: Anuneet Kumar. This post is contributed by Adam McLean – Solutions Developer at AWS and Chirill Cucereavii – Application Architect at AWS In this post, we show you how to automatically refresh the container instances in an active Amazon Elastic Container Service (ECS) cluster with instances built from a newly released AMI. The Amazon ECS-optimized AMI  comes prepackaged with the ECS container agent, Docker agent, and the ecs-init upstart service. We recommend that you use the Amazon ECS-optimized AMI for your container instances unless your application requires any of the following: A specific operating system Custom security and monitoring agents installed ... Read More

Feed: AWS Compute Blog. Author: Anuneet Kumar. This post is contributed by Brent Langston – Sr. Developer Advocate, Amazon Container ServicesLast week, AWS announced enhanced Amazon Elastic Container Service (Amazon ECS) support for GPU-enabled EC2 instances. This means that now GPUs are first class resources that can be requested in your task definition, and scheduled on your cluster by ECS. Previously, to schedule a GPU workload, you had to maintain your own custom configured AMI, with a custom configured Docker runtime. You also had to use custom vCPU logic as a stand-in for assigning your GPU workloads to GPU instances ... Read More

Feed: Cloudera Engineering Blog. Author: Tom Wheeler. [Editor’s note: This article was originally published on the Hortonworks Community Connection, but reproduced here because CDSW is now available on both Cloudera and Hortonworks platforms.] Using Deployed Models as a Function as a Service    Using Cloudera Data Science Workbench with Apache NiFi, we can easily call functions within our deployed models from Apache NiFi as part of flows. I am working against CDSW on HDP (https://www.cloudera.com/documentation/data-science-workbench/latest/topics/cdsw_hdp.html),  but it will work for all CDSW regardless of install type. In my simple example, I built a Python model that uses TextBlob to run sentiment analysis against ... Read More

Feed: Cloudera Engineering Blog. Author: Tom Wheeler. In the last few years, IT security threats to enterprise systems have increased, which has necessitated installing log ingestion and analysis solutions in any enterprise network. This blog post illustrates how Cloudera built its own scalable solution for log ingestion and analytics using Apache Spot and Cloudera Altus. By leveraging transient workloads in the cloud, Cloudera reduced the solution’s operational costs by 50% when compared to traditional, persistent cluster approaches. At Cloudera, the Infosec team needed to build a centralized log ingestion and analytical solution to monitor all key systems in the company ... Read More