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 30 of 52 Next 22 Older Entries

Displaying posts with tag: Other (reset)

Heartbleed OpenSSL Bug: Impact on ClusterControl Users & Recommendations on How to Protect your Systems
+0 Vote Up -0Vote Down
April 10, 2014 By Severalnines


In the wake of recent concerns and debates raised around the Heartbleed bug, we wanted to update Severalnines ClusterControl users on any impact this bug might have on ClusterControl & associated databases and/or applications.




If your ClusterControl's web application has been accessible on the internet, then most likely you have also been exposed to the Heartbleed OpenSSL security bug, see: http://heartbleed.com for more details. 

By default, our database deployment script enables SSL encryption for the

  [Read more...]
9 Reasons For Attending The Percona Live MySQL Conference & Expo 2014
+0 Vote Up -0Vote Down
March 28, 2014 By Severalnines


Percona Live MySQL Conference & Expo - March 31st to April 4th

The Severalnines Team Will Be Onsite at Booth 418 - Come Say Hello!



If you’re still thinking about whether or not you should be attending the Percona Live MySQL Conference & Expo that starts on Monday 31st of March, here are 9 reasons (we are Severalnines after all) on why we’ll be there. May these help you positively in

  [Read more...]
How to Migrate Your Application to Amazon Virtual Private Cloud without Downtime
+0 Vote Up -0Vote Down
March 27, 2014 By Severalnines

With datacenters being stretched by resource-intensive applications, more and more businesses are outgrowing their existing in-house capacity and having to reconfigure their IT operations. But how do you migrate a busy application to a totally new data center without downtime? How will the application scale in a virtualized cloud environment? And how do you guard against cloud server failures and keep a high level of uptime?



In this example, we will show you how to migrate a Web application (Wordpress) from a local data center to a AWS VPC. Without downtime even! 


