Victor ... wait for it .... Anjos vanjos

## innodb_memcheck.sql
SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
SHOW VARIABLES LIKE 'innodb_additional_mem_pool_size';
SHOW VARIABLES LIKE 'innodb_log_buffer_size';
SHOW VARIABLES LIKE 'thread_stack';
SET @kilo_bytes = 1024;
SET @mega_bytes = @kilo_bytes * 1024;
SET @giga_bytes = @mega_bytes * 1024;
SET @innodb_buffer_pool_size = 2 * @giga_bytes;
SET @innodb_additional_mem_pool_size = 16 * @mega_bytes;
SET @innodb_log_buffer_size = 8 * @mega_bytes;

## bpnn.py
#!/usr/bin/env python


import math
import random
import string

random.seed(0)

# calculate a random number where:  a <= rand < b

## datastax_cassandra.sh
#!/bin/bash

###
#
# Find out which ami to use on http://www.alestic.com
#
# at the time of this writing, Ubuntu 12.04 (Precise) was ami-23d9a94a
# with EBS boot
#
# In order for this to work, tuned your firewall for the following:

## NC-MySQLDUMP.sh
#####
# You'll be needing two machines, the target machine and source one (makes sense, right)?

#####
# On the target machine
nc -l 55555 | gzip -d -c | mysql <database name> -u<user> -p<password> [ | <decrypt> ]

#####
# On the source machine
mysqldump -u<user> -p<password> <database name> | gzip | nc <ip of target server> 55555 [ | <encrypt> ]

## ccm_cassandra.sh
#!/bin/bash

###
#
# Find out which ami to use on http://www.alestic.com
#
# at the time of this writing, Ubuntu 12.04 (Precise) was ami-23d9a94a
# with EBS boot
#
# In order for this to work, tuned your firewall for the following:

## Running_query_volume.sh
mysql -e "show processlist" | grep -v Rows | grep -v Sleep | grep -oP -A1 "(SELECT|UPDATE|INSERT).*FROM \w+" | sort -h | uniq -c | sort -n

## ec2metadata_creator.php
<?php

/**
 * This script gets EC2 metadata and saves it to an ini file. It should be run
 * on boot before starting application stuff, such as php-fpm or video
 * processing.
 */

// path to put file
$path = '/usr/local/viafoura';

## get_memcache_keys.php
<?php

$server = "localhost";
$port = 11211;
/**
 * Taken directly from memcache PECL source
 *
 * http://pecl.php.net/package/memcache
 *
 */

## kafka-upstart.conf
description "Kafka Broker"

start on runlevel [2345]
stop on starting rc RUNLEVEL=[016]

respawn
respawn limit 2 5

env CONFIG_HOME="/etc/kafka"
env KAFKA_HOME="/usr/lib/kafka"

## stargate.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                vanjos
                / stargate.md
            
            
              Last active
              August 29, 2015 14:02
            
              
                Stargate Explained (Lucene indexing ON Cassandra) to replace Lucandra/Solandra and SOLR (from DSE)
              
          
    STARGATE INSTALL


Prerequisites


ubuntu
java 1.7


likely want openjdk-7-jre-headless openjdk-7-jre-lib openjdk-7-jdk
	SHOW VARIABLES LIKE 'innodb_buffer_pool_size';
	SHOW VARIABLES LIKE 'innodb_additional_mem_pool_size';
	SHOW VARIABLES LIKE 'innodb_log_buffer_size';
	SHOW VARIABLES LIKE 'thread_stack';
	SET @kilo_bytes = 1024;
	SET @mega_bytes = @kilo_bytes * 1024;
	SET @giga_bytes = @mega_bytes * 1024;
	SET @innodb_buffer_pool_size = 2 * @giga_bytes;
	SET @innodb_additional_mem_pool_size = 16 * @mega_bytes;
	SET @innodb_log_buffer_size = 8 * @mega_bytes;
	#!/usr/bin/env python


	import math
	import random
	import string

	random.seed(0)

	# calculate a random number where: a <= rand < b
	#!/bin/bash

	###
	#
	# Find out which ami to use on http://www.alestic.com
	#
	# at the time of this writing, Ubuntu 12.04 (Precise) was ami-23d9a94a
	# with EBS boot
	#
	# In order for this to work, tuned your firewall for the following:
	#####
	# You'll be needing two machines, the target machine and source one (makes sense, right)?

	#####
	# On the target machine
	nc -l 55555 \| gzip -d -c \| mysql <database name> -u<user> -p<password> [ \| <decrypt> ]

	#####
	# On the source machine
	mysqldump -u<user> -p<password> <database name> \| gzip \| nc <ip of target server> 55555 [ \| <encrypt> ]
	<?php

	/**
	* This script gets EC2 metadata and saves it to an ini file. It should be run
	* on boot before starting application stuff, such as php-fpm or video
	* processing.
	*/

	// path to put file
	$path = '/usr/local/viafoura';
	<?php

	$server = "localhost";
	$port = 11211;
	/**
	* Taken directly from memcache PECL source
	*
	* http://pecl.php.net/package/memcache
	*
	*/
	description "Kafka Broker"

	start on runlevel [2345]
	stop on starting rc RUNLEVEL=[016]

	respawn
	respawn limit 2 5

	env CONFIG_HOME="/etc/kafka"
	env KAFKA_HOME="/usr/lib/kafka"