迅睿CMS: 灾备数据库/主从数据库_迅睿教程_站长学院

迅睿CMS: 灾备数据库/主从数据库

迅睿教程 2024-10-09 15:18:30 0次 0 来源：天荣CMS 收藏

当主数据库由于某些原因无法连接时，你可以配置多个灾备数据库。

例如可以像下面这样为一个连接配置灾备数据库:

config/database.php

<?php

/**
 * 数据库配置文件
 */

$db['default'] = [
    'hostname' => '127.0.0.1',
    'username' => 'demo8',
    'password' => 'demo8',
    'database' => 'demo8',
    'DBPrefix' => 'dr_',
];

// 备用库
$db['failover'] = [
    [
        'hostname' => '127.0.0.122',
        'username' => 'demo8',
        'password' => 'demo8',
        'database' => 'demo8',
    ],
    [
        'hostname' => '127.0.0.133',
        'username' => 'demo8',
        'password' => 'demo8',
        'database' => 'demo8',
    ]
];
										
<hr/>
<div class="text-muted laok-v49leku">
											免责声明：1.凡本站注明“来源：XXX（非天荣模板网）”的作品，均转载自其它媒体，所载的文章、图片、音频视频文件等资料的版权归版权所有人所有，如有侵权，请联系tianrongcms#foxmail.com处理；2.凡本站转载内容仅代表作者本人观点，与天荣模板网无关。凡本站转载内容仅代表作者本人观点，与本站无关。
										</div>
</div>										
										<hr>
										<div class="text-muted">
											凡本站转载内容仅代表作者本人观点，与本站无关。
										</div>
									</div>
								</div>

<div class="portlet">
									<div class="prev">
										<p>上一篇：
																						<a href="/xueyuan-xunrui/4271.html">迅睿CMS: OEM版本恢复到原版</a>
																					</p>
										<p class="margin-0">下一篇：
																						<a href="/xueyuan-xunrui/4273.html">迅睿CMS: 设置网站主目录public</a>
																					</p>
									</div>
								</div>

