Showing entries 1 to 10 of 27
10 Older Entries »
Displaying posts with tag: load balancing (reset)
How to use Round-Robin Load Balancing with the Tungsten Connector

Overview The Skinny

Part of the power of Tungsten Clustering for MySQL / MariaDB is its intelligent MySQL Proxy, known as the Tungsten Connector. The Tungsten Connector has built-in read-write splitting capabilities, and it is also possible to configure different algorithms which select the appropriate slave (i.e. Round-Robin or Lowest-Latency).

The Question Recently, a customer asked us:

How do we best share the load between read-only slaves? Currently, there appears to be an imbalance, with most of the read-only queries reaching just one slave. What may we do to improve this situation?

This customer noticed that a couple of long …

[Read more]
Using Keep-Alives To Ensure Long-Running MySQL & MariaDB Sessions Stay Connected

Overview The Skinny

In this blog post we will discuss how to use the Tungsten Connector keep-alive feature to ensure long-running MySQL & MariaDB/Percona Server client sessions stay connected in a Tungsten Cluster.

Agenda What’s Here?

  • Briefly explore how the Tungsten Connector works
  • Describe the Connector keep-alives – what are they and why do we use them?
  • Discuss why the keep-alive feature is not available in Bridge mode and why
  • Examine how to tune the keep-alive feature in the Tungsten Connector

Tungsten Connector: A Primer A Very Brief Summary

The Tungsten Connector is an intelligent MySQL database proxy located between the clients and the database servers, providing a single connection point, while routing queries to …

[Read more]
Mastering Tungsten Clustering: Keeping a Consistent View of the Cluster

The Question

You already know about the Tungsten Connector which is the “secret sauce” that routes your application database traffic to the appropriate MySQL data source of your cluster.

Have you ever wondered how the Connector keeps track of the cluster configuration? How it always knows which host is the master (or masters in a Composite Multimaster topology), and which are slaves?

The Short Version

This information is actually held and maintained by the Managers, which monitor and take care of their local MySQL node.

Each one of the Connectors maintains a single connection to one, and only one, manager per data service. In the case of a Composite Multimaster topology, that will be one Manager chosen per site.

The Nitty Gritty

Every 3 seconds, each Manager …

[Read more]
Archive and Standby: Do More with Your Slave Replicas!

With its fully integrated solution, Continuent Clustering allows fine control of slave replicas:

  • Want to keep a slave read-only? Have a node that will never be switched-to and become a master itself? Still want to allow client applications to read data from it? We call it “Archive Slave”. It is particularly suitable for hosts that have low computational power and wouldn’t hold the write workload. All you need is to type a single cctrl command:
[LOGICAL:EXPERT] /alpha > datasource host3 set archive

Managers will never turn an archive slave into a master, whereas connector will still route to it for read-only traffic.

  • Prefer a slave as much up-to-date as possible? Protected from reads and that will preferably be selected in case of switch or failover? That’s the stand-by node. By preventing read traffic, you dedicate computing and networking power to replication, keeping latency as low …
[Read more]
Getting Started with MySQL Replication for High-Availability

Many organizations have MySQL or MariaDB databases at the core of their business—for processing and storing product sales, collecting information related to services offered, or just providing essential information to customers. As a result, keeping these databases running continuously can be critical for the success of an organization.

There are many components of a database system that a database administrator will need to consider for maintaining high availability. We considered server equipment (e.g., memory) in a previous introductory article. Now let’s look at using multiple servers for your MySQL and MariaDB databases—let’s look at replication.

Replication Overview

One common and effective way to structure a highly available database system is through some form of database replication. There are a few reasons …

[Read more]
Getting Started with MySQL Replication for High-Availability

Many organizations have MySQL or MariaDB databases at the core of their business—for processing and storing product sales, collecting information related to services offered, or just providing essential information to customers. As a result, keeping these databases running continuously can be critical for the success of an organization.

There are many components of a database system that a database administrator will need to consider for maintaining high availability. We considered server equipment (e.g., memory) in a previous introductory article. Now let’s look at using multiple servers for your MySQL and MariaDB databases—let’s look at replication.

Replication Overview

One common and effective way to structure a highly available database system is through some form of database replication. There are a few …

[Read more]
Severalnines News & Tools: New DevOps Guide Webinar, Load Balancing for MySQL Replay and More..

February 4, 2015 By Severalnines Check Out Our Latest Technical Resources for MySQL, MariaDB & MongoDB Clusters

 

Like every month, we have created new content and tools for you; here is a summary of what we’ve published. Please do check it out and let us know if you have any comments or feedback.

 

New Live Technical Webinars

 

A DevOps Guide to Database Infrastructure Automation for eCommerce

Tuesday, February 17th

 

Infrastructure automation isn’t easy, but it’s not rocket science either, says Riaan Nolan. Automation is a worthwhile investment for retailers serious about eCommerce, but deciding on which …

[Read more]
Load Balancing for MySQL with HAProxy - Webinar Replay in English & French

January 30, 2015 By Severalnines

In this joint webinar series with our friends from the HAProxy team, we covered the concepts around the popular open-source HAProxy load balancer, and demonstrated how to use it with SQL-based database clusters. We also discussed HA strategies for HAProxy with Keepalived and Virtual IP. 

 

Thanks to everyone who participated in these two sessions this week! Please see below for details on next week’s follow up session 'Performance Tuning for HAProxy & MySQL'.

 

The topics covered this week included: 

  • What is HAProxy?
  • SQL Load balancing for MySQL
  • Failure detection using MySQL health checks
  • High Availability with Keepalived and Virtual IP
  • Use cases: MySQL/MariaDB Galera Cluster, MySQL NDB …
[Read more]
Webinar Replay & Slides: Performance Tuning of HAProxy for Database Load Balancing

September 11, 2014 By Severalnines

 

Thanks to everyone who attended and participated in this week’s webinar on ‘Performance Tuning of HAProxy for Database Load Balancing’. And special thanks to our guest speaker, Baptiste Assmann of HAProxy Technologies. 

 

If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

 

Watch the replay of this webinar to learn about what HAProxy can tell you about your application and database instances. And understand the difference between short-lived connections and persistent connections, and how they affect the performance and availability of your applications. 

 

Watch the replay Performance …

[Read more]
New Webinar: Performance Tuning of HAProxy for Database Load Balancing

August 13, 2014 By Severalnines

 

New Webinar: Performance Tuning of HAProxy for Database Load Balancing

As a follow-up to our previous webinar on MySQL Load Balancing and HAProxy, we are glad to organize a new webinar on Performance Tuning of HAProxy. Tuning your HAProxy instances can significantly increase the performance of your application and decrease response times. Joint us for this special session to find out more!

 

Date, Time & Registration: 

Tuesday, September 9th @10am CEST (Europe & MEA / Asia Pacific)

Register here

Tuesday, …

[Read more]
Showing entries 1 to 10 of 27
10 Older Entries »