MySQL Forums
Forum List  »  NDB clusters

Re: unknown option '--ndbcluster'
Posted by: christophe DUMONT
Date: December 23, 2016 07:16AM

Ok,

I ran ./mysql_install_db --user=mysql --datadir=/var/lib/mysql
I think it installed the db
4,0K -rw-r----- 1 xxx xxx 56 déc. 23 13:57 auto.cnf
4,0K -rw------- 1 xxx xxx 1,7K déc. 23 13:57 ca-key.pem
4,0K -rw-r--r-- 1 xxx xxx 1,1K déc. 23 13:57 ca.pem
4,0K -rw-r--r-- 1 xxx xxx 1,1K déc. 23 13:57 client-cert.pem
4,0K -rw------- 1 xxx xxx 1,7K déc. 23 13:57 client-key.pem
4,0K -rw-r----- 1 xxx xxx 323 déc. 23 13:58 ib_buffer_pool
12M -rw-r----- 1 xxx xxx 12M déc. 23 14:07 ibdata1
49M -rw-r----- 1 xxx xxx 48M déc. 23 14:07 ib_logfile0
48M -rw-r----- 1 xxx xxx 48M déc. 23 13:56 ib_logfile1
12M -rw-r----- 1 xxx xxx 12M déc. 23 14:07 ibtmp1
4,0K drwxr-x--- 2 xxx xxx 4,0K déc. 23 13:57 mysql
4,0K drwxr-x--- 2 xxx xxx 4,0K déc. 23 13:57 ndbinfo
4,0K drwxr-x--- 2 xxx xxx 4,0K déc. 23 13:57 performance_schema
4,0K -rw------- 1 xxx xxx 1,7K déc. 23 13:57 private_key.pem
4,0K -rw-r--r-- 1 xxx xxx 451 déc. 23 13:57 public_key.pem
4,0K -rw-r--r-- 1 xxx xxx 1,1K déc. 23 13:57 server-cert.pem
4,0K -rw------- 1 xxx xxx 1,7K déc. 23 13:57 server-key.pem
4,0K -rw-r----- 1 xxx xxx 5 déc. 23 14:08 sql.pid
12K drwxr-x--- 2 xxx xxx 12K déc. 23 13:57 sys

./mysqld

