#mysql TiDB

[pingcap]

TiDB: Modernizing Database Infrastructure with Open Source Innovation

In today's rapidly evolving digital landscape, the demand for scalable, reliable, and efficient database systems is at an all-time high. As businesses transition to more complex and distributed environments, the need for databases that can handle large volumes of data, provide seamless scalability, and ensure high availability has become paramount. Enter TiDB, an open-source distributed SQL database that is redefining the way organizations approach modern transactional applications.

The Rise of Distributed SQL Databases

The traditional relational database management systems (RDBMS) have served the industry well for decades. However, with the explosion of data and the need for real-time processing, these legacy systems are increasingly becoming a bottleneck. The monolithic nature of traditional RDBMS makes it challenging to scale horizontally without compromising performance or consistency. This is where distributed SQL databases come into play.

Distributed SQL databases are designed to scale horizontally across multiple nodes, ensuring that as the data grows, the system can handle the increased load without sacrificing performance. These databases maintain ACID (Atomicity, Consistency, Isolation, Durability) properties, similar to traditional RDBMS, but with the added benefit of distributed architecture. This architecture allows for high availability, fault tolerance, and seamless scalability, making them ideal for modern applications that demand both consistency and speed.

What is TiDB?

TiDB is a highly scalable, open-source distributed SQL database developed by PingCAP. It is designed to provide the best of both worlds: the consistency and reliability of traditional RDBMS and the scalability and flexibility of NoSQL databases. TiDB is built on top of a robust, multi-layered architecture that ensures data is distributed across multiple nodes while maintaining strong consistency and ACID compliance.

TiDB's architecture is composed of three main components: the SQL layer, the KV storage layer, and the Raft consensus protocol. The SQL layer is responsible for handling SQL queries and transactions, ensuring that the database behaves like a traditional RDBMS. The KV storage layer is a distributed key-value store that manages the actual data storage, while the Raft consensus protocol ensures that data is consistently replicated across nodes, providing fault tolerance and high availability.

Key Features of TiDB

1. Horizontal Scalability: One of the most significant advantages of TiDB is its ability to scale horizontally. As the data grows, new nodes can be added to the cluster without any downtime, ensuring that the system can handle increased traffic and data volume without sacrificing performance.

2. Strong Consistency and ACID Compliance: TiDB ensures that all transactions adhere to ACID properties, providing the same level of consistency and reliability as traditional RDBMS. This makes TiDB suitable for mission-critical applications where data integrity is paramount.

3. High Availability: TiDB's distributed architecture ensures that the database remains available even in the event of hardware failures. The Raft consensus protocol replicates data across multiple nodes, ensuring that the system can continue to operate even if some nodes go offline.

4. Seamless Integration with MySQL Ecosystem: TiDB is designed to be compatible with the MySQL ecosystem, allowing organizations to migrate their existing MySQL applications to TiDB with minimal changes. This compatibility extends to MySQL tools, connectors, and client libraries, making the transition to TiDB smooth and hassle-free.

5. Global Distribution: TiDB supports geo-replication, allowing organizations to deploy their databases across multiple regions. This ensures that data is available to users around the world with low latency, improving the overall user experience.

6. Open Source Innovation: As an open-source project, mysql TiDB benefits from a vibrant community of developers and contributors who continuously enhance the platform. This collaborative approach ensures that TiDB remains at the cutting edge of database technology, with regular updates and new features being added to the platform.

Use Cases for TiDB

TiDB's unique combination of features makes it suitable for a wide range of applications across various industries. Some of the key use cases include:

1. Financial Services: For financial institutions, data consistency and reliability are non-negotiable. TiDB's ACID compliance and strong consistency make it an ideal choice for transactional applications, such as payment processing, trading systems, and core banking platforms.

2. E-commerce: E-commerce platforms require databases that can handle high volumes of transactions while ensuring data integrity and low latency. TiDB's horizontal scalability and high availability make it a perfect fit for handling product catalogs, customer data, and order processing systems.

3. Social Media and Gaming: Social media and gaming platforms generate massive amounts of data that need to be processed in real-time. TiDB's ability to scale horizontally and distribute data globally ensures that users can access their data with minimal latency, regardless of their location.

4. SaaS Applications: Software-as-a-Service (SaaS) providers require databases that can scale as their customer base grows. TiDB's compatibility with the MySQL ecosystem and its ability to handle large volumes of data make it an excellent choice for SaaS applications.

The Future of TiDB

As organizations continue to modernize their database infrastructure, the demand for scalable, reliable, and efficient database solutions will only increase. TiDB is well-positioned to meet this demand, offering a powerful and flexible solution for modern transactional applications.

With its open-source nature, TiDB is constantly evolving, driven by a global community of developers and users. As the platform continues to mature, we can expect to see even more features and improvements that will further solidify TiDB's position as a leader in the distributed SQL database space.

Conclusion

TiDB is more than just a database; it is a testament to the power of open-source innovation in modernizing database infrastructure. By combining the strengths of traditional RDBMS with the scalability and flexibility of distributed systems, TiDB is paving the way for a new era of database management. For organizations looking to future-proof their database infrastructure, TiDB offers a compelling solution that is both robust and forward-looking.

[774]

実はこのような行列ストレージ同期のコンセプト自体は昔からよく提唱されているもので、元エンプラDB屋の私はまずOracle DB in-memoryやDB2 BLUを思い出しました。最近でもMySQL HeatwaveやAlloyDB、NewSQLで知られるTiDBのHTAPも同じようなコンセプトです。 そういった既存のHTAPデータベースのなかで、Snowflakeが独自のポジションを取っているのは、Snowflakeがクラウドネイティブな分析用DBとして出発し、そこからOLTP側に拡張しているという点です。多くのHTAPデータベースはOLTP側の出自を持っているため、そのなかで分析側出身として大規模データに対する高い性能、拡張性、可用性を備えていることはSnowflakeの大きな利点です。

Snowflake Hybrid Tablesの裏側 - FoundationDBとは何なのか

[kennak]

そこまでしっかりした構造的な日本語で問い合わせ出来ればAI要らんだろと、と思う。

[B! chatgpt] 日本語の問いをChatGPTでSQLに変換、実行する「Chat2Query」を搭載。MySQL互換のTiDB Cloud

[takachan]

日本語の問いをChatGPTでSQLに変換、実行する「Chat2Query」を搭載。MySQL互換のTiDB Cloud

MySQL互換のオープンソースデータベース「TiDB」（タイデービー）を提供しているPingCAP社は、日本語を含む自然言語の問いをChatGPTを用いてSQL文に変換し、実行する「Chat2Query」機能を、クラウド上でTiDBのマネー... https://www.publickey1.jp/blog/23/chatgptsqlchat2querymysqltidb_cloud.html?utm_source=dlvr.it&utm_medium=tumblr Publickey

[computingpostcom]

