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 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 116 Next 26 Older Entries

Displaying posts with tag: galera (reset)

Slides from Failover or not Failover, that is the question
+0 Vote Up -0Vote Down

Below are the slides from my last talk at this Percona Live Worldwide MySQL Conference. The idea for this talk was proposed by my co-presenter Massimo Brignoli and goes back to a debate on this topic that went through the MySQL blogosphere during last Autumn - which in itself was sparked by an outstanding retrospective published about a MySQL failure at Github.

read more

Galera pre-deployment check
+0 Vote Up -0Vote Down

One of the first things we do when preparing a client’s infrastructure for Galera deployment is see whether their schema is suitable.

  • Avoiding quirks and edge cases, we can say that Galera simply requires all tables to be InnoDB and also have a PRIMARY KEY (obviously having a PK in InnoDB is important anyway, for InnoDB-internal reasons).
  • We want to know about FULLTEXT indexes. With recent InnoDB versions also supporting FULLTEXT we need to check not just whether a table has such an index, but actually which engine it is.
  • Spatial indexes. While both InnoDB and MyISAM can deal with spatial datatypes (POINT, GEOMETRY, etc), only MyISAM has the spatial indexes.

Naturally, checking a schema in the server is more effective than going through other sources and possibly missing bits. On the downside, the only viable way to get this info out of MariaDB

  [Read more...]
Slides and spreadsheets for my MySQL High Availability tutorial
+1 Vote Up -0Vote Down

Good morning Percona Live visitors! Attached to this post you can find a spreadsheet (both LibreOffice or Excel, as you prefer) that you can use towards the end of my tutorial. I've also attached the slides so you can download a copy of them.

SkySQL named 2013 Top 100 Europe winner, more dates added for MySQL & Cloud Database Solutions Day
+0 Vote Up -0Vote Down

We were delighted last week to find out that we’d been named one of the ‘2013 Top 100 Europe’ winning companies by the Red Herring editorial team. Congratulations to all companies involved!

read more

SkySQL named 2013 Top 100 Europe winner, more dates added for MySQL & Cloud Database Solutions Day
+0 Vote Up -0Vote Down

We were delighted last week to find out that we’d been named one of the ‘2013 Top 100 Europe’ winning companies by the Red Herring editorial team. Congratulations to all companies involved!

read more

Running Percona XtraDB Cluster in a Sandbox on Ubuntu
+2 Vote Up -0Vote Down
I wanted to do some experimentation with Percona XtraDB Cluster (Galera) and I didn't want to use virtual machines. I'm already using MySQL Sandbox for many other projects so that's the natural choice.

I've downloaded the tarball for Percona XtraDB Cluster 5.5.29 and I've extracted it to ~/opt/mysql/5.5.29-pxc.

Then I've installed 3 nodes:
make_sandbox 5.5.29-pxc -- --sandbox_port 4551 \
--sandbox_directory msb_5_5_29-pxc01 

make_sandbox 5.5.29-pxc -- --sandbox_port 4552 \
--sandbox_directory msb_5_5_29-pxc02 

make_sandbox 5.5.29-pxc -- --sandbox_port 4553 \
--sandbox_directory msb_5_5_29-pxc03 

But when I try to start a node this error happens:
130327 14:21:03 [Note] WSREP: wsrep_load(): loading provider library '/home/dvee
den/mysql/5.5.29-pxc/lib/libgalera_smm.so'















  [Read more...]
MariaDB Galera Cluster is a unique technology worth testing
+2 Vote Up -0Vote Down

As alway with new technology there is always different approaches regarding the adoption. You can try to use the bleeding edge features or start with a very standard configuration. My personal advise to new users is to start with the most basic configuration.

This allow you to get familiar with the fundamentals : - how [...]

MariaDB Galera Cluster 5.5.29 Stable (GA) released
+5 Vote Up -0Vote Down

After some final testing and polishing, the MariaDB project and Codership are pleased to announce the release of MariaDB Galera Cluster 5.5.29. This is a Stable (GA) release. MariaDB Galera Cluster links:

About MariaDB Galera  [Read more...]

