Overview
This is a repackaged open source software product wherein additional charges apply for support by TechLatest.net.
Important: For step by step guide on how to setup this vm , please refer to our Getting Started guide
This virtual machine is pre-configured with TiDB, a distributed SQL database designed for Hybrid Transactional and Analytical Processing (HTAP). TiDB combines the reliability of traditional relational databases with the flexibility to scale both horizontally as well as vertically, allowing your system to grow effortlessly as data increases. It is perfect for modern applications that require both transactional processing and real-time analytics.
Key TiDB Features:
-
MySQL Compatibility: Easily migrate from MySQL with minimal changes, as TiDB supports MySQL syntax and protocols.
-
Distributed Architecture: Ensures high availability and fault tolerance by automatically replicating data across multiple nodes.
-
HTAP Capabilities: Handle both transactional (OLTP) and analytical (OLAP) workloads in a single system, eliminating the need for separate databases.
-
ACID Compliance: Guarantees strong consistency for all transactions across distributed systems.
-
Horizontal Scalability: Add more servers to your system without downtime, ensuring smooth growth as your data needs expand.
-
Vertical Scalability: You can vertically scale by upgrading server hardware, adding more CPU cores, or increasing RAM to existing VM.
-
Real-Time Analytics: Perform complex queries on live data, enabling immediate insights and data-driven decisions.
Use Cases:
-
E-Commerce and Finance: Manage large volumes of customer transactions while simultaneously running analytics to enhance decision-making.
-
IoT and Real-Time Data: Efficiently process data streams from IoT devices, while performing real-time analysis.
-
Gaming and Media: Support millions of users and analyze data on user behavior without performance bottlenecks.
Advanced Monitoring with Grafana and Prometheus:
This virtual machine also includes Grafana and Prometheus, open-source tools for visualizing and monitoring your TiDB environment. Grafana provides detailed dashboards to track key metrics, while Prometheus collects real-time performance data, allowing you to monitor the health and efficiency of your TiDB setup. Together, they offer end-to-end visibility, helping you quickly identify and address potential issues to ensure high availability and performance.
Disclaimer: Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and/or names or their products and are the property of their respective owners. We disclaim proprietary interest in the marks and names of others.
Highlights
- TiDB: MySQL compatible unified platform for DB Transactions and Real-Time Analytics
Details
Typical total price
$0.223/hour
Features and programs
Financing for AWS Marketplace purchases
Pricing
- ...
Instance type | Product cost/hour | EC2 cost/hour | Total/hour |
---|---|---|---|
t2.medium | $0.13 | $0.046 | $0.176 |
t2.large Recommended | $0.13 | $0.093 | $0.223 |
t2.xlarge | $0.13 | $0.186 | $0.316 |
t2.2xlarge | $0.13 | $0.371 | $0.501 |
t3.medium | $0.13 | $0.042 | $0.172 |
t3.large | $0.13 | $0.083 | $0.213 |
t3.xlarge | $0.13 | $0.166 | $0.296 |
t3.2xlarge | $0.13 | $0.333 | $0.463 |
t3a.medium | $0.13 | $0.038 | $0.168 |
t3a.large | $0.13 | $0.075 | $0.205 |
Additional AWS infrastructure costs
Type | Cost |
---|---|
EBS General Purpose SSD (gp2) volumes | $0.10/per GB/month of provisioned storage |
Vendor refund policy
Will be charged for usage, can be canceled anytime and usage fee is non refundable.
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
first release
Additional details
Usage instructions
-
On the EC2 Console page, instance is up and running. To connect to this instance through putty, copy the IPv4 Public IP Address. (refer Putty Guide available at https://docs.thinkwithwp.com/AWSEC2/latest/UserGuide/putty.html for details on how to connect using putty/ssh).
-
Open putty, paste the IP address and browse your private key you downloaded while deploying the VM, by going to SSH- >Auth->Credentials , click on Open.
-
Login as ec2-user .
-
Update the password of ec2-user using below command : sudo passwd ec2-user
-
Once ec2-user password is set, access the GUI environment using RDP on Windows machine or Remminal on Linux machine. Copy paste the Public IP of the VM and paste it in the RDP. Login with ec2-user and its password.
-
Once you are connected to GUI environment of this VM, access the TiDB by opening the Firefox Browser from the desktop.
-
To update the password of TiDB , open terminal inside the RDP session and run below commands. mysql --host 127.0.0.1 --port 4000 -u root
-
Above command will connect to mysql. update the password using ALTER USER 'root'@'%' IDENTIFIED BY 'new_password';
-
Flush the privileges to start with new password.
FLUSH PRIVILEGES; EXIT; -
Now reconnect to DB using below command. It will prompt for the new password and set test as the DB to use.
mysql --host 127.0.0.1 --port 4000 -u root -p -e "use test;"
-
Now use the same password when logging in to TiDB Dashboard available at http://127.0.0.1:2379/dashboard using root userid.
Please visit Getting Started Guide for step by step guide on how to provision and use this VM
Resources
Vendor resources
Support
Vendor support
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.