This tutorial will cover all the steps required to Install Gogs self-hosted Git service on Ubuntu 20.04|18.04|16.04 server. Gogs project which is written in Go aims to build a simple, stable and extensible self-hosted Git service with a painless setup process. Gogs is distributed as an independent binary distribution and runs on all platforms that Go supports, including Linux, macOS, Windows, and ARM. Gogs has excellent performance and is very light. It has very minimal RAM and CPU utilization. A VPS with 1 CPU core and 256MB RAM is enough to start using the service. Features of Gogs Gogs self-hosted Git service has the following set of features ( from Git ) Activity timeline SMTP/LDAP/Reverse proxy authentication Account/Organization/Repository management Repository Git hooks/deploy keys SSH and HTTP/HTTPS protocols Reverse proxy with sub-path Add/Remove repository collaborators Web editor for repository files and wiki Migrate and mirror repository and its wiki Repository/Organization webhooks (including Slack and Discord) Repository issues pull requests, wiki, and protected branches Two-factor authentication Gravatar and Federated avatar with custom source Jupyter Notebook Administration panel Mail service Supports MySQL, PostgreSQL, SQLite3, MSSQL and TiDB (via MySQL protocol) Multi-language support (29 languages) Gogs Open Source Components Gogs components include: Web Framework: Macaron UI Components: Semantic UI GitHub Octicons Font Awesome Front-end Plugins: DropzoneJS marked clipboard.js highlight.js emojify.js jQuery MiniColors jQuery Date Time Picker notebook.js CodeMirror ORM: Xorm Database Drivers: github.com/go-sql-driver/mysql github.com/mattn/go-sqlite3 github.com/lib/pq github.com/denisenkom/go-mssqldb And all other Go package dependencies Install Gogs Git service on Ubuntu 20.04|18.04 Follow these steps to have Gogs installed on your Ubuntu server. Step 1: Install MariaDB Database Server Gogs requires a MySQL server to store data. We will install MariaDB server using the following commands: sudo apt update sudo apt install mariadb-server mariadb Once the database server has been installed, login to MariaDB console as root user $ mysql -u root -p Set global variables below SET GLOBAL innodb_file_per_table = ON; Then create gogs database DROP DATABASE IF EXISTS gogs; CREATE DATABASE IF NOT EXISTS gogs CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; Create a dedicated database user to manage gogs database. $ mysql -u root -p GRANT ALL PRIVILEGES ON gogs.* TO 'gogs'@'localhost' IDENTIFIED BY "StrongPassword"; FLUSH PRIVILEGES; \q Step 2: Download Gogs from Github Check Gogs releases page  https://github.com/gogs/gogs/releases for the latest release. sudo apt install wget curl vim -y curl -s https://api.github.com/repos/gogs/gogs/releases/latest | grep browser_download_url | grep '\linux_amd64.tar.gz' | cut -d '"' -f 4 | wget -i - Extract the downloaded file tar xvf gogs_*_linux_amd64.tar.gz Step 3: Configure Gogs self-hosted Git service Create git user to run gogs service $ sudo adduser git Adding user `git' ... Adding new group `git' (1001) ... Adding new user `git' (1001) with group `git' ... Creating home directory `/home/git' ... Copying files from `/etc/skel' ... Enter new UNIX password: Retype new UNIX password: passwd: password updated successfully Changing the user information for git Enter the new value, or press ENTER for the default Full Name []: Room Number []: Work Phone []: Home Phone []: Other []: Is the information correct? [Y/n] y Create logs directory sudo mkdir /var/log/gogs sudo chown -R git:git /var/log/gogs/ Copy gogs systemd service file to /etc/systemd/system directory sudo cp gogs/scripts/systemd/gogs.service /etc/systemd/system You can edit the file to set customize the settings:

sudo vim /etc/systemd/system/gogs.service If you have a different service using port,3000 you can set a custom port ExecStart=/home/git/gogs web -port 3001 Move the gogs directory content inside /home/git sudo mv gogs /home/git/ Change ownership of /home/git/to user.git sudo chown -R git:git /home/git/ Reload systemd and start gogs service sudo systemctl daemon-reload sudo systemctl start gogs Enable the service to start on boot sudo systemctl enable gogs You can check service status by running $ systemctl status gogs ● gogs.service - Gogs Loaded: loaded (/etc/systemd/system/gogs.service; enabled; vendor preset: enabled) Active: active (running) since Tue 2021-10-26 23:12:31 UTC; 13s ago Main PID: 3404 (gogs) Tasks: 8 (limit: 2343) Memory: 41.4M CGroup: /system.slice/gogs.service └─3404 /home/git/gogs/gogs web Oct 26 23:12:31 jmutai-ubuntu-01 gogs[3404]: 2021/10/26 23:12:31 [TRACE] Log mode: Console (Trace) Oct 26 23:12:31 jmutai-ubuntu-01 gogs[3404]: 2021/10/26 23:12:31 [ INFO] Gogs 0.12.3 Oct 26 23:12:31 jmutai-ubuntu-01 gogs[3404]: 2021/10/26 23:12:31 [TRACE] Work directory: /home/git/gogs Oct 26 23:12:31 jmutai-ubuntu-01 gogs[3404]: 2021/10/26 23:12:31 [TRACE] Custom path: /home/git/gogs/custom Oct 26 23:12:31 jmutai-ubuntu-01 gogs[3404]: 2021/10/26 23:12:31 [TRACE] Custom config: /home/git/gogs/custom/conf/app.ini Oct 26 23:12:31 jmutai-ubuntu-01 gogs[3404]: 2021/10/26 23:12:31 [TRACE] Log path: /home/git/gogs/log Oct 26 23:12:31 jmutai-ubuntu-01 gogs[3404]: 2021/10/26 23:12:31 [TRACE] Build time: 2020-10-07 03:03:48 UTC Oct 26 23:12:31 jmutai-ubuntu-01 gogs[3404]: 2021/10/26 23:12:31 [TRACE] Build commit: f0e3cd90f8d7695960eeef2e4e54b2e717302f6c Oct 26 23:12:31 jmutai-ubuntu-01 gogs[3404]: 2021/10/26 23:12:31 [ INFO] Run mode: Development Oct 26 23:12:31 jmutai-ubuntu-01 gogs[3404]: 2021/10/26 23:12:31 [ INFO] Listen on http://0.0.0.0:3000 Typing command gogs on the terminal as git user should print help page. $ gogs/gogs NAME: Gogs - A painless self-hosted Git service USAGE: gogs [global options] command [command options] [arguments...] VERSION: 0.12.3 COMMANDS: web Start web server serv This command should only be called by SSH shell hook Delegate commands to corresponding Git hooks cert Generate self-signed certificate admin Perform admin operations on command line import Import portable data as local Gogs data backup Backup files and database restore Restore files and database from backup help, h Shows a list of commands or help for one command GLOBAL OPTIONS: --help, -h show help --version, -v print the version Step 4: Configure Gogs self-hosted Git service Open the URL http://serverip:3000/install to finish the installation of Gogs Set database authentication The username and password provided should match the ones provided in the Database configuration section. If the database server is on a different host, provide the IP address under the Host section. Set Application General Settings Provide application URL, this can be a routable server IP address or domain name that resolves to the IP. The same should be set for SSH. Disable User self-registration You can disable User self-registration under “Server and Other Services Settings”. This means the admin user will manually create user accounts. You can optionally create an admin user account. By default, root user will gain admin access automatically. When done with the configurations, click the “Install Gogs” button to finish the installation. On a successful installation, you should be logged into Gogs administration console. Create additional user accounts To add user accounts, Open Admin Panel at the top right panel You can then use “Create New Account” link to add a new user to Gogs. Step: 5 Test Gogs self-hosted Git service Create a new repository called test-repo

