[PR] Add Oceanbase Support to Ambari MySQL DDL [ambari]

Thu, 02 Jan 2025 07:31:16 -0800 


itongxiaojun opened a new pull request, #3921:
URL: https://github.com/apache/ambari/pull/3921

   This PR introduces compatibility for Oceanbase within Apache Ambari, with 
adjustments made to the MySQL DDL script to ensure proper functioning when 
working with Oceanbase, which supports the MySQL protocol.
   
   1. **Oceanbase Overview**:  
      Oceanbase is a distributed relational database developed by Alibaba, 
designed to be highly scalable and provide high availability. It is fully 
compatible with the MySQL protocol, allowing it to be used as a drop-in 
replacement for MySQL in many cases, which makes it suitable for large-scale 
applications and enterprise environments.
   
   2. **DDL Modifications**:  
      The file `/var/lib/ambari-server/resources/Ambari-DDL-MySQL-CREATE.sql` 
was modified to adjust the field lengths of `service_name` and `view_name`. 
These adjustments help avoid errors when importing the DDL into Oceanbase, 
aligning the field sizes properly.
   
   ![Image of modified 
SQL](https://github.com/user-attachments/assets/e5c0d0c7-e693-4482-a9ab-da17f22edb23)
   
   3. **Testing**:  
      We have thoroughly tested the modified SQL on both Oceanbase and MySQL 
databases. After applying the changes, the DDL was successfully imported into 
both databases, and the Ambari services started without issues.
   
      ![Image showing successful import and service 
start](https://github.com/user-attachments/assets/0f1d2d8c-0d02-4b49-b2f4-e3b2424767a5)
   
![image](https://github.com/user-attachments/assets/c3cc7d78-a46f-435b-b477-1e1c6610430b)
   
   
   4. **Known Issue**:  
      A minor error occurs during the import process of the SQL into Oceanbase 
at line 36. This error is due to MySQL-specific syntax, but it does not impact 
functionality, as the syntax does not affect the overall operation of the 
system.
   
     ![Image showing error in line 
36](https://github.com/user-attachments/assets/264176e9-b02b-495b-9fa3-dd39449dd945)
    
![image](https://github.com/user-attachments/assets/3ab8de2b-f911-4b73-b1d8-2ebb1da9b545)
   
   5. **Final Validation**:  
      After making the changes, we successfully started Ambari, installed, and 
ran all components without any issues. This confirms that the changes ensure 
full compatibility with both Oceanbase and MySQL, allowing Ambari to function 
normally.
   
   
![image](https://github.com/user-attachments/assets/c86399ad-0cae-48a8-b971-50b8ac392969)
   
   We believe that these changes will make Ambari more versatile for users 
running Oceanbase while retaining compatibility with MySQL.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to