Feed Aggregator

HI,

I want to monitor database refresh,when loading database into mysql I want see the below output,so that I can see if any error occurs.

table1 completed.. table2 completed.. table3 completed.. table4 completed.. . . . . tablen completed.. database loaded successfully completed..

Thanks Srihari

Thank you! I was able to get past that issue, but now, I have a new one:

9704:2013-11-18 17:03:53.268 - INFO: FromDual Performance Monitor for MySQL (0.9.1) run started. 9704:2013-11-18 17:03:53.329 - WARN: util-zabbix1, 10051, util-mysql1 9704:2013-11-18 17:03:53.330 - WARN: Connection to zabbix server failed (rc=1305)! 9704:2013-11-18 17:03:53.339 - WARN: util-zabbix1, 10051, util-mysql1 9704:2013-11-18 17:03:53.339 - WARN: Connection to zabbix server failed (rc=1305)! 9704:2013-11-18 17:03:53.347 - WARN: util-zabbix1, 10051, util-mysql1 9704:2013-11-18 17:03:53.347 - WARN: Connection to zabbix server failed (rc=1305)! 9704:2013-11-18 17:03:53.368 - WARN: util-zabbix1, 10051, util-mysql1 9704:2013-11-18 17:03:53.368 - WARN: Connection to zabbix server failed (rc=1305)! 9704:2013-11-18 17:03:53.377 - WARN: util-zabbix1, 10051, util-mysql1 9704:2013-11-18 17:03:53.377 - WARN: Connection to zabbix server failed (rc=1305)! 9704:2013-11-18 17:03:53.378 …

It looks for me like check delivers an empty string and expects an int or decimal. One has to check what check delivers exactly and why. Debugging in the fpmmm agent should help on this…

When I run, I see the following:

30381:20131115:122820.012 item [HOSTNAME:FromDual.MySQL.check] became not supported: Received value [] is not suitable for value type [Numeric (unsigned)] and data type [Decimal]

Suggestions?

Hi Srihari,

What exactly you want to monitor in MySQL ?

HI, Is there any scripts to moniter load database in mysql,I am trying to moniter with –verbose option in mysql client. but the output giving me all the insert commands. Please help me on this. Thanks Srihari

Great News: Galera Cluster v3.1 GA for MySQL 5.6 was released at Percona Live London (PLUK) 2013. The information is still a bit hidden…

You can find it here:

• The Plugin: https://launchpad.net/galera/3.x/25.3.1
• The MySQL: https://launchpad.net/codership-mysql/5.6/5.6.14-25.1

Or directly on our download page.

Careful: Online-Upgrade from 5.5 to 5.6 will not work yet. We have to find a work-around…

Table of Contents

• Introduction
• Prerequisites
• Full Backup
  • Create Full Backup
  • Prepare Full Backup
  • Restore Full Backup
  • Prepare slave from full backup
  • Prepare GTID slave from full backup
  • Advantages / Disadvantages
  • Important Hints
• Incremental Backup
  • Create Incremental Backup
  • Prepare Incremental Backup
  • Restore Incremental Backup
  • Advantages / Disadvantages
  • Important Hints
  • Differential Backup
• Partial Backup
  • Create Partial Backup
  • Prepare Partial Backup
  • Restore Partial Backup
  • Advantages / Disadvantages
  • Important Hints

Introduction

No one can deny that one of the most important and daily tasks for DBAs is performing backup and restore operations, we’re not required to perform backup and restore operations only when we want to add new replication slave, when we want to implement disaster recovery procedures or when we want to prepare testing or staging server for the running production system, but even if we’re going to make any changes to the database schema in order to enhance the database …

FromDual has the pleasure to announce the release of the new version 1.0.1 of its popular multi-instance MySQL Environment MyEnv.

You can download MyEnv from here.

In the inconceivable case that you find a bug in MyEnv please report it to our Bugtracker.

Any feedback, statements and testimonials are welcome as well! Please send them to feedback@fromdual.com.

If you have questions about MyEnv we will answer them in the MyEnv forum.