Try cloning the repo $ git clone http://192.168.18.40:3000/jmutai/test-repo.git Cloning into 'test-repo'... Username for 'http://192.168.18.40:3000': jmutai Password for 'http://jmutai@192.168.18.40:3000': remote: Counting objects: 4, done. remote: Compressing objects: 100% (3/3), done. remote: Total 4 (delta 0), reused 0 (delta 0) Unpacking objects: 100% (4/4), done To avoid Password Authentication, add your SSH public key under “Your Profile > SSH keys > Add Key Provide key name, and paste your SSH public key into the content box. An ssh git clone should not ask for a password $ git clone git@192.168.18.40:jmutai/test-repo.git Cloning into 'test-repo'... Warning: Permanently added '192.168.18.40' (ECDSA) to the list of known hosts. remote: Counting objects: 4, done. remote: Compressing objects: 100% (3/3), done. remote: Total 4 (delta 0), reused 0 (delta 0) Receiving objects: 100% (4/4), done. Step 6: Configure Nginx Reverse Proxy If you would like to access Gogs using a domain name without a port, you need to configure Apache or NGINX reverse proxy sudo apt install nginx Create a VirtualHost reverse proxy configuration file sudo vim /etc/nginx/conf.d/gogs.conf Add: server listen 80; server_name git.example.com; location / proxy_pass http://localhost:3000; If using SSL and would like to have http to https redirect, use: server listen 80; server_name git.example.com; location / rewrite ^ https://git.example.com$request_uri? permanent; server listen 443 ssl; server_name git.example.com; ssl_certificate /etc/letsencrypt/live/git.example.com/fullchain.pem; ssl_certificate_key /etc/letsencrypt/live/git.example.com/privkey.pem; location / proxy_pass http://localhost:3000; Replace git.example.com with your actual domain name. For more reading on Gogs administration and usage, check out the Official Documentation.

[hackernewsrobot]

TiDB open sources its MySQL/MariaDB compatible data migration tool

https://github.com/pingcap/dm Comments

[reportwire]

Flink on TiDB: Reliable, Real-Time Data Service

Flink on TiDB: Reliable, Real-Time Data Service

TiDB is a distributed SQL database that supports Hybrid Transactional and Analytical Processing (HTAP) workloads. It is MySQL compatible and features horizontal scalability, strong consistency, and real-time Online Analytical Processing (OLAP). Apache Flink is the most popular, open-source computing framework. It provides high-throughput, low-latency data computing and exactly-once…

[5llowance]

Thoughts on China's database via /r/China

Thoughts on China's database

Speaking of open source databases in China. When they were closed, domestic database companies still had something to boast about; now that they are open, the source code expose their lack of innovation flat out.

​

Huawei's openGauss can only be considered an improved version of PostgreSQL, and in order to support sharding, it has to work with traditional middleware such as ShardingSphere, which I just extended a few months ago to support MySQL and PostgreSQL protocols.

​

TiDB/TiKV, whose core storage engine is RocksDB, mutilated ClickHouse

to support OLAP, and uses Raft as consistency protocol. TiDB OLTP SQL engine is also not much special. Down the years I found that the company has rarely come up with any original technology worth mentioning, but it stays in the graces of venture capitalists.

​

Ali, recently, opened its source of PolarDB-X. Prior to this I thought highly of it and gave it 75 points; having read the code, I offered 55 to the bummer. So many people over the years only came up with such a dud, which is rather disappointing, and what's more, since I worked with Ali before, I had set the bar a little higher.

​

And the PolarDB for PostgreSQL, might as well be shut down and thrown into the trash bin, and join the Huawei family to engage in openGauss to save a few coders for Ali.

​

Nevertheless independent from Ant Financial Services, OceanBase surprises me, although it hasn't provided heavyweight original technology. At least the project code is relatively good compared to all the above databases.

Submitted October 21, 2021 at 05:25PM by Oswinthegreat via reddit https://ift.tt/3jrAKlL

[mydbops]

​The Mydbops Blog offers expert insights and practical guidance on managing open-source databases such as MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, and Cassandra. It covers topics like performance optimization, security hardening, replication strategies, and the latest trends in database technology. The blog serves as a valuable resource for database administrators and developers seeking to enhance their knowledge and stay updated with industry best practices. ​

[tak4hir0]

