Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 18

Displaying posts with tag: load balancing (reset)

New Webinar: Performance Tuning of HAProxy for Database Load Balancing
+1 Vote Up -0Vote Down
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!   [Read more...]
Picking the Right Clustering for MySQL: Cloud-only Services or Flexible Tungsten Clusters? New webinar-on-demand
+0 Vote Up -0Vote Down
As businesses head into the cloud, it is tempting to reach for the first product that offers to make database operation as simple as punching a few buttons on a menu.  However, there’s a big difference between firing up cloud database services such as Amazon RDS for testing or development and finding a solution that can handle hundreds of millions of transactions daily. This webinar-on-demand
New Webinar on July 9th: How To Set Up SQL Load Balancing with HAProxy
+1 Vote Up -0Vote Down
June 17, 2014 By Severalnines

 

We continuously see great interest in MySQL load balancing and HAProxy, so we thought it was about time we organised a live webinar on the topic!

 

As most of your will know, database clusters and load balancing go hand in hand. 

 

Once your data is distributed and replicated across multiple database nodes, a load balancing mechanism helps distribute database requests, and gives applications a single database endpoint to connect to. 

 

Instance failures or

  [Read more...]
MaxScale 0.7.0 Overview and Highlights
+1 Vote Up -0Vote Down

MaxScale 0.7.0 was recently released (it is the 4th alpha, with the beta on the near horizon), and is available for download here.

The release contains a number of new enhancements as well as 8 bugs fixes.

