Minor Planet Center Annex

@ SBN

 

Database Status: GREEN

25 Feb 2026

  1. Nominal.

Please report concerns!

KEY

Database Replication

Instructions (not for the faint of heart) for replicating the database are posted. Questions/issues related to replication should be directed to Andrei Mamoutkine.

Latest update of every table in MPC MariaDB and Postgres

2026-03-09 20:50:01 (GMT)

Status of all major tables from MariaDB (mpc_development) and Postgres database (mpc_sbn). It includes list of all major tables, number of records in each tables, the latest updated record in each table. A color code corresponds to records updated less than 1 day, from 1 to 3 days and older than 3 days. Updated every 5 min. GMT timestamp of update is at the top left of the page.

MariaDB mpc_development:

Source file of data: statusDB.csv

Table Count Created_at Updated_at
comet_names 5215 2026-03-06 22:06:00 2026-03-06 22:06:00
comet_orbits 12030 2021-10-19 05:20:25 2026-03-07 23:01:17
identifications 217985 2026-03-09 12:35:00 2026-03-09 12:35:00
isolated_tracklets 49820817 2026-03-09 18:58:16 2026-03-09 18:58:16
mp_discoverers 1969147 2025-06-18 21:18:06 2025-06-18 21:18:06
numbered_comet_identifications 1292 2025-10-23 16:03:49 2025-10-23 16:03:49
numbered_identifications 1333152 2026-03-05 21:16:52 2026-03-05 21:16:52
numbered_mps 887103 2026-03-05 21:21:22 2026-03-05 21:21:22
obs_request_observers 52 2019-07-24 16:57:48 2019-07-24 16:57:48
obs_request_users 7 2015-12-04 00:25:22 2015-12-04 00:25:22
observations 511991242 2026-03-09 20:48:04 2026-03-09 20:48:04
orbit_uncertainties 787193 2019-06-03 12:14:45 2022-06-02 16:46:34
orbits 1534614 2026-03-09 20:48:08 2026-03-09 20:48:08
radar_observations 1507 2024-12-04 04:59:18 2024-12-04 04:59:18
No change in Maria mpc_development database structure.

Postgres mpc_sbn:

Table Count Created_at Updated_at
neocp_els 71 2026-03-07 20:48:28.609764 2026-03-09 20:53:44.278229
neocp_events 314535 2026-03-09 20:53:44.51151 2026-03-09 20:53:44.51151
neocp_obs_archive 787728 2026-03-09 20:53:44.236301 2026-03-09 20:53:44.236301
neocp_obs 1488 2026-03-09 20:53:44.194989 2026-03-09 20:53:44.194989
neocp_prev_des 71363 2026-03-09 20:47:18.863091 2026-03-09 20:47:18.863091
neocp_var 137749 2026-03-09 20:53:44.369757 2026-03-09 20:53:44.369757
current_identifications 2047354 2026-03-09 20:46:23.779348 2026-03-09 20:47:32.245829
numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-02-27 03:49:38.898045
primary_objects 1560002 2026-03-09 20:46:23.730727 2026-03-09 20:46:23.730727
obs_sbn 531194535 2026-03-09 16:53:44.654695-04 2026-03-09 16:54:13.033622-04
obs_alterations_deletions 1494310 2026-03-09 17:21:51.051025 2026-03-09 17:21:51.051025
obs_alterations_redesignations 4515 2025-12-01 14:51:10.350811 2026-02-26 23:34:40.379845
obs_alterations_unassociations 563409 2026-03-09 20:15:41.111429 2026-03-09 20:15:41.111429
mpc_orbits 1517030 2021-02-03 22:58:18.410512 2026-03-09 20:54:13.033622
minor_planet_names 25992 2011-10-27 06:38:13 2026-01-16 00:37:34.652007
obscodes 2682 2026-03-04 16:10:58.973055 2026-03-04 16:10:58.973055
comet_names 4364 2026-02-25 01:23:59.404633 2026-02-25 01:23:59.404633
No change to Postgres mpc_sbn database structure

YYYY-MM-DD - latest record is older than 3 days
YYYY-MM-DD - latest record is older than 1 day
YYYY-MM-DD - latest record is less than 1 day old

Replication status view MPC-master → [SBN] → MPC-replica:

