Archives: Bridge
New Feature in Tungsten Clustering 6.0.3: Tungsten Connector Read Affinity Tuning
In this blog post, we describe the new Read Affinity tuning feature of the Tungsten Connector. Tungsten Connector read affinity now supports multiple dataservices with ordering and exclusion (only one was previously allowed). You may now fine-tune the affinity per user in user.map and via the global tpm configuration option connector-affinity. Affinity is defined as […]
Filed Under: MySQL-aware Proxies
Mastering Tungsten Clustering Series: Converting a standalone cluster to a Composite Primary/DR topology using INI configuration
In this blog post, we demonstrate how to convert a single standalone cluster into a Composite Primary/DR topology running in two data centers. Our example starting cluster has 5 nodes (1 master and 4 slaves) and uses service name alpha. Our target cluster will have 6 nodes (3 per cluster) in 2 member clusters alpha_east […]
Filed Under: Mastering Tungsten Clustering
Mastering Tungsten Clustering Series: Tungsten and SELinux, a Case Study
In this blog post, we talk about what happened during an installation of the Tungsten Cluster into an environment with SELinux running and mis-configured. An attempt to execute tpm install on v5.3.2 recently failed with the below error: [crayon-5c6beb1ec8c4b477808800/] Worse, this customer reported that this appeared as a WARNING only in Dev and Staging tests. […]
Filed Under: Mastering Tungsten Clustering
Mastering Tungsten Clustering Series: Configuring Startup on Boot
In this blog post, we talk about how to configure automatic start at boot time for the Tungsten Clustering components. By default, Tungsten Clustering does not start automatically on boot. To enable Tungsten Clustering to start at boot time, use the deployall script provided to create the necessary boot scripts: [crayon-5c6beb1ec908e056866825/] To disable automatic startup […]
Filed Under: Mastering Tungsten Clustering
Mastering Tungsten Clustering Series: Automatic Reconnect in the Tungsten Connector
In this blog post, we talk about the Automatic Reconnect feature in the Tungsten Connector. Automatic reconnect enables the Connector to re-establish a connection in the event of a transient failure. Under specific circumstances, the Connector will also retry the query. Connector automatic reconnect is enabled by default in Proxy and Smartscale modes. Use the […]
Filed Under: Mastering Tungsten Clustering
Mastering Tungsten Clustering Series: Manual Switch Behavior Tuning in the Tungsten Connector
In this blog post, we talk about how existing client connections are handled by the Tungsten Connector when a manual master role switch is invoked and how to adjust that behavior. When a graceful switch is invoked via cctrl or the Tungsten Dashboard, by default the Connector will wait for five (5) seconds to allow […]
Filed Under: Mastering Tungsten Clustering
Mastering Tungsten Clustering Series: Connection Handling in the Tungsten Connector
In this blog post, we talk about how query connections are handled by the Tungsten Connector, especially read-only connections. There are multiple ways to configure session handling in the Connector. The three main modes are Bridge, Proxy/Direct and Proxy/SmartScale. In Bridge mode, the data source to connect to is chosen ONCE for the lifetime of […]
Filed Under: Mastering Tungsten Clustering