.net core ocelot+consul+jwt 身份验证，服务治理与发现，网关配置(三)增加 cap 分布式事务

随着服务的增多 访问量增加  数据库 压力增加  可能拆分多个

拆分 分 水平 拆分  水平拆分 库 水平拆分表 ，只是 表结构不变 拆分多个 相同结构的表 或者库

垂直分 表 就结构 改变了 拆分出 多张 有主外键关系的表 这种拆分 多是数据库设计的问题 

在分布式 集群 环境下 怎么做到 分布式事务呢 那就是net.cap

 先装个rabbitmq 吧 因为 要依赖消息队列

docker run -d --name rabbit -e RABBITMQ_DEFAULT_USER=admin -e RABBITMQ_DEFAULT_PASS=admin -p 15672:15672 -p 5672:5672 -p 25672:25672 -p 61613:61613 -p 1883:1883 rabbitmq:management

http://192.168.0.100:15672/ 

u admin p admin 

需要Nuget 下载

DotNetCore.CAP
DotNetCore.CAP.Dashboard
DotNetCore.CAP.MySql
DotNetCore.CAP.RabbitMQ

我这里是依赖的mysql

注意 cap数据库不能单独一个  会报错文章下面 有解释 

 

接下来先搞个简单点的  项目结构

 

JwtOrder service注入

using JwtEFCore;
using Microsoft.Extensions.Options;

var builder = WebApplication.CreateBuilder(args);
// Add services to the container.
builder.Services.AddControllers();
// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();
builder.Services.Configure<DBOptions>(builder.Configuration.GetSection("DBOptions"));
builder.Services.AddTransient<JwtContext>();

13 string capDbStr = builder.Configuration["CAPDB:con"];
14 builder.Services.AddCap(options =>
15 {
16     options.FailedRetryCount = 10; //失败重试的次数 不一定会正确的到消息队列 所以这里添加是失败重试
17     //如果 重试 次数超过10次 但是后期 人修好了消息队列 可以修改数据库中得retry 次数 改小一点 继续重试
18     options.FailedRetryInterval = 60;//重试间隔60s 
19     options.FailedThresholdCallback = failed =>
20     {
21         var logger = failed.ServiceProvider.GetService<ILogger<Program>>();
22         logger.LogError($@"MessageType {failed.MessageType} 失败了， 重试了 {options.FailedRetryCount} 次, 
23                         消息名称: {failed.Message.Value}");//do anything
24     };
25     options.UseRabbitMQ(config =>
26     {
27         config.HostName = "192.168.0.100";
28         config.Port = 5672;
29         config.VirtualHost = "cap";
30         config.UserName = "admin";
31         config.Password = "admin";
32 
33     });
34     options.UseMySql(capDbStr);
35     options.UseDashboard();
36 });
var app = builder.Build();

// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.UseHttpsRedirection();

app.UseAuthorization();

app.MapControllers();

app.Run();

 

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "DBOptions": { "ConStr": "server=192.168.0.100;port=3306;database=jwtocelot;uid=root;pwd=123456;" },
  "CAPDB": { "con": "server=192.168.0.100;port=3306;database=jwtocelotcap;uid=root;pwd=123456;" }
}

 

using DotNetCore.CAP;
using JwtEFCore.Models;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using JwtEFCore.Enums;
namespace JwtOrder.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class OrderCapController : ControllerBase
    {
        private readonly string publishName = "User-Order-Pay";
        private readonly ICapPublisher _publisher;
        public OrderCapController(ICapPublisher publisher)
        {
            _publisher = publisher;
        }

        /// <summary>
        /// 发送未支付订单到支付
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>
24         [HttpGet("OrderToPay/{Id}")]
25         public IActionResult OrderToPay([FromRoute] long Id)
26         {
27             Order order = new Order { Id = Id, OrderStatus = OrderStatus.Unpaid };
28             _publisher.Publish(publishName, order);          
29             return Ok(order);
30         }
    }
}

这里 如果 只运行 Order项目 是在rabbitmq是没有消息队列的 ，消息队列 是在 消费者 创建的

还有 第一次运行的时候 会创建两个表  cap.published   cap.received

published 有retries 列 对应 配置重试次数  statusName 对应状态 发送 成功或者失败

 

 

received  表有 group 列 就是对应 消息队列的 队列的名称 name列 对应的 生成者主题名称

 对应的是队列名称

 主题名称

 

