You searched for same box - Page 2 of 14

Using MySQL Sandbox with Percona Server

February 16, 2013 By Peter Zaitsev 3 Comments

One of the most useful tools if you’re working with multiple versions of MySQL Servers is MySQL Sandbox which allows you to maintain many different versions of MySQL, Percona Server, MariaDB. If you’re just working with single sandbox you can just use MySQL Sandbox in its most basic way and it will work:

root@smt2:~/sandboxes# make_sandbox /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz
unpacking /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz
Executing low_level_make_sandbox --basedir=/tmp/5.5.29 \
        --sandbox_directory=msb_5_5_29 \
        --install_version=5.5 \
        --sandbox_port=5529 \
        --no_ver_after_name \
        --my_clause=log-error=msandbox.err
...
no_run                         =
no_show                        =
do you agree? ([Y],n) Y
loading grants
... sandbox server started
Your sandbox server was installed in $HOME/sandboxes/msb_5_5_29

root@smt2:~/sandboxes# make_sandbox /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz

unpacking /tmp/Percona-Server-5.5.29-rel29.4-401.Linux.x86_64.tar.gz

Executing low_level_make_sandbox --basedir=/tmp/5.5.29 \

--sandbox_directory=msb_5_5_29 \

--install_version=5.5 \

--sandbox_port=5529 \

--no_ver_after_name \

--my_clause=log-error=msandbox.err

...

no_run =

no_show =

do you agree? ([Y],n) Y

loading grants

... sandbox server started

Your sandbox server was installed in $HOME/sandboxes/msb_5_5_29

However [...]

Filed Under: MySQL Tagged With: MariaDB, MySQL Sandbox, Percona Server

Replication checksums in MySQL 5.6

February 15, 2013 By Stephane Combaudon 3 Comments

MySQL 5.6 has an impressive list of improvements. Among them, replication checksums caught my attention as it seems that many people misunderstand the real added value of this new feature. I heard people think that with replication checksums, data integrity between the master and its replicas is now enforced. As we’ll see, it’s not that [...]

Filed Under: MySQL Tagged With: MySQL 5.6, Percona, Replication checksums, Stephane Combaudon

How to create/restore a slave using GTID replication in MySQL 5.6

February 8, 2013 By Miguel Angel Nieto 7 Comments

MySQL 5.6 is GA! Now we have new things to play with and in my personal opinion the most interesting one is the new Global Transaction ID (GTID) support in replication. This post is not an explanation of what is GTID and how it works internally because there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids-concepts.html One [...]

Filed Under: MySQL

Implications of Metadata Locking Changes in MySQL 5.5

February 1, 2013 By Ovais Tariq 9 Comments

While most of the talk recently has mostly been around the new changes in MySQL 5.6 (and that is understandable), I have had lately some very interesting cases to deal with, with respect to the Metadata Locking related changes that were introduced in MySQL 5.5.3. It appears that the implications of Metadata Locking have not [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: alter table, ddl, metadata locking, query cache, table cache, transaction, Transaction isolation

Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster

January 31, 2013 By Vadim Tkachenko 2 Comments

With our newest release of Percona XtraDB Cluster, I would like to highlight a very nice ability to recovery a node and bring it back to the cluster with an incremental transfer after a crash. This feature was available even in previous release, but now I want to give some details. So, MySQL crashes from [...]

Filed Under: MySQL, Percona Software Tagged With: Percona XtraDB Cluster, Percona XtraDB Cluster 5.5.29, Vadim Tkachenko

Sphinx search performance optimization: multi-threaded search

January 16, 2013 By Aurimas Mikalauskas 6 Comments

Queries in MySQL, Sphinx and many other database or search engines are typically single-threaded. That is when you issue a single query on your brand new r910 with 32 CPU cores and 16 disks, the maximum that is going to be used to process this query at any given point is 1 CPU core and [...]

Filed Under: MySQL Tagged With: FullText Search, Performance, Sphinx, Tips

Profiling MySQL Memory Usage With Valgrind Massif

January 9, 2013 By Roel Van de Paar 1 Comment

There are times where you need to know exactly how much memory the mysqld server (or any other program) is using, where (i.e. for what function) it was allocated, how it got there (a backtrace, please!), and at what point in time the allocation happened. For example; you may have noticed a sharp memory increase [...]

Filed Under: Insight for DBAs, Insight for Developers, MySQL, Quality Assurance

Percona Toolkit Webinar followup Q&A

December 19, 2012 By Fernando Ipar 1 Comment

First, a thank you to everyone who attended the webinar Today, I appreciate your time and nice comments. As promised, here are answers to questions that couldn’t be answered during the talk: Q: How do you install the tools? The manual has full details, but it’s important to know that the latest release for [...]

Filed Under: Insight for DBAs, MySQL Tagged With: MySQL, Webinars

MySQL and predictive option handling – beware

October 29, 2012 By Peter Zaitsev 2 Comments

MySQL command line utilities have an interesting property – if you only use the prefix of the option or command it will go over the list of available command and if there is only one command with matching prefix it will execute it with no warnings or any kind, otherwise it will report the error. [...]

Filed Under: Insight for DBAs, MySQL

Thank you for joining us at Percona Live, NYC 2012

October 7, 2012 By Peter Zaitsev 1 Comment

Over 200 attendees attended last week’s Percona Live NY event. This year we structured event different than in 2011 with Tutorial Day allowing for in-depth 3 hour presentations for those looking to dive deep into specific topics. We also added an Expo Hall which allowed a lot of MySQL Ecosystem participant to meet their prospective [...]

Filed Under: Events and Announcements, MySQL

Using MySQL Sandbox with Percona Server

Replication checksums in MySQL 5.6

How to create/restore a slave using GTID replication in MySQL 5.6

Implications of Metadata Locking Changes in MySQL 5.5

Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster

Sphinx search performance optimization: multi-threaded search

Profiling MySQL Memory Usage With Valgrind Massif

Percona Toolkit Webinar followup Q&A

MySQL and predictive option handling – beware

Thank you for joining us at Percona Live, NYC 2012

Search

Top Searches

Percona Webinars

ABOUT PERCONA

Percona MySQL Training

Percona Careers

SOFTWARE FROM PERCONA

SERVICES FOR MYSQL USERS

ABOUT THIS BLOG AND PERCONA