$ curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh
$ tiup playground
dongxu c4pt0r
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "bufio" | |
| "bytes" | |
| "compress/gzip" | |
| "encoding/base64" | |
| "encoding/csv" | |
| "flag" | |
| "fmt" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "fmt" | |
| "math" | |
| "math/rand" | |
| "os" | |
| "os/exec" | |
| "strconv" | |
| "strings" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env python3 | |
| # Usage: | |
| # ./poll.py --host <xxx.tidbcloud.com> --port 4000 --user <username> --password <pwd> | jq --unbuffered .text | grep http | |
| import signal | |
| import time | |
| import os | |
| import argparse | |
| import MySQLdb | |
| parser = argparse.ArgumentParser(description='polls db for new rows') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package bigetc | |
| import ( | |
| "database/sql" | |
| "time" | |
| "github.com/c4pt0r/log" | |
| _ "github.com/go-sql-driver/mysql" | |
| ) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| package main | |
| import ( | |
| "database/sql" | |
| "fmt" | |
| "log" | |
| "math/rand" | |
| "time" | |
| "github.com/fatih/color" |
c4pt0r
/ gist:43950c1c34127d57c7c1cd0435e8801f
Last active
June 8, 2022 19:56
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 1. Open S3 service in AWS, create bucket and get the access point, like this: https://${bucket-name}.s3.us-west-2.amazonaws.com | |
| 2. Go to https://tidbcloud.com and register a new free TiDB instance (10G), get a MySQL endpoint, and make sure the traffic filter is properly configured to allow public access. | |
| 3. Install the juicefs client locally in Distributed Mode (https://juicefs.com/docs/community/getting-started/for_distributed) | |
| 4. initialize and mount FUSE according to the following two lines: | |
| # juicefs format --storage s3 \ | |
| --bucket https://${bucket-name}.s3.us-west-2.amazonaws.com \ | |
| --access-key ${aws-access-key} \ | |
| --secret-key ${aws-secret} \ | |
| mysql://${mysql-user}:${mysql-password}@\(your-cloud-tidb.prod.aws.tidbcloud.com:4000\)/juice \ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env python3 | |
| import time | |
| import slack | |
| import os | |
| import sqlite3 | |
| from requests_html import HTMLSession | |
| client = slack.WebClient(os.environ.get('SLACK_BOT_TOKEN')) | |
| session = HTMLSession() |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <link href="https://cdn.bootcss.com/mini.css/3.0.1/mini-dark.min.css" rel="stylesheet"> | |
| <meta name="viewport" content="width=device-width, initial-scale=1"> | |
| <meta charset="UTF-8" /> | |
| <title>TiUP</title> | |
| </head> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| TiDB Aurora With FK Aurora Without FK | |
| Q1 15.28 144 144.13 | |
| Q2 4.09 4.18 4.21 | |
| Q3 4.93 20.59 34.18 | |
| Q4 2.3 7.5 7.49 | |
| Q5 19.44 18.25 22.43 | |
| Q6 5.96 21.74 21.94 | |
| Q7 8.42 12.06 81.83 | |
| Q8 3.49 41.7 53.99 | |
| Q9 34.71 33.7 442.26 |
NewerOlder