On Nov 16, 2023, at 21:57, Ryan Hamel <ryan@rkhtech.org> wrote:

Christopher,

A residential customer would be getting their /56 from the providers pool via RA or DHCPv6. With a /32 aggregate, it can handle 1.6 million /56 delegations, which can cover a few regions. It all depends on the planning going into splitting up the aggregate.

Or, if the provider isn’t stingy a /48 from the providers /≤32 (providers can get as many /48s as they need to support whatever number of customers receiving them, at least in the ARIN region).

A rule of thumb I go by in the datacenter is, a /48 per customer per site, and further splitting it into /64s per VLAN, all of which can be plugged into a spreadsheet formula to produce a valid complete subnet.

Either way, keeping track of IPAM via spreadsheet is a recipe for disaster. NetBox and Nautobot are my choices, and is worth deploying on a server or VPS, even for home labs.

On this, we agree.

It’s just not what spreadsheets do.

Owen


Ryan

From: NANOG <nanog-bounces+ryan=rkhtech.org@nanog.org> on behalf of Christopher Hawker <chris@thesysadmin.au>
Sent: Thursday, November 16, 2023 3:52:59 PM
To: Aaron Gould <aaron1@gvtc.com>; Owen DeLong <owen@delong.com>
Cc: nanog@nanog.org <nanog@nanog.org>
Subject: Re: ipv6 address management - documentation

Caution: This is an external email and may be malicious. Please take care when clicking links or opening attachments.

One of the first things that comes to mind, is that if you were to breakout a /64 v6 subnet (a standard-issue subnet to a residential customer) in an Excel spreadsheet, the number of columns you would need is 14 digits long. You could breakout the equivalent of a /12 v4 in just one column. Understandably in the real world no one (in their right mind) would do this, this is just for comparison.

Regards,
Christopher H.
From: NANOG <nanog-bounces+chris=thesysadmin.au@nanog.org> on behalf of Owen DeLong via NANOG <nanog@nanog.org>
Sent: Friday, November 17, 2023 10:39 AM
To: Aaron Gould <aaron1@gvtc.com>
Cc: nanog@nanog.org <nanog@nanog.org>
Subject: Re: ipv6 address management - documentation
 
Spreadsheets are terrible for IPAM regardless of address length, but I am curious to know why you think IPv6 would be particularly worse than IPv4 in such a scenario?

Owen


> On Nov 16, 2023, at 10:02, Aaron Gould <aaron1@gvtc.com> wrote:
>
> For years I've used an MS Excel spreadsheet to manage my IPv4 addresses.  IPv6 is going to be maddening to manage in a spreadsheet.  What does everyone use for their IPv6 address prefix management and documentation?  Are there open source tools/apps for this?
>
> --
> -Aaron