My Oracle Support Banner

Frequently Asked Questions on using MySQL on Oracle Big Data Appliance with Hadoop Components (Doc ID 1542128.1)

Last updated on FEBRUARY 07, 2022

Applies to:

Big Data Appliance Integrated Software
Linux x86-64


 This document provides answers to frequently asked questions about using MySQL with Oracle Big Data Appliance and Hadoop Components.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 Is it possible to upgrade MySQL on the BDA from MySQL 5.7.27 or 5.7.32 or an older MySQL 5.7 version  to MySQL 5.7.33 or MySQL 5.7.34?
 Is replication setup for MySQL(which manages CM and Hadoop Stack) on BDA?
 Is enabling of transparent data encryption (TDE) on MySQL supported on the BDA?
 Is automatic failover configured between primary MySQL and backup?
 Is automatic purging of MySQL binary logs enabled on BDA?
 On BDA V2.0.1 receiving a deadlock error popup when re-starting the HDFS service in Cloudera Manager(CM). How can I resolve this?
 When trying to run Sqoop seeing exception: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure. How can I resolve this?
 Getting exception: "not allowed to connect to this MySQL server" when trying to run Sqoop. How can I resolve this exception?
 On multi-rack Oracle Big Data Appliance (BDA) V2.0.1 or client when trying to execute Hive commands it fails. How can I resolve this?
 On BDA V3.0.1 does MySQL support automatic failover?
 On BDA V4.2.0 does MySQL support automatic failover?
 If /var/lib/mysql is filling up what are the options?
 If needed what would be the best way to restore a backed up MySQL database?
 In the case where the MySQL master has a failure what information is there on promoting the MySQL slave to the master?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.