<div class="portlet">
									<div class="portlet-title">
										<div class="pull-right"><span class="text-red">0</span> 条评论</div>
										<h3>网友留言</h3>
									</div>
									<div class="news-comments-body">
										<div id="dr_module_comment_4272"></div><script type="text/javascript"> function dr_ajax_module_comment_4272(type, page) { var index = layer.load(2, { time: 10000 });$.ajax({type: "GET", url: "/index.php?s=news&c=comment&m=index&id=4272&&type="+type+"&page="+page+"&"+Math.random(), dataType:"jsonp", success: function (data) { layer.close(index); if (data.code) { $("#dr_module_comment_4272").html(data.msg); } else { dr_tips(0, data.msg); } }, error: function(HttpRequest, ajaxOptions, thrownError) { layer.closeAll(); var msg = HttpRequest.responseText;  alert("评论调用函数返回错误："+msg);  } }); } dr_ajax_module_comment_4272(0, 1); </script>									</div>
								</div>
							</div>
							<div class="col-md-3">
	<div class="main-right">
		<div class="side-box-dw"></div>
		<div class="side-fixed-box">
			<div class="side-fixed-con">
				<div class="portlet hidden-xs" style="padding-bottom: 10px;">
					<ul class="portlet-slide-tab margin-0 ">
						<li class="col-md-6 active"><a href="https://www.tianrongcms.net/xueyuan-xunrui/">全部</a></li>
												<li class="col-md-6 active">
							<a href="/xueyuan-xunrui/" title="迅睿教程">迅睿教程</a>
						</li>
												<li class="col-md-6">
							<a href="/xueyuan-thinkphp/" title="ThinkPHP">ThinkPHP</a>
						</li>
											</ul>
				</div>
				<div class="portlet">
					<div class="portlet-title">
						<h3>搜索主题</h3>
					</div>
					<div class="portlet-body">
						<div class="side-search">
							<form method="get" action="/index.php" target="_blank">
								<input type="hidden" name="s" value="api">
								<input type="hidden" name="c" value="api">
								<input type="hidden" name="m" value="search">
								<input type="hidden" name="dir" value="xiazai" >
								<input type="text" placeholder="输入关键字搜索" name="keyword" value='' id="dr_search_keyword" class="form-control">
								<button class="submit" type="submit">
									<i class="fa fa-search"></i> 
								</button>
							</form>
						</div>
					</div>
				</div>
				<div class="portlet">
					<div class="portlet-title">
						<a class="pull-right" href="https://www.tianrongcms.net/xueyuan-xunrui/">更多</a>
						<h3>人气文章</h3>
					</div>
					<div class="portlet-body">
						<ul class="side-text-list">
														<li class="text-overflow">
								<a title="迅睿cms模板安装教程" href="/xueyuan/2.html" class="title">
									<span class="spot text no"></span>迅睿cms模板安装教程</a>
							</li>
														<li class="text-overflow">
								<a title="迅睿CMS程序安装教程" href="/xueyuan-xunrui/4893.html" class="title">
									<span class="spot text no"></span>迅睿CMS程序安装教程</a>
							</li>
														<li class="text-overflow">
								<a title="重装迅睿CMS程序" href="/xueyuan-xunrui/4892.html" class="title">
									<span class="spot text no"></span>重装迅睿CMS程序</a>
							</li>
														<li class="text-overflow">
								<a title="迅睿CMS安装二级目录" href="/xueyuan-xunrui/4891.html" class="title">
									<span class="spot text no"></span>迅睿CMS安装二级目录</a>
							</li>
														<li class="text-overflow">
								<a title="迅睿CMS: 自定义栏目seo函数" href="/xueyuan-xunrui/4550.html" class="title">
									<span class="spot text no"></span>迅睿CMS: 自定义栏目seo函数</a>
							</li>
														<li class="text-overflow">
								<a title="迅睿CMS: 二次开发须知（必读）" href="/xueyuan-xunrui/4549.html" class="title">
									<span class="spot text no"></span>迅睿CMS: 二次开发须知（必读）</a>
							</li>
														<li class="text-overflow">
								<a title="迅睿CMS: 自定义内容seo函数" href="/xueyuan-xunrui/4548.html" class="title">
									<span class="spot text no"></span>迅睿CMS: 自定义内容seo函数</a>
							</li>
														<li class="text-overflow">
								<a title="迅睿CMS: 模块内容搜索SEO" href="/xueyuan-xunrui/4547.html" class="title">
									<span class="spot text no"></span>迅睿CMS: 模块内容搜索SEO</a>
							</li>
														<li class="text-overflow">
								<a title="迅睿CMS: 共享模块栏目SEO" href="/xueyuan-xunrui/4546.html" class="title">
									<span class="spot text no"></span>迅睿CMS: 共享模块栏目SEO</a>
							</li>
														<li class="text-overflow">
								<a title="迅睿CMS: 独立模块SEO" href="/xueyuan-xunrui/4545.html" class="title">
									<span class="spot text no"></span>迅睿CMS: 独立模块SEO</a>
							</li>
													</ul>
					</div>
				</div>
				<div class="portlet border hidden-sm hidden-xs">
					<div class="portlet-title">
						<h3>关注我们</h3>
					</div>
					<div class="portlet-body text-center">
						<p class="margin-0"><img class="img-responsive" src="/static/demo9/web/images/personal-wx.jpg"></p>
						<p><span class="text-muted">扫描二维码关注我们</span></p>
					</div>
				</div>
			</div>
		</div>
	</div>
