3
MySQL is a fast, stable and true multi-user, multi-threaded SQL database server.
4
SQL (Structured Query Language) is the most popular database query language in
5
the world. The main goals of MySQL are speed, robustness and ease of use.
7
Percona is fork of MySQL by Percona Inc. which focuses on maximizing
8
performance, particularly for heavy workloads. It is a drop-in replacement for
9
MySQL and features XtraDB, a drop-in replacement for the InnoDB storage engine.
11
[http://www.mysql.com](http://www.mysql.com)
13
[http://www.percona.com/software/percona-server](http://www.percona.com/software/percona-server)
3
[MySQL](http://www.mysql.com) is a fast, stable and true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular database query language in the world. The main goals of MySQL are speed, robustness and ease of use.
5
This charm also can deploy [Percona Server](http://www.percona.com/software/percona-server) is fork of MySQL by Percona Inc. which focuses on maximizing performance, particularly for heavy workloads. It is a drop-in replacement for MySQL and features XtraDB, a drop-in replacement for the InnoDB storage engine.
19
11
To deploy a MySQL service:
23
Once deployed, you can retrive the MySQL root user password by logging in to the machine via `juju ssh`
24
and readin the `/var/lib/mysql/mysql.passwd` file. To log in as root MySQL User at the MySQL console
25
you can issue the following:
15
Once deployed, you can retrive the MySQL root user password by logging in to the machine via `juju ssh` and readin the `/var/lib/mysql/mysql.passwd` file. To log in as root MySQL User at the MySQL console you can issue the following:
28
18
mysql -u root -p=`cat /var/lib/mysql/mysql.passwd`
30
To change deployment to a Percona server:
32
juju set mysql flavor=percona
36
22
You can tweak various options to optimize your MySQL deployment:
68
54
juju set mysql query-cache-type=ON
69
55
juju set mysql query-cache-size=-1
57
Deploying Percona Server is an option in this charm, you can do so by editing the `flavor` option:
59
juju set mysql flavor=percona
61
WARNING: Migrating from MySQL to Percona Server in this fashion is currently a one-way migration, once you migrate you cannot migrate back via Juju.
73
67
MySQL supports the ability to replicate databases to slave instances. This
74
68
allows you, for example, to load balance read queries across multiple slaves or
93
87
juju add-unit mysql-slave
97
This charm provides relations that support monitoring via either Nagios or
98
Munin. Refer to the appropriate charm for usage.
91
This charm provides relations that support monitoring via either [Nagios](https://jujucharms.com/precise/nagios) or [Munin](https://jujucharms.com/precise/munin/). Refer to the appropriate charm for usage.
93
## Contact Information
95
Though this will be listed in the charm store itself don't assume a user will know that, so include that information here:
97
### MySQL and Percona Server Contact Information
99
- [MySQL Homepage](http://www.mysql.com)
100
- [MySQL Bug Tracker](http://bugs.mysql.com/)
101
- [Percona Server Homepage](http://www.percona.com/software/percona-server)
102
- [Percona Server Bug Tracker](https://bugs.launchpad.net/percona-server/)
103
- [MySQL mailing lists](http://lists.mysql.com/)
b'\\ No newline at end of file'