VMware vSphere服务器虚拟化实验二 准备SQL数据库环境
VMware vSphere 服务器虚拟化实验二 准备 SQL 数据库环境 在 VMware vSpherede 虚拟化环境中，我们可以直接使用 vSphere Client 直接去管理 ESXi 主机，但是需要连接每一台管理十分麻烦，而且 vSphere Client 只能实现简单的功能但是如统一管理、 DRS 、 vMo
VMware vSphere服务器虚拟化实验二 准备SQL数据库环境
在VMware vSpherede虚拟化环境中，我们可以直接使用vSphere Client直接去管理ESXi主机，但是需要连接每一台管理十分麻烦，而且vSphere Client只能实现简单的功能但是如统一管理、DRS、vMotion、HA、FT、分布式交换机、Update Manager等功能就无能为力了，因此VMware提出了VCenter和Update Manager管理工具，但是这些管理环境都需要数据库的支持，数据库软件可以是：IBM DB2、Oracle、Microsoft SQL Server；其实在vSpherevCenter安装光盘中包含了一个Microsoft SQL Server Express版本，但是这个版本的数据库最多支持5个主机和50个虚拟机，这样限制了生产环境的扩展，因此需要另行安装数据库版本，注意每个vCenter的实例无法共享同一个数据库，各自必须具有自身的数据库，多个vCenter Server的数据库可以驻留在同一个数据库服务器上或者多个数据库服务器上。下面就要开始准备自己的数据库环境为后续的管理工具环境做准备
说明：
此次实验基于实验一，数据库软件使用Microsoft SQL Server 2008 x64
1准备一台Windows Server 2012的虚拟机名为vSphereDB,然后加入域kkfloat.com，关闭防火墙功能
2在vSphereDB服务器上安装.Net Framework 3.5功能，然后插入Microsoft SQL Server 2008 x64的安装光盘进行安装，注意在SQL Server 2008 安装配置时必须把SQL Server的所有服务设置成自动运行且运行账号为域管理员，SQL Server身份验证配置成混合模式，然后启用SQL Server的远程数据库访问功能。
3 在vSphereDB服务器上打开数据库管理工具，创建vCenter工具的数据库名为vCenterDB，创建Update Manager工具的数据库名为vUpdateDB
4在vSphereDB服务器上创建Single Sign On数据库，创建这个数据库有点不一样，需要使用vCenter安装光盘下的SQL脚本先创建数据库空间，然后创建授权用户访问数据库（脚本路径：x:\Sigle Sign On\DBScripts\SSOServer\schema\mssql）,两个脚本分别是rsaIMSLiteMSSQLSetupTablespaces.sql用于创建数据库空间,rsaIMSLiteMSSQLSetupUsers.sql用于创建数据库授权用户,注意运行脚本时要自定义修改的地方包括数据库路径和数据库用户的密码
以上步骤完成，vSphere的数据库环境已经准备好
视频分享：http://pan.baidu.com/share/link?shareid=781165&uk=1025659618
Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AMMastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.
Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AMChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic
MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AMBest practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.
MySQL: How to Add a User RemotelyMay 12, 2025 am 12:10 AMToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori
The Ultimate Guide to MySQL String Data Types: Efficient Data StorageMay 12, 2025 am 12:05 AMTostorestringsefficientlyinMySQL,choosetherightdatatypebasedonyourneeds:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseTEXTforlong-formtextcontent.4)UseBLOBforbinarydatalikeimages.Considerstorageov
MySQL BLOB vs. TEXT: Choosing the Right Data Type for Large ObjectsMay 11, 2025 am 12:13 AMWhen selecting MySQL's BLOB and TEXT data types, BLOB is suitable for storing binary data, and TEXT is suitable for storing text data. 1) BLOB is suitable for binary data such as pictures and audio, 2) TEXT is suitable for text data such as articles and comments. When choosing, data properties and performance optimization must be considered.
MySQL: Should I use root user for my product?May 11, 2025 am 12:11 AMNo,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions
MySQL String Data Types Explained: Choosing the Right Type for Your DataMay 11, 2025 am 12:10 AMMySQLstringdatatypesshouldbechosenbasedondatacharacteristicsandusecases:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseBINARYorVARBINARYforbinarydatalikecryptographickeys.4)UseBLOBorTEXTforlargeuns
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
SublimeText3 English version
Recommended: Win version, supports code prompts!
Zend Studio 13.0.1
Powerful PHP integrated development environment
SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.
MantisBT
Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.
VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft
