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: MaxScale (reset)

Moving On
+0 Vote Up -0Vote Down
I have a difficult task of making this post interesting, helpful and personal at the same time. I think the main goal is to balance these aspects, and I really appreciate your comments and suggestions that I will add here.For the busy readers who may be put off by the length of this post, here is a very short summary: I spent 4 wonderful years, first as the head of Field Services, then as a CTO, I believe it is now time for a change, so I am leaving SkySQL. I am leaving behind a great company and very good friends, but I am not disappearing completely, and I will continue supporting the work I started and the projects I created with the help of such great people.For many, leaving a company is not easy, and it is extremely difficult if you have contributed to its creation and development since the beginning. Even more difficult is to depart  [Read more...]
Script to manage MaxScale
+1 Vote Up -0Vote Down
MaxScale 1.0 from SkySQL is now in Beta and there are some cool features in it, I guess some adventurous people has already put it into production. There are still some rough edges and stuff to be fixed, but it is clearly close to GA. One thing missing though are something to manage starting and stopping MaxScale in a somewhat controlled way, which is what this blog is all about.

I have developed two simple scripts that should help you manage MaxScale in a reasonable way, but before we go into the actual scripts, there are a few things I need to tell you. To begin with, if you haven't yet downloaded MaxScale 1.0 beta, you can get it from MariaDB.com, just go to Resources->MaxScale and to get to the downloads you first need to register (which is free). Here are downloads to

  [Read more...]
MySQL Slave Scaling and more
+3 Vote Up -0Vote Down

Jean-François talks about binlog servers. Take a look here: http://blog.booking.com/mysql_slave_scaling_and_more.html

MariaDB Replication, MaxScale and the need for a binlog server
+2 Vote Up -0Vote Down


This is an introduction to MariaDB Replication and to why we need a binlogs server and what this is. The first part is an introduction to replication basics, and if you know this already, then you want want to skip past the first section or two.

MariaDB Replication

MySQL and MariaDB has a simple but very effective replication system built into it. The replication system is asynchronous and is based on a pull, instead of a push, system. What this means in short is that the Master keeps track of the DML operations and other things that might change the state of the master database and this is stored in what is called the binlog. The slave on the other hand is responsible for getting the relevant information from the master to keep up to speed. The binlogs consist of a number of files that the master generates, and the traditional
  [Read more...]
MaxScale 1.0-beta is out - Happy Birthday MaxScale!
+2 Vote Up -0Vote Down
It was a year ago, on a nice Sunday night of the English Summer (apologies for the oxymoron), that Mark Riddoch came to see me and together we headed to the Vansittart Arms, our local family pub round the corner. A pint of London Pride on one side and a Honey Dew on the other were the perfect add-on to Mark’s MacBook Pro, on which Mark was showing me the 0.1 version of MaxScale. It was the result of the joint efforts of Mark’s team, Massimiliano and Vilho, who had worked hard to bring to life the first version of something that I believe will be a natural addition to clusters of  [Read more...]
MariaDB hugged Helsinki
+0 Vote Up -0Vote Down
MariaDB Roadshow Helsinki

One could say that MariaDB originates from Finland’s capital Helsinki. In fact so does MySQL. It was in the Helsinki area that MySQL saw daylight. It was here that Monty Widenius laid the ground for MySQL already in the 80’s, maybe even 1979, when he created UNIREG from which parts were reused when he together with the other 2 founders of MySQL released the first version of MySQL in 1995.

Last week, 19 years later, a MariaDB event was held in Helsinki. It was SkySQL that arranged the first in a row of this year’s MariaDB Roadshow events. The agenda included a walkthrough of

  [Read more...]
MaxScale 0.7 Feature Highlights
+2 Vote Up -0Vote Down

The latest set of updates for MaxScale has just been released, among the highlights of this alpha release are improved Galera support, the introduction of the first phase of the filter API and server maintenance mode.

Galera Support

