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

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
156.151.63.6    mysql.com
74.121.199.234  percona.com
173.203.202.13  askmonty.org
2a02:16a8:dc51::50 postgresql.org
137.254.16.101  oracle.com
67.18.92.124    sqlite.org
69.89.31.240    code.openark.org
94.143.114.49   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') |
+---------------------+
| 127.0.0.1 |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT reverse_lookup('127.0.0.1');
+-----------------------------+
| reverse_lookup('127.0.0.1') |
+-----------------------------+
| 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...]
    Showing entries 1 to 10 of 18 8 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.