</div>						</div>
						<div class="main-box-dw"></div>
					</div>
				</div>
			</div>
		</div>
		<div class="footer hidden-sm hidden-xs" id="footer">
	<div class="container">
		<div class="row">
			<ul class="item clearfix">
				<li class="col-md-6 left">
					<h2 style="margin-top: 0;margin-bottom: 30px;" class="footer-logo">
						<img src="https://www.tianrongcms.net/uploadfile/202511/490f38b25dc1822.png" title="天荣CMS" alt="天荣CMS">
					</h2>
					<p class="desc hidden-xs" style="margin-bottom: 20px;">
						高端网页主题模板产品提供商，覆盖各大开源系统主题，一站式在线选购高品质主题模板，助力您的网站从芸芸同行业的网站中脱颖而出。
					</p>
					<p class="copy margin-0">
						Copyright © 2026 © 天荣CMS ✪ 版权所有 
						<a target="_blank" href="http://beian.miit.gov.cn"> 粤ICP备2021056357号</a>
						<a target="_blank" href="https://www.demo9.com/sitemap.xml">sitemap地图</a>
						<a target="_blank" href="https://www.demo9.com/sitemap.txt">站点txt</a>
						<a target="_blank" href="https://www.demo9.com/tag.txt">TAGtxt</a>
					</p>
				</li>
				<li class="col-md-2 text-center">
					<h4>关于我们</h4>
					<p>
						<a href="/guanggao">天荣CMS</a>
					</p>
					<p>
						<a href="/guanggao">合作</a>
					</p>
					<p>
						<a href="/guanggao">留言反馈</a>
					</p>
					<p>
						<a href="/guanggao">举报投诉</a>
					</p>
				</li>
				<li class="col-md-2 text-center">
					<h4>常见问题</h4>
					<p>
						<a href="javascript:;"
							onclick="dr_html_show('常见问题','<div class=\'p20\'>本站已经开发注册，您需要填写用户名和正确的常用邮箱即可，邮箱需要通过验证后才可以正常使用相关功能。</div>','300px','300px')">如何注册</a>
					</p>
					<p>
						<a href="javascript:;"
							onclick="dr_html_show('常见问题','<div class=\'p20\'>找到对应商品后点击页面的“立即购买”按钮下单即可，本站商品支持自助下单，无需联系客服干预操作</div>','300px','300px')">怎么购买</a>
					</p>
					<p>
						<a href="javascript:;"
							onclick="dr_html_show('常见问题','<div class=\'p20\'>目前我们支持两种方式<br>1.在线支付，仅支持支付宝在线支付实时交易，完全自助完成交易流程<br>2.转账充值，支持任意付款方式，需要客服给您充值到余额在进行交易</div>','300px','300px')">支付方式</a>
					</p>
					<p>
						<a href="javascript:;"
							onclick="dr_html_show('常见问题','<div class=\'p20\'>虚拟商品购买后可返回至商品详情页获得对应的素材或下载文件<br>实物商品将以快递、物流等方式寄送到您的手中</div>','300px','300px')">发货方式</a>
					</p>
				</li>
				<li class="col-md-2 text-right">
					<h4>扫一扫手机访问</h4>
					<p><img src="/static/demo9/web/images/site.png" alt="天荣CMS" width="120"></p>
				</li>
			</ul>

</div>
	</div>
</div>

<div class="disclaimer" style="background:#202935;border-top:1px solid #333;padding:14px 0;font-size:12px;color:#999;line-height:1.9;text-align:center;">
	<div class="container">
		免责声明：1.凡本站注明"来源：XXX（非本站）"的作品，均转载自其它媒体，所载的文章、图片、音频视频文件等资料的版权归版权所有人所有，如有来源标注错误或侵犯了您的合法权益，请联系本站处理；2.本站部分内容转载自老K模板网（www.laokcms.com），转载内容仅代表作者本人观点，与本站无关。
	</div>
</div>

<div class="footer visible-sm visible-xs" style="padding: 20px;">
	<p class="margin-0 text-center">
		Copyright © 2026 © 天荣CMS ✪ 版权所有 <a target="_blank" href="http://beian.miit.gov.cn"> 粤ICP备2021056357号</a>
	</p>
</div>

<div class="" id="kefu" style="text-align: center; display: none;">
	<p><img src="/static/demo9/web/images/icon_kefu.png"></p>
	<p>在线时间09:00-24:00</p>
	<p>
		<a target="_blank" class="btn btn-qq" href="/guanggao">
			<i class="fa fa-qq"></i> 50183970
		</a>
	</p>
	<p>
		<a class="btn btn-wx" href="javascript:;" onclick="dr_img_show('关注我们','/static/demo9/web/images/personal-wx.jpg','微信扫一扫关注我们')">
			<i class="fa fa-weixin"></i> 18922311568
		</a>
	</p>
</div><div class="login_pop" id="login_box" style="display: none;">
	<span class="close_login"><i class="bi bi-x-circle"></i></span>
	<div class="l col-lg-5 col-md-5 hidden-sm hidden-xs">
		<ul>
			<li>一次支付终身使用</li>
			<li>响应式布局，适配所有设备</li>
			<li>代码干净简洁，体验好</li>
			<li>高端视觉设计助力您的发展</li>
			<li>在线工单，完美售后</li>
		</ul>
	</div>
	<div class="r col-lg-7 col-md-7 col-sm-12 col-xs-12">

