The latest from the MySQL community

#DBHangOps 07/23/15 -- Information Security, Database, and you!

Hello everybody!

Join in #DBHangOps this Thursday, July, 23, 2015 at 11:00am pacific (19:00 GMT), to participate in the discussion about:

• What does security mean for you?

  • What tools do you use to improve security?
  • What are good security settings for MySQL?

• What does Compliance mean for you?

  • Any useful tools?
  • What are good compliance settings for MySQL?

• Resolving production issues in a secure and compliant way

  • Do you have to change some ways your defenses and tools work for security/compliance?
  • How do you empower developers to debug production issues in a compliant and secure way? …

I’ve been invited to speak at a joint meeting of the Austin MySQL meetup and the Austin Data Geeks meetup on Monday, July 27, 2015. This is a real treat for me. I have not spent much time in this area but whenever I have I’ve loved it. And the community is large and highly engaged at lots of levels. Here’s the summary of the event:

… your database’s performance is a lot less important to your business than the way you structure your engineering team. The interesting thing is that a lot of the most serious team, communication, and process bottlenecks in your business (the ones that make you miss ship deadlines, crash the site, and lose your best team members after repeated all-nighters) are actually driven by database issues, but not the way you think they are. …

Continuing from our April 2015 release of the VMware Continuent 4.0 products is a new 4.0.1 release that provides important fixes to both the replication and MySQL clustering.For full details, read the full release notes, available at the links below, but the highlights are as follows: VMware Continuent for Replication and Data Warehousing

Expanded support for EBS Snapshots to enable MySQL table

Today Percona announced the immediate availability of 24/7, enterprise-class support for MongoDB and TokuMX. The new support service helps organizations achieve maximum application performance without database bloat. Customers have round-the-clock access (365 days a year) to the most trusted team of database experts in the open source community.

The news means that Percona now offers support across the entire open-source database ecosystem, including the entire LAMP stack (Linux, Apache, MySQL, and PHP/Python/Perl), providing a single, expert, proven service provider for companies to turn to in good times (always best to be proactive) – and during emergencies, too.

Today’s support announcement follows …

Welcome to MySQL QA Episode #7 – Reducing Testcases for Beginners: single-threaded reducer.sh!

In this episode we’ll learn how to use reducer.sh. Topics discussed;

1. reducer.sh introduction/concepts
2. Basic configurable variables & their default reducer.sh settings
   1. INPUTFILE options
   2. MODE=x
   3. TEXT=”text”
   4. WORKDIR_LOCATION & WORKDIR_M3_DIRECTORY
   5. MYEXTRA
   6. MYBASE
   7. PQUERY_MOD & PQUERY_LOC
   8. MODE5_COUNTTEXT, MODE5_ADDITIONAL_TEXT & MODE5_ADDITIONAL_COUNTTEXT
   9. How to learn more about each of the settings
3. Manual example
4. Introduction to the script’s self-recursion concept – subreducer
5. Quick setup re-cap, details of an already executed QA run
6. Examples from …

Are your databases more costly than they need to be? If you’re not sure, this webinar will show you how to find out, quickly and easily, with KPIs that indicate overprovisioning or opportunity for driving more efficiency from your databases. If there is an opportunity to run your databases at lower cost, you’ll find out how to identify which of 5 key areas offer the biggest chances for improvement, and a specific action plan to get results fast.

If you did not have a chance to join the webinar, the slide deck is embedded below. You can also register for a recording here.

If you are in the Austin area on July 27, join the MySQL Group, Data Geeks and Devops meetups at RackSpace from 6:30 - 8:45.

In this talk Baron Schwartz, renowned MySQL performance expert and all-around database guru, will explain why your database’s performance is a lot less important to your business than the way you structure your engineering team. The interesting thing is that a lot of the most serious team, communication, and process bottlenecks in your business (the ones that make you miss ship deadlines, crash the site, and lose your best team members after repeated all-nighters) are actually driven by database issues, but not the way you think they are. And the …

Here at VividCortex, it can be exciting (and humbling) to take an occasional step back and revisit some of the great work that’s been done in our offices over the past couple of years. Our blog in particular has grown quite a lot. We’re finally at a point where we can look over the steady stream of articles we’ve published and the manifold topics covered, and we can point to a few in particular and say, “Niiiiice.” But our opinions don’t count for much – it’s you, the faithful VividCortex blog readers, whose say-so really matters. What is it that you’ve found most interesting, most helpful, and most enjoyable in our archives?

Without further ado, here are the VividCortex Blog’s 12 most popular blog posts of all time, as selected by your own readerly eyeballs, organized by topic.

Go

By a long, long shot, our perennially most popular topic is Google’s Go language and our various considerations …

Before proceeding installation things , go through cluster basics from the MySQL website and forums. It will be helpful to easily understand installation and configuration. First time is difficult to get things to done in one shot is not possible , no problem will learn it .
MySQL Cluster Installation will be mostly done by two ways.,

1. Using binaries
2. rpm(Rethat,CentOS..,)

 Different Linux flavors has different methods to install format , here I have explaining with CentOS7 .

1.Have prepared two different machines to install MySQL Cluster . First you have to login two different machines

…

Valgrind's helgrind tool identifies data races and lock deadlocks in multi-threaded programs.  Since the MySQL server is a multi-threaded program, can helgrind find any issues in the MySQL server?

A simple test that does nothing except start up the MySQL server and shut it down is run on the MySQL test suite with memcheck and with helgrind.  For this simple test on MySQL 5.7.7, the memcheck run is nice and clean but the …