19 April 2014

The Ruby Reflector

Topic

Percona Server

  Source Favicon
Email

…Percona Toolkit and Percona XtraBackup are up to the latest versions, but Percona Server and Percona XtraDB Cluster comes with 5.5 versions, and it is in line with default MySQL version, which again is 5.5.

I expect this release will make it much easier for users to get familiar with our software, so you can go and try this today!

The post Percona Software in Ubuntu 14.04 LTS ( Trusty Tahr) release appeared first on MySQL Performance Blog .

mysqlperformanceblog.com Read
  Source Favicon
By Paar of MySQL Performance Blog 3 days ago.
Email

…bugs.mysql.com (for MySQL Server bugs) or on bugs.launchpad.net/percona-server (for Percona Server bugs) already.

In this example, we will be testing Percona Server, as the combination.pl (.cc) grammar we use is optimized for Percona Server. If you would like to test the MySQL server, you can build your own grammars, or use one of the many grammars available in RQG (though they are not many combinations.pl grammars in RQG yet. There are plenty of ( less-powerful) runall.pl …

mysqlperformanceblog.com Read
  Source Favicon
By Klampaeckel of till's blog 2 years ago.
Email

Among all the different technologies in our stack, we also use MySQL. While we still run MySQL (or Percona-Server) ourselves, we selected a managed solution to power parts of our production infrastructure: a Multi-AZ setup with Amazon's RDS.

AZ is Amazon-speak for "availability zone", essentially a datacenter. RDS stands for: Relational Database Service.

Judging from my experience with our own setups where EBS is in the mix, I have to say that Amazon does an …

till.klampaeckel.de Read
  Source Favicon
By Paar of MySQL Performance Blog 3 days ago.
Email

…bugs.mysql.com (for MySQL Server bugs) or on bugs.launchpad.net/percona-server (for Percona Server bugs) already.

In this example, we will be testing Percona Server, as the combination.pl (.cc) grammar we use is optimized for Percona Server. If you would like to test the MySQL server, you can build your own grammars, or use one of the many grammars available in RQG (though they are not many combinations.pl grammars in RQG yet. There are plenty of ( less-powerful) runall.pl …

mysqlperformanceblog.com Read
  Source Favicon
By Todd Hoff of High Scalability 2 months ago.
Email

Hey, it's HighScalability time:

Google "Corkboard" Server, 1999

5 billion requests per day : Heroku serves 60,000 requests per second; 500 Petabytes : Backblaze's New Data Center; 25000 simultaneous connections : on a Percona Server

How algorithms help determine that shape of our world. First we encode normative rules of an idealized world in algorithms. Second those algorithms help enforce those expectations by nudging …

highscalability.com Read
  Source Favicon
By patrick.crews of MySQL Performance Blog over 2 years ago.
Email

./ dbqp.py -default-server-type=mysql -basedir=/path/to/ Percona-Server -suite=randgen_basic innodbDictSizeLimit_test

This enabled us to reproduce the crash within 5 seconds.

The reason I think this is interesting is that we were unable to duplicate this bug otherwise. The combination of the randgen's power and dbqp's organization helped us knock this out with about 15 minutes of tinkering.

Once we had a bead on this bug, we went on to try a couple of other bugs:

Crash when …

mysqlperformanceblog.com Read
  Source Favicon
Email

…can be a lot). Given the sensitivity to replication delay and the high end infrastructure in place ( Percona Server 5.6, 384G RAM, Virident and FusionIO PCI-Flash cards), we decided it was important to absorb the extra traffic in an effort gain further insight into the precise points of any slave lag.

There had been discussion about tweaking the use of pt-heartbeat (-interval = .01 with reduced skew) to look at the sub-second delay, but there were some other considerations:

The tool …

mysqlperformanceblog.com Read
  Source Favicon
By Ryan Lowe of MySQL Performance Blog 3 years ago.
Email

HandlerSocket matures. More people will publish benchmarks and use cases. As companies upgrade their Percona-Server installations, HandlerSocket will become available and easily accessible to them. Finally, as the code matures and the community grows, we'll see lots more third-party involvement with bug reports, feature requests, and patches. I see lots of interest in HandlerSocket and am tremendously optimistic about it's future.

mysqlperformanceblog.com Read
  Source Favicon
By Yves Trudeau of MySQL Performance Blog over 3 years ago.
Email

Last Friday I published results of DBT2 performance while varying the number of idle connections here , but I had compiled MySQL with the debugging code enabled. That completely screw up my results, be aware... debug options have a huge performance impact. So, I recompiled Percona-Server 11.2 without the debug options and did another benchmark run. The result is shown below:

As you can see, the impact is more moderate and far less shocking. The performance loss is approximately …

mysqlperformanceblog.com Read
  Source Favicon
Email

But enough on Percona Software. There is an impact to Percona web systems as well. The majority of our systems have not been impacted directly because they were running an OpenSSL version which did not have the Heartbleed vulnerability. However, because of how our systems are integrated, there was a small probability that some customer accounts could be exposed through impacted services: https://rdba.percona.com and https://cloud.percona.com . We promptly patched these …

mysqlperformanceblog.com Read