<div class="r_block account" style="display: block;">
			<div class="title">
				<p>账号密码登录</p>
			</div>
			<form id="myforml" method="post" novalidate="novalidate">
				<div class="input_box">
					<input type="text" placeholder="账号/邮箱/手机" name="data[username]" class="layui-input">
				</div>
				<div class="input_box">
					<input type="password" autocomplete="off" placeholder="登录密码" name="data[password]"
						class="layui-input">
				</div>
				<div class="input_box">
					<input type="text" name="code" placeholder="请输入图片验证码" class="layui-input img_code">
					<div id="verificationCode" class="verificationCode">
						<img align="absmiddle" style="cursor:pointer;" onclick="this.src='/index.php?s=api&c=api&m=captcha&width=120&height=35&t='+Math.random();" src="/index.php?s=api&c=api&m=captcha&width=120&height=35" />					</div>
				</div>
				<div class="login_links">
					<span class="switch_click">
						<a href="/find.html">忘记密码？</a></span>
					<span class="switch_click" onclick="dr_show_box('register','account')">新用户注册</span>
				</div>
			</form>
			<div class="input_box">
				<div class="layui-btn layui-btn-fluid login_accunt_btn"
					onclick="dr_ajax_member('https://www.tianrongcms.net/index.php?s=member&c=login&m=index', 'myforml');">
					登录</div>
			</div>
			<p style="margin-top: 10px;">
				登录即视为同意<a href="javascript:dr_show_protocol();">《用户注册协议》</a>
			</p>
			<div class="login_type">
				<span>其他用户登录方式</span>
				<ul>
					<li>
						<a href="https://www.tianrongcms.net/index.php?s=api&c=oauth&m=index&name=qq&type=login&back=https%3A%2F%2Ftianrongcms.net%2Fxueyuan-xunrui%2F4272.html"class="switch_click"> 
							<img src="/static/demo9/web/images/qq.png"> 
						</a>
					</li>
				</ul>
			</div>
		</div>

<div class="input_box">
					<input type="text" name="code" placeholder="请输入图片验证码" class="layui-input img_code">
					<div id="verificationCode" class="verificationCode">
						<img align="absmiddle" style="cursor:pointer;" onclick="this.src='/index.php?s=api&c=api&m=captcha&width=120&height=35&t='+Math.random();" src="/index.php?s=api&c=api&m=captcha&width=120&height=35" />					</div>
				</div>
				<div class="input_box">
					<button type="button" class="layui-btn layui-btn-fluid login_password_btn"
						onclick="dr_ajax_member('https://www.tianrongcms.net/index.php?s=member&c=register&m=index', 'regform');">立即注册</button>
				</div>
				<p style="margin-top: 10px;">
					<label class="mt-checkbox mt-checkbox-outline" style="margin-left:20px;">
						<input type="checkbox" name="is_protocol" value="1" checked=""> 我已阅读并同意
						<span></span>
					</label>
					<label>
						<a href="javascript:dr_show_protocol();">《用户注册协议》</a>
					</label>
				</p>
			</form>
		</div>

</div>
</div>
<div class="mask-body mask-body-dark" style="display: none;"></div><script src="/static/assets/global/plugins/jquery.min.js" type="text/javascript"></script>
<script src="/static/demo9/web/js/lazysizes-umd.min.js" type="text/javascript"></script>
<script src="/static/assets/js/cms.js" type="text/javascript"></script>
<script src="/static/assets/global/plugins/bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
<script src="/static/demo9/web/js/home.js" type="text/javascript"></script>
<script src="/static/demo9/web/js/clipboard.min.js" type="text/javascript"></script>
<script src="/static/demo9/web/js/jquery.cookie.min.js" type="text/javascript"></script>
<script src="/static/demo9/web/js/viewer.min.js" type="text/javascript"></script>
<script src="/static/demo9/web/js/theme.js" type="text/javascript"></script>
<script src="/static/demo9/web/js/jquery.waypoints.min.js" type="text/javascript"></script>
<script>
    $(function(){
        var dat = [
                'https://ucenter.cdn.bcebos.com/homepage/gom/background/jtlpuneq1s5wmv329933.png',
                'https://ucenter.cdn.bcebos.com/homepage/gom/background/fsdq60t3gh5lx29542.png',
                'https://ucenter.cdn.bcebos.com/homepage/gom/background/h86syvegl0br5qz31538.png',
                'https://ucenter.cdn.bcebos.com/homepage/gom/background/wlrm2z8a5pvcten43706.png',
                'https://ucenter.cdn.bcebos.com/homepage/gom/background/qygvkpc4nah57u820194.png',
                'https://ucenter.cdn.bcebos.com/homepage/gom/background/73wd84fgeymionp88447.png',
                'https://ucenter.cdn.bcebos.com/homepage/gom/background/srhpnwo49xemzu578922.png',
                'https://ucenter.cdn.bcebos.com/homepage/gom/background/u17drqm4nbyi8wa66429.png',
                'https://ucenter.cdn.bcebos.com/homepage/gom/background/uamtnb53o4w68zi3478.png',
                'https://ucenter.cdn.bcebos.com/homepage/gom/background/gmhfkjzb3ywra5v7692.png',
            ]
        // $('#bj').attr("style:background-image",dat[Math.trunc(Math.random()*dat.length)])
        $("#bj").css("background-image", "url('"+dat[Math.trunc(Math.random()*dat.length)]+"')");
    })