MaxScale has always supported Galera, at least since the earliest downloadable release, now it has the ability to use Galera in a different way.

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.


  • 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...]
    MaxScale 0.6
    +0 Vote Up -0Vote Down
    Kudos to the SkySQL Engineering team, who released the 3rd alpha version of MaxScale, a database proxy for MySQL, MariaDB and Percona servers, labeled MaxScale 0.6.
    This version comes with two 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 MariaDB and MySQL 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.

    Binaries and source code are “hidden” here: http://downloads.skysql.com/files/SkySQL/MaxScale.
    The project is on GitHub: https://github.com/skysql/MaxScale/
    Other helpful links are:

      [Read more...]
    MySQL related IRC discussion channels
    +0 Vote Up -0Vote Down

    There are many MySQL related IRC discussion channels as the ecosystem itself grows. I join the following. Are there any that I’m missing?

    Freenode (irc.freenode.net):

    • #mysql – main channel for all kinds of end user MySQL related discussions (the noisiest of the lot, naturally)
    • #maria – main channel for all kinds of MariaDB related discussions
    • #webscalesql – for all kinds of WebScaleSQL discussions
    • #percona – main channel for all kinds of Percona related discussions
    • #tokutek – main channel for Tokutek discussions (TokuDB or TokuMX)
    • SkySQL-specific channels: #maxscale and #mariadb-mgr

    OFTC (irc.oftc.net):

    • #debian-mysql – for all kinds of Debian MySQL related bits (packaging, bugs, etc.)
      [Read more...]
    MaxScale for the rest of us - Part 4
    +2 Vote Up -0Vote Down
    If you have followed this series of blogs (Introduction in part 1, Setting up the cluster in part 2 and Installing and configuring MaxScale in part 3), you should now have MaxScale up and running on a Cluster using MariaDB Replication. But as I said when I left off in Part 3, there is more to it.

    To begin with, let's look at how the replication system works. Let's insert some more data through MaxScale, this should end up with the master and the replication system will handle making this available on the slaves. So on the

      [Read more...]
    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

    MaxScale for the rest of us - Part 3
    +2 Vote Up -0Vote Down
    This third post in this series of blogs about MaxScale is finally getting where you want to go: Install and configure MaxScale. The first blog in this series was an overview of what MaxScale is and the second about how to set up a Cluster of MariaDB servers, using MariaDB Replication, for MaxScale to access. But now it's time to introduce MaxScale.

    If you skipped the second post as you already know how to set up MariaDB with Replication and all that, be remineded that I will use the same Linux server setup as outlined there even for the MaxScale server and for a client to do some testing, and I recommend you stick with that for now (for

      [Read more...]
    MaxScale for the rest of us - Part 2
    +0 Vote Up -0Vote Down
    The first blogpost in this series did a quick introduction to MaxScale, but now it is time start getting our hands dirty. We will get a more practical view on MaxScale and begin to put it to work. The following is based on a simple Proof of Concept that I did recently. The application is a mid-size web-based online shop where scalability is becoming an issue. They use PHP and with an old and rather inflexible framework, so even though changing how the database is used is possible, it's not easy and having database routing in the application code isn't a very good idea either.

    The scalability issues affects reads, but as all traffic is directed to one database server, when this server gets slow, writes, like when entering an order, gets very slow,

      [Read more...]
    Upcoming MariaDB Enterprise and MaxScale Webinar
    +1 Vote Up -0Vote Down

    As many of you know, both MariaDB Enterprise and MaxScale have been released and are now available for use.

    Since they are both so new, I just wanted to let everyone know Ivan Zoratti will conducting a webinar next week discussing both of these technologies.

    I’m looking forward to it, and should anyone out there be interested in either MDBE or MaxScale, we hope you’ll attend, and get any questions you might have answered.

    When: February 6, 2014 – 6:00pm CET

    Sign up now here:


    MaxScale for the rest of us - Part 1
    +4 Vote Up -0Vote Down

    MaxScale for the rest of us - Part 1

    SkySQL released MaxScale as Open Source on github a few weeks ago. For some instructions on how to install and configure it, Ivan Zoratti has written a blog about that, and Mark Riddoch has written about why we need MaxScale here, but what I will try in a series of blogs is to describe what MaxScale is, in terms of what you can do with it, and to put it into context, so that you have an idea why you would want to install it in the first place. I will also show how to configure and manage MaxScale. This first post is a quick introduction to MaxScale.

    So what is

      [Read more...]
    A Close Encounter with MaxScale
    +1 Vote Up -0Vote Down

    MaxScale is the new proxy server from the SkySQL/MariaDB team. It provides Connection Load Balancing (CLB) and Statement Load Balancing (SLB) out of the box. This post is a [relatively] quick “how to” install, configure and test SLB with the read/write splitting module.

    Step 1 - Server preparation

    If you do not have many HW resources, you may run everything on a single Linux instance, but the best way to test MaxScale is to use at least 4 servers: one for MaxScale and for the client apps, one as Master and two as slaves - so, 4 in total. In this post I am going a bit further, I will use 5 servers:
    Max 0 - For client apps (
    Max 1 - The master server (
    Max 2 - The first slave (
    Max 3 - The second slave (
    Max 4 - The third slave (
    Max 6 - The MaxScale

      [Read more...]
    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.