Select a ranking Special reports Ranking Complete Ranking DB-Engines RankingThe DB-Engines Ranking ranks database management systems according to their popularity. The ranking is updated monthly. Read more about the method of calculating the scores. 350 systems in ranking, February 2020RankDBMSDatabase ModelScoreFeb 2020Jan 2020Feb 2019Feb 2020Jan 2020Feb 20191.1.1.Oracle Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store, Graph DBMS, RDF store1344.75-1.93+80.732.2.2.MySQL Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store1267.65-7.00+100.363.3.3.Microsoft SQL Server Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store, Graph DBMS1093.75-4.80+53.694.4.4.PostgreSQL Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store506.94-0.25+33.385.5.5.MongoDB Detailed vendor-provided information availableDocument, Multi-model Document store, Search engine433.33+6.37+38.246.6.6.IBM Db2 Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store, RDF store165.55-3.15-13.877.7. 8.Elasticsearch Detailed vendor-provided information availableSearch engine, Multi-model Search engine, Document store152.16+0.72+6.918.8. 7.Redis Detailed vendor-provided information availableKey-value, Multi-model Key-value store, Document store, Graph DBMS, Search engine, Time Series DBMS151.42+2.67+1.979.9.9.Microsoft AccessRelational128.06-0.52-15.9610.10.10.SQLite Detailed vendor-provided information availableRelational123.36+1.22-2.8111.11.11.Cassandra Detailed vendor-provided information availableWide column120.36-0.31-3.0212.12. 13.SplunkSearch engine88.77+0.10+5.9613.13. 12.MariaDB Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store, Graph DBMS87.34-0.11+3.9114.14. 15.Hive Detailed vendor-provided information availableRelational83.53-0.71+11.2515.15. 14.Teradata Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store, Graph DBMS, Time Series DBMS76.81-1.48+0.8416.16. 21.Amazon DynamoDB Detailed vendor-provided information availableMulti-model Document store, Key-value store62.14+0.12+7.1917.17. 16.SolrSearch engine56.16-0.41-4.8118. 19. 19.SAP HANA Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store, Graph DBMS54.97+0.28-1.5819. 18. 18.FileMakerRelational54.88-0.23-2.9120. 21. 17.HBaseWide column52.95-0.39-7.3321. 20. 20.SAP Adaptive ServerRelational52.73-1.86-3.0222.22.22.Neo4j Detailed vendor-provided information availableGraph51.21-0.45+3.3523.23.23.Couchbase Detailed vendor-provided information availableDocument, Multi-model Document store, Key-value store32.16+0.12-3.4224.24. 27.Microsoft Azure Cosmos DB Detailed vendor-provided information availableMulti-model Document store, Graph DBMS, Key-value store, Wide column store31.95+0.44+7.0925.25.25.Microsoft Azure SQL DatabaseRelational, Multi-model Relational DBMS, Document store, Graph DBMS31.41+3.20+4.2826.26. 33.Google BigQuery Detailed vendor-provided information availableRelational27.56+0.81+8.8127. 28. 24.MemcachedKey-value25.30+0.20-4.1428. 27. 26.InformixRelational, Multi-model Relational DBMS, Document store, Time Series DBMS24.89-0.25-1.4729.29. 28.Vertica Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store22.63-0.02-0.1730.30. 32.FirebirdRelational21.82-0.73+2.4731. 32. 35.InfluxDB Detailed vendor-provided information availableTime Series21.57+0.44+5.8132. 31. 29.Amazon Redshift Detailed vendor-provided information availableRelational20.97-0.62-0.0233.33. 31.NetezzaRelational18.75-0.87-1.0334.34. 30.CouchDBDocument18.13-0.24-1.8735.35. 34.Spark SQLRelational16.95-0.19+0.3836.36. 37.ImpalaRelational, Multi-model Relational DBMS, Document store15.71-0.32+0.9137.37. 40.dBASERelational14.20-0.58+2.3138. 39. 41.Firebase Realtime DatabaseDocument12.35+0.07+1.9239. 38. 36.MarkLogic Detailed vendor-provided information availableMulti-model Document store, Native XML DBMS, RDF store, Search engine12.25-0.11-2.7440.40. 38.GreenplumRelational, Multi-model Relational DBMS, Document store11.93-0.21-0.9141.41. 39.Oracle EssbaseRelational10.64+0.07-1.3442.42. 44.Microsoft Azure SQL Data WarehouseRelational9.58+0.14+1.1243.43. 76.PrestoRelational9.53+0.39+6.0544. 46. 46.Realm Detailed vendor-provided information availableDocument8.85+0.62+1.9745. 44. 42.Datastax Enterprise Detailed vendor-provided information availableWide column, Multi-model Wide column store, Document store, Graph DBMS8.48-0.18-0.6746. 45. 43.Hazelcast Detailed vendor-provided information availableKey-value, Multi-model Key-value store, Document store8.28-0.08-0.6147.47. 53.Amazon AuroraRelational, Multi-model Relational DBMS, Document store8.18+0.01+2.2948. 53. 45.SphinxSearch engine7.26+0.74-0.3149. 48.etcdKey-value7.24-0.0650. 49.50.H2Relational7.13+0.07+0.7151. 50. 48.Aerospike Detailed vendor-provided information availableKey-value6.88+0.06+0.2652. 51. 47.EhcacheKey-value6.68-0.01-0.1253. 52. 49.InterbaseRelational6.55-0.08+0.0154.54. 55.Microsoft Azure SearchSearch engine6.31-0.17+0.7755. 57. 72.Google Cloud FirestoreDocument6.21+0.55+2.4556. 55. 54.IngresRelational5.92-0.43+0.1657. 56. 59.SAP SQL AnywhereRelational5.75-0.03+0.5258. 59. 51.Riak KVKey-value5.47+0.07-0.6259. 58. 57.Kdb+ Detailed vendor-provided information availableTime Series, Multi-model Time Series DBMS, Relational DBMS5.38-0.11-0.0260.60. 58.DerbyRelational5.22-0.10-0.1061. 62. 63.SAP IQRelational5.01-0.14+0.5862. 64. 56.IgniteMulti-model Key-value store, Relational DBMS5.00-0.01-0.4263.63. 52.OrientDBMulti-model Document store, Graph DBMS, Key-value store4.94-0.17-1.1164. 67. 65.Google Cloud DatastoreDocument4.89+0.08+0.5865.65. 61.Microsoft Azure Table StorageWide column4.86-0.15+0.0866. 61. 64.ArangoDB Detailed vendor-provided information availableMulti-model Document store, Graph DBMS, Key-value store, Search engine4.85-0.35+0.5067. 66. 60.HyperSQLRelational4.85-0.11-0.2768. 69. 74.AlgoliaSearch engine4.69+0.07+0.9869. 68. 71.AdabasMultivalue4.53-0.13+0.7370.70. 73.MemSQLRelational, Multi-model Relational DBMS, Document store4.49-0.03+0.7571.71. 67.JackrabbitContent4.36-0.14+0.3872. 73. 75.MaxDBRelational4.15+0.13+0.4473. 72. 93.PrometheusTime Series4.01-0.06+1.5174. 79. 80.Oracle NoSQL Detailed vendor-provided information availableKey-value, Multi-model Key-value store, Relational DBMS3.91+0.30+0.8775. 78. 100.ClickHouseRelational3.89+0.19+1.6076. 75. 107.CockroachDBRelational3.85+0.07+1.7777. 74. 66.AccumuloWide column3.83-0.09-0.2878. 81. 68.RavenDBDocument, Multi-model Document store, Graph DBMS3.82+0.37-0.1179. 76. 69.OpenEdgeRelational3.80+0.03-0.0980. 82. 70.CloudantDocument3.74+0.29-0.0981. 77. 62.RethinkDBDocument3.63-0.13-0.9082. 80. 78.InterSystems CachéMulti-model Key-value store, Object oriented DBMS, Relational DBMS, Document store3.43-0.10+0.1583.83. 82.GraphiteTime Series3.34-0.01+0.3984.84. 77.UniData,UniVerseMultivalue3.300.00-0.0785.85. 87.SAP Advantage Database ServerRelational3.13+0.01+0.4186.86. 91.Amazon CloudSearchSearch engine3.08+0.03+0.5687. 90. 81.Oracle Berkeley DBMulti-model Key-value store, Native XML DBMS2.98+0.14-0.0188.88. 84.PouchDBDocument2.96-0.01+0.0389. 87. 108.EXASOLRelational2.89-0.14+0.8390. 91. 79.Google Search ApplianceSearch engine2.77-0.03-0.2891. 96. 83.Virtuoso Detailed vendor-provided information availableMulti-model Graph DBMS, Native XML DBMS, Relational DBMS, RDF store, Search engine, Document store2.77+0.12-0.1792. 89. 86.LevelDBKey-value2.77-0.10+0.0393. 95. 96.4DRelational2.72+0.03+0.3394. 93. 85.Apache DrillMulti-model Document store, Relational DBMS2.69-0.05-0.1495. 92. 88.RRDtoolTime Series2.68-0.09-0.0296. 97. 98.RocksDBKey-value2.67+0.06+0.3497. 104.Microsoft Azure Data ExplorerRelational2.66+0.3398. 94. 92.InfinispanKey-value2.64-0.05+0.1499. 98. 106.Apache Jena - TDBRDF2.62+0.02+0.44100.100. 104.IMSNavigational2.59+0.16+0.38101. 107. 102.Snowflake Detailed vendor-provided information availableRelational2.56+0.32+0.30102. 101. 105.CloudKitDocument2.53+0.16+0.34103. 99. 90.Percona Server for MySQLRelational2.52+0.07-0.05104. 103. 101.Amazon SimpleDBKey-value2.46+0.13+0.19105. 102. 95.EnterpriseDB Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store2.38+0.02-0.06106. 108. 99.Oracle CoherenceKey-value2.38+0.23+0.07107. 109. 89.TimesTen Detailed vendor-provided information availableRelational2.31+0.19-0.39108. 106. 111.Google Cloud BigtableWide column2.27+0.02+0.58109. 110. 133.ScyllaDBWide column2.25+0.19+1.19110. 112. 103.OpenTSDBTime Series2.14+0.17-0.10111. 113. 110.Google Cloud SpannerRelational2.13+0.20+0.44112. 111. 94.DatomicRelational2.12+0.14-0.34113. 105. 97.OmniSci Detailed vendor-provided information availableRelational2.08-0.22-0.27114. 118. 117.jBASEMultivalue1.99+0.19+0.43115. 121. 134.Amazon NeptuneMulti-model Graph DBMS, RDF store1.96+0.23+0.90116. 117. 119.MonetDB Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store1.95+0.14+0.50117. 116. 118.DruidMulti-model Relational DBMS, Time Series DBMS1.91+0.03+0.42118. 120. 113.IBM Db2 warehouseRelational1.90+0.13+0.25119. 115. 115.Versant Object DatabaseObject oriented1.89+0.00+0.24120. 119. 125.JanusGraphGraph1.88+0.11+0.65121. 114. 149.TimescaleDB Detailed vendor-provided information availableTime Series, Multi-model Time Series DBMS, Relational DBMS1.88-0.04+1.00122. 124.122.GeodeKey-value1.81+0.22+0.53123.123. 112.VoltDBRelational1.78+0.14+0.12124. 122. 109.GridGainMulti-model Key-value store, Relational DBMS1.77+0.10-0.24125. 126. 126.TiDB Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store1.73+0.16+0.50126. 127. 116.Red BrickRelational1.64+0.08+0.06127. 130. 166.D3Multivalue1.61+0.18+0.88128. 125. 120.TiberoRelational1.59+0.00+0.18129.129.129.ObjectStoreObject oriented1.57+0.14+0.37130. 128. 114.mSQLRelational1.46-0.02-0.19131. 134.131.SQLBaseRelational1.46+0.13+0.38132. 136. 123.BaseXNative XML1.43+0.19+0.16133. 132. 124.MnesiaDocument1.43+0.07+0.20134. 131. 121.Db4oObject oriented1.38-0.03+0.07135.135. 127.DatameerDocument1.34+0.06+0.12136. 133. 128.EmpressRelational1.29-0.05+0.06137. 139. 130.CubridRelational1.24+0.13+0.10138. 144. 154.TarantoolKey-value1.22+0.16+0.38139. 138. 132.MatisseObject oriented1.21+0.08+0.14140. 143. 138.Altibase Detailed vendor-provided information availableRelational1.20+0.14+0.20141. 142. 147.HFSQLRelational1.16+0.10+0.27142. 145. 169.Dgraph Detailed vendor-provided information availableGraph1.16+0.11+0.45143. 137. 152.GraphDB Detailed vendor-provided information availableMulti-model Graph DBMS, RDF store1.14+0.00+0.28144. 140. 189.InterSystems IRIS Detailed vendor-provided information availableMulti-model Document store, Key-value store, Object oriented DBMS, Relational DBMS1.13+0.06+0.60145. 141. 170.LiteDBDocument1.08+0.01+0.38146. 152. 172.CitusRelational, Multi-model Relational DBMS, Document store1.07+0.07+0.39147. 158. 153.NuoDB Detailed vendor-provided information availableRelational1.06+0.12+0.21148. 159. 146.WiredTigerKey-value1.05+0.13+0.15149. 157. 155.NCache Detailed vendor-provided information availableKey-value1.05+0.11+0.24150. 149. 142.Model 204Multivalue1.03+0.02+0.09151. 147. 139.InfobrightRelational1.01-0.02+0.04152. 153. 137.Oracle RdbRelational1.01+0.02+0.01153. 155. 140.NonStop SQLRelational1.00+0.03+0.05154. 166. 214.FaunaDB Detailed vendor-provided information availableMulti-model Document store, Graph DBMS, Relational DBMS, Time Series DBMS0.98+0.18+0.62155. 146. 135.IDMSNavigational0.98-0.05-0.05156. 148. 136.GiraphGraph0.98-0.04-0.03157. 150. 143.DataEaseRelational0.98-0.04+0.06158. 163. 141.1010dataRelational0.96+0.10+0.01159. 156. 145.GT.MKey-value0.950.00+0.04160. 154. 151.SednaNative XML0.94-0.04+0.08161.161. 156.FoundationDBMulti-model Document store, Key-value store, Relational DBMS0.94+0.08+0.14162. 165. 171.Stardog Detailed vendor-provided information availableMulti-model Graph DBMS, RDF store0.91+0.10+0.22163. 160. 144.HAWQRelational0.90-0.01-0.01164. 169. 174.DBISAMRelational0.89+0.10+0.22165. 151. 173.TigerGraph Detailed vendor-provided information availableGraph0.87-0.13+0.19166. 182.Amazon DocumentDBDocument0.84+0.16167. 162. 148.AllegroGraph Detailed vendor-provided information availableMulti-model Document store, Graph DBMS, RDF store0.84-0.01-0.04168. 171. 225.YugabyteDB Detailed vendor-provided information availableRelational, Multi-model Relational DBMS, Document store, Wide column store0.83+0.06+0.52169. 168. 161.R:BASERelational0.82+0.03+0.06170. 164. 163.ZODBKey-value0.820.00+0.07171. 167. 150.XAPMulti-model Document store, Key-value store, Object oriented DBMS0.81+0.01-0.06172. 170. 180.GemStone/SObject oriented0.81+0.03+0.19173. 172. 159.KognitioRelational0.79+0.02+0.01174. 173. 160.Objectivity/DBObject oriented0.78+0.02+0.01175.175. 167.solidDBRelational0.730.00+0.00176. 174. 178.XapianSearch engine0.73-0.02+0.08177. 186. 157.Splice MachineRelational0.73+0.06-0.06178. 180. 165.Datacom/DBRelational0.72+0.02-0.01179.179. 177.WebSphere eXtreme ScaleKey-value0.71+0.00+0.05180. 178. 164.ScaleArcRelational0.710.00-0.03181. 176. 179.FrontBaseRelational0.71-0.01+0.08182. 177. 175.ClustrixRelational0.70-0.01+0.03183. 184. 176.eXist-dbNative XML0.70+0.02+0.03184. 183. 186.Event StoreEvent0.70+0.02+0.14185. 202. 206.PerstObject oriented0.70+0.14+0.29186. 181. 168.Actian VectorRelational0.690.00-0.03187. 193. 201.Northgate RealityMultivalue0.69+0.08+0.27188.188. 187.Tokyo CabinetKey-value0.68+0.04+0.11189. 187. 158.BigchainDBDocument0.67+0.00-0.12190. 191. 188.CrateDB Detailed vendor-provided information availableMulti-model Relational DBMS, Search engine, Document store0.67+0.04+0.13191. 199. 190.ObjectDBObject oriented0.65+0.08+0.11192. 189. 191.BlazegraphMulti-model Graph DBMS, RDF store0.640.00+0.11193. 185. 162.MapR-DBMulti-model Document store, Wide column store0.63-0.04-0.12194. 190. 184.OpenBaseRelational0.62-0.02+0.05195. 194. 198.SQL.JSRelational0.610.00+0.15196. 192. 181.SciDBMultivalue0.60-0.02-0.01197. 205. 182.Percona Server for MongoDBDocument0.60+0.080.00198.198. 193.KineticaRelational0.59+0.02+0.07199. 203. 185.VistaDBRelational0.58+0.03+0.02200. 197. 183.Graph EngineMulti-model Graph DBMS, Key-value store0.58+0.00+0.01201. 196. 192.NexusDBRelational0.57-0.02+0.04202. 195. 196.OpenInsightMultivalue0.57-0.04+0.07203. 201. 194.KairosDBTime Series0.56+0.01+0.04204. 206. 226.c-treeACE Detailed vendor-provided information availableMulti-model Key-value store, Relational DBMS0.51-0.01+0.21205. 210. 209.ObjectBoxObject oriented0.51+0.03+0.12206. 212. 211.BoltDBKey-value0.51+0.03+0.13207. 200.YellowbrickRelational0.50-0.06208. 222. 213.AlaSQLMulti-model Document store, Relational DBMS0.49+0.10+0.12209. 204. 231.GridDB Detailed vendor-provided information availableTime Series, Multi-model Time Series DBMS, Key-value store, Relational DBMS0.48-0.04+0.21210. 207.210.RedlandRDF0.48-0.04+0.10211. 213. 197.MapDBKey-value0.48+0.00-0.01212. 208. 237.Alibaba Cloud MaxComputeRelational0.47-0.02+0.22213. 211. 203.Postgres-XLRelational, Multi-model Relational DBMS, Document store0.47-0.02+0.05214. 216. 199.Tokyo TyrantKey-value0.46+0.01+0.01215. 214. 207.SQream DB Detailed vendor-provided information availableRelational0.44-0.02+0.04216. 209. 218.JadeObject oriented0.44-0.04+0.10217. 215. 202.RasdamanMultivalue0.44-0.01+0.02218.218. 205.TrafodionRelational0.43+0.01+0.02219. 217. 204.eXtremeDB Detailed vendor-provided information availableMulti-model Relational DBMS, Time Series DBMS0.42-0.02+0.01220. 219. 228.Amazon TimestreamTime Series0.41+0.01+0.13221. 228. 219.4storeRDF0.40+0.03+0.06222. 232. 215.Project VoldemortKey-value0.40+0.05+0.04223. 220. 217.RDF4JRDF0.390.00+0.05224.224. 222.ScalarisKey-value0.39+0.01+0.07225. 226. 220.HibariKey-value0.39+0.01+0.06226. 223. 208.InfiniteGraphGraph0.39+0.00-0.01227. 225. 235.LokiJSDocument0.38+0.00+0.13228. 231. 245.SnappyDataRelational0.37+0.02+0.16229. 237. 224.Mimer SQLRelational0.37+0.07+0.06230. 227. 234.c-treeEDGE Detailed vendor-provided information availableMulti-model Key-value store, Relational DBMS0.370.00+0.11231. 221.RocksetDocument, Multi-model Document store, Relational DBMS, Search engine0.37-0.02232. 230. 221.Raima Database ManagerRelational0.37+0.00+0.04233. 229. 212.StarcounterObject oriented0.35-0.01-0.02234. 259. 227.Actian PSQLRelational0.35+0.15+0.04235. 233. 216.ModeShapeContent0.35+0.02+0.00236.236. 247.Alibaba Cloud Table StoreWide column0.32+0.02+0.12237. 234. 233.Alibaba Cloud HybridDBRelational0.32+0.01+0.06238. 248. 240.Kyoto CabinetKey-value0.31+0.06+0.06239. 240. 242.PipelineDBRelational0.31+0.01+0.07240. 252. 238.IBM Db2 Event StoreMulti-model Event Store, Time Series DBMS0.30+0.08+0.05241. 235. 223.TajoRelational0.30-0.01-0.01242. 239. 232.SearchBloxSearch engine0.30+0.01+0.03243. 245. 236.FlockDBGraph0.29+0.02+0.03244. 241. 230.OpenQMMultivalue0.28-0.01+0.00245. 246. 246.Riak TSTime Series0.28+0.02+0.07246. 244. 229.SequoiadbMulti-model Document store, Relational DBMS0.270.00-0.01247. 242. 241.LovefieldRelational0.27-0.01+0.03248. 251. 274.HeroicTime Series0.27+0.04+0.17249. 243. 278.GRAKN.AI Detailed vendor-provided information availableMulti-model Graph DBMS, Relational DBMS0.27-0.01+0.17250. 238. 263.ITTIARelational0.25-0.05+0.11251. 247. 248.AxibaseTime Series0.250.00+0.05252. 255.DolphinDBTime Series0.25+0.04253. 249. 239.Comdb2Relational0.23-0.02-0.01254.254. 265.Valentina ServerRelational0.23+0.02+0.10255. 262. 276.EJDBDocument0.21+0.03+0.11256.256. 270.XtremeDataRelational0.200.00+0.09257. 253. 293.LeanXcaleMulti-model Key-value store, Relational DBMS0.20-0.02+0.14258. 260. 254.HyperGraphDBGraph0.20+0.01+0.03259. 258. 250.ElevateDBRelational0.19-0.010.00260. 250.260.RedStoreRDF0.18-0.06+0.03261. 263.QuestDBTime Series, Multi-model Time Series DBMS, Relational DBMS0.180.00262. 257. 292.MulgaraRDF0.17-0.03+0.10263. 264. 253.TransLatticeRelational0.17+0.00-0.01264. 261. 284.Transbase Detailed vendor-provided information availableRelational0.17-0.02+0.09265. 300. 251.Warp 10Time Series0.15+0.09-0.03266. 265. 252.EsgynDB Detailed vendor-provided information availableRelational0.15-0.01-0.03267. 299.Nebula Graph Detailed vendor-provided information availableGraph0.14+0.08268. 266. 257.CubicWebRDF0.14+0.00-0.02269. 268. 275.TinkerGraphGraph0.14+0.01+0.04270. 275.KeyDBKey-value0.13+0.02271. 289. 264.AnzoGraph Detailed vendor-provided information availableMulti-model Graph DBMS, RDF store0.13+0.05-0.01272. 270.GeoSpockRelational, Multi-model Relational DBMS, Time Series DBMS0.12-0.01273. 267. 258.AgensGraphMulti-model Graph DBMS, Relational DBMS0.12-0.01-0.04274. 269. 311.GraphBaseGraph0.12-0.01+0.07275. 271. 303.BrytlytRelational0.11-0.01+0.07276. 273. 268.SparkseeGraph0.11-0.01-0.01277. 272. 305.searchxmlMulti-model Native XML DBMS, Search engine0.11-0.01+0.06278. 284. 267.WakandaDBObject oriented0.10+0.02-0.02279. 278. 266.Quasardb Detailed vendor-provided information availableTime Series0.10+0.00-0.03280. 276. 294.BluefloodTime Series0.100.00+0.03281.281. 299.JethroDataRelational0.10+0.00+0.04282. 302. 306.Resin CacheKey-value0.09+0.03+0.05283. 279. 256.NEventStoreEvent0.09-0.01-0.08284. 283. 281.SenseiDBDocument0.09+0.00+0.00285. 277. 279.DensoDBDocument0.09-0.02-0.01286. 288. 255.STSdbKey-value0.09+0.01-0.09287. 334. 331.IndicaSearch engine0.08+0.08+0.08288. 285. 273.BadgerKey-value0.080.00-0.03289. 274. 290.StrabonRDF0.08-0.03+0.01290. 286. 319.Manticore SearchSearch engine0.080.00+0.05291.291. 271.RaptorDBDocument0.08+0.00-0.04292. 297. 259.Hawkular MetricsTime Series0.08+0.01-0.07293. 280. 325.HGraphDBGraph0.08-0.02+0.06294. 290. 282.BrightstarDBRDF0.08+0.00-0.01295. 282.M3DBTime Series0.08-0.01296. 293. 308.Kyoto TycoonKey-value0.070.00+0.03297. 318. 314.UpscaledbKey-value0.07+0.04+0.04298. 292. 269.VelocityDBMulti-model Graph DBMS, Object oriented DBMS0.070.00-0.05299. 314.WeaviateGraph, Multi-model Graph DBMS, Search engine0.07+0.03300. 296. 287.WhiteDBDocument0.070.00-0.01301. 315.VictoriaMetricsTime Series0.07+0.03302. 301. 283.DydraRDF0.060.00-0.02303. 295. 291.EllipticsKey-value0.06-0.01-0.01304. 294. 297.ToroDBDocument0.06-0.010.00305.305. 298.IRONdb Detailed vendor-provided information availableTime Series0.06+0.01+0.01306. 304. 316.InfinityDBKey-value0.06+0.00+0.03307. 287. 300.SwayDBKey-value0.06-0.02+0.01308. 303. 307.Machbase Detailed vendor-provided information availableTime Series0.06+0.00+0.02309. 308. 323.OrigoDBMulti-model Document store, Object oriented DBMS0.06+0.00+0.04309. 313. 321.SiriDBTime Series0.06+0.01+0.04311.311.HugeGraphGraph0.06+0.00312. 307. 277.NosDBDocument0.05+0.00-0.04313. 306. 285.MemgraphGraph0.050.00-0.02314. 309. 326.TerarkDBKey-value0.050.00+0.04315. 332. 331.Sadas EngineRelational0.05+0.04+0.05316. 312. 304.BigObjectRelational0.04-0.010.00317. 298.CovenantSQLRelational0.04-0.03318. 310. 301.SiaqodbObject oriented0.04-0.02-0.01319. 316. 302.DBSightSearch engine0.04+0.00-0.01320. 317. 296.SmallSQLRelational0.030.00-0.03321. 330. 315.HyperLevelDBKey-value0.03+0.020.00322. 327. 309.LedisDBKey-value0.02+0.01-0.02323. 320. 322.NewtsTime Series0.02-0.01+0.00324.324. 272.Versant FastObjectsObject oriented0.020.00-0.10325. 321. 320.FinchDBMulti-model Document store, Search engine0.02-0.01-0.01326. 323. 317.CortexDBMulti-model Document store, Key-value store0.02-0.01-0.01327. 325. 324.LinterRelational0.02-0.01+0.00328. 334. 331.SiteWhereTime Series0.01+0.01+0.01329. 326. 289.BangdbKey-value0.01-0.01-0.06330. 322. 312.ExorbyteSearch engine0.01-0.01-0.03331.331. 313.iBoxDBDocument0.01+0.00-0.03332. 328. 318.ScaleOut StateServerKey-value0.01-0.01-0.02333.333. 261.ActorDBRelational0.00+0.00-0.14334.334. 331.BergDBKey-value0.00±0.00±0.00334.334. 331.Cachelot.ioKey-value0.00±0.00±0.00334.334. 331.DaggerDBRelational0.00±0.00±0.00334. 329. 330.Edge IntelligenceRelational0.00-0.010.00334.334. 262.EloqueraObject oriented0.00±0.00-0.15334.334.FlureeDBGraph0.00±0.00334.334. 331.HeliumKey-value0.00±0.00±0.00334.334.HyprcubdTime Series0.00±0.00334.334. 329.JaguarDB Detailed vendor-provided information availableKey-value0.00±0.000.00334.334. 331.JasDBDocument0.00±0.00±0.00334.334. 331.JSqlDbMulti-model Document store, Object oriented DBMS0.00±0.00±0.00334.334. 331.K-DBRelational0.00±0.00±0.00334. 319. 327.SparkleDBRDF0.00-0.03-0.01334.334.TerminusDBGraph, Multi-model Graph DBMS, Document store, RDF store0.00±0.00334.334. 310.TomP2PKey-value0.00±0.00-0.04334.334. 331.YaacomoRelational0.00±0.00±0.00334.334. 331.YanzaTime Series0.00±0.00±0.00 Share this page

