Personal blog of Yzmir Ramirez

Percona is pleased to announce the availability of Percona Toolkit 2.2.19.  Released August 16, 2016. Percona Toolkit is a collection of advanced command-line tools that perform a variety of MySQL server and system tasks that DBAs find too difficult or complex for to perform manually. Percona Toolkit, like all Percona software, is free and open source.

This release is the current GA (Generally Available) stable release in the 2.2 series. Downloads are available here and from the Percona Software Repositories.

New Features:

• 1221372: pt-online-schema-change now aborts with an error if the server is a slave, because this can break data consistency in case of row-based replication. If you are sure that the slave will not use row-based replication, you can disable this check using the --force-slave-run option.
• 1485195: pt-table-checksum now forces replica table character set to UTF-8.
• 1517155: Introduced --create-table-engine option to pt-heartbeat, which sets a storage engine for the heartbeat table different from the database default engine.
• 1595678 and 1595912: Introduced --slave-user and --slave-password options to pt-online-schema-change, pt-table-sync, and pt-table-checksum.
• 1610385: pt-online-schema-change now re-checks the list of slaves in the DSN table. This enables changing the contents of the table while the tool is running.

Bugs Fixed:

• 1581752: Fixed pt-query-digest date and time parsing from MySQL 5.7 slow query log.
• 1592166: Fixed memory leak when pt-kill kills a query.
• 1592608: Fixed overflow of CONCAT_WS when pt-table-checksum or pt-table-sync checksums large BLOB, TEXT, or BINARY columns.
• 1593265: Fixed pt-archiver deleting rows that were not archived.
• 1610386: Fixed pt-slave-restart handling of GTID ranges where the left-side integer is larger than 9.
• 1610387: Removed extra word ‘default’ from the --verbose help for pt-slave-restart.
• 1610388: Fixed pt-table-sync not quoting enum values properly. They are now recognized as CHAR fields.

Find release details in the release notes and the 2.2.19 milestone at Launchpad. Report bugs on the Percona Toolkit launchpad bug tracker

 Vettery, a startup offering an alternative to the traditional recruiting process, has raised $9 million in Series A funding. On the Vettery website, the company pairs potential job-seekers with a “talent executive” who helps them through the process of creating a profile and looking over interview requests from employers. If they accept a job, Vettery will give them a $1,000… Read More

 Your speech-recognizing friends at Nuance are back with a major update to their flagship app, Dragon. The popular productivity software is now in its 15th version, an update that promises some substantial improvements in accuracy courtesy of the company’s own deep learning tech, which forms the basis of its speech engine. According to Nuance, this latest upgrade brings… Read More

Let me introduce myself, I’m Colin Charles.

Percona turns ten years old this year. To me, there is no better time to join the company as the Chief Evangelist in the CTO office.

I’ve been in the MySQL world a tad longer than Percona has, and have had the pleasure of working on MySQL at MySQL AB and Sun Microsystems. Most recently I was one of the founding team members for MariaDB Server in 2009. I watched that grow into the MariaDB Corporation (after the merger with SkySQL) and the MariaDB Foundation.

For me, it’s about the right server for the right job. Today they all support a myriad of different features and different storage engines. Each server has its own community that supports and discusses their pros and cons. This is now true for both the MySQL and MongoDB ecosystems.

I’ve always had a lot of respect for the work Percona does — pragmatic engineering, deeply technical consulting (and blog posts) and amazing conferences. A big deal for me, and a big reason why I’m now here, is that Percona truly believes in the spirit of open source software development. Their obvious support of the open source community is a great pull factor for users as well.

I just spent time on the Percona Live Europe conference committee. (I’ve been involved in MySQL-related conferences since 2006, and was even Program Chair for a couple of years). There, I got to see how the conference is evolving beyond just stock MySQL to also include MongoDB and other open source databases

Recently I visited a customer who was not just interested in using a database, but also in offering a database-as-a-service to their internal customers. I discussed OpenStack with them, and knowing that Percona, the company I now represent, can support the architecture and deployment too? That’s kind of priceless.

