Posts Categorized: Pythian

Cassandra Update – Leap Second & JMX Security

2000px-Cassandra_logo.svg

This is a short post about two things that should be on the to-do list for all Cassandra Administrators. The leap second issue and the new JMX default. The Leap Second Before we move on you should learn more about how the leap second affects Cassandra in more detail. In short, you must update your JVM to version…

Making Existing SQLPLUS Scripts 12c and Container DB (PDB) Compatible

Oracle 12c introduces new catalog features including CDB_ dictionary views (which include a CON_ID column) superseding the DBA_ views that most DBA sqlplus scripts are based upon. However, existing DBA sqlplus scripts can easily be modified using just a few simple sqlplus techniques to be compatible with 11g, as well as all types of 12c…

fsfreeze in Linux

The fsfreeze command, is used to suspend and resume access to a file system. This allows consistent snapshots to be taken of the filesystem. fsfreeze supports Ext3/4, ReiserFS, JFS and XFS. A filesystem can be frozen using following command: # /sbin/fsfreeze -f /data Now if you are writing to this filesystem, the process/command will be…

Ingest a Single Table from Microsoft SQL Server Data into Hadoop

Introduction This blog describes the best-practice approach in regards to the data ingestion from SQL Server into Hadoop. The case scenario is described as under: Single table ingestion (no joins) No partitioning Complete data ingestion (trash old and replace new) Data stored in Parquet format Pre-requisites This example has been tested using the following versions: Hadoop…

OpenTSDB and Google Cloud Bigtable

Data comes in different shapes. One of the these shapes is called a time series. Time series is basically a sequence of data points recorded over time. If, for example, you measure the height of the tide every hour for 24 hours, then you will end up with a time series of 24 data points….

OEM 12c Silent Installation

“What’s for lunch today?”, said the newly born ready to run Red Hat 6.4 server. “Well, I have an outstanding 3-course meal of OEM12c installation. For the appetizer, a light and crispy ASM 12c, DB 12c with patching for the main and desert, and to cover everything up, OEM 12c setup and configuration”, replied  the DBA who…

Page 3 of 23212345...10...Last Page »