[masaa-ma]

【Cloud Native Days Kansai 2019】参加記録

from https://qiita.com/tzkoba/items/9a657766221edeae7965?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

CNDK2019に行ってきました

2019年の11月末に大阪で行われた、Cloud Native Days Kansaiに参加してきました。

Tokyoの際とは異なり、今回は登壇なしです（前夜祭のLTで少しだけお話しました）。そのためか、結構リラックスした���ラットな気持ちで各セッションを聞くことが出来ました。 登壇すると、自分のセッションが終わるまではやっぱり落ち着かないし、終わったら終わったで結構燃え尽きるのですよね。CNDTの時はこの燃え尽き症状が大きくて、なんというか疲弊していた記憶があります。

印象に残ったセッション

ということで各セッションを集中して聞くことが出来ました。今回のCNDKでは2並列でセッションが行われていたのですが、どのセッションも魅力的で毎回どちらを聞くか悩みました。 そんな中でも個��的に興味深かったセッションを3つ紹介したいと思います。

メルペイのマイクロサービスとCloud Native

まず1つ目はメルペイの高木さん(@tjun)がお話になったKeynoteセッションです。

こんにちは！ このあと発表する資料です、よろしくおねがいします #CNDK2019 https://t.co/ZskzYtYJ2B

— tjun (@tjun) November 28, 2019

