Infosys Senior Consultant Interview Questions, Process, and Tips

MySQL native replication allows for data to be copied from one MySQL database to another in real-time.

• Enable binary logging on the master server

• Configure the master server to allow replication connections

• Create a replication user on the master server

• Configure the slave server with the master server's information

• Start the replication process on the slave server

InnoDB is a storage engine for MySQL that provides ACID-compliant transactions and crash recovery.

• InnoDB uses a clustered index to store data, which helps in faster retrieval of data.

• It supports row-level locking for better concurrency.

• InnoDB maintains a transaction log to ensure data integrity and recoverability in case of crashes.

• It uses a doublewrite buffer to avoid data corruption during crashes.

• InnoDB also support...read more

Procedure for finding and fixing Galera cluster node issues

• Check Galera cluster status using 'SHOW STATUS LIKE 'wsrep_cluster_size''

• Look for any errors in Galera cluster logs

• Verify network connectivity between cluster nodes

• Restart the Galera cluster node if necessary

• Check for any hardware issues that may be causing the problem

MySQL 8 version offers improved performance, security, and scalability.

• Improved performance with new features like common table expressions and window functions

• Enhanced security with default authentication plugin set to caching_sha2_password

• Increased scalability with support for more efficient resource management

• Better JSON support with new functions and operators

• Enhanced replication capabilities for high availability

HANA 2.0 has improved features and capabilities compared to HANA 1.0.

• HANA 2.0 has enhanced security features such as data masking and encryption

• HANA 2.0 supports more programming languages including Python and R

• HANA 2.0 has improved performance and scalability compared to HANA 1.0

• HANA 2.0 has a new feature called Multi-tenant database containers (MDC) which allows multiple databases to run on a single HANA instance

• HANA...read more

Oracle upgrade steps involve planning, testing, and executing the upgrade process.

• Assess current environment and determine upgrade path

• Create a backup and recovery plan

• Test the upgrade process in a non-production environment

• Perform the upgrade and validate the new environment

• Perform post-upgrade tasks such as data migration and application testing