Within a Primary/Replica service, there is a single Primary which replicates data to the Replicas. The Tungsten Connector handles connectivity by the application and distributes the load to the datasources in the dataservice.
Before continuing with deployment you will need the following:
The name to use for the cluster.
The list of datasources in the cluster. These are the servers which will be running MySQL.
The list of servers that will run the connector.
The username and password of the MySQL replication user.
The username and password of the first application user. You may add more users after installation.
All servers must be prepared with the proper prerequisites. See Appendix B, Prerequisites for additional details.
Install the Tungsten Cluster package or download the Tungsten Cluster tarball, and unpack it:
shell> cd /opt/continuent/software
shell> tar zxf tungsten-clustering-7.0.3-141.tar.gz
Change to the Tungsten Cluster directory:
shell> cd tungsten-clustering-7.0.3-141
Run tpm to perform the installation, using either the staging
method or the INI method. Review Section 10.1, “Comparing Staging and INI
tpm Methods”
for more details on these two methods.
Click the link below to switch examples between Staging and INI methods
shell> vi /etc/tungsten/tungsten.ini
[defaults]
user=tungsten
install-directory=/opt/continuent
profile-script=~/.bash_profile
replication-user=tungsten
replication-password=password
replication-port=13306
application-user=app_user
application-password=secret
application-port=3306
rest-api-admin-user=apiuser
rest-api-admin-pass=secret
[alpha]
topology=clustered
master=host1
members=host1,host2,host3
connectors=host4
Configuration group defaults
Configuration group alpha
If you plan to make full use of the REST API (which is enabled by default) you will need to also configure a username and password for API Access. This must be done by specifying the following options in your configuration:
rest-api-admin-user=tungsten
rest-api-admin-pass=secret
For more information on using and configuring the REST API, see Section 11.1, “Getting Started with Tungsten REST API”
Run tpm to install the software with the configuration.
shell > ./tools/tpm install
During the startup and installation, tpm will notify you of any problems that need to be fixed before the service can be correctly installed and started. If the service starts correctly, you should see the configuration and current status of the service.
Initialize your PATH
and environment.
shell > source /opt/continuent/share/env.sh
Do not include start-and-report
if you are taking over for MySQL native replication. See
Section 3.11.1, “Migrating from MySQL Native Replication 'In-Place'” for next steps
after completing installation.
Follow the guidelines in Section 2.5, “Best Practices”.