Trouble installing Percona on GCE

[Lawrence Taur]

I've been trying to install percona server on a fresh google compute engine instance.

I havent installed mysql server previously. i followed the instructions from herehttp://www.unixmen.com/install-percona-server-5-6-phpmyadmin-debian-7-wheezy/

I get this when i use

apt-get install percona-server-server-5.6 percona-server-client-5.6


Setting up percona-server-common-5.6 (5.6.15-rel63.0-519.wheezy) ...
Setting up percona-server-client-5.6 (5.6.15-rel63.0-519.wheezy) ...
Setting up percona-server-server-5.6 (5.6.15-rel63.0-519.wheezy) ...
[ ok ] Stopping MySQL (Percona Server): mysqld.
2014-01-22 04:54:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.     Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-01-22 04:54:28 21278 [Note] Plugin 'FEDERATED' is disabled.
2014-01-22 04:54:28 21278 [Note] InnoDB: The InnoDB memory heap is disabled
2014-01-22 04:54:28 21278 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-01-22 04:54:28 21278 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-01-22 04:54:28 21278 [Note] InnoDB: Using Linux native AIO
2014-01-22 04:54:28 21278 [Note] InnoDB: Using CPU crc32 instructions
2014-01-22 04:54:28 21278 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-01-22 04:54:28 21278 [Note] InnoDB: Completed initialization of buffer pool
2014-01-22 04:54:28 21278 [Note] InnoDB: Highest supported file format is Barracuda.
2014-01-22 04:54:29 21278 [Note] InnoDB: 128 rollback segment(s) are active.
2014-01-22 04:54:29 21278 [Note] InnoDB: Waiting for purge to start
2014-01-22 04:54:29 21278 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.15-    rel63.0 started; log sequence number 1625987
2014-01-22 04:54:29 21278 [Note] RSA private key file not found:     /var/lib/mysql//private_key.pem. Some authentication plugins will not work.
2014-01-22 04:54:29 21278 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work.
2014-01-22 04:54:29 21278 [Note] Binlog end
2014-01-22 04:54:29 21278 [Note] InnoDB: FTS optimize thread exiting.
2014-01-22 04:54:29 21278 [Note] InnoDB: Starting shutdown...
2014-01-22 04:54:30 21278 [Note] InnoDB: Shutdown completed; log sequence number 1625997


 * Percona Server is distributed with several useful UDF (User Defined Function) from Percona Toolkit.
 * Run the following commands to create these functions:

    mysql -e "CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'"
    mysql -e "CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'"
    mysql -e "CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'"

 * See http://www.percona.com/doc/percona-server/5.5/management/udf_percona_toolkit.html for more details


[FAIL] Starting MySQL (Percona Server) database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.

What am i doing wrong here?

[Jonathan Simon]

Hello Lawrence,

I was able to install Percona Server on a fresh Google Compute Engine instance (running the current Debian-wheezy image) by following a subset of the installation instructions that you linked to.

Three things to be aware of:

1) The installation commands require root privileges so after you ssh on to the instance, start by running the following command to switch user to root:

sudo su

2) Since it is a brand new instance you can skip the commands associated with removing software packages (at the beginning of the instructions) and start with the "add the key to your server" step.

3) Use a Machine type that is a "g1-small" or bigger when you create your instance. 

Please give it another try and let me know if this works for you.

Thanks,

--Jonathan

[Lawrence Taur]

Hello Simon, 

I gave up on that and installed mysql with apt-get install mysql

I am on the very basic shared instance. Maybe that is why it did not work.

Do you have any idea why it did not work?

[Jonathan Simon]

Not completely certain but the issue appears to be that Percona Server 5.6 requires more Memory than the 0.60 GB available in the 'f1-micro' Machine Type.