百度智能云

All Product Document

          Relational Database Service

          FAQs About Configuration

          Does the RDS for MySQL database set a limit on data volume?

          The RDS sets a limit on the data volume of MySQL instance for every package. The minimum package supports disk data space of 5G, and the maximum package supports disk data space of 3000GB. Disk package of above 1000GB may be created only in Guangzhou Region for now.

          How does the cloud database RDS for MySQL set a limit on the number of connections to the database?

          The upper limit for the number of connections to the database is the RDS for MySQL's system variable "max_connections". If the number of connections to "cloud database" instance exceeds "max_connections", you are unable to establish a new connection. the RDS's "max_connections" value by default varies for different memory configurations. For details, see the "Purchase" page or refer to the table below. If the current maximum number of connections does not meet your needs, recommend you to upgrade the package.

          Memory Maximum linking number
          256 M 64
          512 M 128
          1024 M 256
          2048 M 512
          4096 M 1000
          8 G 2000
          16 G 4000
          24 G 6000
          32 G 8000
          48 G 10000

          What is the RDS for Mysql's datasheet storage engine by default? Can it be modified as another storage engine by default?

          Presently, the RDS for Mysql's datasheet storage engine by default is InnoDB. You may modify the storage engine by default by altering the "default_storage_engine" value on the "Parameter Configuration" page, and InnoDB and MyISAM are supported. Table damage might occur due to MyISAM's inborn defects, so recommend the user to adopt an InnoDB storage engine by default.

          How to calculate the used disk space?

          Used disk space of the RDS for MySQL instance refers to the size of the "var" folder under MySQL path, which comprises shared table space, binlog, and data volume.

          What statuses does the RDS instance comprise? What actions can the users perform in each status?

          Status Value Description Actions Available
          Creating. Waiting creation of instance No
          Running In normal running All actions
          Restarting During restarting of instance Renew
          In configuration change Package upgrading or downgrading No
          Backing up Automated backup or manual backup Renew
          Modify domain name Modifying domain name All actions
          Recovering Recovering as per backup data Renew
          Deleting. Recovery of resources at expiration No
          Synchronizing data Master instance status when creating read-only instance No
          Master instance upgrading Read-only instance status No
          Disk locked Available space, full Account, not available for write-in, only available for data reading
          Expired In arrears Continue the use after renewal

          Can the RDS be further accessed if its disk space reaches the upper limit?

          If its disk space reaches the upper limit, the RDS may be further accessed, but it is not available for data write-in. You need to delete the disk data or upgrade your package.

          Can you create the account without limits? What is the upper limit of the account number?

          You are unable to create accounts without limits, and you can create up to 20 accounts.

          Can you create the database without limits? How many databases can you create for one MySQL instance?

          You cannot create a database without limits, but you can create up to 100 databases for one MySQL instance.

          Can each database be managed with different accounts?

          Yes. You need to authorize different accounts on the "Account Management" page of the database. For details, see Manage Database Account.

          How long is the backup data saved?

          The RDS presents you with backup storage space (100%*local disk space) free of charge. By default, only complimentary space is used for saving the database's automated backup files. If complimentary space is exceeded, the system automatically deletes old backups, without generating any backup storage fees. The users may set time length for the backup storage manually. For example, storage fees are generated for the excess part beyond the complimentary space. For storage billing, see Backup Storage Space Billing .

          Does the data backup influence online access?

          Data is backed up on the slave, exerting no influence on database access. During the backing-up, you are unable to execute other actions on the console until the backing-up is complete.

          Do "binlog" data take up the disk space? How many days are they saved by default?

          "binlog" data occupy the disk space. However, they do not take up the disk space the user purchases. "binlog" data are saved locally for 7 days by default, and their deletion is contingent upon the disk space usage. "binlog" of 7 days in full are reserved in shared storage.

          How many IPs does the whitelist support?

          IP whitelist supports up to 15 IPs.

          How to upgrade cloud database RDS?

          • If the users need to upgrade MySQL version, they may complete instance version upgrading via the following steps: first, create the instance of a new version, migrate original instance data into the new instance, and switch the request to the new instance. You may realize the migration from the original instance to a new instance by use of an online migration tool. For details, see Data Migration in Operations Guide.
          • The RDS support supports change configurations (including memory and storage disk) of purchased instance. For details, see Configuration Change in Operations Guide.

          How to connect to the database?

          There are two ways for connecting to the database, namely, Intranet (a private network) and cloud network, of which,

          • Connection via Intranet: access via the RDS domain name.
          • Connection via cloud network: Enable access to the cloud network.

          Can the users connect to the instance using Intranet IP?

          Recommend you to connect to the instance using Intranet IP. The reasons are as follows:

          • As to master instance, if the master instance fault occurs, the master-backup switch automatically begins at the backend, during which the Intranet IP might change. In case of direct connection to the RDS master instance using Intranet IP and failure in updating IP after switching, it might bring about the outcome that the data cannot be read or written.
          • As to read-only instance, its Intranet IP changes after recovery from failure. Direct connection to the read-only instance via Intranet IP and failure in updating IP after recovery causes the impossibility to read the data.

          Does the RDS support direct connection to JDBC?

          Yes, but you need to enable access to the cloud network. After enabling the cloud network, you may directly access JDBC using the database name.

          Can external servers access the RDS?

          Yes, but you need to enable the RDS "cloud network Access" feature. Some traffic fees are charged for enabling this feature, but the cloud network traffic is free of charge for now. See Product Pricing.

          How does the BCC access the RDS via the Intranet?

          Under the same account, the user can directly access cloud database RDS on BBC by use of the RDS domain name.

          How to access the database via tool or code?

          For detailed connection to the database, see Connect to the RDS Instance. In case of access via cloud network, you need to enable the "cloud network Access" privilege on the "Detailed Information" page of the RDS instance.

          How is MySQL imported into the SQL file of greater than 8192KB?

          After MySQL newly creates database instance, the users may import the data via the database management tool "phpMyAdmin", but the imported file's maximum size is 8192KB.

          If the file size exceeds 8192KB, you can realize the remote connection and login after the cloud network access is enabled. In case of connection via MySQL's client tools like "sqlyog", the address is Baidu AI cloud database RD's domain name or IP address, the port is 3306, and the user name and password are account set in "Account Management". After remote connection succeeds, you may import the SQL file greater than 8192.

          Does the RDS require users to complete sharding action or read/write splitting on their own?

          • The RDS requires users to complete the sharding actions on their own.
          • Presently, the RDS realizes read/write splitting via proxy instance and read-only instance.

          How to check if cloud database RDS's read/write splitting succeeds?

          Make judgment by viewing the content in "binlog". After read/write splitting succeeds, master log data should be "Write-in", and read database's log content should be "Read". If the log contents are correct, it means the configuration is successful.

          Can multiple cloud servers use the identical the RDS database?

          Yes.

          What is the RDS instance's monitoring port? 3306 by default?

          Yes. You can see the RDS instance's port number on the "Details" Page of the instance.

          Can the RDS port 3306 by default be changed into other port?

          Yes. You can change it to another port at the backend, but such action is not recommended. The RDS port relevant to the monitoring is 3306. If it is changed, the system is unable to display the monitoring information. Thus, no change to the port is strongly recommended.

          Support root account?

          MySQL common account does not support "root" account, but "super" account supports it.

          • You may create the "root" account on the console via "Create super account" command.
          • The users may execute the following actions via "super" account, such as executing SQL command, creating DB, managing account, and killing database, etc. To create "root" account, the users can execute the following SQL command `CREATE USER 'root' @ '%' IDENTIFIED BY 'XXXXXX" via "super" account.

          For actions relevant to the "super" account, see Create High-privilege Account.

          Does the RDS instance take effect after enabling the cloud network access?

          • If cloud network access for the RDS is enabled for the first time, the cloud network IP address is allocated to the RDS instance. However, it takes about 10 minutes to update DNS information. Before refreshing of DNS information, the users are unable to get cloud network IP address via commands like "nslookup". Thus you are unable to access this the RDS from cloud network.
          • If you ever enabled and then disabled cloud network access before, this cloud network address is saved on DNS. At this moment, the "nslookup" command can parse the domain name into the previous cloud network address, but it's impossible to ping the address successfully. Then, if you enable the cloud network access privilege on the "Details" page of the RDS instance anew, this address takes effect very soon, without the need of waiting for 10 minutes.

          How to set blacklist/whitelist for the RDS database?

          In RDS, there is "Whitelist Settings", and you can set the whitelist in "Management Console RDS Instance->Security->Whitelist", which has the same roles as the security group. For details, see Whitelist Management.

          How to apply for an RDS refund?

          You may apply for an unconditional refund within 7 days via "Financial Center -Unsubscription Management". Before unsubscribing from RDS products, make sure that you have backed up the data for the data that cannot be recovered once the unsubscription succeeds. For details, see Unsubscription Rule

          How to upgrade configurations for RDS?

          RDS supports configuration upgrading. For details, see Configuration Change .

          How to downgrade configurations for RDS?

          The standalone basic version of RDS does not support configuration change, and the dual high-availability RDS only supports downgrading of the memory. Therefore, you can adjust the memory as needed. The postpaid instance supports memory downgrading, but the prepaid instance does not support this action for now. The proxy instance does not support configuration downgrading for now. You need to downgrade the configuration for the read-only instance separately. For details, see Configuration Change .

          How to set "Multiple back-ups one day" for the RDS database's automated backup?

          Automated backup on the RDS console belongs to a full backup, and the RDS does not support "multiple full back-ups every day". But, the RDS performs one incremental back-up every five minutes at present. If you need to recover data, you may recover the data to designated time point via Clone Instance feature.

          For details about the Automated Backup feature, see Set Automated Backup.

          Previous
          FAQs About Billing
          Next
          FAQs About SQL-Development