Personal blog of Yzmir Ramirez

 In a significant settlement that could embolden American employees who witness company misconduct, VMware and government contractor Carahsoft Technology Corporation agreed to pay the $75.5 million today to settle illegal pricing allegations. The Department of Justice accused the companies of violating the Fair Claims Act and overcharging the government, in a case brought in conjunction with… Read More

 Mobile payment startup Square has been gradually building out the products it offers to small businesses to position itself as a one-stop shop for their various front-of-house and back-office needs. Today sees the latest development on that theme: the company has launched Square Payroll, software for businesses to pay and track taxes and other costs for both hourly and salaried employees.… Read More

 One Month, the learning platform that promises a solid, enterprise-based education in one month or less, has today announced the close of an additional $1.9 million in seed funding, co-led by existing investor Idea Bulb Ventures and new investor Arena Ventures. Cornerstone On-Demand also participated in the round as a strategic investor.
One Month launched back in August 2013 out of the Y… Read More

 The rise of the CFO from back-office number cruncher to business leader is being played out across a number of companies, from tech leaders like Twitter through to consumer giants like PepsiCo. That shift of gravity, it turns out, is also being played out in the world of enterprise software.
Adaptive Insights, a fast-growing startup that sells cloud-based services to finance and other… Read More

Like any good, thus lazy, engineer I don’t like to start things manually. Creating directories, configuration files, specify paths, ports via command line is too boring. I wrote already how I survive in case when I need to start MySQL server (here). There is also the MySQL Sandbox which can be used for the same purpose.

But what to do if you want to start Percona XtraDB Cluster this way? Fortunately we, at Percona, have engineers who created automation solution for starting PXC. This solution uses Docker. To explore it you need:

1. Clone the pxc-docker repository:
   git clone https://github.com/percona/pxc-docker
2. Install Docker Compose as described here
3. cd pxc-docker/docker-bld
4. Follow instructions from the README file:
   
   

   a) ./docker-gen.sh 5.6    (docker-gen.sh takes a PXC branch as argument, 5.6 is default, and it looks for it on github.com/percona/percona-xtradb-cluster)

   b) Optional: docker-compose build (if you see it is not updating with changes).

   c) docker-compose scale bootstrap=1 members=2 for a 3 node cluster

5. Check which ports assigned to containers:
   

   $docker port dockerbld_bootstrap_1 3306
   0.0.0.0:32768
   $docker port dockerbld_members_1 4567
   0.0.0.0:32772
   $docker port dockerbld_members_2 4568
   0.0.0.0:32776

   
   Now you can connect to MySQL clients as usual:
   

   $mysql -h 0.0.0.0 -P 32768 -uroot
   Welcome to the MySQL monitor.  Commands end with ; or g.
   Your MySQL connection id is 10
   Server version: 5.6.21-70.1 MySQL Community Server (GPL), wsrep_25.8.rXXXX
   Copyright (c) 2009-2015 Percona LLC and/or its affiliates
   Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
   Oracle is a registered trademark of Oracle Corporation and/or its
   affiliates. Other names may be trademarks of their respective
   owners.
   Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
   mysql>

6. To change MySQL options either pass it as a mount at runtime with something like volume: /tmp/my.cnf:/etc/my.cnf in docker-compose.yml or connect to container’s bash (docker exec -i -t container_name /bin/bash), then change my.cnf and run docker restart container_name

Notes.

• If you don’t want to build use ready-to-use images
• If you don’t want to run Docker Compose as root user add yourself to docker group

The post Playing with Percona XtraDB Cluster in Docker appeared first on MySQL Performance Blog.

 Update: In an interview, Microsoft indicated that Bing now doesn’t lose money. That’s several quarters ahead of its stated public cashflow schedule.  Following the news that it will shed around 100 employees to Uber in a mapping technology deal, Microsoft announced this afternoon that it will now power AOL’s search property, and will apportion parts of its advertising work… Read More

 Microsoft today announced that Visual Studio 2015 (VS 2015), the latest version of the company’s integrated development environment, will launch on July 20.
This latest version greatly emphasizes cross-platform development, with support for targeting Windows, iOS and Android, in part through its support for the Apache Cordova project and Xamarin’s app development platform. Read More

Applications often become impacted by MySQL performance. Optimization is the obvious solution but where to start? Join me on July 2 at 11 a.m. Pacific and I’ll show you how to optimize MySQL in a practical way – spending time on what gives you the best return. Many of you have heard me talk on this topic before and this updated presentation will get you up to speed on the latest areas to consider when improving MySQL performance.

I’ll be pointing out the most important things you need to get right for each of the following:

• Hardware
• MySQL Configuration
• Schema and Queries
• Application Architecture

I’ll also share some tools and techniques to focus on the queries most important for your application. At the end of this webinar, aptly titled “Practical MySQL Performance Optimization,” you will know how to optimize MySQL performance in a practical way to ensure our system is “good enough” in terms of responsiveness, efficiency and scalability.

I hope to see you there! Register now to reserve your spot.

The post Practical MySQL Performance Optimization (July 2 webinar) appeared first on MySQL Performance Blog.

 A company like Facebook encounters that kind of choice constantly, but back in the 2009/2010 timeframe, it had an extraordinary one. It was growing faster than just about any company on the planet and was having issues keeping up with that scale. That’s when it decided it had to start designing its own hardware and building its own data centers to meet the company’s very… Read More

 Most programmers like two things: pizza and things that make their work easier. That’s why I was especially interested in SlashDB, a product that purports to turn any data source into accessible XML, JSON, or HTML. Created by programmer Victor Olex, the system allows you to connect almost any data to the web in a few seconds with a REST API.
“SlashDB is an automated web API for… Read More