openstack neutron数据库
一．Neutron 数据库的整体架构图Neutron Database采用的是分布式架构，由3台服务器组成一个cluster.Neutron Server通过Plugin,然后发送给Neutron Database的VIP, HAProxy收到消息后,转发给database的实地址.
1.Neutron server 接收 api 请求。
2.plugin转换消息,发送给database
3.database 保存 neutron 网络状态。
4.HAProxy实现数据的主备保护
二． Neutron数据库及字段
1.Neutron数据库table列表
| Tables_in_neutron |
+-----------------------------------------+
| agents |代理
| alembic_version |alembic版本
| alembic_version_fwaas |防火墙即服务的alembic版本
| alembic_version_lbaas |负载均衡即服务的alembic版本
| allowedaddresspairs |允许的地址对
| arista_provisioned_nets | arista提供者网络
| arista_provisioned_tenants | arista提供者租户
| arista_provisioned_vms |arista提供者虚机
| brocadenetworks |博科网络
| brocadeports |博科端口
| cisco_credentials |思科证书
|cisco_csr_identifier_map |思科CSR标识地图
| cisco_firewall_associations |思科防火墙关联
| cisco_hosting_devices |思科主机设备
| cisco_ml2_apic_contracts |思科ML2 APIC合同
|cisco_ml2_apic_host_links |思科ML2 APIC主机链接
| cisco_ml2_apic_names |思科ML2 APIC名称
| cisco_ml2_n1kv_network_bindings |思科ML2 n1kv网络绑定
| cisco_ml2_n1kv_network_profiles |思科ML2 n1kv网络配置文件
| cisco_ml2_n1kv_policy_profiles |思科ML2 n1kv策略配置文件
| cisco_ml2_n1kv_port_bindings |思科ML2 n1kv端口配置文件
|cisco_ml2_n1kv_profile_bindings |思科ML2 n1kv配置文件绑定
| cisco_ml2_n1kv_vlan_allocations |思科ML2 n1kv vlan分配
| cisco_ml2_n1kv_vxlan_allocations |思科ML2 n1kv vxlan分配
| cisco_ml2_nexus_nve |思科ML2NexusNVE
| cisco_ml2_nexusport_bindings |思科ML2 Nexus 端口绑定
| cisco_n1kv_multi_segments |思科n1kv多个区段
| cisco_n1kv_network_bindings |思科n1kv网络绑定
| cisco_n1kv_port_bindings |思科n1kv端口绑定
| cisco_n1kv_profile_bindings |思科n1kv配置文件绑定
| cisco_n1kv_trunk_segments |思科n1kv主要区段
| cisco_n1kv_vlan_allocations |思科n1kv vlan 分配
| cisco_n1kv_vmnetworks |思科n1kv虚机网络
| cisco_n1kv_vxlan_allocations |思科n1kv vxlan 分配
| cisco_network_profiles |思科网络配置文件
| cisco_policy_profiles |思科端口配置文件
| cisco_port_mappings |思科端口映射
| cisco_provider_networks |思科提供者网络
| cisco_qos_policies |思科qos 策略
| cisco_router_mappings |思科路由映射
| consistencyhashes |一致性散列值
| csnat_l3_agent_bindings |csnat l3代理绑定
| default_security_group |默认安全组
| dnsnameservers |dns域名服务器
| dvr_host_macs |DVR主机的MAC
| embrane_pool_port |embrane资源池端口
| externalnetworks |外部网络
| extradhcpopts |额外dhcp端口
| firewall_policies |防火墙策略
| firewall_router_associations |防火墙路由关联
| firewall_rules |防火墙规则
| firewalls |防火墙
| floatingips |浮动ip
| ha_router_agent_port_bindings |ha路由代理端口绑定
| ha_router_networks |ha路由网络
| ha_router_vrid_allocations |ha路由VRID分配
| healthmonitors |健康监测
| ikepolicies |ike 策略
| ipallocationpools |ip 分配资源池
| ipallocations |ip 分配
| ipavailabilityranges |ip可用范围
| ipsec_site_connections |IPSec的站点连接
| ipsecpeercidrs |Ipsec的CIDR
| ipsecpolicies |IPsec策略
| lbaas_healthmonitors |负载均衡的健康监测
| lbaas_listeners |负载均衡监听器
| lbaas_loadbalancer_statistics |负载均衡即服务的负载均衡统计
| lbaas_loadbalanceragentbindings |负载均衡即服务的负载均衡的代理绑定
| lbaas_loadbalancers |负载均衡即服务的负载均衡
| lbaas_members |负载均衡即服务的成员
| lbaas_pools |负载均衡即服务的资源池
| lbaas_sessionpersistences |负载均衡即服务的会话持久性
| lbaas_sni |负载均衡即服务的sni
| lsn |大型网络
| lsn_port |大型网络端口
| maclearningstates |MAC地址学习状态
| members |成员
| meteringlabelrules |计量标签规则
| meteringlabels |计量标签
| ml2_brocadenetworks |ML2博科网络
| ml2_brocadeports |ML2博科端口
|ml2_dvr_port_bindings |ML2 DVR端口绑定
| ml2_flat_allocations |ML2平分配
| ml2_gre_allocations |ML2 的gre分配
| ml2_gre_endpoints |ML2 GRE端点
| ml2_network_segments |ML2网段
| ml2_nexus_vxlan_allocations |ML2 的nexu vxlan 的分配
| ml2_nexus_vxlan_mcast_groups |ML2 Nexus VXLAN组播组
| ml2_port_binding_levels |ML2端口绑定等级
| ml2_port_bindings |ML2端口绑定
| ml2_ucsm_port_profiles |ML2 ucsm端口配置文件
| ml2_vlan_allocations |ML2vlan 分配
| ml2_vxlan_allocations |ML2 vxlan分配
| ml2_vxlan_endpoints |ML2 vxlan端点
| multi_provider_networks |多个供应商网络
| network_bindings |网络绑定
| network_states |网络状态
| networkconnections |网络连接
| networkdhcpagentbindings |网络与dhcp代理的绑定
| networkflavors |网络
| networkgatewaydevicereferences |网络网关设备的引用
| networkgatewaydevices |网络网关设备
| networkgateways |网络网关
| networkqosmappings |网络qos映射
| networkqueuemappings |网络队列映射
| networks |网络
| networksecuritybindings |网络安全组绑定
| neutron_nsx_network_mappings |neutron 与nsx 网络映射
| neutron_nsx_port_mappings |neutron 与nsx 端口映射
| neutron_nsx_router_mappings |neutron 与nsx 路由映射
| neutron_nsx_security_group_mappings |neutron 与nsx 安全组映射
| nexthops |下一跳
| nfv_lock |nfv锁
| nfv_routers |nfv路由
| nsxv_edge_dhcp_static_bindings |NSX边缘DHCP静态绑定
| nsxv_edge_monitor_mappings |NSX边缘DHCP监控映射
| nsxv_edge_pool_mappings |NSX边缘DHCP资源池映射
| nsxv_edge_vip_mappings |NSX边缘 与虚拟ip映射
| nsxv_edge_vnic_bindings |NSX边缘与虚拟网卡映射
| nsxv_firewall_rule_bindings |NSX防火墙规则绑定
| nsxv_internal_edges |nsxv内部的边缘
| nsxv_internal_networks |nsxv内部的网络
| nsxv_port_index_mappings |nsxv端口映射指数
| nsxv_port_vnic_mappings |nsxv端口虚拟网卡映射
| nsxv_router_bindings |nsxv路由绑定
| nsxv_router_ext_attributes |nsxv路由器外部属性
| nsxv_rule_mappings |nsxv规则映射
| nsxv_security_group_section_mappings |nsxv安全组会话映射
| nsxv_spoofguard_policy_network_mappings|nsxv用政策网络映射
|nsxv_tz_network_bindings |nsxv TZ网络绑定
| nuage_net_partition_router_mapping | nuage网络分区映射路由器
| nuage_net_partitions | nuage网络分区
| nuage_provider_net_bindings | nuage提供者网络绑定
| nuage_subnet_l2dom_mapping | nuage子网L2 域映射
| ofcfiltermappings |OFC过滤器映射
| ofcnetworkmappings |OFC网络映射
| ofcportmappings |OFC端口映射
| ofcroutermappings |OFC路由映射
| ofctenantmappings |OFC租户映射
| ovs_network_bindings |ovs 与网络绑定
| ovs_tunnel_allocations |ovs隧道分配
| ovs_tunnel_endpoints |ovs隧道端点
| ovs_vlan_allocations |ovs的vlan分配
| packetfilters |数据包过滤器
| poolloadbalanceragentbindings |资源池负载均衡代理绑定
| poolmonitorassociations |资源池监控器关联
| pools |资源池
| poolstatisticss |资源池统计
| portbindingports |端口绑定端口
| portinfos |端口的相关信息
| portqosmappings |端口的qos映射
| portqueuemappings |端口队列映射
| ports |端口
| portsecuritybindings |端口安全绑定
| protqosmappings |端口qos映射
|providerresourceassociations |供应商资源关联
| qos_policies |qos策略
| qoses |qos
| qosqueues |qos队列
| quotas |配额
| router_extra_attributes |路由的附加属性
| routerflavors |路由特性
| routerl3agentbindings |路由L3代理绑定
| routerports |路由端口
| routerproviders |路由提供者
| routerroutes |路由器的路由
| routerrules |路由规则
| routers |路由
| securitygroupportbindings |安全组端口绑定
| securitygrouprules |安全组规则
| securitygroups |安全组
| sessionpersistences | 会话持久性
| ste |串口服务器
| subnetpoolprefixes |子网前缀资源池
| subnetpools |子网资源池
| subnetroutes |子网路由
| subnets |子网
| tz_network_bindings |tz网络绑定
| vcns_router_bindings |虚拟管理软件路由绑定
| vips |虚拟ip
| ***services |***服务
+-----------------------------------------+
三、某解决方案中neutron数据库的关键table：
1、.默认安全组
MariaDB> descdefault_security_group;
2、外部网络
MariaDB> desc externalnetworks;
3、防火墙策略
MariaDB> desc firewall_policies ;
4、防火墙路由关联
MariaDB> desc firewall_router_associations
5、 防火墙规则
MariaDB> desc firewall_rules
6、防火墙
MariaDB> desc firewalls
7、浮动ip
MariaDB> desc floatingips
8、Ipsec站点连接
MariaDB> desc ipsec_site_connections
9、负载均衡健康监控
MariaDB> desc lbaas_healthmonitors
10、负载均衡监听器
MariaDB> desc lbaas_listeners
11、负载均衡即服务
MariaDB> desc lbaas_loadbalancers
12、负载均衡成员
MariaDB> desc lbaas_members
13、负载均衡资源池
MariaDB> desc lbaas_pools
14、网络
MariaDB> desc lbaas_pools
15、NFV路由
MariaDB> desc nfv_routers
16、nuage网络分区路由映射
MariaDB> desc nuage_net_partition_router_mapping
17、nuage网络分区
MariaDB> desc nuage_net_partitions
18、nuage提供商网络绑定
MariaDB> desc nuage_provider_net_bindings
19、nuage子网L2域映射
MariaDB> desc nuage_subnet_l2dom_mapping
20、QOS
MariaDB> desc qoses
21、Quota
MariaDB> desc quotas
22、路由
MariaDB> desc routers
23、安全组规则
MariaDB> desc securitygrouprules
24、安全组
MariaDB> desc securitygroups
25、子网
MariaDB> desc subnets
26、虚拟IP
MariaDB> desc vips
页:
[1]