</script><link href="/static/assets/global/plugins/bootstrap-touchspin/bootstrap.touchspin.css" rel="stylesheet"
	type="text/css" />
<script src="/static/assets/global/plugins/fuelux/js/spinner.min.js" type="text/javascript"></script>
<script src="/static/assets/global/plugins/bootstrap-touchspin/bootstrap.touchspin.js" type="text/javascript">
</script>
<script type="text/javascript" src="/static/assets/js/sku.js"></script>

<script type="text/javascript">
	var is_mobile_cms = '';
</script>
<script src="/api/language/zh-cn/lang.js" type="text/javascript"></script>

<script src="/static/assets/global/plugins/bootstrap/js/bootstrap.min.js" type="text/javascript"></script>
<script src="/static/demo9/member/scripts/app.min.js" type="text/javascript"></script>
<script type="text/javascript">
	$(function () {
		order_xiazai_select_sku_price();
		order_xiazai_get_sku_price();
		$("#dr_buy_num").TouchSpin({
			step: 1,
			min: 1,
			max: 0		});
	})
	// 模块收藏
	function dr_app_favorite(id) {
		$.get("https://www.tianrongcms.net/index.php?is_ajax=1&s=api&app=news&c=module&m=favorite&id=" + id,
			function(data) {
				dr_cmf_tips(data.code, data.msg);
				if (data.code) {
					$('#module_favorite_' + id).html(data.data);
				}
			}, 'json');
	}
	// 加入购物车
	function order_xiazai_add_cart() {
		$.get("/index.php?is_ajax=1&s=order&c=cart&m=add&mid=news&num=" + $('#dr_buy_num').val() +
			"&id=4272&sku=" +
			$('#dr_sku_value').val(),
			function(data) {
				dr_cmf_tips(data.code, data.msg);
				if (data.code) {
					// 存储购物车数量
					$('#dr_order_xiazai_cart_nums').html(data.data);
				}
			}, 'json');
	}
	// 购买地址
	function order_xiazai_add_buy() {
		var url = "https://www.tianrongcms.net/index.php?s=order&c=order&m=buy&mid=news&id=4272";
		url += "&sku=" + $('#dr_sku_value').val();
		url += "&num=" + $('#dr_buy_num').val();
		window.location.href = url;
	}
	// 组合价格选择
	function order_xiazai_select_sku_price() {
		$('.fc-sku-select-price .fc-sku-value').click(function() {
			$(this).parent('.fc-sku-select-price').find('.fc-sku-value').removeClass('red');
			$(this).addClass('red');
			order_xiazai_get_sku_price();
		});
	}
	//价格
	function order_xiazai_get_sku_price() {
		var oname = new Array();
		$('.fc-sku-select-price').each(function() {
			oname.push($(this).find('.red').attr('fvalue'));
		});
		var k = oname.join("_");
		$('#dr_sku_value').val(k);
		$('#dr_sku_price').html($('#dr_sku_price_' + k).val());
		$('#dr_sku_quantity').html($('#dr_sku_quantity_' + k).val());
		$('#dr_sku_sn').html($('#dr_sku_sn_' + k).val());
	}
</script>
	</body>
</html>