chris@sql:/opt/mysql/server-5.7/bin$ ./mysqld &
[1] 1798
chris@sql:/opt/mysql/server-5.7/bin$ 2016-12-23T13:07:30.137168Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-12-23T13:07:30.137641Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2016-12-23T13:07:30.137665Z 0 [Note] ./mysqld (mysqld 5.7.16-ndb-7.5.4-cluster-gpl) starting as process 1798 ...
2016-12-23T13:07:30.139830Z 0 [Note] InnoDB: PUNCH HOLE support available
2016-12-23T13:07:30.140061Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-12-23T13:07:30.140294Z 0 [Note] InnoDB: Uses event mutexes
2016-12-23T13:07:30.140351Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2016-12-23T13:07:30.140383Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-12-23T13:07:30.140413Z 0 [Note] InnoDB: Using Linux native AIO
2016-12-23T13:07:30.140577Z 0 [Note] InnoDB: Number of pools: 1
2016-12-23T13:07:30.140677Z 0 [Note] InnoDB: Using CPU crc32 instructions
2016-12-23T13:07:30.141544Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2016-12-23T13:07:30.145985Z 0 [Note] InnoDB: Completed initialization of buffer pool
2016-12-23T13:07:30.147150Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2016-12-23T13:07:30.158270Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2016-12-23T13:07:30.159197Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2538225
2016-12-23T13:07:30.159452Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2538234
2016-12-23T13:07:30.159716Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2538234
2016-12-23T13:07:30.159892Z 0 [Note] InnoDB: Database was not shutdown normally!
2016-12-23T13:07:30.160027Z 0 [Note] InnoDB: Starting crash recovery.
2016-12-23T13:07:30.340087Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2016-12-23T13:07:30.341117Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2016-12-23T13:07:30.341649Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2016-12-23T13:07:30.403538Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2016-12-23T13:07:30.405492Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2016-12-23T13:07:30.405895Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2016-12-23T13:07:30.406739Z 0 [Note] InnoDB: Waiting for purge to start
2016-12-23T13:07:30.458068Z 0 [Note] InnoDB: 5.7.16 started; log sequence number 2538234
2016-12-23T13:07:30.459384Z 0 [Note] Plugin 'FEDERATED' is disabled.
2016-12-23T13:07:30.463710Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2016-12-23T13:07:30.466162Z 0 [Note] InnoDB: Buffer pool(s) load completed at 161223 14:07:30
2016-12-23T13:07:30.657587Z 0 [Note] NDB: NodeID is 3, management server '192.168.56.101:1186'
[Note] NDB[0]: NodeID: 3, no storage nodes connected (timed out)
2016-12-23T13:08:00.840054Z 0 [Warning] NDB: server id set to zero - changes logged to bin log with server id zero will be logged with another server id by slave mysqlds
2016-12-23T13:08:00.841109Z 0 [Note] NDB Binlog: Starting...
2016-12-23T13:08:00.841736Z 1 [Note] NDB Binlog: Started
2016-12-23T13:08:00.842140Z 1 [Note] NDB Binlog: Setting up
2016-12-23T13:08:00.842998Z 1 [Note] NDB Binlog: Created schema Ndb object, reference: 0x80040003, name: 'Ndb Binlog schema change monitoring'
2016-12-23T13:08:00.844224Z 1 [Note] NDB Binlog: Created injector Ndb object, reference: 0x80050003, name: 'Ndb Binlog data change monitoring'
2016-12-23T13:08:00.844859Z 1 [Note] NDB Binlog: Setup completed
2016-12-23T13:08:00.845522Z 1 [Note] NDB Binlog: Wait for server start completed
2016-12-23T13:08:00.846549Z 0 [Note] NDB Util: Starting...
2016-12-23T13:08:00.847409Z 2 [Note] NDB Util: Wait for server start completed
2016-12-23T13:08:00.851733Z 0 [Note] NDB Index Stat: Starting...
2016-12-23T13:08:00.852447Z 0 [Note] NDB Index Stat: Wait for server start completed
2016-12-23T13:08:00.951717Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2016-12-23T13:08:00.952035Z 0 [Warning] CA certificate ca.pem is self signed.
2016-12-23T13:08:00.953311Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2016-12-23T13:08:00.953446Z 0 [Note] IPv6 is available.
2016-12-23T13:08:00.953587Z 0 [Note] - '::' resolves to '::';
2016-12-23T13:08:00.953799Z 0 [Note] Server socket created on IP: '::'.
2016-12-23T13:08:00.973175Z 0 [Note] Event Scheduler: Loaded 0 events
2016-12-23T13:08:00.973440Z 0 [Note] ./mysqld: ready for connections.
Version: '5.7.16-ndb-7.5.4-cluster-gpl' socket: '/tmp/mysql.sock' port: 3306 MySQL Cluster Community Server (GPL)
2016-12-23T13:08:00.973646Z 1 [Note] NDB Binlog: Check for incidents
2016-12-23T13:08:00.973673Z 1 [Note] NDB Binlog: Wait for cluster to start
2016-12-23T13:08:00.973669Z 0 [Note] NDB Index Stat: Wait for cluster to start
2016-12-23T13:08:00.973712Z 0 [Note] NDB Index Stat: Started
2016-12-23T13:08:00.973666Z 2 [Note] NDB Util: Wait for cluster to start
2016-12-23T13:08:00.973750Z 2 [Note] NDB Util: Started
2016-12-23T13:08:00.973931Z 0 [Note] NDB Index Stat: created Ndb object 'Ndb Index Stat', ref: 0x80070003

ps -ef | grep mysql :

chris 1798 1268 1 14:07 pts/0 00:00:05 ./mysqld
chris 1867 1268 0 14:14 pts/0 00:00:00 grep --color=auto mysql

i can't access the db

chris@sql:/opt/mysql/server-5.7/bin$ ./mysql -u root
2016-12-23T13:16:32.077971Z 7 [Note] Access denied for user 'root'@'localhost' (using password: NO)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Options: ReplyQuote


Subject
Views
Written By
Posted
498
December 23, 2016 02:50AM
233
December 23, 2016 04:54AM
Re: unknown option '--ndbcluster'
279
December 23, 2016 07:16AM
316
December 23, 2016 10:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.