Setting up percona-xtradb-cluster-server-5.6 (5.6.21-25.8-0ubuntu5) ...
update-alternatives: using /etc/mysql/percona-xtradb-cluster.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
2016-09-08 17:39:16 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2016-09-08 17:39:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
Setting up percona-xtradb-cluster-server (5.6.21-25.8-0ubuntu5) ...
inaddy@tinocoyakkety:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.21-70.1-70.1 Percona XtraDB Cluster (GPL), Release 5.6.21-25.8.4150, wsrep_25.8.rXXXX
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| test |
+--------------------+
4 rows in set (0.00 sec)
## YAKKETY verification
# policy
inaddy@ tinocoyakkety: ~$ apt-cache policy percona- xtradb- cluster- server xtradb- cluster- server: 25.8-0ubuntu5 6.21-25. 8-0ubuntu5 500 ports.ubuntu. com/ubuntu- ports yakkety/universe ppc64el Packages
percona-
Installed: (none)
Candidate: 5.6.21-
Version table:
5.
500 http://
# installation
Setting up percona- xtradb- cluster- server- 5.6 (5.6.21- 25.8-0ubuntu5) ... alternatives: using /etc/mysql/ percona- xtradb- cluster. cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode defaults_ for_timestamp server option (see documentation for more details). xtradb- cluster- server (5.6.21- 25.8-0ubuntu5) ...
update-
2016-09-08 17:39:16 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2016-09-08 17:39:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
Setting up percona-
# running
inaddy@ tinocoyakkety: ~$ ps -ef | grep mysql mysqld_ safe /var/lib/ percona- xtradb- cluster --plugin- dir=/usr/ lib/mysql/ plugin --user=mysql --log-error= /var/log/ mysql/error. log --pid-file= /var/run/ mysqld/ mysqld. pid --socket= /var/run/ mysqld/ mysqld. sock --port=3306 --wsrep_ start_position= 00000000- 0000-0000- 0000-0000000000 00:-1
root 2649 1 0 17:39 ? 00:00:00 /bin/sh /usr/bin/
mysql 2989 2649 0 17:39 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=
# accessing
inaddy@ tinocoyakkety: ~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.21-70.1-70.1 Percona XtraDB Cluster (GPL), Release 5.6.21-25.8.4150, wsrep_25.8.rXXXX
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases; ------- ------- + ------- ------- + ------- ------- +
+------
| Database |
+------
| information_schema |
| mysql |
| performance_schema |
| test |
+------
4 rows in set (0.00 sec)