Thanks Keith for your reply.
Once again, you experience is very interesting.

Rudy

December 4, 2013 By Severalnines

As OpenStack deployments mature from evaluation/development to production environments supporting apps and services, high-availability becomes a key requirement. In a previous post, we showed you how to cluster the database backend - which is central to the operation of OpenStack. In that setup, you would have two controllers, while placing a 3-node Galera cluster on separate hosts. Now, it can be quite a leap to go from one VM with all services running on it, to a fully distributed setup with 5 VMs. The good news is that you can have a highly available setup starting with just 3 VMs.

In this post, we are going to show you how to cluster OpenStack Havana in a minimal node setup with 2 controllers and one compute node. Our controllers will be running all OpenStack services, as well as clustered RabbitMQ …

The first thing any MySQL user learns is mysql -u user database -p to use the mysql client program to connect with an instance. In this case the user will be prompted for the password and the given password will be encrypted before being passed to the server as part of the authentication process. Some folks (and the majority of scripts) will use -p password on the com
I yanked out the binary atamand line which is less secure as the password is in plain text for anyone privileged or sneaky to see. You could put the password in the ~.my.cnf file but once again the password is there in plain text.

MySQL 5.6 introduced the mysql_config_editor that stores authentication credentials in an encptryed file named .mylogin.cnf in your home directory. MySQL client programs can read this file. No exposure of the password on the …

We are happy to announce a new release of XAMPP for all supported platforms: OS X. This release ships new versions of the main components:

1.8.2-3 version (PHP 5.4 based)

• Updated PHP to 5.4.22
• Updated MySQL to 5.5.34
• Updated Apache to 2.4.7
• Updated phpMyAdmin to 4.0.9

1.8.3-2 version (PHP 5.5 based)

• Updated PHP to 5.5.6
• Updated MySQL to 5.6.14
• Updated Apache to 2.4.7
• Updated phpMyAdmin to 4.0.9
• Fixed issue restarting MySQL database on Windows

We also expanded the number of BitNami-packaged applications compatible with …

I would like to write a short and dislocated post on my condition of Chairman of the PLUK this year. When I accepted this mission, I had no clue what was going to be my job and I have no regret about this decision.
Because it was a fantastic experience and a wonderful conference.

So, I would like to thanks Kortney and Percona again for trusting me.
My committee fellows, David, Todd, Kenny, Ben and Ivan for their involvement.
All those of you who have submitted talks and tutorials for their high level and quality.
And of course all the attendees, we have cooked up this conference for you, thank you for being there.

I jumped into this adventure with my beliefs and I wanted to do it as honestly as possible and as humbly as possible.
I attended all the last PLUK conferences and I quickly knew what I wanted for this new event.

My priority was to have …

I recently came across an issue trying to connect to a MySQL server using the mysql client. It appeared as through the connection was hanging.

A subsequent connection using the -A option highlighted the problem with the previous connection stuck in the state “Waiting for table metadata lock”.

mysql> SHOW PROCESSLISTG
*************************** 1. row ***************************
     Id: 37
   User: root
   Host: localhost
     db: tmp
Command: Query
   Time: 90
  State: preparing
   Info: create table missing as select id from AK where id not in (select id ..
*************************** 2. row ***************************
     Id: 38
   User: root
   Host: localhost
     db: tmp
Command: Field List
   Time: 50
  State: Waiting for table metadata lock
   Info:
*************************** 3. row ***************************
     Id: 39
   User: root
   Host: localhost
     db: tmp
Command: Query
   Time: 0
  State: init
   Info: show processlist …

This week we talk about how to install and set up Galera Cluster. Ear Candy talks about the new MySQL repos from Oracle and what to know about using them; At the Movies is Michael Stonebreaker talking about how to process today's big data transactional processing needs.

Galera Cluster
Codership documentation of Galera Cluster
Installing Percona XtraDB Cluster on Ubuntu documentation
MariaDB's Galera Cluster documentation

read more

Part of an article originally published in the article MySQL Forks: Which one is right for me?, published in the June edition of php[architect]. The preceding portions of the article are available: A Brief History of MySQL Oracle MySQL Percona Server MariaDB Facebook patch The Facebook Patch is a patchset used by Facebook to run [...]

What is SeaLion?

SeaLion is a Linux monitoring tool, built from the ground up for troubleshooting hundreds of servers.

Why did we create SeaLion?

We’ve another product line - CloudMagic which is a search centric email app. We manage petabytes of indexed user data spread across hundreds of servers. This data is hosted on AWS. Being a search centric email app, the search speed is critical. We take pride in being known for blazing fast search speeds. When a search query takes more than the threshold value, we get an alert and we debug.

Typically, it’s important at this point to determine if the issue was with the hosting provider or in our code. Inspite of having a suite of monitoring tools, we always fall back to the output of traditional commands. What took time? We check the usual suspects …

The MySQL Development team is happy to announce our 5.7.3 development milestone release, now available for download at dev.mysql.com.  You can find the full list of changes and bug fixes in the 5.7.3 Release Notes.  Here are the highlights. Enjoy!

Over 1 million QPS with InnoDB Memcached Plugin

After reaching 500 thousand QPS in Read-Only on SQL queries in 5.7.2 we now follow up with over 1 million QPS with InnoDB Memcached Plugin. Read more on this at Dimitri’s blog.  Thanks to Yoshinori (Facebook) for  inspiration!

Over 50 thousand connects/disconnects per second

Fast processing of new connections is important for …