腾讯云 CDB for MySQL Get Started 产品文档
版权声明 2015-2016 腾讯云版权所有 本文档著作权归腾讯云单独所有, 未经腾讯云事先书面许可, 任何主体不得以任何形式复制 修改 抄袭 传 播全部或部分本文档内容 商标声明 及其它腾讯云服务相关的商标均为腾讯云计算 ( 北京 ) 有限责任公司及其关联公司所有 本文档涉及的第三方 主体的商标, 依法由权利人所有 服务声明 本文档意在向客户介绍腾讯云全部或部分产品 服务的当时的整体概况, 部分产品 服务的内容可能有所调整 您所购买的腾讯云产品 服务的种类 服务标准等应由您与腾讯云之间的商业合同约定, 除非双方另有约定, 否则, 腾讯云对本文档内容不做任何明示或模式的承诺或保证 第 2 页共 9 页
文档目录 文档声明... 2 Purchase & Initialization... 4 Connection... 6 Manage Database... 7 第 3 页共 9 页
Purchase & Initialization 1. After purchasing a CDB on Tencent Cloud, users can enter the console, and perform necessary operations (such as name modification and initialization) on the purchased CDB instance on the console. 2. The newly purchased instance is originally in an uninitialized state, and needs to be initialized on the console. During initialization, you need to specify the character set supported for the purchased CDB, determine whether the table name is case-sensitive, and set the root account password for the CDB, as shown in the figure below: You can view the initialization and other operation tasks in the list of tasks on the console. After the CBD is initialized, CBD instance will be running, as shown in the figure below: 第 4 页共 9 页
Now, you can log in to CDB, enter the management interface, and perform such operations as capacity and memory upgrade. 第 5 页共 9 页
Connection There are two methods to connect to CDB: Public network access: You can log in to phpmyadmin through the login entry on the console with a public network account, and perform operations on the database (the public network address is disabled by default). Refer to CDB for MySQL Database Management for subsequent operations or use a connection tool from a third party; In the other method, with an automatically assigned private network address, you can access the database by using the CVM in the same availability zone. The latency is relatively low because a high-speed private network is employed in this method. 第 6 页共 9 页
Manage Database CDB for MySQL management entry enables viewing and modification of database instance details, instance monitoring, parameter configuration, account management, database operations, backup management, as well as download of database operation logs, rollback and upgrade, etc. 1. Instance details. You can view and operate on various information of databases, as shown in the figure below. The public network address is disabled by default, and you need to enable it manually. 2. Instance monitoring. You can monitor multiple key indicators running in the current database from the following six dimensions: access, load, query cache, table, Innodb and MyISAM. The monitoring data items for access include statistics for sql operations such as numbers of slow queries, full table scans, queries, updates, deletions, insertions, and overwrites, total number of requests, number of current connections and connection usage and other server service indicators. With these data, you can get an overall sense of operations currently performed on the database in real time. The monitoring data items for load include real disk capacity, total disk capacity, volume rate, and sent and received data volume. These data can reflect some indicators such as database space increase, and can be used as the basis for database upgrade. The monitoring data items for query cache include cache hit rate and cache usage. This indicator reflects the cache efficiency of database. When there is a low cache hit rate, you need to analyze the SQL operations on the service. The table monitoring contains two indicators: number of temporary tables and number of table lock waits. If there are too many temporary tables, there might be a large number of 第 7 页共 9 页
data table connection operations. In this case, the query efficiency will be severely affected, and you need to optimize the query then. InnoDB monitoring and MyISAM monitoring are used to monitor the running indicators of these two storage engines respectively, so that the administrators can better understand the running status of the actual table (the above two storage engines may be used). 3. Parameter configuration. You can configure the modifiable parameters in the database and view the modification history, as shown in the figure below: 4. Account management. You can modify the password of the default root account in the system, as shown in the figure below: 第 8 页共 9 页
Powered by TCPDF (www.tcpdf.org) Get Started 产品文档 5. Database operations. You can import sql files into a specified database, as shown in the figure below: 6. Backup management. You can download binlog and cold backup, as shown in the figure below: 7. Operation log. You can download slow query and rollback logs. 8. Upgrade and rollback. Database expansion can be done through upgrading. With cold backup and binlog, you can roll the database back to a specified time, as shown in the figure below: https://mccdn.qcloud.com/static/img/2cb7c8818e790b0b54d41143068f3d86/2cb7c8818e79.p ng 第 9 页共 9 页