morgo

6 ms·

1.
Spirit (MySQL Online Schema Change)(code.cash.app)
12 points by morgo 3y ago|0 comments
2.
by morgo 5y ago
I work remotely and I've decided that ON is the right choice for me. I made this choice when I started joining a lot of calls where they had to be in English because of me. I figured camera on was a good way to show I was paying attent
3.
by morgo 5y ago
You are correct, it is a disk-format issue, and MySQL officially supports in-place upgrade between versions. It's actually quite hard to fix bugs in charset/collations, because any changes to the sort order implicitly could affe
4.
by morgo 6y ago
I really like the workflow GitHub uses for this: https://github.blog/2020-02-14-automating-mysql-schema-migra... (It makes use of skeema, which allows you to track your schema in a declarative way vs. ALTER TABLE statements
5.
by morgo 7y ago
For MySQL there are better ways to do this: https://mysql.wisborg.dk/2018/08/10/innodb-progress-informat... The article is MariaDB specific.
6.
by morgo 7y ago
An interesting example to bring up mysql_embedded :-) I was the product manager, and we did have complaints about the size. So it was removed: https://mysqlserverteam.com/mysql-8-0-retiring-support-for-l... I don't bel
7.
by morgo 7y ago
If someone uses `utf8` in MySQL 8.0, they will get a warning suggesting they should use `utf8mb4`, because `utf8` will be deprecated. Redefining `utf8` to mean 4-byte would break the upgrade since existing tables would not be able to join a
8.
by morgo 7y ago
Hi! Former product manager for MySQL here. The defaults have changed a lot across major releases: https://mysqlserverteam.com/new-defaults-in-mysql-8-0/ https://dev.mysql.com/doc/refman/5.7&#x
9.
by morgo 8y ago
It should work fine, with one item to note: I believe SqlAlchemy defaults to READ-COMMITTED, whereas TiDB defaults to (and recommends) MySQL's default of REPEATABLE-READ.
10.
by morgo 8y ago
Morgan from the TiDB team here. I agree that column and row store have very different characteristics, but what I think is worth mentioning is that some hybrid solutions actually store as both row and columnar and have a query optimizer t
11.
by morgo 8y ago
Update: The documentation has now been updated https://github.com/pingcap/tidb/pull/9144
12.
by morgo 8y ago
Morgan from the TiDB team here. We are working on at rest encryption now - stay tuned. w.r.t. nested transactions, this is not something that MySQL currently offers (TiDB is MySQL 5.7 compatible). Sometimes this is emulatable via savepoin
13.
by morgo 8y ago
Morgan from the TiDB team here. Thank you for the feedback, and I agree with you. We actually took this line out from the same copy in the docs: https://pingcap.com/docs/ (We must have missed a spot, and I will follo
14.
by morgo 8y ago
Hi Rafuino, send me an email at [firstname]@pingcap.com and I'll connect you with the benchmark author. Just to expand a little bit on this comment: > The expected data volume for TiDB is larger than memory. There is both total data
15.
by morgo 8y ago
Yes, that is correct. I hope to see FOREIGN KEY constraints added in the future. In the interim though, when comparing TiDB to (application) sharded systems, it is important to clarify that FOREIGN KEYS will only be available locally to a s
16.
by morgo 8y ago
Yes. As a general comment: the component-based architecture lends itself well to adding additional protocols on top. The community has added a Redis protocol on top of TiKV with Titan: https://medium.com/@shafreeck/tita
17.
by morgo 8y ago
I'll pass this onto the engineering team. Thanks! For a quick answer, I believe Daniel Abadi's followup comment addresses it: > This post did not discuss a central oracle. It discusses the difference between partitioned vs glo
18.
by morgo 8y ago
At a high level: - TiDB is Open Source (Apache 2.0 license). Several others that you mention here are commercial offerings. - The expected data volume for TiDB is larger than memory. I believe MemSQL, for example, is memory-only. - The arc
19.
by morgo 8y ago
To your point: I agree that it pays to be conservative with new filesystems and databases alike. However, I want to mention mitigating circumstances which have helped TiDB stabilize: - We use RocksDB as the underlying storage library, which
20.
by morgo 8y ago
TiDB is an open source NewSQL database that speaks the MySQL protocol. You can scale it horizontally by adding nodes. It is a relational DB (not time series). To describe a couple of differentiators from its peers: - It aims to optimize bo
21.
by morgo 8y ago
Morgan from the TiDB team here. Happy to answer any questions you have.
22.
by morgo 8y ago
I can't speak to PostgreSQL, but I work on the TiDB team having previously worked on the MySQL team. Ensuring compatibility from a clean slate is hard, but to make MySQL distributed requires more than the current storage engine API pro
23.
by morgo 8y ago
The technical design for views was recently completed, and I expect to see them added soon :-) Window functions & CTEs are only very recent features in MySQL 8.0 (TiDB is 5.7 compatible). None the less, they are important for HTAP work
24.
by morgo 8y ago
Hi! I work for PingCAP, the company behind TiDB and come from previously working on MySQL. The gap of features missing is documented here: https://www.pingcap.com/docs/sql/mysql-compatibility/ I would rate c
25.
by morgo 8y ago
> the percona performance patchset that made it into MariaDB and isn't in MySQL Many Percona patches did make it into MySQL 5.7 and MySQL 8.0.
26.
by morgo 8y ago
Former product manager. Could you give some examples of what you mean by opinionated direction?
27.
by morgo 8y ago
AFAIU Alibaba uses AliSQL, based on MySQL 5.6 (not MariaDB): https://github.com/alibaba/AliSQL
28.
by morgo 8y ago
Besides being AWS only, Aurora is very expensive when you factor the IO costs for a large deployment. That's not to say that I'm not a fan of it, but it's for a smaller sized deployment than GitHub. You can see this for your
29.
by morgo 8y ago
Correct.
30.
by morgo 8y ago
Certainly, but let’s not rewrite history here. What innodb could/couldn’t do was not the motivation.

More ›