MySQL Events
+3 Vote Up -0Vote Down
The last MySQL User Group NL meeting was last Friday. It's always nice to learn about MySQL and meet other MySQL users. There were two presentations: one about MySQL User Defined Functions (UDF's) and one about MySQL TCO. The slides are available from the meetup page.

There are already a number of MySQL events announced for the next few months. I'll only list events in the Netherlands and Virtual events.

MySQL Virtual Developer Days
This is a virtual event which will take place on March 19 (EMEA region, NA event is on March 12). There are many interesting topics: Performance Schema, New 5.6 Features, Replication, MySQL Enterprise Monitor
The eVite

SkySQL and MariaDB roadshow
21 March 2013 in Amsterdam
This event  have









  [Read more...]
Galera Load Balancer RPMs
+1 Vote Up -0Vote Down
I have created Centos6 RPMs for Codership’s Galera Load Balancer version 0.9.2

License: GPLv2.
Warranty: none at all.

Downloads:
glb-0.9.2-1.x86_64.rpm md5: 49bfb241c6738056f6bf0bce4de6b96b
glb-0.9.2-1.i686.rpm md5: 2491370cb3f78c804831c078250ae611 

Source
SkySQL and MariaDB After Work Meetup with Monty Widenius, the "Father of the MySQL® & MariaDB Databases"
+4 Vote Up -2Vote Down

The SkySQL and MariaDB Roadshow comes to Sweden:

Stockholm 7 February 2013, 16:30-19:30, Dramaten Restaurang Pauli

SkySQL and Monty Program are on the road with our joint - free - roadshow in Stockholm where Monty Widenius will unveil his vision of the future of the MySQL database via MariaDB.

In addition, we will have speakers from Codership/Galera, as well as SkySQL experts.

read more

[Plus] readers choice 2012 : It’s time to vote!
+2 Vote Up -0Vote Down

Oh yes, 2012 was an incredible year for the MySQL Community!
That’s why I would like to change the rules this year and I would like to offer you a new survey for this [Plus] reader’s choice 2012.

Community users, bloggers and events made the whole community last year, tell us how you used this community?
It will only take 5 minutes of your precious time, votes will be closed Jan. 31.

Vote for what you used! (with your heart, again…)

Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit

  [Read more...]
Galera features beyond just HA
+3 Vote Up -3Vote Down
Galera from codership has been getting a lot of attention recently. Galera provides a nice High Availability solution for MySQL where Galera provides synchronous replication with conflict detection using the classic InnoDB Storage Engine. No more playing about with special storage engines of DRBD failover, just continue to use InnoDB and add Galera as the secret sauce for High Availability.

Some of the neat features of Galera are, but are not limited to, multi-master replication, a lightweight implementation of replication and zero failover times due to the multi.master ability. This is not a complete HA solution though, just a component of it, we still need to add some monitoring and failover mechanisms, but as Galera is multi-master this is greatly simplified and can in many cases be handled by the driver or the application with little overhead.



  [Read more...]
Notes on "5 Tips for migrating your MySQL server to a Galera Cluster"
+1 Vote Up -0Vote Down

This post comes as response to 5 Tips for migrating your MySQL server to a Galera Cluster by Henrik Ingo (Galera), which is a good read. This post is a bit lengthy which is one of the reasons why I didn't just comment on said post.

The Galera talk in London was indeed well crowded, judging from my own chair. I think there is an obvious interest in Galera, as well as a general thirst for information from real-life experience. I am personally very interested in production stories; either "war stories" or "peace stories" - anything to shed more light on the adoption of this technology.

For disclosure, I have not tried Galera myself as yet. Not on production nor on staging machines. But here's a couple thoughts on Henrik's post:

  [Read more...]
Slides from Percona Live UK posted
+0 Vote Up -0Vote Down

Percona Live UK took place this week. It was the second year in a row and once again a great conference. Thank you Percona for bringing the show to Europe, it means a lot for the European MySQL community - many people who don't visit the Santa Clara conference were present in London. It's kind of funny, I even meet more Finnish MySQL users in London than I do at home!

I gave 2 talks. Slides are now posted on Slideshare:

read more

MariaDB Foundation
+11 Vote Up -11Vote Down

