Seems interesting. Where do we apply for beta testing ?

Also, when we can expect Linux version ?

Annnd all set! Check out the recording for the topics below:

Hello everyone!

We missed out on the last meeting time for #DBHangOps due to some conflicts, but we're looking to come back strong this Wednesday, June 12th 2013 at 12:00pm pacific (19:00 GMT). Come join the discussion and contribute your experience on:

• Upgrading to MySQL 5.6
  • Any issues or gotchas?
• MySQL Python Utilities
  • How do you use them?
• MySQL patches
  • Patches you use
  • Patches you want
• Interesting or valuable Linux kernel settings

Be sure to check out the #DBHangops twitter search, the DBHangops Twitter Feed, …

We are excited to announce that we just released a new beta of XAMPP. It is a little rough around the edges, but we wanted to release it early to give you a chance to let us know what you think and help make XAMPP a better software bundle.

http://www.apachefriends.org/xampp-beta.html

This is the first version we have released since we announced earlier this year that the BitNami team would be joining the XAMPP project. Thanks to their work, this version of XAMPP includes the following improvements:

• Updated main components PHP to 5.4.15, MySQL to 5.5.30, Apache to 2.4.4
• Updated Linux and Mac OS X versions of XAMPP, which had not been updated for a while. Moving forward, we aim to keep them up to date and perform releases at the same time as the Windows version.
• New manager tools for Linux and OS X that allows starting / …

Percona Server for MySQL version 5.1.69-14.7

Percona is glad to announce the release of Percona Server 5.1.69-14.7 on June 10, 2013. A drop in replacement for MySQL, downloads are available  here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will include all the bug fixes in it. All of Percona’s software is open-source and free, all the details of the release can be found in the …

Recently, I was working with a client that asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with a different schema name on the same server.  It caught me off guard because I’d never really thought about it – typically, I’ve used Xtrabackup simply to clone a server (for replication or migration) or migrate an existing schema to a new server.  However, given the import/export functionality of Xtrabackup combined with Percona Server (Exporting and Importing Tables), it did seem …

First, I have to tell you, that the “fragmentation” is not the best word what I should use, but that was the closest to that what I wanted to say. The base of the fragmentation checker script is Peter Zaitchev’s 2008 article about Information_schema, I used that query to get that results what I needed.

Some background: a few weeks ago we got some free space related problems (well, they weren’t a real problem, but they could lead onto one, and we had to act fast.) The innodb is working on a bit strange way, it is not like to free up space what is deleted before, and because of this, the datafiles will grow to the end of the world. The first thing what we could do to reclaim free space is to use

innodb_file_per_table

configuration option, what will split up the database to a lot of …

Use tungsten replicator to replicate between mysql and mongodb.

Mysql tables are equivalent to collections in mongodb. The replication works by replicating inserts and updates. But all DDL statements on mysql are ignored...

Replication in detail

MySQL continues to improve in terms of performance. To get the best out of MySQL, you must learn to analyze your system and use tools to monitor, evaluate and tune the MySQL Server.

The MySQL Performance Tuning training is a 4-day instructor-led course which teaches you to configure the database for performance, tune application and SQL code, tune the server, examine storage engines and assess the application architecture.

You can take this course through the following event types:

• Training-on-Demand: Start training within 24 hours of registration. Follow this course at your own pace through streaming video of instructor delivery and scheduling time to do lab exercises at a time that suits you.
• Live-Virtual: Attend …

Zabbix is an enterprise-class open source software for monitoring of networks and applications. It is designed to monitor and track the status of various network services, servers and applications. It offers advanced monitoring, alerting, and visualization features.

This is a step by step guide on "Installing Zabbix on CentOS" for MySQL monitoring. Monitoring mysql will be posted in seperate article.

Install Apache httpd

[root@localhost ~]# yum -y install httpd

Start httpd service

[root@localhost ~]# /etc/init.d/httpd start           [  OK  ]
[root@localhost ~]# ps -ef | grep http
root      2011     1  0 11:46 …

A fascinating post-mortem on high profile network failures:

This post is meant as a reference point–to illustrate that, according to a wide range of accounts, partitions occur in many real-world environments. Processes, servers, NICs, switches, local and wide area networks can all fail, and the resulting economic consequences are real. Network outages can suddenly arise in systems that are stable for months at a time, during routine upgrades, or as a result of emergency maintenance. The consequences of these outages range from increased latency and temporary unavailability to inconsistency, corruption, and data loss. Split-brain is not an academic concern: it happens to all kinds of systems–sometimes for days on end. Partitions deserve serious consideration.