Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 18

Displaying posts with tag: IPv6 (reset)

Time to get some 128-bit types into MySQL?
+1 Vote Up -0Vote Down

I think that getting 128-bit types into MySQL would be good. There are a few use cases for this and right now we have to work around them. That should not be necessary.  While not essential they would make things easier.

The headline is easy to understand, but is this really needed?

First we need to look to see where this might be used. I can think of three different 128-bit types which are missing at the moment:

  • IPv6 addresses
  • uuid values
  • a bigger value than (signed) bigint [64-bit numbers]

IPv6 Addresses

IPv6 addresses are 128-bit numbers, and having a native way to store them would be really helpful. Given this also includes an IPv4 representation then for those people who store IP addresses (client connections and other things) such a native type would be much better than the typical unsigned int or

  [Read more...]
IPv6 on database websites
+1 Vote Up -0Vote Down
After reading www.postgresq.org now active over IPV6 by default I quickly tried some other host to see what the current state of IPv6 is for some known database websites.

$ getent hosts mysql.com percona.com askmonty.org postgresql.org oracle.com sqlite.org code.openark.org skysql.com drizzle.org    mysql.com  percona.com  askmonty.org
2a02:16a8:dc51::50 postgresql.org  oracle.com    sqlite.org    code.openark.org   skysql.com173.203.110.72  drizzle.org

So only postgresql.org supports IPv6 right now. On the MySQL side Facebook is one

  [Read more...]
Working with IP's in MySQL and MariaDB - Part 2
+0 Vote Up -0Vote Down
Use DNS directly from your database

mysql> SELECT lookup('localhost');
| lookup('localhost') |
| |
1 row in set (0.00 sec)

mysql> SELECT reverse_lookup('');
| reverse_lookup('') |
| localhost |
1 row in set (0.00 sec)

