So of course Percona has documentation that explain the process.
The goal of this blog is to go into a little more detail in hopes
that can help someone.
Hyperlinks for review:
Taxonomy upgrade extras: myenvoperationMySQL Operationsmulti instanceconsolidationBackup
FromDual has the pleasure to announce the release of the new version 1.0.5 of its popular MySQL, MariaDB and Percona Server multi-instance environment MyEnv.
The majority of improvements happened on the MySQL Backup Manager
(mysql_bman) utility.
You can download MyEnv from …
[Read more]The development version of PECL/mysqlnd_ms now has an very early version of distributed (2PC/XA) transaction support tailored for use with clusters of MySQL servers. XA transactions can span multiple servers in a cluster to ensure transaction guarantees among them. In real life, there is always, at some point, a sequence of work on your data for which atomicity, consistency, isolation, and durability must be given. The early generation of NoSQL sharding solutions has a weak spot here. How do you, as a developer, ensure a logical operation affecting two shards is either applied to both or none? Either you don’t …
[Read more]In my last post, I gave a technical explanation of the performance characteristics of partitioned collections in TokuMX 1.5 (which is right around the corner) and partitioned tables in relational databases. Given those performance characteristics, in this post, I will present some best practices when using this feature in TokuMX or TokuDB. Note that these best practices are designed for TokuMX and TokuDB only, which use …
[Read more]In this post I would like to review how my dumper for MySQL works from the point of view of locks. Since 0.6 serie we have different options, so I will try to explain how they work
As you may know mydumper is multithreaded and this adds a lot of complexity compared with other logical backup tools as it also needs to coordinate all threads with the same snapshot to be consistent. So let review how mydumper does this with the default settings.
By default mydumper uses 4 threads to dump data and 1 main thread
Main Thread
Dump Thread X
Main Thread
Dump Thread X
As you can see in this case we need FTWRL for two things, coordinate transaction’s snapshots …
[Read more]To whom it may concern. Surrogate keys: auto-increment or UUID?I recently overheard a statement about whether to use auto-incrementing id's (i.e, a sequence managed by the RDBMS) or universal unique identifiers (UUIDs) as method for generating surrogate key values. LeakinessMuch has been written about this subject with regard to storage space, query performance and so on, but in this particular case the main consideration was leakiness. Leakiness in this case means that key values convey information about the state of the system that we didn't intend to disclose. Auto-incrementing id's are leakyFor example, suppose you would subscribe to a new social media …
[Read more]I really enjoy using cloud-based virtual servers for testing MariaDB and MySQL deployments. With automation scripts, it's fast and easy to create environments that match what customers are using to solve issues quicker. For example, with just a couple of commands, we can bring up a replication cluster with one master and two slaves, running a specific MySQL version, and run tests to find a memory leak.
MySQL 5.5.38 was recently released (it is the latest MySQL 5.5, is GA), and is available for download here:
http://downloads.skysql.com/archive/index/p/mysql/v/5.5.38
This release, similar to the last 5.5 release, is mostly uneventful.
Out of the mere 13 bugs, most were benign, but I thought there were two worth mentioning (just because one is a slight performance improvement for InnoDB, and the other relates to slave consistency, so always important to see if it could affect you):
Red Hat Enterprise Linux 7 was declared GA on Tuesday, more than 3.5 years after the release of RHEL 6. A big piece of news with this release is that it includes MariaDB Server instead of Oracle MySQL as "the default implementation of MySQL in Red Hat Enterprise Linux 7". What does this mean? When you need to install a "MySQL server", the one included in the RHEL7 repositories, and the one officially supported by Red Hat, will be MariaDB. This is great news for the MariaDB team and a testament to the incredibly hard work they've done in the areas of security, stability, performance, and openness. But what does it mean for users of RHEL7? …
[Read more]Tungsten Replicator is an innovative and reliable open source tool that can solve your most complex MySQL replication problems. In this webinar we will introduce Replicator installation and show you how to use key Replicator features effectively with MySQL.
Replication is a powerful technology that takes knowledge and planning to use effectively. This webinar gives you the background that