Upgrade from 1.0 or 1.0.x to 1.0.y

# cd /home/mysql/product
# tar xf /tmp/myenv-1.0.y.tar.gz
# rm -f myenv
# ln -s myenv-1.0.y myenv

Changes in MyEnv 1.0.1

MyEnv

• New alias v introduce for echo $MYENV_VERSION.
• Function start was extended by --option. This allows you to start a Galera cluster node as follows: start --wsrep-cluster-address="gcomm://" (Bug
  #58).
• Requirements for Ubuntu in README added.
• Mismatch between my.cnf and myenv.conf or [mysqld] section and [client] section in my.cnf is checked and reported (Bug
  #71).
• Before an instance is started MyEnv will check if …

I don’t think that there’s such way in MySQL like MSSQL to track users modifications, but you can check the general log file (if it’s enabled) and search for all DCL statements related to the user in question. In the general log file, MySQL records all commands received by the client along with the issuance timestamp. I hope that helps..

Dear friends, Is there is any command to check when user and password created in MySQL user table. I want command for user logins last password change date and password created date. in MSSQL we are able to take where as in MySQL unable to take. Kindly help me

Thanks Oli for the very helpful post, it really helped me to understand how to use and operate GLB, but I'd like to mention here that the option "-q" works only in Ubuntu, but in CentOS, it should be replaced by "-s" to be used as follows:

 echo getinfo | nc -s 1 127.0.0.1 4444
 

- To drain a node from the GLB, the following command should be used:

 echo 192.168.56.101:3306:0 | nc -s 1 127.0.0.1 4444
 

- To add or remove a node from the GLB, the following commands should be used:

 echo 192.168.56.103:3306:-1 | nc -s 1 127.0.0.1 4444
 
 echo 192.168.56.103:3306:1 | nc -s 1 127.0.0.1 4444
 

Table of Contents

• Introduction
• Prerequisites
  • System information
  • Installed packages
  • Required packages
• Upgrade the first node
  • Upgrade the installed binaries
  • Upgrade mysql schema
  • Prepare the node to join the cluster
  • Joining the cluster
• Rolling upgrade the other nodes
• Get rid of old release option

Introduction

Codership announced from weeks ago introducing the Galera Cluster new release 3.0 having many bug fixes, performance enhancements plus the main purpose which is working with MySQL 5.6. In this article, I’ll go through the upgrade steps from Galera 2.x to the new release 3.0, but at the time of writing this article - as mentioned in the Codership release notes - THIS IS A BETA QUALITY RELEASE FOR TESTING PURPOSES. NOT RECOMMENDED FOR PRODUCTION YET.

Important note: a new Galera version (3.1) will be available soon for production and it will be INCOMPATIBLE with this beta version (3.0) but still compatible with 2.x, so again DO NOT go for production using 3.0 and postpone the production upgrade …

We had a Galera Cluster support case recently. The customer was drenched in tears because his Galera Cluster did not work any more and he could not make it work any more.

Upsss! What has happened?

A bit of the background of this case: The customer wanted to do a rolling-restart of the Galera Cluster under load because of an Operating System upgrade which requires a reboot of the system.

Lets have a look at the MySQL error log to see what was going on. Customer restarted server with NodeC:

12:20:42 NodeC: normal shutdown --> Group 2/2
12:20:46 NodeC: shutdown complete
12:22:09 NodeC: started
12:22:15 NodeC: start replication
12:22:16 NodeC: CLOSED→OPEN
12:22:16 all  : Group 2/3 component all PRIMARY
12:22:17 NodeC: Gap in state sequence. Need state transfer.
12:22:18 all  : Node 1 (NodeC) requested state transfer from '*any*'. Selected 0 (NodeB)(SYNCED) as donor.
12:22:18 NodeB: Shifting SYNCED→DONOR/DESYNCED (TO: 660966498)
12:22:19 NodeC: Shifting PRIMARY→JOINER (TO: 660966498)
12:22:19 NodeC: Receiving …

FromDual has the pleasure to announce the release of the new version 1.0 of its popular multi-instance MySQL Environment MyEnv.

Thanks to the countless feedback of many big customers and the community we finally feel ready to publish version 1.0. A major step forward from the last version 0.4 (dated March 2011) and not published version 0.5 (dated August 2013).

What is MyEnv?

MyEnv is a CLI environment for operating multiple MySQL instances on the same server. If you are using mysqld_multi or/and if you have set-up multiple mysqld instances on the same machine you should really have a look at MyEnv.

If you consider to consolidate your MySQL databases on one machine but if you do not want to pack everything in one instance you are a candidate for MyEnv as well…

You can download MyEnv from here.

In the inconceivable case that you find a bug in MyEnv please report it in our Bugtracker.

Any feedback, statements and testimonials are welcome as well! Please send them to feedback@fromdual.com.

Upgrade from …

FromDual holds its annual company meeting this year in Leoforos Vravronos near Athens (20 km outside) in Greece.

We are happy to invite everybody interested in MySQL technologies (MySQL, Percona Cluster, MariaDB, Galera Cluster, etc.) to participate Wednesday evening October 9^th at the Mare Nostrum Hotel in Leoforos Vravronos for exchanging ideas about MySQL.

Meeting at 17:00 in the hotel lobby.

• Presentation about Xtrabackup (25’) and 5’ Questions and Answers (Abdel-Mawla Gharieb, Support Engineer at FromDual)
• Presentation of a MySQL community member (25’) and 5’ Questions and Answers
• Break 15 min
• Presentation about Galera Cluster (25’) and 5’ Questions and Answers (Oli Sennhauser, CTO of FromDual))
• Presentation of a MySQL community member or discussion and questions about MySQL (25’) and 5’ Questions and Answers
• Dinner at the Mare Nostrum Hotel Restaurant

Please feel free to send us your suggestion about your presentation. Any technical or non-technical MySQL …

Hello thatsafunnynamecomment,

Thanks for reading and correcting my findings! You are absolutely right. I did a bit short-cut too much in maths!

For your comment #2 it looks like I did not investigate carefully enough. Thanks for correcting me. I found several sources pointing to tcp_fin_timeout and mentioned TIME_WAIT is affected. So I should just be more careful next time. Especially in a domain I am an absolute noob.

Shinguz

Thank you for the article. Sorry to nitpick. My colleague pointed out if the local port range is 32768 – 61000, that there are 28233 available ports, not 28232.

It may also be worth mentioning the difference between FIN TIMEOUT (/proc/sys/net/ipv4/tcp_fin_timeout) and the TIMEWAIT length which is hard-coded to 60s in the linux kernel.

This question contains some good pointers and the answer contains a little program in C that you can compile and use to see how long the timeout is: http://unix.stackexchange.com/questions/17218/how-long-is-a-tcp-local-socket-address-that-has-been-bound-unavailable-after-clo

A similar article: http://www.krenel.org/tcp-time_wait-and-ephemeral-ports-bad-friends/

In MySQL we have the typical behaviour that we open and close connections very often and rapidly. So we have very short-living connections to the server. This can lead in extreme cases to the situation that the maximum number of TCP ports are exhausted.

The maximum number of TCP ports we can find with:

# cat /proc/sys/net/ipv4/ip_local_port_range
32768   61000

In this example we can have in maximum (61000 - 32768 = 28232) connections concurrently open.

When a TCP connections closes the port cannot be reused immediately afterwards because the Operating System has to wait for the duration of the TIME_WAIT interval (maximum segment lifetime, MSL). This we can see with the command:

# netstat -nat

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address               Foreign Address             State
tcp        0      0 0.0.0.0:10050               0.0.0.0:*                   LISTEN
tcp        0      0 0.0.0.0:10051               0.0.0.0:*                   LISTEN
tcp        0 …

I’ve setup an F5 to actually do a select and check wsrep_ready. F5 BigIP has an builtin mysql client. For more details see this article on f5 devcentral.