Main steps:

      [Read more...]
    Clustering SugarCRM with MySQL Galera for High Availability and Performance
    +1 Vote Up -0Vote Down
    March 20, 2014 By Severalnines

    SugarCRM is the leader in open source CRM systems, and has been adopted by some of the largest firms, including IBM. The CRM software includes all sales, marketing and support tools out of the box, and can also be extended to integrate social media sources. For those depending on SugarCRM, especially when deploying in cloud environments with lower SLAs, having a high availability architecture can make a lot of sense. 

    In this blog post, we will show you how to cluster SugarCRM Community Edition

      [Read more...]
    Webinar Replay & Slides: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
    +0 Vote Up -0Vote Down
    March 13, 2014 By Severalnines

    Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.


    Special thanks to Seppo Jaakola, CEO at Codership, the creators of Galera Cluster, and to Johan Andersson, CTO at Severalnines, for their presentations and the live demo.


    Webinar topics discussed: 

    • Application use cases for Galera
    • Schema design
    • Events and Triggers
    • Query design
    • Migrating the schema
    • Loading initial data into the
      [Read more...]
    How to use the ClusterControl REST API to automate your Database Cluster
    +0 Vote Up -0Vote Down
    March 11, 2014 By Severalnines

    For ops folks with multiple environments and instances to manage, a fully programmable infrastructure is the basis for automation. ClusterControl exposes all functionality through a REST API. The web UI also interacts with the REST API to retrieve monitoring data (cluster load, alarms, backup status, etc.) or to send management commands (add/remove nodes, run backups, upgrade a cluster, add/remove load balancer, etc.). The API is written in PHP and runs under Apache. The diagram below illustrates the architecture of ClusterControl.

    Figure: ClusterControl

      [Read more...]
    Resources for HA Database Clusters: New ClusterControl Release, Galera Migration Webinar & Blog Resources
    +0 Vote Up -0Vote Down
    March 6, 2014 By Severalnines


    Check Out Our Latest Resources for MySQL, MariaDB & MongoDB Clusters


    Here is a summary of resources & tools that we’ve made available to you in the past weeks. If you have any questions on these, feel free to contact us!


    ClusterControl 1.2.5 released

    We are pleased to announce the release of ClusterControl 1.2.5, which now supports MySQL 5.6 and Global Transaction IDs to enable cross-datacenter and cloud replication over high latency networks. Galera users are now able to assign nodes to their

      [Read more...]
    How to Set Up Asynchronous Replication from Galera Cluster to Standalone MySQL server with GTID
    +1 Vote Up -0Vote Down
    March 3, 2014 By Severalnines

    Hybrid replication, i.e. combining Galera and asynchronous MySQL replication in the same setup, became much easier with MySQL 5.6 and GTID. Although it was fairly straightforward to replicate from a standalone MySQL server to a Galera Cluster, doing it the other way round (Galera → standalone MySQL) was a bit more challenging. At least until MySQL 5.6 and GTID. 

    There are a few good reasons to attach an asynchronous slave to a Galera Cluster. For one, long-running reporting/OLAP type queries on a Galera node might slow down an entire cluster, if the reporting load is so intensive that the node has to

      [Read more...]
    MongoDB and Hadoop - Stockholm MongoDB User Group Meetup - Monday, March 3, 2014
    +0 Vote Up -0Vote Down
    February 27, 2014 By Severalnines


    Stockholm MongoDB User Group Meetup: “MongoDB and Hadoop”

    Monday, March 3, 2014 starting @ 5:00 PM


    Join us next Monday as we host the Stockholm MongoDB User Group Meetup in Kista, or the Wireless Valley as it is also referred to. 


    Our very own Vinay Joosery will be speaking about how to best automate the management & deployment of database clusters, specifically MongoDB clusters though the same principles apply for MySQL, MariaDB and Percona XtraDB based clusters. Henrik Ingo of MongoDB will be talking about Analytics with MongoDB & Hadoop. And Jim Dowling, a Senior Researcher at the Swedish Institute of Computer Science, will talk

      [Read more...]
    How to Deploy Galera Cluster for MySQL using Docker Containers
    +0 Vote Up -0Vote Down
    February 18, 2014 By Severalnines

    Virtual Machines are great, and very useful when trying out new software. However, they might be an unnecessarily heavyweight solution when testing clusters, especially if these consist of multiple nodes running exactly the same software. Each VM runs a full-blown OS image. On the other hand, Linux Containers (LXC) are an efficient alternative to OS-level virtualization and can run multiple isolated systems on a single host. Docker is a wrapper around LXC, it automates the deployment of applications inside containers. 

    A notable advantage if you run with Docker + LXC is you can run many containers on a single host.

      [Read more...]
    Webinar: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
    +0 Vote Up -0Vote Down
    February 13, 2014 By Severalnines


    Galera is slowly but surely establishing itself as a credible replacement for traditional MySQL master-slave architectures. 

    The benefits are clear - a true multi-master InnoDB setup with built-in fail-over, potentially across data centers. 

    But how do you migrate? Does the schema or application change? What are the limitations? Can migration be done online, without service interruption? What are the potential risks, and how to address those?


    Webinar: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster


    Tuesday, March

      [Read more...]
    How to Cluster Liferay with MySQL Galera and Ceph for High Availability and Performance
    +1 Vote Up -1Vote Down
    February 3, 2014 By Severalnines

    Liferay is an open-source content management system written in Java. It is used by a number of high traffic sites, as this survey suggests. 

    Clustering Liferay and other components such as the database and the file system is a good way to handle the performance requirements of a high traffic site. The latest Liferay version has introduced features that simplify clustering, such as built-in support for Ehcache clustering, Lucene replication, read/write splitting capabilities for database (in case if you run on

      [Read more...]
    Webinar Replay & Slides: Repair & Recovery for Your MySQL, MariaDB & MongoDB / TokuMX Clusters
    +0 Vote Up -0Vote Down
    January 23, 2014 By Severalnines


    Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again and browse through the slides, they are now available online.


    Special thanks to Seppo Jaakola from Codership, the creators of Galera Cluster, for walking us through the various scenarios of Galera recovery. 


    Webinar topics discussed: 

    • Redundancy models for Galera, NDB and MongoDB / TokuMX
    • Failover & Recovery (Automatic vs Manual)
      [Read more...]
    Active-active Alfresco cluster with MySQL Galera and GlusterFS
    +1 Vote Up -0Vote Down
    January 20, 2014 By Severalnines

    Alfresco is a popular collaboration tool available on the open-source market. It is Java based, and has a content repository, web application framework and web content management system. For critical large-scale implementations that require 24*7 uptime, a multi-node cluster would be appropriate. Since Alfresco depends on external components such as the database and the filesystem, clustering the Alfresco instances only would not be enough.

    In this post, we are going to show you how to deploy an active-active Alfresco cluster with MySQL Galera Cluster (database), GlusterFS (filesystem) and HAproxy with Keepalived (load balancer)

      [Read more...]
    Deploying an Active-Active FreeRadius Cluster with MySQL NDB or Galera
    +0 Vote Up -0Vote Down
    January 6, 2014 By Severalnines

    MySQL Cluster is a popular backend for FreeRADIUS, as it provides a scalable backend to store user and accounting data. However, there are situations when the backend database becomes a centralized datastore for additional applications and services, and needs to take a more general-purpose role. NDB usually works very well for FreeRADIUS data, but for wider use cases and reporting type applications, InnoDB can be a better storage engine. For users who need to keep their data in InnoDB and still benefit from a highly available clustered datastore, Galera Cluster can be an appropriate alternative.

    In this post, we will show you how to deploy FreeRadius both with MySQL Cluster and Galera Cluster to store

      [Read more...]
    Online Schema Upgrade in MySQL Galera Cluster using RSU Method
    +1 Vote Up -0Vote Down
    December 23, 2013 By Severalnines

    This post is a continuation of our previous post on Online Schema Upgrade in Galera using TOI method. We will now show you how to perform a schema upgrade using the Rolling Schema Upgrade (RSU) method. This requires that the new schema is backward compatible with the old schema, so it requires a bit more planning than the TOI method. In some cases, you might need to turn off any connections to the target node. 


    If you are using non-uniform hardware across your Galera cluster, RSU might be preferable as the more predictable process. RSU does not slow down your

      [Read more...]
    New Webinar: Repair and Recovery for your MySQL, MariaDB and MongoDB/TokuMX Clusters
    +1 Vote Up -0Vote Down
    December 19, 2013 By Severalnines

    Database clusters are pretty sophisticated distributed systems with complex dependencies between nodes. The failure of a node will generally impact the overall cluster, as the remaining nodes need to reconfigure themselves to continue to operate without the failed node. Since re-introducing a node will also affect the existing cluster, the timing could therefore be dependent on the state of the other nodes in the cluster. Repair and restarts often needs to be performed

      [Read more...]
    Online Schema Upgrade in MySQL Galera Cluster using TOI Method
    +0 Vote Up -0Vote Down
    December 10, 2013 By Severalnines

    As a follow-up to the Webinar on Zero Downtime Schema Changes in Galera Cluster, we’ll now walk you through the detailed steps on how to update your schema. The two methods (TOI and RSU) have both their pros and cons, and given parameters like table size, indexes, key_buffer_size, disk speed, etc., it is possible to estimate the time taken for the schema to be upgraded. Also, please note that a schema change is non-transactional so it would not be possible to rollback the DDL if it fails midway. Therefore, it is always recommended to test the schema changes and ensure

      [Read more...]
    Webinar Replay & Slides: Galera Cluster Best Practices - Zero Downtime Schema Changes
    +4 Vote Up -0Vote Down
    December 5, 2013 By Severalnines


    Thanks to everyone who attended yesterday’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.


    Thanks again to our speaker, Seppo Jaakola from Codership, the creators of Galera Cluster, for this in-depth talk on Galera Cluster Best Practices - Zero Downtime Schema

      [Read more...]
    High-Availability Openstack on a shoestring budget: Deploying a Minimal 3-node Cluster
    +0 Vote Up -0Vote Down
    December 4, 2013 By Severalnines

    As OpenStack deployments mature from evaluation/development to production environments supporting apps and services, high-availability becomes a key requirement. In a previous post, we showed you how to cluster the database backend - which is central to the operation of OpenStack. In that setup, you would have two controllers, while placing a 3-node Galera cluster on separate hosts. Now, it can be quite a leap to go from one VM with all services running on it, to a fully distributed setup with 5 VMs. The good news is that you can have a highly available setup starting with just 3 VMs.


      [Read more...]
    Upcoming Webinar: Zero Downtime Schema Changes in Galera Cluster
    +0 Vote Up -0Vote Down
    November 14, 2013 By Severalnines

    Database schema changes are usually not popular among DBAs or sysadmins, not when you are operating a cluster and cannot afford to switch off the service during a maintenance window. There are different ways to perform schema changes, some procedures being more complicated than others. We invited Seppo from the Codership team to tell us about the options. If you’d like to learn more, please register for our new webinar.


      [Read more...]
    Severalnines at Percona Live London 2013: MySQL Cluster Performance Tuning, exhibitor space with live demos, discount code...
    +1 Vote Up -0Vote Down
    November 4, 2013 By Severalnines

    Percona Live London MySQL Conference - 11-12th November, 2013

    We’re particularly excited about this year’s Percona Live London MySQL Conference. The line-up of speakers & topics looks excellent and it’s good to see speakers from Oracle, Percona, the MariaDB Foundation (amongst others) scheduled at the same event. It demonstrates not just the diversity of the ever broadening MySQL ecosystem, but also the fact that there really is room for everyone to contribute, participate in and advance MySQL in manifold directions while still retaining a certain amount of uniformity.

    And this is how we will be contributing to the event ...

      [Read more...]
    Point-in-time Recovery in MySQL Galera Cluster
    +1 Vote Up -0Vote Down
    October 28, 2013 By Severalnines

    Data protection is vital for DB admins, especially when it involves data that is accessed and updated 24 hours a day. Clustering and replication are techniques that provide protection against failures, but what if a user or DBA issues a detrimental command against one of the databases? A user might erroneously delete or update the contents of one or more tables, drop database objects that are still needed during an update to an application, or run a large batch update that fails midway. How do we recover lost data? 


    In a previous post, we showed you how to do a full restore from backup. Great, now you’ve

      [Read more...]
    Webinar Replay and Q&A: Galera 3.0 Introduction and Cluster Management - with MySQL 5.6, Global Transaction IDs and WAN
    +3 Vote Up -1Vote Down
    October 23, 2013 By Severalnines


    Last week, the Severalnines & Codership teams came together to co-host two webinar sessions on Galera 3.0, MySQL 5.6, Global Transaction IDs and WAN. The sessions were held during EMEA/APAC as well as NA/LATAM timezones, which worked out quite nicely. Our speakers were Seppo Jaakola from Codership & Vinay Joosery from Severalnines


    Webinar topics:

    • Galera Cluster
      [Read more...]
    Understanding gcache in Galera
    +1 Vote Up -0Vote Down
    October 16, 2013 By Severalnines

    Galera uses a preallocated file with a specific size called gcache, used to store the writesets in circular buffer style. By default, its size is 128MB. In this post, we are going to explore how to leverage gcache to improve the operation of a Galera cluster.


    Test Case


    We have a four node Galera cluster, using the latest release 23.2.7(r157). We have a table called t1 that is replicated by Galera on all nodes. The cluster nodes have allocated the default 128MB gcache.size, and we’ll try to execute a large writeset to see how gcache responds.

      [Read more...]
    Resources for HA Database Clusters: Latest Updates
    +0 Vote Up -0Vote Down
    September 24, 2013 By Severalnines

    For those of you who know Severalnines and maybe use some of our tools & products, you’ll know that we provide our users with a monthly summary of all the resources & tools that we’re publishing. Since this is publicly available material, we thought it’d be useful also for the broader open source database community.

    In the past month, we’ve made the following resources & tools available: 

    • Troubleshooting MySQL Cluster (free online MySQL Cluster Training)

      [Read more...]
    Avoiding Deadlocks in Galera - Set up HAProxy for single-node writes and multi-node reads
    +0 Vote Up -0Vote Down
    September 17, 2013 By Severalnines

    Galera cluster has known limitations, one of them is that it uses cluster-wide optimistic locking. This may cause some transactions to rollback. With an increasing number of writeable masters, the transaction rollback rate may increase, especially if there is write contention on the same dataset. It is of course possible to retry the transaction and perhaps it will COMMIT in the retries, but this will add to the transaction latency. However, some designs are deadlock prone, e.g sequence tables. In this blog we present how you can minimize the risk for deadlocks due to the

      [Read more...]
    How to Scale Joomla on Multiple Servers
    +0 Vote Up -0Vote Down
    July 2, 2013 By Severalnines

    Joomla! is estimated to be the second most used CMS on the internet after WordPress, with users like eBay, IKEA, Sony, McDonald’s and Pizza Hut. In this post, we will describe how to scale Joomla on multiple servers. This architecture not only allows the CMS to handle more users, by load-balancing traffic across multiple servers. It also brings high availability by providing fail-over between servers.


    This post is similar to our previous posts on web application scalability and high availability:

      [Read more...]
    Replicate from a MySQL Server into a Galera Cluster
    +0 Vote Up -0Vote Down
    June 28, 2013 By Severalnines

    This article describes how to setup replication between a regular MySQL server and a Galera Cluster. The regular MySQL Server is the MASTER , and one of the Galera nodes will be the SLAVE:


    In this example we have the following hosts:


    read more

    How to Cluster Magento, nginx and MySQL on Multiple Servers for High Availability
    +0 Vote Up -0Vote Down
    June 17, 2013 By Severalnines

    Magento is an open-source e-commerce platform built on Zend PHP and MySQL. It is widely adopted by online retailers with some 150,000 sites known to use it. Single server setups are easy to set up, but if your store is a huge success, then you probably need to think about clustering your environment with multiple servers. Clustering is done at the web, database and file-system level, as all web nodes need access to catalog images. 


    This post is similar to our previous posts on scaling Drupal and

      [Read more...]
    Showing entries 1 to 30 of 52 Next 22 Older Entries

    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.