MariaDB tries to encourage use of many storage engines, which Oracle doesn't bother with. The ones that could be considered -- occasionally! -- as InnoDB replacements are: Mroonga, TokuDB, and Aria.

Mroonga

I predicted that Mroonga would be in MariaDB 10.0.8, and behold, here it is in MariaDB 10.0.15. Truly I am the Nostradamus of the database world.

It's a general-purpose storage engine, in that it doesn't have serious limitations regarding what can be stored or indexed. I think its "column-store" feature has limited appeal, but as I saw in January, it's dandy for full-text searching. This time I look at the list of "Full-Text Restrictions" in the MySQL manual, and quote from it:

"Full-text searches are supported for …

Intro

I had the opportunity to work with a variety of databases: Firebird (yeap!), MySQL, Postgres, Oracle and SQL Server. And to count the NoSQL ones I was able to work with MongoDB and DynamoDB.

I have different opinions about each one of the above (note that I didn't include Access on the list, as far as I know, that is not a database). Also, it is not secret that I like Amazon AWS products, and using some of them daily I can see why each service can be magically integrated to achieve a goal. …

Do you use Google’s Go language (golang)? Do you use a relational database such as MySQL or PostgreSQL with it? Do you want to learn how to?

Go has a package called database/sql for connecting to relational databases. There’s package documentation, but you’ll need to read the source code if you really want to understand how to use the package. The documentation doesn’t really explain how to use the package, it just explains what it does.

Fortunately, there’s a free, online, opensource tutorial that fills this need. If you haven’t read it, I highly recommend it. (I am one of the authors.) There is a lot of wisdom from very experienced people in the tutorial, including the two primary authors of the main MySQL driver for Go.

The tutorial is online at go-database-sql.org.

Do you use Google’s Go language (golang)? Do you use a relational database such as MySQL or PostgreSQL with it? Do you want to learn how to?

Go has a package called database/sql for connecting to relational databases. There’s package documentation, but you’ll need to read the source code if you really want to understand how to use the package. The documentation doesn’t really explain how to use the package, it just explains what it does.

Fortunately, there’s a free, online, opensource tutorial that fills this need. If you haven’t read it, I highly recommend it. (I am one of the authors.) There is a lot of wisdom from very experienced people in the tutorial, including the two primary authors of the main MySQL driver for Go.

The tutorial is online at go-database-sql.org.

It is easy to set up a replication topology with MySQL Sandbox, and I use it for lots of testing scenarios. For example I used MySQL Sandbox to run the tests for yeterday's post about the way UUIDs are replicated in row-based replication (RBR) versus statement-based replication (SBR).

Here's how easy it is to set up a replicated sandbox for testing:

Installing MySQL Sandbox

If you've never installed MySQL Sandbox before, you can do so by running a single command as root:

sudo su - cpan MySQL::Sandbox

Download the MySQL binary

Pick the appropriate binary based on your OS and the version of MySQL you want to use. In my case I'm on Mac OS X and I want to test MySQL 5.6 so I went to …

Tweet

Another centurion mark achieved by the Log Buffer as it reaches 400. Freshness and uniqueness of Log Buffer still is as youthful as was with the edition 1. Enjoy the gems of Oracle, SQL Server and MySQL.

Oracle:

What Cloud Infrastructure Will Best Deliver?

Adaptive Case Management 12c and ADF Human Tasks.

What Does “Backup Restore Throttle Speed” Wait Mean?

All You Need, and Ever Wanted to Know About the Dynamic Rolling Year.

December 8, 2014 By Severalnines

Percona XtraBackup is a great backup tool with lots of nice features to make online and consistent backups, although the variety of options can be a bit overwhelming. s9s_backup tries to make it simpler for users, it creates an easy to use interface for XtraBackup features such as full backups, incremental backups, streaming/non-streaming, and parallel compression.

Backups are organized into backup sets, consisting of a full backup and zero or more incremental backups. s9s_backup manages the LSNs (Log Sequence Number) of the XtraBackups. The backup set can then be restored as one single unit using just one command.

In earlier posts, we covered various ways on restoring your backup files …

Introducing Consul

I’m always interested in what Mitchell Hashimoto and Hashicorp are up to, I typically find their projects valuable.  If you’ve heard of Vagrant, you know their work.

I recently became interested in a newer project they have called ‘Consul‘.  Consul is a bit hard to describe.  It is (in part):

• Highly consistent metadata store (a bit like Zookeeeper)
• A monitoring system (lightweight Nagios)
• A service discovery system, both DNS and HTTP-based. (think of something like haproxy, but instead of tcp load balancing, it provides dns lookups with healthy services)

What this has to do with Percona XtraDB Cluster

I’ve had some more complex testing for  …

With MySQL replication, when using the UUID() function to insert or update values in your database you need to be careful to assure the UUIDs are replicated properly. This is primarily a problem in statement-based replication.

Here's a simple example with row-based replication to illustrate UUIDs replicating successfully:

Master

``` master > set binlog_format = 'ROW'; Query OK, 0 rows affected (0.00 sec)

master > insert into uuid_test (binlog_format,uuid_string) values(@@binlog_format,uuid()); Query OK, 1 row affected (0.00 sec)

master > select id,binlog_format,uuid_string,md5(uuid_string) from uuid_test; +----+---------------+--------------------------------------+----------------------------------+ | id | binlog_format | uuid_string | md5(uuid_string) | …