![]() ![]() Now let’s try to connect to our OceanBase instance using OBClient, OceanBase’s official CLI based on the MariaDB CLI, which can be used to connect to OceanBase Server/Proxy. *.*.42:3000/d/oceanbase | admin | oceanbase | active | | ip | server_port | pprof_port | status | Since OceanBase recommends having a disk space of “four times the memory size or more,” I’ll mount a 100-GiB SSD storage volume to the instance. In this walkthrough, I will use the CentOS 8 operating system and the a1.x2large EC2 instance type, which comes with 8 vCPUs and 16 GiB of RAM. The recommended operating systems are Red Hat Enterprise Linux Server, CentOS Linux, and Anolis OS. Pre-requisitesīefore we jump into the installation process of OceanBase, we need to make sure that the EC2 instance we spin up in AWS meets the hardware requirements of OceanBase as stated in the documentation.Īccording to the documentation, a server with at least four cores and 10 GiB of RAM (preferably 16 GiB) is required to install OceanBase. This is the first in a series of articles where I demonstrate how to integrate OceanBase into your applications. In this article, I will walk you through how to install OceanBase on an AWS EC2 instance. OceanBase, a distributed database that offers capabilities in both transactions and analytics, as well as compatibility with MySQL, is rapidly gaining traction among data-driven teams.ĭeveloped by Ant Group, OceanBase has been the driving force behind Alibaba’s Singles Day shopping event for nine consecutive years, managing billions of dollars in transactions annually.Īs an enterprise-grade DBMS, OceanBase also provides a community edition that allows developers to experience its full potential without a complicated setup. An increasing number of companies are already shifting to distributed databases. As data generated and processed by companies grow exponentially, there is a growing need for scalable and reliable database management solutions. Below is general query syntax to create enum type.In the world of big data, distributed databases play an important role. In this article, delivery status example above will be used. Otherwise, other solutions like reference table or even simple integer type will suffice. Personally, I'd say less than 10 as rule of thumb. ![]() Enum values won't change a lot in the future. ![]()
0 Comments
Leave a Reply. |