下面来一个 消费者

消费者 service注入与 生成者是一样的

 

using JwtEFCore;
using Microsoft.Extensions.Options;

var builder = WebApplication.CreateBuilder(args);
// Add services to the container.
builder.Services.AddControllers();
// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();
builder.Services.Configure<DBOptions>(builder.Configuration.GetSection("DBOptions"));
builder.Services.AddTransient<JwtContext>();
string capDbStr = builder.Configuration["CAPDB:con"];
builder.Services.AddCap(options =>
{
    options.FailedRetryCount = 10; //失败重试的次数 不一定会正确的到消息队列 所以这里添加是失败重试
    //如果 重试 次数超过10次 但是后期 人修好了消息队列 可以修改数据库中得retry 次数 改小一点 继续重试
    options.FailedRetryInterval = 60;//重试间隔60s 
    options.FailedThresholdCallback = failed =>
    {
        var logger = failed.ServiceProvider.GetService<ILogger<Program>>();
        logger.LogError($@"MessageType {failed.MessageType} 失败了， 重试了 {options.FailedRetryCount} 次, 
                        消息名称: {failed.Message.Value}");//do anything
    };
    options.UseRabbitMQ(config =>
    {
        config.HostName = "192.168.0.100";
        config.Port = 5672;
        config.VirtualHost = "cap";
        config.UserName = "admin";
        config.Password = "admin";

    });
    options.UseMySql(capDbStr);
    options.UseDashboard();
});
var app = builder.Build();

// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.UseHttpsRedirection();

app.UseAuthorization();

app.MapControllers();

app.Run();

消费者具体代码 

特性 [NonAction] 是必须的

[CapSubscribe("User-Order-Pay",Group =("User-Order-Pay-Grop1"))] 订阅主题 是  User-Order-Pay rabbitmq 队列是 User-Order-Pay-Grop1 生成者 与消费者是 一对多 可以有多个 消费者

也就是 可以多次订阅同一个主题 下面就是典型 运用 

如果 还有 下一级 业务 可以 继续 写   _publisher.Publish(publishName, order);    发送到下一级 业务中

 

！！！Cap 源码  Name 是 Topic 或者是 交换机的路由key Group 是队列名称

/// <summary>

/// Topic or exchange route key name.

/// </summary>

public string Name { get; }

 

/// <summary>

/// Default group name is CapOptions setting.(Assembly name)

/// Kafka --> groups.id

/// RabbitMQ --> queue.name

/// </summary>

public string Group { get; set; } = default!;

 

src/DotNetCore.CAP/Internal/TopicAttribute.cs · Gitee 极速下载/dotnetcore-cap - Gitee.com

 

 

 

 

using DotNetCore.CAP;
using JwtEFCore.Models;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;

namespace JwtPay.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class PayCapController : ControllerBase
    {
        private readonly ICapPublisher _capPublisher;
        private readonly ILogger<PayCapController> _logger;
        public PayCapController(ICapPublisher capPublisher, ILogger<PayCapController> logger)
        {
            _capPublisher = capPublisher;
            _logger = logger;
        }

        [NonAction]
21         [CapSubscribe("User-Order-Pay",Group =("User-Order-Pay-Grop1"))]
        public void OrderPay1(Order order)
        {
            order.OrderStatus = JwtEFCore.Enums.OrderStatus.Payment;
            _logger.LogError($"订单状态{order.OrderStatus}");         
        }
        [NonAction]
28         [CapSubscribe("User-Order-Pay")]
        public void OrderPay2(Order order)
        {
            order.OrderStatus = JwtEFCore.Enums.OrderStatus.Payment;
            _logger.LogError($"订单状态{order.OrderStatus}");
        }

        [NonAction]
36         [CapSubscribe("User-Order-Pay",Group =("User-Order-Pay-Grop3"))]
        public void OrderPay3(Order order)
        {
            order.OrderStatus = JwtEFCore.Enums.OrderStatus.Payment;
            _logger.LogError($"订单状态{order.OrderStatus}");
        }
    }
}

两个项目 一起运行 才能有 效果 如果 只运行 生产者 那么消息只是发送到 交换机 因为 此时并没有 生成消息队列 消息队列是 消费者创建的 所以 看不出 效果 而且 发送到交换机的消息不会持久化

 以上 并没有 加入 事物 ，以上的演示 可以用做 领域事件 

