Setting up percona-xtradb-cluster-server-5.6 (5.6.21-25.8-0ubuntu3.2) ...
update-alternatives: using /etc/mysql/percona-xtradb-cluster.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
2016-09-08 17:31: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:31: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-0ubuntu3.2) ...
inaddy@tinocoxenial:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
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)
--------------------------
I'm not facing any problem with Xenial version from -proposed during installation. My verification works, am I missing something ? It worked for Trusty and Xenial.
## XENIAL VERIFICATION
inaddy@ tinocoxenial: ~$ uname -a
Linux tinocoxenial 4.4.0-24-generic #43-Ubuntu SMP Wed Jun 8 19:25:36 UTC 2016 ppc64le ppc64le ppc64le GNU/Linux
inaddy@ tinocoxenial: ~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 16.04.1 LTS
Release: 16.04
Codename: xenial
# policy
percona- xtradb- cluster- server: 25.8-0ubuntu3. 2 6.21-25. 8-0ubuntu3. 2 500 ports.ubuntu. com/ubuntu- ports xenial- proposed/ universe ppc64el Packages 6.21-25. 8-0ubuntu3. 1 500 ports.ubuntu. com/ubuntu- ports xenial- updates/ universe ppc64el Packages 6.21-25. 8-0ubuntu3 500 ports.ubuntu. com/ubuntu- ports xenial/universe ppc64el Packages
Installed: (none)
Candidate: 5.6.21-
Version table:
5.
500 http://
5.
500 http://
5.
500 http://
# installation
Setting up percona- xtradb- cluster- server- 5.6 (5.6.21- 25.8-0ubuntu3. 2) ... 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-0ubuntu3. 2) ...
update-
2016-09-08 17:31: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:31:16 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
Setting up percona-
# running
inaddy@ tinocoxenial: ~$ 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 2908 1 0 17:31 ? 00:00:00 /bin/sh /usr/bin/
mysql 3249 2908 0 17:31 ? 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=
# accessing
inaddy@ tinocoxenial: ~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
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)
------- ------- ------- -----
I'm not facing any problem with Xenial version from -proposed during installation. My verification works, am I missing something ? It worked for Trusty and Xenial.