polardbx-sql
polardbx-sql copied to clipboard
polardb
PolarDB-X is a cloud native distributed SQL Database designed for high concurrency, massive storage, complex querying scenarios.
刚部署好，建了一个数据库还是好的，可以顺利的创建表，过了几天建了一个新数据库创建表失败。 版本：5.6.29-PXC-5.4.15-20221129 数据库： ```sql CREATE DATABASE `dbapi_log` /* MODE = 'auto' */ ``` 建表语句： ```sql CREATE TABLE `access_log` ( `id` varchar(50) NOT NULL, `url` varchar(255) DEFAULT NULL, `status` int(11) DEFAULT...
``` mysql>create user yejr identified by 'xx'; -- hostname is not specified, treated as% Query OK, 0 rows affected (0.12 sec) mysql>show grants for yejr; -- hostname is not specified,...
``` mysql> show create table t1; +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | TABLE | CREATE TABLE | +-------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` ( `id` bigint(11) NOT NULL AUTO_INCREMENT, `score` tinyint(4) NOT NULL,...
polardb-x cluster was created via: ``` $ pxd tryout -cn_replica 2 -cn_version latest -dn_replica 2 -dn_version latest -cdc_replica 2 -cdc_version latest ``` dump data by mysqldump ``` $ mysqldump -t...
ref doc: https://www.polardbx.com/document How to customize the port number when editing the polardb-x cluster topology definition YAML file?
``` mysql>select user(); +--------------------------+ | USER() | +--------------------------+ | [email protected] | +--------------------------+ 1 row in set (0.00 sec) mysql>select current_user(); +----------------+ | current_user() | +----------------+ | d1@pxc-tryout | +----------------+ 1...
https://hub.docker.com/r/polardbx/polardb-x 如题 参考 https://hub.docker.com/_/postgres 的 How to extend this image