接下来 演示 分布式 事物的实现 分布式事物 没有 回滚 只能 是commit  因为 没法回滚 服务 都不在一个 服务器 上 很难回滚 

 Table 'jwtocelot.cap.published' doesn't exist

 

 分布式事物 数据库与在Order表是一个库要不就会报上面的错 

所以代码有改动

order服务代码

using JwtEFCore;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Options;

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.

builder.Services.AddControllers();
// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();
builder.Services.Configure<DBOptions>(builder.Configuration.GetSection("DBOptions"));
builder.Services.AddTransient<JwtContext>();
//必须是在一个库 不能 单独一个库
//string capDbStr = builder.Configuration["CAPDB:con"];
string capDbStr = builder.Configuration["DBOptions:ConStr"];
builder.Services.AddCap(options =>
{
    options.FailedRetryCount = 10;
    options.FailedRetryInterval = 60;
    options.FailedThresholdCallback = failed =>
    {
        var logger = failed.ServiceProvider.GetService<ILogger<Program>>();
        logger.LogError($@"MessageType {failed.MessageType} 失败了， 重试了 {options.FailedRetryCount} 次, 
                        消息名称: {failed.Message.Value}");//do anything
    };

    options.UseRabbitMQ(config =>
    {
        config.HostName = "192.168.0.100";
        config.Port = 5672;
        config.VirtualHost = "cap";
        config.UserName = "admin";
        config.Password = "admin";

    });
    options.UseMySql(capDbStr);

    options.UseDashboard();
});


var app = builder.Build();

// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.UseHttpsRedirection();

app.UseAuthorization();

app.MapControllers();

app.Run();

 

using DotNetCore.CAP;
using JwtEFCore.Models;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using JwtEFCore.Enums;
using JwtEFCore;

namespace JwtOrder.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class OrderCapController : ControllerBase
    {
        private readonly string publishName = "User-Order-Pay";
        private readonly string publishTransName = "UserTrans-Order-Pay";
        private readonly ICapPublisher _publisher;
        private readonly JwtContext _jwtContext;
        public OrderCapController(ICapPublisher publisher, JwtContext jwtContext)
        {
            _publisher = publisher;
            _jwtContext = jwtContext;
        }

        /// <summary>
        /// 发送未支付订单到支付
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>
        [HttpGet("OrderToPay/{Id}")]
        public IActionResult OrderToPay([FromRoute] long Id)
        {
            Order order = new Order { Id = Id, OrderStatus = OrderStatus.Unpaid };
            _publisher.Publish(publishName, order);
            return Ok(order);
        }

        /// <summary>
        /// 分布式事物
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>

        [HttpGet("OrderToPayTran/{Id}")]
44         public async Task<IActionResult> OrderToPayTranAsync([FromRoute] long Id)
45         {
46             Order order = _jwtContext.Orders.Find(Id);
47             if (order == null)
48             {
49                 User user = new User { Id = 1, Name = "ceshi", Password = "1234", Phone = "1" };
50                 order = new Order { Id = Id, OrderStatus = OrderStatus.Unpaid };
51                 order.User = user;
52              
53             }
54 
55             //BeginTransaction 这个方法是 cap的扩展方法 autoCommit: false 设置 不是自动commit
56             using (var trans = _jwtContext.Database.BeginTransaction(this._publisher, autoCommit: false))
57             {
58                 //保存
59                 _jwtContext.Orders.Add(order);
60                 //保存到数据库
61                 await _jwtContext.SaveChangesAsync();
62                 //发送消息
63                 this._publisher.Publish(publishTransName, order);
64                 //提交
65                 trans.Commit();
66             }
67 
68             return Ok("保存成功");
69         }


    }
}

 

pay项目

using JwtEFCore;
using Microsoft.Extensions.Options;

