KT Experts
1,081 FOLLOWERS
This is Vinod Kumar having around 14+ years of experience as Oracle DBA having exposure to RAC, Dataguard, RMAN, GoldenGate, DB Upgrades, Hadoop. Looking forward to sharpening my skill set and adopt new things. Worked for various industries like Banking, financial, Telecom, Product based companies, and retail, etc.
KT Experts
2d ago
APACHE CASSANDRA INSTALLATIONS
These are the guidelines for setting up the supported Apache Cassandra releases on Linux systems. Cassandra runs on a wide array of Linux distributions including (but not limited to): ⦁ Ubuntu, most notably LTS releases 16.04 to 18.04. ⦁ CentOS & RedHat Enterprise Linux (RHEL) including 6.6 to 7.7. ⦁ Amazon Linux AMIs including 2016.09 through to Linux 2 ⦁ Debian versions 8 & 9 ⦁ SUSE Enterprise Linux 12 This is neither a prescriptive nor a complete list of operating system platforms. Nonetheless, users would be wise to carry out thorough tests on their ..read more
KT Experts
1w ago
BLOOM FILTERS
WHAT ARE BLOOM FILTERS: Cassandra combines data from RAM (in memtables) and disk (in SSTables) in the read path. Cassandra uses a data structure called a bloom filter to avoid having to go through each and every SSTable data file to find the partition that is being requested. Cassandra can decide one of two probable states using bloom filters, a probabilistic data structure: either the data absolutely does not exist in the provided file, or the data probably does. Bloom filters can be made more accurate by allowing them to use more RAM, even when they cannot ensure that the data ..read more
KT Experts
2w ago
Creating a new Docker Image/container from existing Container
And run the new container. Step 1: Create an initial Base Container – for an App Let’s get started by creating a running container. So that we don’t get bogged down in the details of any particular container, We can use nginx. The Docker create command will create a new container.
docker create --name nginx_base -p 80:80 nginx:alpine
Step 2: Inspect Images If you look at the list of images on your system You will now see the nginx:alpine image: docker images -a
Step 3: Inspect Containers- created but not started. Not ..read more
KT Experts
2w ago
CASSANDRA BACKUPS
WHAT ARE BACKUPS: Immutable SSTable files are used by Apache Cassandra to store data. The backup copies of the database data that are kept as SSTable files in the Apache Cassandra database are called backups. There are various uses for backups, some of which are as follows: ⦁ To preserve a copy of the data. ⦁ To be able to restore a table in the event that a node, partition, or network failure causes the loss of table data. ⦁ For portability, to be able to move the SSTable files to another computer.
TYPES OF BACKUPS IN APACHE CASSANDRA: A snapshot is a hard link-creat ..read more
KT Experts
3w ago
Creating Docker Container using Docker file: Use Case of Docker: Consider a team working on a Java application. Various groups are involved in the Software Development lifecycle: designing, development, testing, production, deployment, etc. Step 1: The developer will create an environment that includes a Tomcat server. Step 2: The tester must test the application after it has been developed. The tester will now create a new Tomcat environment to test the application from scratch. Step 3: The application will be deployed to the production server when the testing is completed. Again ..read more
KT Experts
1M ago
This content is password protected. To view it please enter your password below:
Password ..read more
KT Experts
1M ago
USER DEFINED DATA TYPES IN CQL
Handling several fields of connected data in a table is made easier with the use of a user-defined type. By representing the linked fields of information using a user-defined type rather than storing them in separate tables, applications that previously required numerous tables can be made simpler and use fewer tables. User-defined types (UDTs) are defined using CQL. Using the create_type_statement, alter_type_statement, and drop_type_statement functions listed below, such a type can be established, changed, and eliminated. However, after it is built, a UDT is o ..read more
KT Experts
1M ago
Handling SQL Error and Vulnerability BUG in JENKINS_job by SQLplus script runner plugin
How to make Jenkins job as failure for SQL errors (SQL syntax or any SQL Error): Add the additional code in Jenkins SQL file or SQL user defined code. To check the SQL failure. Build the job and check for the job status: Check the console output for ERROR: Console output: continued Known Issues: – Reported problems for SQL Plus Runner KNOWN ISSUE 1: my script takes forever to execute… Windows users sometimes get a running script stuck on build, even though they run everything on Orac ..read more
KT Experts
1M ago
Dictionary
Dictionary is the inbuilt data type in python which organizes data in a collection of key-value pairs, where each key is unique and maps to a specific value. Each element in the dictionary is a key–value pair and one individual key value pair is treated as an item in the dictionary. Keys are immutable i.e. you can’t change the key once you created it and must be unique within a dictionary. Values can be mutable i.e. you can change the value which is associated with a specific key. The keys and values in the dictionary are case sensitive, you can use the same name as key with d ..read more
KT Experts
1M ago
DATATYPES IN CQL (2.0)
CUSTOM DATA TYPE:
A Custom datatype is defined by every Java class that extends the server-side Abstract Type class and can be loaded by Cassandra is called a custom type; as a result, it should be included in the CLASSPATH of every node that is running Cassandra. When used as a clustering column, that class will specify which values are appropriate for the type and how the time sorting works. A custom type’s value can be entered using the blob literal syntax and is equivalent to a blob for all other purposes.
When hex is a hexadecimal character, as [0-9a-fA-F], th ..read more