Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 12 2 Older Entries

Displaying posts with tag: network (reset)

Troubleshooting Database Network Problems Using tshark
+0 Vote Up -0Vote Down
Today, one of the MySQL database server response time has been increased within the pool of servers and noticed it was returning the query in 0.20 secs (randomly) as opposed[...]
Pictures from Pedro’s Dinner 2012
+0 Vote Up -0Vote Down

Pedro’s dinner was full! I didn’t count, but we had 9 tables of 8-10 people or so – dare I say almost 100 people? Lots of beer, margaritas, and good conversations! Here are a few pictures from the event:

  [Read more...]
MySQL Conference 2012 Day 0
+0 Vote Up -0Vote Down

Wow! A lot has changed since the last MySQL conference I blogged about in 2007.

MySQL has been acquired twice: once as MySQL by Sun and the second time around bundled with Sun when Oracle bought Sun. The conference is no longer organized by O’Reilly but by Percona. And the MySQL database itself has changed — we were talking about new features in MySQL 5.1, which wasn’t released yet, along with Falcon (where did it go?). 5.1 has long since been released as has 5.5, and we’re now talking about 5.6 instead of 6.0. There was no “Cloud” on the horizon, nor was there MariaDB, XtraDB, Drizzle, Schooner, or any of the other offshoots of MySQL, all of which are creating a new buzz around the product.

Yet, one thing remains constant: the vibrant community around MySQL.

  [Read more...]
mysql jdbc connector autoReconnect=true
+0 Vote Up -0Vote Down

What makes you think jdbc autoreconnect is needed?
Application is idle for long periods at a time?
Wait_timeout too short?
Network failure or glitches?

Some good suggestions form Mark Matthews - Bug #5020

Having encountered the problem again myself today, trying to make jdbc for mysql reconnect any terminated connections using autoreconnect=true I figured out a way to work it out from the pooling side.


Introduction to the problem:

On the mysql side wait_timeout is set to default 8hrs and any connections idle for longer than that were beomg terminated despite setting the connection string to: url=jdbc:mysql://localhost:3306/dbname?autoReconnect=true. The application was thence throwing an exception.

The solution was to introduce a ping







  [Read more...]
Ravelry Runs On – 2010
+0 Vote Up -0Vote Down

I guess that it’s time for the 3rd annual “Ravelry Runs On” roundup. The last two were in March 2008 and March 2009.

This year, our traffic increased by 50% to 5,000,000 page views and 15 million Rails requests per day. We made very few changes to our architecture in 2009 but we did add a new master database server after our working set of data outgrew our memory and IO capacity.

This summary is more detailed then the last two and I’ve broken it up into rough sections.

Physical Network

We own our own servers and colocate then in a datacenter here in Boston. The datacenter provides us with a cooled

  [Read more...]
Enabling IPv6 Support in nginx
+0 Vote Up -0Vote Down

This is going to be a really short post, but for someone it could save an hour of life.

So, you’ve nothing to do and you’ve decided to play around with IPv6 or maybe you’re happened to be an administrator of a web service that needs to support IPv6 connectivity and you need to make your nginx server work nicely with this protocol.

First thing you need to do is to enable IPv6 in nginx by recompiling it with --with-ipv6 configure option and reinstalling it. If you use some pre-built package, check if your nginx already has this key enabled by running nginx -V.

The results should have --with-ipv6 option in configure arguments:

1
2
3
4
5
[root@node ~]# nginx -V
nginx version: nginx/0.7.64





  [Read more...]
As license issues swirl, a new CAOS report
+0 Vote Up -0Vote Down

There has been no shortage of lively discussion on open source software licenses with recent shifts in the top licenses, perspectives on the licenses or lack of them for networked, SaaS and cloud-based software, increased prominence of a Microsoft open source license and concern over the openness (or closedness, depending on your perspedtive) of the latest devices. Amid all of it, we’re pleased to present our latest long-form report, CAOS 12 - The Myth of Open Source License

  [Read more...]
A taste of MySQL certification on Facebook
Employee +0 Vote Up -0Vote Down

Do you plan to take the MySQL Certification (http://www.mysql.com/certification/)?

Or, are you just curious to know how good you are at MySQL ?

If you use Facebook, and chances are that you do, then you should give a try to the MySQL Quiz Application.

Well, it is not like the real certification, but it's fun, and some of the questions are hard enough to give you pause.

The MySQL Quiz Application was created by Dave Stokes, the MySQL certification manager. Thanks, Dave!

A taste of MySQL certification on Facebook
Employee +0 Vote Up -0Vote Down

Do you plan to take the MySQL Certification (http://www.mysql.com/certification/)?

Or, are you just curious to know how good you are at MySQL ?

If you use Facebook, and chances are that you do, then you should give a try to the MySQL Quiz Application.

Well, it is not like the real certification, but it's fun, and some of the questions are hard enough to give you pause.

The MySQL Quiz Application was created by Dave Stokes, the MySQL certification manager. Thanks, Dave!

A taste of MySQL certification on Facebook
Employee +0 Vote Up -0Vote Down

Do you plan to take the MySQL Certification (http://www.mysql.com/certification/)?

Or, are you just curious to know how good you are at MySQL ?

If you use Facebook, and chances are that you do, then you should give a try to the MySQL Quiz Application.

Well, it is not like the real certification, but it's fun, and some of the questions are hard enough to give you pause.

The MySQL Quiz Application was created by Dave Stokes, the MySQL certification manager. Thanks, Dave!

Showing entries 1 to 10 of 12 2 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.