Appliance:MySQL Appliance
From rPath Wiki
|
|
An appliance that bundles up MySQL and the rPath Appliance Platform (rAP) to provide a self-contained, turn-key, updateable database appliance.
Download
Download page on rBuilder Online.
Installation
The fastest way to get started is to download one of the virtual appliance images and boot it. Alternatively, you can download the ISO images and complete the graphical installation to install MySQL appliance on a dedicated system.
 | For more information on using rPath-based appliances with various virtual machine technologies, see Using rBuilder Images with Virtual Machines |
Configuration
- Login to the rPath Appliance Platform interface and complete the wizard. rAP will be at
https://<your_ip>:8003/orhttp://<your_ip>:8004/. - Set a password for
webaccount, it will be used to access web-interface to database. - The MySQL database service starts automatically upon first boot, no additional configuration required.
Configure networking
By default, this appliance is set to use DHCP to obtain its network address automatically.
To change the network configuration for this appliance, you can use the rPath Appliance Platform web-based configuration UI. See the rPath Appliance Platform User Guide for detailed instructions.
Configure MySQL
- Point your browser to
http://<your_ip>/phpMyAdmin/, login with user nameweband the password you set in the rAP wizard. - You can create new users to access MySQL both from the localhost and from other hosts. But please do not change
root@localhostrecord, because it's used internally by phpMyAdmin.
Security Tips
- Use secure
httpsprotocol instead of plainhttpto access rAP or phpMyAdmin. - If you're creating new users that can access MySQL from other hosts, do not forget to provide passwords for them.
Passwords
| purpose | username | default password | how to change |
|---|---|---|---|
| console access | root | empty |
|
| rAP access | admin | password |
|
| phpMyAdmin access | web | not set |
|
| MySQL super-user | root | empty | do not change since this user can access MySQL from localhost only and is used by phpMyAdmin |
Updates
Unlike software appliances based on "snapshot" techniques, appliances built with rPath technologies can updated incrementally as new features are added by the development team. Launch updates during remote administration through the rPath™ Appliance Platform, or bypass the rPath Appliance Platform to use a direct command.
Update with rPath Appliance Platform
If you have updated to at least version 5.0.24 (December 14, 2006) of this appliance, you can use the rPath Appliance Platform Agent to update remotely using a web interface. The rPath Appliance Platform Agent interface can be accessed using:
https://<appliance_ip_or_hostname>:8003/
See the rPath Appliance Platform User Guide for full instructions.
 | Please note that if you have added additional packages using conary update, these packages will be removed by a rPath Appliance Platform update. To preserve this custom update of the appliance software, do not use the rPath Appliance Platform Agent. Instead, use conary updateall command line (see next section). Alternatively, you can change rPath Appliance Platform Agent's default behavior by modifying /etc/raa/prod.cfg file and change the line updatetroves.migrate = True to updatetroves.migrate = False |
Update with Conary Commands
If you have downloaded a version of the appliance without the rPath Appliance Platform, login to your appliance as root and issue the command:
conary updateall
This command will update the appliance, including adding the rPath Appliance Platform. If you have added other packages using conary update, they will remain on the system.
Support
MySQL Appliance is a community supported project. Questions about MySQL Appliance should be raised on the MySQL Appliance discussion list
You can also discuss the project using the discussion tab in this wiki.