This is how you install these functions.
  • Build udf_example.so which is in your mysql source. (make udf_example.so)
  • Copy the udf_example.so file from your build directory to your plugin_dir.
  • Create the lookup and reverse_lookup

  •   [Read more...]
    Working with IP's in MySQL and MariaDB
    +2 Vote Up -0Vote Down
    For MySQL it's a best practice to store IP addresses in a INT column rather than in a VARCHAR. This allows for more compact storage. This best practice is only for MySQL as PostgreSQL does have data types like inet and cidr.

    MySQL is equiped with the INET_ATON() and INET_NTOA() functions since version 3.23.15. In MySQL 5.6.3 the INET6_ATON() and INET6_NTOA() functions were addes to finaly add IPv6 address support. To make it easier to work with IPv4 and IPv6 addresses the IS_IPV4_COMPAT(), IS_IPV4_MAPPED(), IS_IPV4() and IS_IPV6() functions were added. The difference between the new and old functions is that the old functions use INT UNSIGNED to store IP addresses and the new function uses VARBINARY(16) for IPv6 addresses and VARBINARY(4) for IPv4 addresses.

      [Read more...]
    RFC 3177 (IPv6 Address Assignment to End Sites) Has Been Obsoleted
    +0 Vote Up -0Vote Down

    For those that don’t follow the ARIN Public Policy Mailing List, the following is excerpted from a post by Thomas Narten in response to the announcement that the IESG has approved a new document to replace the existing RFC 3177 (IPv6 Address Assignment to End Sites).

    > The IESG has approved the following document:
    > – ‘IPv6 Address Assignment to End Sites’
    > (draft-ietf-v6ops-3177bis-end-sites-01.txt) as a BCP

    Quoting from the Introduction:

    This document obsoletes RFC 3177, updating its recommendations in the following ways:

      [Read more...]
    Tech Messages | 2011-01-08
    +0 Vote Up -0Vote Down

    A special extended edition of Tech Messages for 2011-01-07 through 2011-01-08:

      [Read more...]
    XS4ALL offer IPv6 connectivity to retail customers
    +0 Vote Up -0Vote Down
    Good news. I was told by a colleague that the Dutch ISP XS4ALL is offering IPv6 connectivity to its retail customers. You can see here although the comments are in Dutch.  They also provide a list of ADSL routers which should work for their service. The Cisco name may not be surprising but this is [...]
    Don’t forget to monitor your nameservers
    +0 Vote Up -0Vote Down
    As I mentioned in a past article I got my IPv6 connectivity working so started working on setting up various IPv6 services. One of these was to setup my name server so it also worked on IPv6. This worked fine, but recently I lost my IPv6 connectivity but thought no more about it. I’m trying [...]
    Review of IPv6 Network Administration
    +0 Vote Up -0Vote Down

    Originally submitted at O’Reilly

    This essential guide explains what works, what doesn’t, and most of all, what’s practical about IPv6–the next-generation Internet standard. A must-have for network administrators everywhere looking to fix their network’s scalability and management problems. Also covers other IPv6 ben…

    IPv6 Network Administration

    A little outdated – needs updating

    By Simon Mudd from Madrid, Spain on 8/18/2010 3out of 5

    Pros: Well-written, Easy to understand

    Cons: Too basic

    I forgot  [Read more...]

    IPv6 Reading list
    +0 Vote Up -0Vote Down

    I have just returned from holiday and while it’s not normal reading during some of my spare time I managed to read a couple of books on IPv6 I’d recently bought to get me up to scratch and refresh my memory on the topic.

    These books are:

    The first book is quite good, and while a little old provided a good solid background for me on the subject. A lot of the information was not relevant to my interest in setting up a networked SOHO network but that’s not really a problem. The background was interesting.

    The second book was a bit of a mistake.

      [Read more...]
    Checking IPv6 support in my existing hardware
    +0 Vote Up -0Vote Down

    As part of my IPv6 setup I wanted to check what support I could expect for my current hardware. This post relates the results I got by checking on each one.

    • Linux PC – IPv6 is supported in Linux
    • MacBook – IPv6 is supported in MacOS X
    • Windows 7 NetBook – IPv6 is supported in Windows 7
    • Draytek Vigor 2820N – Draytek support in Spain confirmed to plans to implement IPv6 on this box, but they have 1 IPv6 aware router so future models should hopefully have support.
    • HP Officejet Ro L7680 Printer – this printer has a network connection. A support request on HP’s website generated an automatic message
      [Read more...]
    Setup local name server to serve IPv6 addresses for my domain
    +0 Vote Up -0Vote Down

    In order to use IPv6 you probably need to setup things so that your sites can be reached over IPv6. I manage my own DNS server for my domain so decided to make my DNS server reachable over IPv6.  This did not sound too complicated.

    This required 2 things:

    • Ensure that Bind 9 was configured to receive and respond to queries on this address
    • Tell my registrar about the IPv6 address of my domain

    I checked my DNS software, Bind (v9), and it did not seem to be responding to DNS requests to the IPv6 address. A quick look around indicated that I had to add an extra block in the options section of named.conf

    options {
     directory "/etc/named";
     // required to listen for ipv6 queries
     listen-on-v6 { any; };

    My registrar is

      [Read more...]
    Request IPv6 Allocation
    +0 Vote Up -0Vote Down

    When originally looking around to find out how to connect to a IPv6 network there seem to be quite a few different options and providers.

    I originally requested an allocation with Hurricane Electric but had trouble setting up the tunnel. Their web page said they could not ping my public IP address (my router) and this prevented them allowing the tunnel to be created. My ADSL router does not have any ICMP filters configured and as the public IP address is forwarded to my Linux PC I knew that did not either. I also remember when setting up my ADSL connection with Jazztel that I had some configuration issues, and this turned out to be related to the fact (from what I remember) that Jazztel block ICMP traffic to the customer’s IP address.  So with this problem I looked to see if I could find another tunnel broker.

      [Read more...]
    Created IPv6 Setup Progress page
    +0 Vote Up -0Vote Down

    The following page http://blog.wl0.org/ipv6-setup-progress/ is going to be used to show how I make progress in setting up IPv6 and the issues I come across.

    Starting to play with IPv6
    +0 Vote Up -0Vote Down

    Other the last few years I’ve read quite a lot about IPv6 but not really done a lot about it. The theory is easy but when you actually look to try to set it up you suddenly find that most hardware does not really support it.

    • My ISP (Jazztel) have told me they don’t provide an IPv6 service.
    • My Draytek 2820n ADSL router does not support IPv6. Draytek seem to be just starting to look at this in their Vigor 2130 series, but my ADSL router is not covered.
    • My Thecus N5200 Pro NAS device does run Linux underneath so it can be configured to support IPv6. I’ve
      [Read more...]
    6to4: Easing the IPv6 transition
    +0 Vote Up -1Vote Down

    With the exhaustion of IPv4 address space looming sometime in 2012; probably earlier rather than later, it makes sense to ease on into IPv6 land.  Without straying into tunnel broking and endpoint shenanigans 6to4 is a method of wrapping up IPv6 inside of IPv4.

    (note that MySQL does not currently support IPv6 itself – but what we’re discussing here is about externally facing systems, like your web/application servers)

    6to4 performs three functions:

  • Allocates an IPv6 address block to any host/network that has a global IPv4 address.
  • Wraps up IPv6 packets inside IPv4 packets for transmission over IPv4 using 6in4 (traffic is sent over IPv4 inside IPv4 packets whose IP headers have the IP protocol number  set to 41; IPv6-in-IPv4. ) 
  •   [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:

    [root@node ~]# nginx -V
    nginx version: nginx/0.7.64

      [Read more...]
    IPv6 for Gandi (coming soon!)
    +0 Vote Up -0Vote Down

    As a long-time registrar, we are aware of the importance of keeping up with the internet, as well as trying to be at the forefront of changing technologies as we have done for the past four years. Now it's time to do the same with IPv6!

    As a result of this and requests from our customers coupled with the ominous depletion of IPv4 address space, I am pleased to announce that we will be offering IPv6 connectivity for our customers.  Given that IPv6 is the future of the Internet, it is perfectly logical that it is something of particular interest to us.  

    This is, of course, not an overnight affair, and will take some time to be able to fully offer the service for all customers, and at the moment we expect to pass through several stages of testing before general deployment.   In any case, we hope to have IPv6 fully available for our customers before the end of the

      [Read more...]
    Showing entries 1 to 18

    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.