Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 134 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.

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...]
Before every release: A glimpse into Percona XtraDB Cluster CI testing
+0 Vote Up -0Vote Down

I spoke last month at linux.conf.au 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: Glimpse into CI testing from Raghavendra Prabhu

Below is a rough transcript of the talk:

This talk covered the continuous integration

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

1) On node #1:

MariaDB [test]> CREATE TABLE t1(c1 INT AUTO_INCREMENT PRIMARY KEY, c2 INT)ENGINE=InnoDB;
Query OK, 0 rows affected (0.07 sec)

MariaDB [test]> START TRANSACTION;
Query OK, 0
  [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...]
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 Galera Cluster.

Download MariaDB Galera Cluster 5.5.35

Release Notes

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

  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 134 10 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.