高木さんは謙虚に自分たちの活動がCloud Nativeか分からないということを仰っていたのですが、国内でもトップクラスの取り組みをされていて、メルペイがCloud Nativeじゃないなら何処がそう呼べるのだろう、と思える素晴らしい内容でした。

そして、私はサービスの中でデータベースばかり注目してしまうという悪癖があるのですが、メルペイさんは決済サービスにおいてGoogle Cloud Spannerを使っているという特徴があります。そのことは決済トランザクションの話や残高管理の話をブログで読んでいたのですが、これまで余り腹落ちしていませんでした。 しかし、今回は東京ー新大阪の移動中に折り良く分散データベースに関する記事を読んでおり、メルペイさんの取り組みがどれほど凄いことなのか、やっと分かってきました。

（分散データベースについて呟いてたのがこれ）

ymmtさんに紹介頂いた、CockroachDB対YugaByte DBの記事がめちゃんこ面白い。名古屋から新大阪までの間、すごい楽しめた。Insertに強いHashパーティショニング(YugaByte)、複数行selectに強いRange(Cockroach)ってことなんだけど考察深い。https://t.co/KTOoOWDrRW

— こば（右） (@tzkb) November 27, 2019

Writeヘビーな決済ワークロードを受け止めるには、例えば、

Oracle Exadataのような、超強力なマルチマスターなRDBで書込みブロックを散らす工夫をする。