Enhancements:

  • Galera Support: Enhanced support for Galera cluster to allow Galera to be used as a High Available Cluster with no write contention between the nodes. MaxScale will control access to a Galera Cluster such that one node is designated as the master node to which all write operations will be sent. Read operations will be sent to any of the remaining nodes that are part of the cluster. Should the currently elected master node fail MaxScale will automatically promote one of the remaining nodes to become the new master node.
  • Multiple Slave
  •   [Read more...]
    MaxScale 0.6.0 Overview and Highlights
    +1 Vote Up -0Vote Down

    MaxScale 0.6.0 was recently released (it is the 3rd alpha, with the beta on the near horizon), and is available for download here.

    The particular release only contains 2 great additions and 2 important fixes (and note development continues with the 1.0 (GA) features, but these have not been put into this alpha version).

    Important Additions:

  • A feature-complete read/write splitting module, i.e. read and write operations are now balanced in a smarter way to master or slave servers.
  • New client-based features, such as a version string that provides compatibility with the major connectors, the ability to connect through the root user and the use of the Unix socket when MaxScale is co-located with a client application on the same server.
  • Important Bug

      [Read more...]
    Continuent Tungsten 2.0.2 Release Notification
    +0 Vote Up -0Vote Down
    We are pleased to inform you that the new Continuent Tungsten 2.0.2 is now available. Continuent Tungsten keeps data available to applications 7x24 through hardware failures, maintenance, and software upgrades. It ensures business continuity and performance by keeping up-to-date data closer to the user, and increases application throughput and improves response time by load balancing SQL
    MaxScale has now its own public irc channel
    +1 Vote Up -0Vote Down

    MaxScale is a Proxy for the MySQL protocol built with a modular architecture. The underlying concept of modules allows to extend the MaxScale proxy services. The current version implements Read Write splitting and Connection Load Balancing. Internally MySQL queries go through a SQL parsing phase. This gives MaxScale great capabilities regarding queries routing.

    So if [...]

    MaxScale, ProxySQL and MySQL Proxy
    +2 Vote Up -0Vote Down

    At FOSDEM 2014 ProxySQL and MaxScale were both presented. Both are proxy that can help build sophisticated MariaDB/MySQL architectures. But currently what is the most used proxy with MySQL? It is HAproxy. HAproxy is a level 4 proxy that has no knowledge of the MySQL protocol. Being low level makes it very fast but it [...]

    MaxScale - We'd Love to Know Your Thoughts
    +0 Vote Up -0Vote Down

    As you've heard, MaxScale was recently released, and we'd love for you to try it out and let us know your thoughts.

    Anders Karlsson and Ivan Zoratti have written some excellent posts on downloading and setting it up, so if you're intersted in that, please see their respective posts for quick, detailed instructions.

    read more

    Secrets of mysqlnd Presentation
    +1 Vote Up -1Vote Down

    Download PDF Presentation

    At the recent New York PHP Group in New York, I gave a presentation on “Secrets of mysqlnd”. While there are no real “secrets” of the new MySQL Native Driver for PHP, available in PHP 5.3, and the default for PHP 5.4+ replacing libmysqlclient, there are new features of the driver many are unaware of. If you have ever had to fight the gods with compiling a particular version of PHP with the right libmysqlclient dependency, the good news is that legacy requirement is no longer necessary.

    Some of the topics discussed in detail


      [Read more...]
    Tungsten University: Unleashing the Power of Tungsten Connectors
    +0 Vote Up -0Vote Down
    How To Configure Tungsten Connector For Load Balancing, Read/Write Splitting, Automatic Failover And Online Maintenance
    MySQL Load Balancing, Read/Write Splitting, Automatic Failover And Online Maintenance
    +1 Vote Up -0Vote Down
    How To Configure Tungsten Connector For Load Balancing, Read/Write Splitting, Automatic Failover And Online Maintenance  Tungsten clusters use the Tungsten Connector to ensure your applications transparently connect to the master. This enables fail over and seamless switching of masters for online maintenance. However, you can do far more. Tungsten Connector allows you to make better use of
    Tungsten University: Unleashing the Power of Tungsten Connectors
    +0 Vote Up -0Vote Down
    Tungsten clusters use the Tungsten Connector to ensure your applications transparently connect to the master. This enables failover and seamless switching of masters for maintenance. However, you can do far more. Tungsten Connector allows you to make better use of hardware by load balancing SQL traffic to slaves. There is also a wealth of configuration settings to help Tungsten Connector manage
    Some sharding support and cache locality optimization support for PHP MySQL driver
    Employee +5 Vote Up -0Vote Down

    It is time for christmas presents: some sharding support and cache locality optimizations are coming with PECL/mysqlnd_ms 1.5. PECL/mysqlnd_ms is a plugin for the mysqlnd library. The plugin adds replication and load balancing support to any PHP MySQL API (mysql, mysqli, PDO_MySQL) if compiled to use the mysqlnd library.

    As a MySQL user you can choose between a wide variety of clustering solutions to scale-out. Your options range from eventual consistent solutions to strong consistent ones, from built-in (MySQL Replication, MySQL Cluster) to third party or home-grown. PECL/mysqlnd_ms is a client side load

      [Read more...]
    MySQL JDBC Load Balancing with MySQL Cluster
    +0 Vote Up -0Vote Down

    Here's a neat tip posted by Henrik Ingo from the MySQL Telecom Team

    It's not really properly documented in the manual part, but I found in the changelogs, and confirmed on IRC that to do load-balancing across the SQL nodes in MySQL Cluster, you would use a different JDBC connection string with the "loadbalance" keyword added...
    jdbc:mysql:loadbalance://host-1,host-2,...host-n/database?loadBalanceBlacklistTimeout=5000
    
    Simple MySQL Proxy Failover
    +0 Vote Up -0Vote Down

    mysql-proxy defaults to round-robin load balancing. There are fancy tricks around to get mysql-proxy to balance connections based on how many idle connections there are in a proxy-based connection pool.

    But there is no code that I found that would simply load balance based on “always go to one server, go to another server only when the first server is down.”

    Well, I spent way too long figuring this out today, again running into the problem where the manual hasn’t been updated. I have indeed made a Forge snippet of this code, but it does not hurt to post it here.

    This was in fact taken from

      [Read more...]
    More progress on High Performance MySQL, Second Edition
    +0 Vote Up -0Vote Down

    Whew! I just finished a marathon of revisions. It's been a while since I posted about our progress, so here's an update for the curious readers.

    High Performance MySQL, Second Edition: Replication, Scaling and High Availability
    +0 Vote Up -0Vote Down

    Continuing in the tradition, which I hope has been as helpful to you as it has been to me, I'm opening the floor for suggestions on chapter 9 of the upcoming High Performance MySQL, Second Edition. Unlike the other chapters for which I've listed outlines, this one isn't substantially written yet. It's in detailed outline form at this point (a tactic that has worked very well for us so far -- I'll write about that someday).

    I'm trying to get feedback much earlier in this chapter's lifecycle, for several reasons. Two of the most important are that this is one of the first chapters I've had a chance to really take from scratch, and the chapters I haven't written from scratch have been harder to organize, as you've probably seen from the last few outlines I posted. There's a lot of value in working top-down on this deep encyclopedia-style material.

    Read on for the outline and more thoughts I just can't keep to myself.

    Showing entries 1 to 18

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.