var builder = WebApplication.CreateBuilder(args);
// Add services to the container.
builder.Services.AddControllers();
// Learn more about configuring Swagger/OpenAPI at https://aka.ms/aspnetcore/swashbuckle
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen();
builder.Services.Configure<DBOptions>(builder.Configuration.GetSection("DBOptions"));
builder.Services.AddTransient<JwtContext>();
//string capDbStr = builder.Configuration["CAPDB:con"];
string capDbStr = builder.Configuration["DBOptions:ConStr"];
builder.Services.AddCap(options =>
{
    options.FailedRetryCount = 10; //失败重试的次数 不一定会正确的到消息队列 所以这里添加是失败重试
    //如果 重试 次数超过10次 但是后期 人修好了消息队列 可以修改数据库中得retry 次数 改小一点 继续重试
    options.FailedRetryInterval = 60;//重试间隔60s 
    options.FailedThresholdCallback = failed =>
    {
        var logger = failed.ServiceProvider.GetService<ILogger<Program>>();
        logger.LogError($@"MessageType {failed.MessageType} 失败了， 重试了 {options.FailedRetryCount} 次, 
                        消息名称: {failed.Message.Value}");//do anything
    };
    options.UseRabbitMQ(config =>
    {
        config.HostName = "192.168.0.100";
        config.Port = 5672;
        config.VirtualHost = "cap";
        config.UserName = "admin";
        config.Password = "admin";

    });
    options.UseMySql(capDbStr);
    options.UseDashboard();
});
var app = builder.Build();

// Configure the HTTP request pipeline.
if (app.Environment.IsDevelopment())
{
    app.UseSwagger();
    app.UseSwaggerUI();
}

app.UseHttpsRedirection();

app.UseAuthorization();

app.MapControllers();

app.Run();

如果 还有下一级 还可以 写事物 和 消息发布

using DotNetCore.CAP;
using JwtEFCore.Models;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;

namespace JwtPay.Controllers
{
    [Route("api/[controller]")]
    [ApiController]
    public class PayCapController : ControllerBase
    {
        private readonly ICapPublisher _capPublisher;
        private readonly ILogger<PayCapController> _logger;
        public PayCapController(ICapPublisher capPublisher, ILogger<PayCapController> logger)
        {
            _capPublisher = capPublisher;
            _logger = logger;
        }

        [NonAction]
        [CapSubscribe("User-Order-Pay",Group =("User-Order-Pay-Grop1"))]
        public void OrderPay1(Order order)
        {
            order.OrderStatus = JwtEFCore.Enums.OrderStatus.Payment;
            _logger.LogError($"订单状态{order.OrderStatus}");         
        }
        [NonAction]
        [CapSubscribe("User-Order-Pay")]
        public void OrderPay2(Order order)
        {
            order.OrderStatus = JwtEFCore.Enums.OrderStatus.Payment;
            _logger.LogError($"订单状态{order.OrderStatus}");
        }

        [NonAction]
        [CapSubscribe("User-Order-Pay",Group =("User-Order-Pay-Grop3"))]
        public void OrderPay3(Order order)
        {
            order.OrderStatus = JwtEFCore.Enums.OrderStatus.Payment;
            _logger.LogError($"订单状态{order.OrderStatus}");
        }


44         [NonAction]
45         [CapSubscribe("UserTrans-Order-Pay", Group = ("UserTrans-Order-Pay-Group"))]
46         public void OrderPayForTrans(Order order)
47         {
48             order.OrderStatus = JwtEFCore.Enums.OrderStatus.Payment;
49             _logger.LogError($"订单状态{order.OrderStatus}");
50         }
    }
}

 

测试

 

 

 

 

 

 

 

还可以进行 header 消息头传递

生产者代码

        /// <summary>
        /// 发送未支付订单到支付
        /// </summary>
        /// <param name="Id"></param>
        /// <returns></returns>
        [HttpGet("OrderToPay/{Id}")]
        public IActionResult OrderToPay([FromRoute] long Id)
        {
            Order order = new Order { Id = Id, OrderStatus = OrderStatus.Unpaid };
            ConcurrentDictionary<string, string> dic = new ConcurrentDictionary<string, string>();
11             dic.TryAdd("username", "测试");
12             dic.TryAdd("age","11");
13             _publisher.Publish(publishName, order,dic);
            return Ok(order);
        }

消费者

        [NonAction]
        [CapSubscribe("User-Order-Pay")]
        public void OrderPay2(Order order, [FromCap] CapHeader header)
        {
            order.OrderStatus = JwtEFCore.Enums.OrderStatus.Payment;
            _logger.LogError($"订单状态{order.OrderStatus}");
            _logger.LogError($"用户名称={header["username"]},年龄={header["age"]} ");
        }

 

测试

 

https://localhost:6001/cap/index.html