Server Table Count Updated_at Queried_at
MPC_primarydb obs_sbn 531194476 2026-03-09 19:57:09.339129 2026-03-09 20:00:02.279619
MPC_mpcsbndb obs_sbn 531194476 2026-03-09 19:57:09.339129 2026-03-09 20:00:15.657944
SBN_to_AWS obs_sbn 531194479 2026-03-09 20:01:18.580747 2026-03-09 20:02:11.597964
MPC_primarydb current_identifications 2047341 2026-03-09 20:11:01.441174 2026-03-09 20:11:04.570179
MPC_mpcsbndb current_identifications 2047341 2026-03-09 20:11:01.441174 2026-03-09 20:11:05.242456
SBN_to_AWS current_identifications 2047341 2026-03-09 20:11:01.441174 2026-03-09 20:11:05.907317
MPC_primarydb comet_names 4364 2026-02-25 01:23:59.404633 2026-03-09 20:11:07.382053
MPC_mpcsbndb comet_names 4364 2026-02-25 01:23:59.404633 2026-03-09 20:11:07.491732
SBN_to_AWS comet_names 4364 2026-02-25 01:23:59.404633 2026-03-09 20:11:07.57539
MPC_primarydb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-03-09 20:11:07.668705
MPC_mpcsbndb minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-03-09 20:11:07.824021
SBN_to_AWS minor_planet_names 25992 2026-01-16 00:37:34.652007 2026-03-09 20:11:07.920153
MPC_primarydb mpc_orbits 1517016 2026-03-09 20:08:40.59319 2026-03-09 20:11:08.055711
MPC_mpcsbndb mpc_orbits 1517016 2026-03-09 20:08:40.59319 2026-03-09 20:11:09.602165
SBN_to_AWS mpc_orbits 1517016 2026-03-09 20:08:40.59319 2026-03-09 20:11:11.048129
MPC_primarydb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-09 20:11:14.804155
MPC_mpcsbndb numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-09 20:11:15.099044
SBN_to_AWS numbered_identifications 887935 2026-02-27 03:49:38.898045 2026-03-09 20:11:15.236431
MPC_primarydb neocp_els 73 2026-03-09 20:07:47.716715 2026-03-09 20:11:15.484761
MPC_mpcsbndb neocp_els 73 2026-03-09 20:07:47.716715 2026-03-09 20:11:15.594913
SBN_to_AWS neocp_els 73 2026-03-09 20:07:47.716715 2026-03-09 20:11:15.677815
MPC_primarydb neocp_events 314523 2026-03-09 20:07:47.941214 2026-03-09 20:11:15.766786
MPC_mpcsbndb neocp_events 314523 2026-03-09 20:07:47.941214 2026-03-09 20:11:15.949844
SBN_to_AWS neocp_events 314523 2026-03-09 20:07:47.941214 2026-03-09 20:11:16.066693
MPC_primarydb neocp_obs 1504 2026-03-09 20:07:47.634268 2026-03-09 20:11:16.208382
MPC_mpcsbndb neocp_obs 1504 2026-03-09 20:07:47.634268 2026-03-09 20:11:16.311911
SBN_to_AWS neocp_obs 1504 2026-03-09 20:07:47.634268 2026-03-09 20:11:16.394845
MPC_primarydb neocp_obs_archive 787697 2026-03-09 20:07:47.675111 2026-03-09 20:11:16.487469
MPC_mpcsbndb neocp_obs_archive 787697 2026-03-09 20:07:47.675111 2026-03-09 20:11:16.698118
SBN_to_AWS neocp_obs_archive 787697 2026-03-09 20:07:47.675111 2026-03-09 20:11:16.838068
MPC_primarydb neocp_prev_des 71360 2026-03-09 18:11:55.382011 2026-03-09 20:11:17.057775
MPC_mpcsbndb neocp_prev_des 71360 2026-03-09 18:11:55.382011 2026-03-09 20:11:17.195942
SBN_to_AWS neocp_prev_des 71360 2026-03-09 18:11:55.382011 2026-03-09 20:11:17.294376
MPC_primarydb neocp_var 139749 2026-03-09 20:07:47.807257 2026-03-09 20:11:17.410087
MPC_mpcsbndb neocp_var 139749 2026-03-09 20:07:47.807257 2026-03-09 20:11:17.577903
SBN_to_AWS neocp_var 139749 2026-03-09 20:07:47.807257 2026-03-09 20:11:17.689449
MPC_primarydb obscodes 2682 2026-03-04 16:10:58.973055 2026-03-09 20:11:17.841484
MPC_mpcsbndb obscodes 2682 2026-03-04 16:10:58.973055 2026-03-09 20:11:17.963024
SBN_to_AWS obscodes 2682 2026-03-04 16:10:58.973055 2026-03-09 20:11:18.047149
MPC_primarydb primary_objects 1559989 2026-03-09 20:10:29.704101 2026-03-09 20:11:18.14059
MPC_mpcsbndb primary_objects 1559989 2026-03-09 20:10:29.704101 2026-03-09 20:11:18.538806
SBN_to_AWS primary_objects 1559989 2026-03-09 20:10:29.704101 2026-03-09 20:11:18.796008
MPC_primarydb obs_alterations_corrections 0 2026-03-09 20:11:20.395916
MPC_mpcsbndb obs_alterations_corrections 0 2026-03-09 20:11:20.504806
SBN_to_AWS obs_alterations_corrections 0 2026-03-09 20:11:20.585927
MPC_primarydb obs_alterations_deletions 1494310 2026-03-09 17:21:51.051025 2026-03-09 20:11:20.672248
MPC_mpcsbndb obs_alterations_deletions 1494310 2026-03-09 17:21:51.051025 2026-03-09 20:11:21.058721
SBN_to_AWS obs_alterations_deletions 1494310 2026-03-09 17:21:51.051025 2026-03-09 20:11:21.203804
MPC_primarydb obs_alterations_redesignations 4515 2026-02-26 23:34:40.379845 2026-03-09 20:11:21.435393
MPC_mpcsbndb obs_alterations_redesignations 4515 2026-02-26 23:34:40.379845 2026-03-09 20:11:21.546673
SBN_to_AWS obs_alterations_redesignations 4515 2026-02-26 23:34:40.379845 2026-03-09 20:11:21.630966
MPC_primarydb obs_alterations_unassociations 563406 2026-03-09 18:10:13.531288 2026-03-09 20:11:21.720536
MPC_mpcsbndb obs_alterations_unassociations 563406 2026-03-09 18:10:13.531288 2026-03-09 20:11:21.971537
SBN_to_AWS obs_alterations_unassociations 563406 2026-03-09 18:10:13.531288 2026-03-09 20:11:22.095185