LRN Replication Database

Host Your Own LRN Database. Zero Per-Query Fees.

Full NPAC-sourced LRN data replicated to your MySQL server via binlog streaming. Automated provisioning, flat-rate pricing, unlimited queries.

Start Replication SetupView Pricing
400M+
NANP Records
<1s
Change Latency
Flat
Rate Pricing
mysql -u repl_user -p lrn_db
SELECT lrn, ocn, spid
  FROM number_portability
  WHERE number = '6145550037';
✓ lrn: 6145550037 | latency: 0.3ms

Infrastructure-Grade

Enterprise LRN Database Replication

Built for carriers and high-volume dialers who need NPAC-accurate LRN data without per-query costs.

🗄

MySQL Binlog Streaming

Replicate changes from our NPAC-sourced master database to your MySQL server in real time using native MySQL binlog protocol. Zero-lag change propagation.

🤖

Fully Automated Setup

Register, provide your server's binlog credentials, and we do the rest. Initial snapshot + continuous replication configured automatically.

📊

Full NPAC Database

400M+ NANP telephone numbers with complete LRN, OCN, SPID, LATA, rate center, and porting history — continuously synchronized.

⚡

Zero Query Latency

Query your local database for sub-millisecond LRN resolution. Eliminate network round-trips entirely for the highest-throughput dialers.

🔄

Continuous Change Feed

All NPAC porting events are replicated within seconds of confirmation. Your local database stays authorized-source accurate.

💰

Flat-Rate Pricing

No per-query fees for replicated databases. Pay a flat monthly rate regardless of lookup volume — ideal for high-volume dialers.

Start Free — 1,000 Lookups Included

Simple Process

Up and Running in 4 Steps

01

Register

Create your SIPSmart account and select the Replication plan.

02

Configure

Provide your MySQL server credentials and enable binlog access in our wizard.

03

Snapshot

We push the initial full database snapshot to your server automatically.

04

Replicate

Continuous binlog streaming begins. Your database stays NPAC-current.

Simple, Predictable Pricing

No Surprises. Ever.

We charge less than legacy providers and publish our prices openly. No setup fees, no hidden costs, no annual lock-in required.

API Access
$0.0001
per LRN dip
  • ✓ Real-time lookup
  • ✓ Sub-10ms Ohio cluster
  • ✓ 99.99% SLA
  • ✓ 1,000 free requests
Most Popular
Database Replication
Custom
flat-rate pricing, no per-query fees
  • ✓ Full NPAC-sourced database
  • ✓ MySQL binlog replication
  • ✓ Automated provisioning
  • ✓ Dedicated support

🛡 Pricing Guarantee

We will match or beat any competitor's published price for equivalent LRN lookup volume. Contact us with a quote.

Get Started Free

FAQ

LRN Replication FAQ

Have another question? Email us at support@sipsmart.io

  • SIPSmart maintains a continuously-updated NPAC-sourced MySQL master. We stream changes to your replica using MySQL's native binlog protocol. After an initial snapshot copy, all NPAC porting events are pushed to your server within seconds.
  • MySQL 5.7 or 8.0 (or compatible forks like MariaDB 10.3+). Your server must have log_bin enabled and a replication user grant configured. Our wizard walks you through setup automatically.
  • The full NPAC LRN table is approximately 15–20 GB in MySQL InnoDB format, covering all NANP numbers. We also offer subset replicas (geographic or NPA-filtered) for smaller storage footprints.
  • Yes. Once replicated to your server, you own the query layer. No usage metering, no per-dip fees. You pay a flat monthly subscription for the replication feed.

Own Your LRN Data. No Per-Query Fees.

Full NPAC database replication to your MySQL server. Automated setup, flat-rate pricing.

Start Replication SetupView Pricing

1,000 free lookups included • No credit card required • Instant provisioning