You may have already seen the announcement MariaDB Foundation to Safeguard Leading Open Source Database. We at Open Query wholeheartedly support this (r)evolution of the MySQL ecosystem, which appears to be increasingly necessary as Oracle Corp is seriously dropping the ball with security updates and actually just general development and innovation. Oracle has actually done some very good work, I happily acknowledge that – but security issues are critical, having crashing bugs and incorrect query results in a .28 of a GA release is uncool, and not incorporating awesome development efforts by the community is just astonishing.

MariaDB is where the

  [Read more...]
Blogging at codership.com
+1 Vote Up -0Vote Down

As a few LinkedIn friends already noticed, I have started working together with the Galera team at Codership. It is a part time "advisor" position and I still continue my full time work at Nokia, supporting various databases behind the new HERE.com portal.

We get a lot of requests for more blogs and better documentation to explain in-depth how Galera work. That's an area I will work on a lot. The first "deliverable" is out today: the first Galera white paper.

read more

Attend Percona Live MySQL Conference: London 2012 next week with SkySQL’s 40% discount code
+1 Vote Up -0Vote Down

First 10 to register this week will benefit from a 40% discount

The Percona Live MySQL Conference: London 2012 is just around the corner and we’ll be present both with talks as well as in the exhibition hall alongside other sponsors of the conference.

Talks & Hot Topics

Our very own Ivan Zoratti has the following two talks on Tuesday December 4th:

read more

Galera gotchas
+0 Vote Up -0Vote Down
We’ve recently implemented Galera clustering and have been pleased with the relatively easy install and implementation. A quick description of galera is the joining of individual mysql dbs as nodes to create a cluster that features multi-threaded synchronous replication, which allows for true high availability while still using your original db and engine (innodb). Likewise, [...]
Slides for Evaluating MySQL HA Alternatives
+1 Vote Up -0Vote Down

Attached are the slides for my MySQL Connect talk Evaluating MySQL High-availability alternatives, which I will present today at 14:30 at the MySQL Connect conference.

A bit unusually I'm posting the material ahead of the talk. The point of the talk is about evaluating each alternative from your own perspective. With that in mind, if you're at the talk with your own laptop, feel free to browse the slides at your own pace from here.

read more

MariaDB Directions
+5 Vote Up -0Vote Down

Infor announced this week, that they will provide open source database alternatives to some of their products. MariaDB has been chosen, tested, and certified by Infor to be the open source database of choice (together with MySQL) for the Infor LN and ION products. Infor LN is Infor’s flagship ERP and is sometimes better known by its former name, Baan. It has 25 years of manufacturing know-how built into it and is used by more than 5,000 companies worldwide in a wide range of industries. These include automotive, industrial equipment and machinery, high tech and electronics, and aerospace and defense. This is a big stamp of approval that even the most critical systems can be run on MariaDB.

In other news, there are currently several really interesting paths coming together into some important

  [Read more...]
Failover is evil
+1 Vote Up -0Vote Down

In the Matrix movie there is a scene where the heroes visit a spiritual councelor, and amongst the people in her waiting room they see a little boy, dressed like a buddhist monk, who can bend a spoon just by looking at it. When they ask him what he does to bend the spoon, the boy's answer is: "There is no spoon". And if you watch the movie to the end, you will see that he is right. (In that spirit, if this post is too long to read for you, just skip to the last paragraph for the answer.)

The title for this blog post is of course inspired by Baron's "Is automated failover the root of all evil?", which is a commentary on GitHub's detailed explanation of their recent Pacemaker-induced downtime. Baron makes a good

  [Read more...]
Monty’s team announces the availability of MariaDB Galera Cluster!
+6 Vote Up -0Vote Down

We’re delighted to share the news that our friends at MariaDB today announced the availability of MariaDB Galera Cluster!

We’ve been talking a good bit about MariaDB in the past few months and it’s great to see the MariaDB & Codership partnership result in today’s announcement.

read more

MariaDB Galera Cluster Alpha immediately available
+7 Vote Up -1Vote Down

Today we’re pleased to announce the availability of MariaDB Galera Cluster!

