Wed, 2015-07-01 12:54anderskarlsson

It was a very long time since I wrote something in this blob, but I have been very busy this spring with MariaDB on Power. This has been a lot of work, but also a lot of fun. So, what is this MariaDB on Power thing all about, well I wrote an introduction to the Power platform late last year. Since then a lot of things has happened.

One thing is that several service providers out there have adopted Power8 as a platform. To be honest, this really isn't sexy, but it is useful and as a user of one of these services, you will just see the same old Linux you are used to, but potentially it is more powerful and reliable. One such provider is OVH, whose service is more known as RunAbove. If you want to try it, you can do so for …

Quite often, especially for benchmarks, I am trying to limit available memory for a database server (usually for MySQL, but recently for MongoDB also). This is usually needed to test database performance in scenarios with different memory limits. I have physical servers with the usually high amount of memory (128GB or more), but I am interested to see how a database server will perform, say if only 16GB of memory is available.

And while InnoDB usually respects the setting of innodb_buffer_pool_size in O_DIRECT mode (OS cache is not being used in this case), more engines (TokuDB for MySQL, MMAP, WiredTiger, RocksDB for MongoDB) usually get benefits from OS cache, and Linux kernel by default is generous enough to allocate as much memory as available. There I should note that while TokuDB (and TokuMX for MongoDB) supports DIRECT mode (that is bypass OS cache), we found there is a performance gain if OS cache is used for compressed pages.

It’s important to monitor the (database) backups after you set-it-up. In this post we will answer a few how to monitor MySQL Database backups solutions – monitoring methods. We should…

The post How to monitor MySQL backups first appeared on Change Is Inevitable.

I used Ubuntu 12.04 LTS on Amazon EC2 to download, compile, and install Varnish cache.

As of this writing, you can find the latest stable release at https://www.varnish-cache.org/releases

One of the decisions I notice acutely about other companies’ products is their user model. I always notice it, and it makes me either smile or grit my teeth. Companies get this wrong all the time.

• Right: a user account owns itself and is affiliated to a company/organization/etc. It may belong to teams and have various levels of permissions. But the person who created the account owns the account.
• Wrong: a user account is created and owned by, and depends on, an organization or company.

The difference may seem silly. Why would anyone care?

Think of GitHub. You probably have your own opensource repos, and you probably participate in your company’s repos. You probably also participate in some teams for repos that you care about, which are owned by other organizations or users. You can do this all with a single account.

What if …

We recently added a token-based authentication example to the Siesta repository that provides an excellent starting point for building authenticated APIs using our lightweight HTTP handler library for Go. This example, modeled after our own internal API services, demonstrates features and practices that we’ve developed and found useful after using Siesta in production for many months.

Here’s what you’ll see in this “meaty” example:

• Request identification and logging
• Token-based authentication
• Use of typed URL parameters
• Usage of a handler for some state, such as a database
• JSON responses
• “Pre” and “post” middleware chains
• Error handling and bypassing of handlers …

Recently a friend asked about Installing Percona Monitoring Tools for Nagios as he was facing a few issues. I managed to set-it-up on my ubuntu VM. Sharing the the work-log…

The post Install Percona Monitoring Tools for Nagios – MySQL Plugins first appeared on Change Is Inevitable.

Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports via command line is too boring. I wrote already how I survive in case when I need to start MySQL server (here). There is also the MySQL Sandbox which can be used for the same purpose.

But what to do if you want to start Percona XtraDB Cluster this way? Fortunately we, at Percona, have engineers who created automation solution for starting PXC. This solution uses Docker. To explore it you need:

1. Clone the pxc-docker repository:
   git clone https://github.com/percona/pxc-docker …

[…] PlanetMySQL Voting: Vote UP / Vote DOWN Full article:MySQL Cluster: Una introducción en Español. […]

MariaDB 5.5.44 was recently released (it is the latest MariaDB 5.5), and is available for download here:

https://downloads.mariadb.org/mariadb/5.5.44/

This is a maintenance release, and no major changes, so there are only several noteworthy items (but one of those being a security fix and five potential crashing bug):

• Security Fix: Client command line option –ssl-verify-server-cert (and MYSQL_OPT_SSL_VERIFY_SERVER_CERT option of the client API) when used together with –ssl will ensure that the established connection is SSL-encrypted and the MariaDB server has a valid certificate. This fixes CVE-2015-3152.
• Crashing Bug: mysql_upgrade crashes the server with REPAIR VIEW ( …