Click to have a surprise
Oceanbase is fully compatible with the MySQL protocol, before the article also mentioned, so oceanbase connection is the same as MySQL, need to install MySQL client, using ip+ port + user @tenant+ password link. MYSQL-H-uxxxx@tenant-pxxxx-p8306-h OB cluster VIP
-u@tenant User and Tenant name-p password-p port
Before a user could not connect to the OB database, the error is as follows:
[Ftpuser@fuggr~]mysql-h-uxxxx-pxxxx-p8306
warning:using a password on the command line interface can is insecure.
ERROR 2003:can ' t connect to MySQL server on ' IP '
What kind of database may be not connected to the database, may be the cluster hangs, may be the network has a problem, we look at what this problem. First Oceanbase is a cluster, the following figure, a total of three copies, that is, three zone. The zone are made up of different servers, and the servers that connect to them externally provide services via outside proxy.
This may be the obproxy boot problem, the proxy is not started by the Configg server URL, directly using the RS list, so when the user logs on, either does not specify the cluster name login (proxy uses the default Obcloud), or log on using the Obcloud cluster. 1. When client accesses OB via proxy, if the proxy has only one cluster at the back end, the user can be username@tenantname, and if it is multiple clusters, the cluster name needs to be specified; 2. Assuming that the user is passing in a cluster named A, then proxy first looks for the cluster from the JSON content in the config server URL and, if so, logs on to the cluster Observer 3. Proxy in the case of cluster famous check switch open (default), access to observer when the user incoming cluster name and OB cluster name is consistent, inconsistent error.
OB connection database actually need to enter the information than MySQL is just one more tenant, because in the OB resource division is according to the tenant granularity to divide, each tenant resource is isolated, that is to say this resource was divided into a tenant, then this tenant will monopolize this part of the resources, Even if the other tenant is full of CPU at this time, it is not possible to use another tenant's resources.
Since you have the same command-line connection as MySQL, most MySQL client tools can also be connected to oceanbase. Like Navicate and so on. I hope everyone can get a cloud of OB to do a play.
Click to have a surprise