| Powershell HTTP Request | |
| $r = [System.Net.WebRequest]::Create("http://url/") | |
| $resp = $r.GetResponse() | |
| $reqstream = $resp.GetResponseStream() | |
| $sr = new-object System.IO.StreamReader $reqstream | |
| $result = $sr.ReadToEnd() | |
| write-host $result | |
| Username and passwords |
| apply plugin: 'java' | |
| apply plugin: 'signing' | |
| version = '0.5.3-SNAPSHOT' | |
| isReleaseVersion = !version.endsWith("SNAPSHOT") | |
| sourceCompatibility = 1.5 | |
| //targetCompatibility has the same value as sourceCompatibility by default | |
| //to enable fancy test reports with ReportNG | |
| isReportNGEnabled = hasProperty("reports") |
This is a simple way to backup your MySQL tables to Amazon S3 for a nightly backup - this is all to be done on your server :-)
Sister Document - Restore MySQL from Amazon S3 - read that next
this is for Centos 5.6, see http://s3tools.org/repositories for other systems like ubuntu etc
| -- show running queries (pre 9.2) | |
| SELECT procpid, age(clock_timestamp(), query_start), usename, current_query | |
| FROM pg_stat_activity | |
| WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' | |
| ORDER BY query_start desc; | |
| -- show running queries (9.2) | |
| SELECT pid, age(clock_timestamp(), query_start), usename, query | |
| FROM pg_stat_activity | |
| WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' |
| apply plugin: 'maven' | |
| apply plugin: 'scala' | |
| apply plugin: 'signing' | |
| def isMavenDeployable = hasProperty('mavenRepositoryUrl') && | |
| hasProperty('mavenRepositoryUsername') && | |
| hasProperty('mavenRepositoryPassword') | |
| if (isMavenDeployable) { | |
| signing { |
| /* | |
| * Topic Entity | |
| */ | |
| @Entity | |
| @Table(uniqueConstraints = Array(new UniqueConstraint(columnNames=Array("application_id", "name")))) | |
| @NamedQueries(Array( | |
| new NamedQuery(name="Topic.findAllByApplication", query="from Topic where application=:application"), | |
| new NamedQuery(name="Topic.findByApplicationAndName", query="from Topic where application=:application and name=:name") | |
| )) | |
| class Topic { |
| /* | |
| * Copyright (c) 2017 Emil Davtyan | |
| * | |
| * Permission is hereby granted, free of charge, to any person obtaining | |
| * a copy of this software and associated documentation files (the | |
| * "Software"), to deal in the Software without restriction, including | |
| * without limitation the rights to use, copy, modify, merge, publish, | |
| * distribute, sublicense, and/or sell copies of the Software, and to | |
| * permit persons to whom the Software is furnished to do so, subject to | |
| * the following conditions: |
| private static String WRITE_STATEMENT = "INSERT INTO avatars (id, image_type, avatar) VALUES (?,?,?);"; | |
| private final BoundStatement writeStatement=writeStatement = session.prepare(WRITE_STATEMENT) | |
| .setConsistencyLevel(ConsistencyLevel.LOCAL_QUORUM).bind(); | |
| try { | |
| BoundStatement stmt = driver.getWriteStatement(); | |
| stmt.enableTracing(); | |
| stmt.setLong("id", accountId); | |
| stmt.setString("image_type", image.getType()); | |
| stmt.setBytes("avatar", ByteBuffer.wrap(image.getBytes())); |
| package spikes.cluster | |
| import akka.actor._ | |
| import com.typesafe.config.ConfigFactory | |
| import akka.contrib.pattern.{ClusterClient, ClusterReceptionistExtension} | |
| object DemoMaster { | |
| def main(args: Array[String]): Unit = { |
| SELECT id,state,command,time,left(replace(info,'\n','<lf>'),120) | |
| FROM information_schema.processlist | |
| WHERE command <> 'Sleep' | |
| AND info NOT LIKE '%PROCESSLIST%' | |
| ORDER BY time DESC LIMIT 50; |
