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) | …

As of MySQL 5.5.41, released on November 28 (last week), Oracle has fixed MySQL Bug 67433, which I filed on October 31, 2012 and wrote about 4 months ago in Stupid and dangerous: SET GLOBAL sql_log_bin. You can see the fix in Launchpad revision 4718.

The MySQL 5.5.41 release notes mention:

Replication: The global scope for the sql_log_bin system variable has been deprecated, and this variable can now be set with session scope only. The statement SET GLOBAL SQL_LOG_BIN now produces an error. It remains possible for now to read the global value of sql_log_bin, but you …