With this release, we’re addressing the numerous requests we’ve received over the past few months for a MariaDB-based Galera Cluster. MariaDB, the more reliable, performant, feature-complete & backwards compatible MySQL database becomes even more attractive by making it available for Galera Cluster.

What is it?

  • A straight merge of MariaDB 5.5.25 with Galera Cluster by Codership
  • An alpha release which should not be used in production environments
  • Using the Galera replication methodology, users get:
    • Synchronous, multi-master replication with guaranteed data consistency
    • This solution provides both read & write scalability
  [Read more...]
MySQL and PostgreSQL faces at Froscon
+0 Vote Up -1Vote Down

My three previous blog posts I already wrote from Froscon. In this post I still want to go back and mention some people I met and discussions I had.

The MySQL side

There were of course many MySQL people, with both SkySQL and Oracle sponsoring. It was great to meet Carsten from Oracle, who has joined the MySQL Sales Engineer team in Europe (he moved from an OpenOffice position). That's my former team, so it was great to see a new face!

Going there the person I was most looking forward to meet was Hana Hütter, formerly a MySQL account manager for Central Europe, and now doing the same at SkySQL. My first ever MySQL sales gig was with Hana, and Ralf Gebhart who is also now with SkySQL but was not at Froscon. While Ralf was there only that first time to teach me how to be a Sales Engineer, with Hana we then continued to sell MySQL into telecom companies

  [Read more...]
Understanding the Galera commit sequence and innodb_doublewrite_buffer back to 1
+0 Vote Up -0Vote Down

People often assume the reason I talk at conferences is because I like to teach them about Galera, MySQL and other cool, open source things. That's of course true to some extent. But for me personally, another reason is even more important: It happens almost always that the audience teaches me something. Thus the process of public speaking has increasingly become my way to learn new insights. Low level details that aren't easy to learn by just RTFM.

read more

Log Buffer #282, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down
Blogging is the way to express an idea in an informal way by a person, who has either worked with it, or planning to work with it, or has seen it at work. In databases, ideas are the foundations of everything, and these Log Buffer Edition is presenting ideas from bloggers in Log Buffer #282. [...]
Speaking at MySQL Connect (OpenWorld)
+7 Vote Up -0Vote Down

My talk for MySQL Connect has been accepted. This is the MySQL specific 2 day conference just before the big Oracle OpenWorld and JavaOne. It is kind of a new conference by Oracle. They've had something called MySQL Sunday at this spot before, but this year it is a bit bigger and with a bigger spin on it. I'm glad it is on a weekend because otherwise I wouldn't be able to attend.

I will give the popular Evaluating MySQL High Availability Alternatives talk that I have been refining in two Percona Live conferences already. With MySQL 5.6 in the oven now, there's something new again to talk about.

read more

Video: My Introduction to Galera talk at OUGF Harmony 2012
+2 Vote Up -0Vote Down

Sheeri was also in Hämeenlinna for the OUGF Harmony conference a few weeks ago, and of course she had her video camera with her. My talk "Synchronous multi-master clusters with MySQL: an introduction to Galera" is now posted on Youtube. (You may also want to watch the slides on slideshare while listening.)

I think this is a really good talk if you are interested in Galera. First we cover how to get a Galera cluster running, including the most important options and status variables to pay attention to. I cover both the internal Galera architecture and how to use load balancers and clustering frameworks, and explain how galera handles node crashes and network partitioning.

read more

Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
+2 Vote Up -0Vote Down

I have a customer who is considering Percona XtraDB Cluster (PXC) in a two colo WAN environment.  They wanted me to do a test comparing PXC against semi-synchronous replication to see how they stack up against each other.

Test Environment

The test environment included AWS EC2 nodes in US-East and US-West (Oregon).  The ping RTT latency between these nodes was right around 100ms.

All environments used Percona Server or Percona XtraDB Cluster server 5.5.24.  Innodb durability was disabled for all tests (innodb_flush_log_at_trx_commit=2).  All other settings were the same kept the same unless otherwise noted.

I tested against the following

  [Read more...]
Previous 30 Newer Entries Showing entries 61 to 90 of 116 Next 26 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.