dongxu c4pt0r

## main.go
package main

import (
	"bufio"
	"bytes"
	"compress/gzip"
	"encoding/base64"
	"encoding/csv"
	"flag"
	"fmt"

## vortex.go
package main

import (
	"fmt"
	"math"
	"math/rand"
	"os"
	"os/exec"
	"strconv"
	"strings"

## poll.py
#!/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')

## bigetc.go
package bigetc

import (
	"database/sql"
	"time"

	"github.com/c4pt0r/log"
	_ "github.com/go-sql-driver/mysql"
)

## jq.go
package main

import (
	"database/sql"
	"fmt"
	"log"
	"math/rand"
	"time"

	"github.com/fatih/color"

## gist:43950c1c34127d57c7c1cd0435e8801f

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                c4pt0r
                / gist:43950c1c34127d57c7c1cd0435e8801f
            
            
              Last active
              June 8, 2022 19:56
            
          
    Install TiUP

$ curl --proto '=https' --tlsv1.2 -sSf https://tiup-mirrors.pingcap.com/install.sh | sh

Start a TiDB Cluster

$ tiup playground


## How
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 \

## zhihu.py
#!/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()

## index.html
<!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>

## result
	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
	package main

	import (
	"bufio"
	"bytes"
	"compress/gzip"
	"encoding/base64"
	"encoding/csv"
	"flag"
	"fmt"
	#!/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')
	package bigetc

	import (
	"database/sql"
	"time"

	"github.com/c4pt0r/log"
	_ "github.com/go-sql-driver/mysql"
	)
	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 \
	#!/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()
	<!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>
	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