RedisとMySQLのように書込みをインメモリKVSで受け、定期的にRDBへ書き出す。

などの工夫が必要だと思います。 前者は予算的な面で誰もが取れる手法ではありませんし、後者もWriteキャッシュとなる部分と永続化部分の整合性は常に担保されなければならず、簡単に設計できるものではないでしょう。

そうした部分をAsk the speakerのブースで高木さんと色々お話しすることが出来ました。 そして、Spannerの代替として、CockroachDB（ロゴがアレなので嫌いだとか）やYugaByte DB、TiDBなどを調査されていたことも知り、分散DBについて貴重な意見交換を行うことが出来たのはCNDKの（個人的に）最大の収穫かもしれません。

なお、分散DBの話は高木さんのセッションの本質ではありません。ですので、上記に示したスライドをお読みになることをお勧めします。

（※さらに反省点として、日常会話で使うことのないTiDB等の単語を使って話が出来る喜びに舞い上がった結果、早口なオタクみたいになっていたと感じており、高木さんにはご迷惑をおかけしました。 ）

創るものから活用するものへ -価値を生み出すOperatorの力-

2つ目はレッドハット斎藤さんのKubernetes Operatorに関するセッションです。

発表資料を公開しました。 #CNDK2019 「創るものから活用するものへ -価値を生み出すOperatorの力-」https://t.co/MZ9ICKXbfE 全CNDK参加者の半分(Room A)に「Operator 知ってる！」「Kubernetes Loverだぜ！」って言ってもらえるようにプレゼンさせてもらいました。K8s やっていきまっしょい😎

