Skip to end of metadata
Go to start of metadata

The Joyent Percona SmartMachine is a dynamically scalable SmartOS instance that is optimized as a Percona MySQL server. This appliance includes components such as the XtraDB storage engine.

Information about the image is stored in /etc/product, and the default /etc/motd is created using that information.

In this topic:

Directory Layout

Starting with image version 13.x, the Percona libraries are installed in /opt/local and databases are stored in /var/mysql.

Image Version 13.x and later

Description Directory
Percona Server MySQL binaries /opt/local/bin
MySQL data directory /var/mysql
MySQL configuration /opt/local/etc/my.cnf
Backups from Joyent QuickBackup /var/backups/percona
MySQL DTrace scripts /opt/local/bin

Image Version 1.6.0 and earlier

Description Directory
Percona Server MySQL binaries /mysql
MySQL data directory /databases
MySQL configuration /mysql.cnf
Backups from Joyent QuickBackup /backups
MySQL DTrace scripts /root/bin

Starting and Stopping a Percona MySQL Server

To start, stop, or restart a Percona server, use the following svcadm commands. You must use sudo be logged in as root to use svcadm commands.

  Image 13.3.0 Image 13.1.0 Image 1.6.0
Starting svcadm enable percona svcadm enable percona-server svcadm enable mysql:percona
Stopping svcadm disable percona svcadm disable percona-server svcadm disable mysql:percona
Restarting svcadm restart percona svcadm restart percona-server svcadm restart mysql:percona

Connecting to a Percona MySQL Server

The Percona MySQL server is configured to listen on its private IP address. Although you can change this configuration, it's best to connect to the Percona instance from another instance with a public IP address.

You can find the private IP for your instance in the Instance Details page of the Joyent Portal, or by using ifconfig.

If you want to connect to your Percona server directly, but you don't want to have it listen on a public IP address, you can use a SSH tunnel. Some MySQL administrator tools (for example, Navicat) already support SSH tunneling. If you plan to use a tool like Navicat, use these values when configuring it:

  • SSH hostname: Your Percona instance hostname or public IP address.
  • SSH port: 22 (default)
  • SSH username (login): admin
  • SSH password: The "admin" user password (from the Instance Details page)
  • MySQL hostname: Your instance private IP address.
  • MySQL port: 3306 (default)
  • MySQL username: root or a MySQL user you created
  • MySQL password: The "mysql" user password (from the Instance Details page)

Release Notes

Starting with version 13.1.0, we use the new version numbering scheme for SmartOS images.

13.3.0

Name percona
Description A SmartOS 64-bit image pre-configured and optimized as a Percona 5.6.13 64-bit MySQL server with Quickbackup and Sphinx Plug-in.
UUID fb6e7820-60ee-11e3-93b6-7f34ea3f2616
Based on base64 13.3.0
pkgsrc 2013Q2

What's New in This Release

  • Base image is base64-13.3.0 (2013Q3)
  • Percona Server version is 5.6.13
  • Xtrabackup version is 2.1.3
  • Percona ToolKit version is 2.1.7
  • Quickbackup version is 3.5
  • The name of the SMF service is now percona

Software Included in This Release

For a detailed list of every package installed with this image, click here.

13.1.0

Name percona
Description A SmartOS 64-bit image pre-configured and optimized as a Percona 5.5.29 64-bit MySQL server with Quickbackup, Handlersocket, and Sphinx Plug-in.
UUID 3882b5da-b0e8-11e2-b3a9-dbcf26c3e051
Based on base64 13.1.0
pkgsrc 2013Q1

What's New in This Release

  • Base image is now base64-13.1.0 (with pkgsrc 2013Q1)
  • New versioning scheme based on pkgsrc version
  • Percona Server version is now 5.5.29
  • Xtrabackup version is now 2.0.5
  • Quickbackup version is now 3.5
  • Percona ToolKit version is now 2.1.7
  • The Percona binaries are now installed via pkgsrc. To accommodate moving the Percona binaries to pkgsrc, the following changes were required:
    • Percona Server MySQL binaries were moved from /mysql to /opt/local/bin
    • The Percona Server SMF service name changed from network/mysql:percona to pkgsrc/percona-server
    • Percona databases are now stored in /var/mysql/ rather than /databases
    • The Percona config file is now located in /opt/local/etc/my.cnf instead of /mysql/my.cnf
    • Quickbackup service name changed from network/mysql-quickbackup to pkgsrc/quickbackup-percona

Software Included in This Release

For a detailed list of every package installed with this image, click here.

1.6.0

Name percona
Description SmartOS image pre-configured and optimized as a Percona 5.5 64-bit MySQL server with Quickbackup, Handlersocket, and Sphinx Plug-in.
UUID dc1a8b5e-043c-11e2-9d94-0f3fcb2b0c6d
Based on base 1.7.1
pkgsrc 2012Q1

What's New in This Release

  • Upgraded Percona to 5.5.27-rel28.1 (compiled with gcc 4.7)
  • Upgraded Xtrabackup to 2.1.0
  • Upgraded PerconaToolKit to 2.1.3
  • Upgraded SphinxSE to 2.0.5
  • Upgraded Quickbackup to version 3.3 with fixes below
  • Fixed mysql-percona.xml to use libumem
  • Fixed xtrabackup binary to be xtrabackup_55 (default) because innobackupex calls this by default
  • Fixed quickbackup to call xtrabackup_55 instead of xtrabackup
  • Fixed bug in quickbackup rotate() - PERCONA-4
  • Fixed bug in quickbackup depending on PID file - PERCONA-5
  • Added LD_LIBRARY_PATH hack to quickbackup for gcc47 libs

Software Included in This Release

For a detailed list of every package installed with this image, click here.

Earlier Versions

1.5.1

1.5.0

  • Upgraded Percona to Percona 5.5.24-rel26.0
  • Upgraded Xtrabackup to 2.0.0
  • Upgraded perconatoolkit to 2.1.1
  • Upgraded Quickbackup to version 3.0 which includes: xbstream, qpress, backupdir option, SMF name change to mysql-quickbackup, qb-username change
  • Fixed Quickbackup to not be dependent on Percona anymore
  • Added standard SM files: /etc/motd, /etc/release, /etc/product
  • Added default IPF rules in /etc/ipf/ipf.conf

1.3.9

  • Upgraded base dataset to use smartos-1.5.4 to fix redis install

1.3.8

  • Upgraded Percona to Percona-5.5.20-rel24.1 64-bit
  • Upgraded Xtrabackup to 1.6.5
  • Upgraded perconatoolkit to 2.0.3
  • Upgraded Quickbackup to version 2.0 (has databases SMF option)
  • Fixed Quickbackup to be dependent upon Percona running
  • Fixed Quickbackup bug in failing to rotate backups properly
  • Set query_cache_type 0 by default in all sizes

1.2.2

  • Fixed the way max_connections are set by size

1.2.1

  • Upgraded Percona to Percona 5.5.16-rel22 64-bit
  • Upgraded Xtrabackup to 1.6.3 with optimized (-O3) and 64-bit
  • Replaced mysqltoolkit with perconatoolkit 1.0.1

1.0.7

  • Initial release Percona 5.1.56
  • Xtrabackup 1.6
  • Quickbackup version 1.0
Labels:
percona percona Delete
mysql mysql Delete
xtradb xtradb Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.