We’re all crazy about databases and their position in the overall IT structure. They provide us with cool apps, internet functionality, and all sorts of short cuts to our daily lives. Percona’s role in providing solutions that address the issues that infrastructure faces is what really excites me about my new journey here.

 In a year where money is harder to come by, especially from conventional venture capital sources, Rubrik is a notable exception, announcing a $61 million Series C round from several brand-named Silicon Valley venture firms. The round was led by Khosla Ventures with participation from existing investors Lightspeed Venture Partners and Greylock Partners, and unnamed angel investors coming… Read More

 Business analytics platform BeyondCore will be officially joining Salesforce, according to a blog post by BeyondCore CEO Arijit Sengupta. BeyondCore is an enterprise analytics tool that bolsters business intelligence with computational and statistical analysis. While Salesforce could have gone fishing and come up with a number of business intelligence companies to buy, BeyondCore was… Read More

 DroneDeploy released a new study of the commercial and industrial drones market this week, revealing bad news for the makers of fixed-wing drones — quadcopters are far outpacing this type of unmanned aerial vehicle in every industry.
Fixed-wing drones, like the SenseFly eBee Ag, 3DR Aero-M and PrecisionHawk Lancaster, promise performance benefits, including endurance and ruggedness.
A… Read More

This post reveals the full Percona Live Europe 2016 schedule for Amsterdam this October 3-5.

The official The Percona Live Open Source Database Conference Europe 2016 schedule is now live, and you can find it here.

The schedule demonstrates that this conference has something for everyone! Whether your interest is in MySQL, MongoDB or other open source databases, there are talks that will interest you.

The Percona Live Open Source Database Conference is the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software. The conferences have a technical focus with an emphasis on the core topics of MySQL, MongoDB, and other open source databases. Tackling subjects such as analytics, architecture and design, security, operations, scalability and performance, Percona Live provides in-depth discussions for your high-availability, IoT, cloud, big data and other changing business needs. This conference is an opportunity to network with peers and technology professionals by bringing together accomplished DBA’s, system architects and developers from around the world to share their knowledge and experience – all to help you learn how to tackle your open source database challenges in a whole new way.

Some of the talks for each area are:

MySQL

• MySQL 8.0: what’s new in Optimizer
  
• Securing your MySQL/MariaDB data
• Transactional Data Dictionary in MySQL 8.0: An Internal Server Component That Matters
• MySQL Load Balancers – MaxScale, ProxySQL, HAProxy, MySQL Router & nginx – a close-up look
  
• MySQL Monitoring with Percona Monitoring and Management (PMM)
• Understanding Percona XtraDB Cluster 5.7 Operation and Key Algorithms

MongoDB

• MongoDB Analytics & Dashboards
• WiredTiger B-Tree vs WiredTiger In-Memory
• Everything you wanted to know about MongoRocks
• Secondary Reads: The good and the bad

Open Source Databases

• Inside CockroachDB’s Survivability Model
• Elasticsearch for SQL Users
• Processing 11 billions events a day with Spark in Badoo

Check out the full schedule now!

Advanced Tickets

Purchase your passes now and get the advanced tickets discount. The earlier you buy, the better the value. You can register for Percona Live Europe here.

Sponsor Percona Live

Sponsor the Percona Live Open Source Database Performance Conference Europe 2016. Sponsorship gets you bigger visibility at the most important open source database conference in Europe. Benefits to sponsorship include:

• Worldwide Audience: Made up of DBAs, developers, CTOs, CEOs, technology evangelists, entrepreneurs, and technology vendors.
• Perfect Location: In Amsterdam City Centre, walking distance from Amsterdam Central Station.
• Perfect Event: The showcase event for the rich and diverse MySQL, MongoDB and open source database markets in Europe.

Click here to sponsor now.

 Workday announced a 7-year cloud infrastructure deal with IBM Softlayer today to run their development and testing services on IBM’s cloud, handing IBM a huge win in the process.
The Wall Street Journal first reported the news.
It’s a big deal from a number of perspectives. First of all, it’s the size and scope of the deal, running seven years. Secondly, it’s a… Read More

 Salesforce’s efforts to turn its Inbox app into a central resource for salespeople has a new trick: An integrated calendar built from its acquisition of Tempo that pulls in contact data from your Salesforce database, giving you a way to quickly find out more about the people you’re meeting with. Only CRM data is pulled right now, but in the future, the product will draw in… Read More