— Kazu @capsmalt (Red Hat K.K.) (@capsmalt) November 28, 2019

私も東京で少なからずMeetupに参加しているので、Operatorに関するセッションはいくつか聞いてきました。 その中でも今回の斎藤さんのセッションは、要素技術の幅広さで難しいと感じがちなOperatorを丁寧に解きほぐしており（あくまで私個人の感想です）、関西のKubernetesファンを増やす非常に良いものだと感じました。

斎藤さんは前夜祭の聴衆の反応を真剣に観察されておられたようで、その後スライドを大幅に練り直したと聞き、頭が下がりました。 私もスライド作りの際には聴衆を設定してレベル感を合わせるように努力していますが、あくまでそれは頭の中の話です。実際に見て感じたものを取り込む勇気と努力に感服しました。

内容としては、（私も普��話している）ストレージやデータベースの構築・管理をOperatorで自動化するというところまで至っており、前段の話方次第で印象がここまで変わるんだなと非常に勉強になりました。

Production Ready Kubernetesに必要な15のこと

最後は@go_vargoさんのこちらのセッションです。

CNDK2019で話す「Production Ready Kubernetesに必要な15のこと」のスライドをアップロードしています セッションでは、Kubernetes上で気をつけたいことを15のテーマに分けて話します 自社事例も一例として入れていますが、あくまでプレーンなKubernetesの話ですhttps://t.co/0yHpZe0OH5#CNDK2019

— バルゴ (@go_vargo) November 28, 2019

これは私が解説するのが野暮なぐらいの、Cloud Native Daysにふさわしい素晴らしい内容でした。 Kubernetes完全ガイド等でも紹介されている機能やその他を、運用に際してどのように使っていくべきかが丁寧に解説されています。40分で本当に15個いけるのか？と思いましたが、非常に上手く濃淡を付けながら、分かりやすく説明されていました。

ProductionにKubernetesを投入するにあたり、多くの人がリファレンスとして使うことになる資料になると思います。

まとめ

如何だったでしょうか。

読み返すと趣味全開でCNDK2019の雰囲気を誤って伝えていないかは心配ですが、まあこれが私のCloud Native Daysということでご了承頂きたいと思います。

実際、CNDK中にも以下のように揶揄されており、たしかにいつもそれしか言ってないな感はあります。

どんな話題もDBに繋げれるこばさん！

— ロフトくん@11/27 CNDK2019 前夜祭LT (@loftkun) November 28, 2019

こちらのまとめを見て、CNDKが気になった方は他の方の参加ブログも見てみることを強く推奨します。 ありがとうございました。

https://cdn.qiita.com/assets/qiita-fb-2887e7b4aad86fd8c25cea84846f2236.png

[amuawia]

Post has been published on http://muawia.com/upcoming-webinar-wed-5-1-horizontally-scale-mysql-with-tidb-while-avoiding-sharding/

Upcoming Webinar Wed 5/1: Horizontally scale MySQL with TiDB while avoiding sharding