Coderhsip is pleased to announce that latest release of Galera Cluster for MySQL now supports MySQL 5.5

Downloads both MySQL 5.5 and 5.6 can be found from galeracluser.com/downloads.  We are also releasing Galera now 3.10, wsrep API version 25.

This and future releases will be available from Galera Cluster Downloads, while previous releases remain available on LaunchPad. The source repositories  and bug tracking are now on http://www.github.com/codership.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package …

MongoDB 3.0 was recently released. Instead of focusing on what’s new – that is so easy to find, let’s rather talk about something that has not changed a lot since the early MongoDB days. This topic is sharding and most specifically: how to choose a good sharding key. Note that most of the discussion will also apply to MySQL, so if you are more interested in sharding than in MongoDB, it could still be worth reading.

When do you want to shard?

In general sharding is recommended with MongoDB as soon as any of these conditions is met:

• #1: A single server can no longer handle the write workload.
• #2: The working set no longer fits in memory.
• #3: The dataset is too large to easily fit in a single server.

Note that #1 and #2 are by far the most common reason why people need sharding. Also note that in the MySQL world, #2 does not imply that you need sharding.

…

With over 7,000 users to date, ClusterControl is the leading, platform independent automation and management solution for the MySQL, MongoDB and now Postgres databases, its latest main feature. 

With ClusterControl 1.2.9, we’ve introduced a whole range of new features, which we’d like to demonstrate to you in this live webinar on March 24th.

New Features Webinar: ClusterControl 1.2.9 - March 24th 2015

DATE & TIME
Europe/MEA/APAC
Tuesday, March 24th at 09:00 (UK) / 10:00 CET (Germany, France, Sweden)
Register …

 If table is partitioned then that makes it easy to maintain. Table has grown so huge and the backups are just keep running long then probably you need to think of archival or purge.

Purge the data if you don't want data from old partitions just by doing truncate or drop of those partitions which completes momentarily without locking the table for a long time

Archival can be done couple of ways.
We can take mysqldump (preferably from a slave) with a where condition to filter out the data you don't want to copy. And then import the dump file to archive database. check this link out for mysqldump with where clause .. and once data is copied, the …

If a table is partitioned then that makes it easy to maintain. Table has grown so huge and the backups are just keep running long then probably you need to think of archival or purge.

Purge the data if you don't want data from old partitions just by doing truncate or drop of those partitions which completes momentarily without locking the table for a long time

Archival can be done couple of ways.
We can take mysqldump (preferably from a slave) with a where condition to filter out the data you don't want to copy. And then import the dump file to archive database. check this link out for mysqldump with where clause .. and once data is copied, …

So you want to contribute to OpenStack? I can help!

For the last year or so I have been involved with OpenStack and more specifically the Trove (DBaaS) project as sort of an ambassador for Percona, contributing bits of knowledge, help and debugging wherever I could and thought I would share some of my experience with others that wanted to get involved with OpenStack development, documentation, testing, etc. Getting started with OpenStack contributions is also the idea behind my talk next month at Percona OpenStack Live 2015. (Percona Live attendees have access to OpenStack Live)

Back at the last OpenStack Conference and Design Summit in Paris last November, I had the amazing opportunity to attend the two-day …

Wed, 2015-03-18 10:55geoff_montee_g

MariaDB Galera Cluster is part of the easily deployed High Availability product MariaDB Enterprise Cluster. This blog raises a question about the behaviour of the bootstrapping method.

Old Bootstrapping Method

When Galera was first released, the usual method used to bootstrap a cluster was to set wsrep_cluster_address to 'gcomm://'. With no other node addresses specified in wsrep_cluster_address, the node would form its own cluster:

[gmontee@localhost ~]$ sudo service mysql start --wsrep_cluster_address='gcomm://'
Starting MySQL....                                         [  OK  ]
[gmontee@localhost ~]$ mysql -u root --execute="SHOW GLOBAL STATUS WHERE Variable_name …

JavaScript has emerged in the past couple years as the de facto expression of next generation web technologies, and a critical component of HTML5 technologies – along with CSS and JQuery. JavaScript is really ubiquitous – it really is showing up everywhere! There are many other reasons why JavaScript and JS-based tools are becoming the wave of the future. JavaScript is the #1 most-used language on GitHub, and this trend is only going to increase. As one article put it, “JavaScript is the number one …

In addition to our general CJK support, as detailed in this blog post, we’ve also added a MeCab parser. MeCab is a Japanese morphological analyzer, and we now have a full-text plugin parser based on it!

How Would I Use It?

1. Set the mecab_rc_file option — mecab_rc_file is a read-only system variable pertaining to the MeCab parser. The mecabrc file that it points to is a configuration file required by MeCab, …

Finely tune your query writing and database performance with tips from the experts.

MySQL offers a few different types of indexes and uses them in a variety of ways. There’s a lot to know about the various kinds of indexes and how they interact with the storage engines, and it’s all very important for query optimization. A few examples are listed below:

• The “leftmost prefix rule”
• Clustered primary indexes versus secondary indexes
• B-Tree and hash
• New types of indexes such as LSM and Fractal Trees
• Newer features in the query optimizer and executor in MySQL 5.6 and 5.7

You will leave this webinar with a better understanding of how MySQL and its storage engines use indexes to speed up queries, as well as how you can improve query performance with basic and advanced index optimizations. Register below, and we will send you a copy of the recording and slide …