…replication. Corosync allows any number of servers to be part of the cluster … have created a Vagrant environment to speed up installation and testing this new solution…Percona XtraDB Cluster with Vagrant). In the follow “terminalcast” you can see how to deploy the setup and some basic commands to…
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
… how to get the script working. Just need to ADD these two lines: yes | yum -y remove mysql-libs yes | yum -y install Percona-XtraDB-server Percona-XtraDB-client right BEFORE: yes | yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client and then the mysql_install_db will be installed…
Comment: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
Hi Mark, No it’s not, in these setup Percona XtraDB Server is used (but it can be any other MySQL version… similar to this setup. I know Yves plans to look on how to use MHA with PRM. The goal of my approach here it to automate the installation and to allow everybody to test…
Post: Percona Server security fix releases
May 23, 2010 By 4 Comments
… our download area: http://www.percona.com/downloads/Percona-Server-5.0/Percona-Server-5.0.91-22/ Release Percona Server/XtraDB 5.1.45-rel10.2… backported patches from 5.1.47 to 5.1.45): http://www.percona.com/downloads/Percona-Server-5.1/Percona-Server-5.1.45-10.2… 4.1 installations and we understand how hard it is upgrade 4.0/4.1 to 5.1. With published exploits these installation are…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… information reported by Percona Server. Another great thing about Percona Server is the ability to enable logging atomically… log. Installing pt-query-digest tool (as well as other tools from Percona Toolkit) is…Next the “Query_time distribution” section shows how this query times mostly, which you …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…such problems, in conjunction with Percona Toolkit’s pt-deadlock-logger …server installations) or a system administration mistake to delete one of MySQL’s log or data files from disk. The database server will continue to… server has been restarted recently. It is surprising how often a server crashes,…
Post: Percona Server and XtraBackup weekly news, April 4th
April 4, 2011 By 1 Comment
… for Percona Server, we think that it is extremely important to continue developing Percona Server, we don’t see the need for any major changes to how we’re doing that right now, and we plan to… it easy to read from a terminal like a man page if you don’t have the man pages installed. We merged…
Post: Percona Server now both SQL and NOSQL
December 14, 2010 By 19 Comments
… dedicated web servers ( using perl clients) I reached 200,000 req/sec and the clients were real bottleneck, while Percona Server was busy only 5-7%. I did not have more clients in my lab to put more load… were done with Percona Server installed on Cisco UCS C250 server with 12cores/24threads and 380GB of RAM . How it can be used: To provide high…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…’t work. How can I recover deleted rows? We’re going to follow the…to download Percona Data Recovery Tool and compile all the tools using the “make” command. In this example I’m going to install…to find the correct index and here I’m going to explain three of them: A) INNODB_SYS_INDEXES Percona Server…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… the server is installed in /customsoftware/mysql with a different my.cnf file. The way to find this out is to look at ps: [percona… stock MySQL server are extremely limited, and for serious analysis it’s basically mandatory to use a server that has the Percona patches for… plan. This is where you need to really know how to write queries and how EXPLAIN works. At Percona, we have peer training constantly on…
