Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 70 of 164 10 Older Entries

Displaying posts with tag: galera (reset)

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.

  [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 …

  [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 …

  [Read more...]
Before every release: A glimpse into Percona XtraDB Cluster CI testing
+0 Vote Up -0Vote Down

I spoke last month at 2014 in Perth, Australia, and one of my sessions focused on the “Continuous Integration (CI) testing of Percona XtraDB Cluster (PXC)” at the Developer,Testing, Release and CI miniconf.

Here is the video of the presentation:

Here is the presentation itself:

Percona XtraDB Cluster before every release: …

  [Read more...]
Auto increments in Galera
+0 Vote Up -0Vote Down

Lets start by considering a scenario where records are being inserted in a single auto-increment table via different nodes of a multi-master cluster. One issue that might arise is ‘collision’ of generated auto-increment values on different nodes, which is precisely the subject of this article.

As the cluster is multi-master, it allows writes on all master nodes. As a result of which a table might get same auto-incremented values on different nodes on INSERTs. This issue is discovered only after the writeset is replicated and that’s a problem!

Galera cluster suffers with the similar problem.

Lets try to emulate this on a 2-node Galera cluster : …

  [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 …

  [Read more...]
MariaDB Galera Cluster 5.5.35 Now Available
+0 Vote Up -0Vote Down

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.35. This is a Stable release.

See the Release Notes and Changelog for detailed information on this release and the Galera page in the MariaDB Knowledge Base for general information about MariaDB …

  [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 …

  [Read more...]
Follow up on FOSDEM
+0 Vote Up -0Vote Down

After my presentation at FOSDEM I got a few questions regarding our Galera implementation and why we did things the way we want. First of all, the slides: Spil Games @ FOSDEM: Galera Replicator IRL from spil-engineering Second of all, the questions I got: Q: Why first copy all the data to a new MySQL […]

The post Follow up on FOSDEM appeared first on Spil Games Engineering.

Announcing Partnership with Percona
+2 Vote Up -1Vote Down

February 4, 2014 By Severalnines

Great news for Percona customers! We are thrilled to announce our partnership with Percona. Effective immediately, Percona customers will be able to enjoy the advanced automation, monitoring and cluster management capabilities of ClusterControl. Percona will be bundling, with its Cluster support contracts, Percona ClusterControl - a privately branded version of ClusterControl Community. Together we're providing support for the full stack, from Percona XtraDB Cluster to management tools, giving customers one number to call. 

For anyone who has deployed, managed or monitored a mission-critical database cluster, …

  [Read more...]
10 Newer Entries Showing entries 61 to 70 of 164 10 Older Entries

Planet MySQL © 1995, 2015, 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.