Posted inCassandra

Cassandra import & export

Cassandra.csv file data: car_make,car_model,start_year,id,first_name,last_name,department BMW,Saloon,2011,1,Johny,Depp,IT AUDI,Saloon,2013,2,Meryl,Streep,HR LEXUS,Sports,2011,3,Brad,Pitt,IT AUDI,Sports,2012,4,Tom,Hanks,FI BMW,Compact,2012,5,Angelina,Jolie,FI BMW,Saloon,2011,6,Tom,Cruise,HR AUDI,Compact,2013,7,Scarlett,Johansson,IT LEXUS,Compact,2013,8,Matt,Damon,IT NISSAN,Saloon,2013,9,Julia,Roberts,FI BMW,Saloon,2011,10,Nicole,Kidman,HR NISSAN,Compact,2012,11,George,Clooney,HR AUDI,Saloon,2012,12,Dwayne,Johnson,IT AUDI,Sports,2011,13,Natalie,Portman,FI Create keyspace and create tables and then importing the data form local system…
No Comments
Posted inLinux Oracle

Linux Administration.

A Linux distribution is a collection of (usually open source) software on top of a Linux kernel. A distribution (or short, distro) can bundle server software, system management tools, documentation…
No Comments
Posted inMySQL

MySQL HA DR Setup

/etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.56.10 mysql-prim.localdomain mysql-prim 192.168.56.11 mysql-dr.localdomain mysql-dr User to install and configure mysql: avs Install MySQL [avs@mysql-master ~]$ sudo dnf…
No Comments
Posted inOracle

Basic Performance and Tuning

As a DBA, you are responsible for the performance of your Oracle database. Typically, performance problems result from unacceptable response time, which is the time to complete a specified workload,…
No Comments