Appendix C. FAQ

Table of Contents

C.1. General Questions

C.1.1. What is Shardman?

C.1.2. What does Shardman consist of?

C.1.3. When to use Shardman?

C.1.4. When is Shardman not appropriate?

C.1.5. How many nodes does it take to deploy Shardman?

C.1.6. Does Shardman support fault tolerance?

C.1.7. How is sharding structured?

C.1.8. Is it possible to change the number of partitions?

C.1.9. Does Shardman support resharding?

C.1.10. Is it possible to convert an unsharded (local) table to a sharded one?

C.1.11. Does Shardman support adding and removing shards?

C.1.12. What is the status of data balancing?

C.1.13. How is a Shardman cluster accessed?

C.1.14. How is balancing between cluster nodes implemented?

C.1.15. Is mass data loading supported in Shardman?

C.2. Databases

C.2.1. Is it possible to create multiple databases in a Shardman cluster?

C.3. Tables

C.3.1. What kind of tables are there in Shardman?

C.3.2. What are global tables?

C.3.3. What are global tables suitable for?

C.3.4. What are sharded tables?

C.3.5. Which partitioning parameters are optimal when creating a sharded table?

C.3.6. What are colocated tables?

C.3.7. How to create a colocated table?

C.3.8. What are local tables?

C.3.9. Are foreign keys supported in Shardman?

C.4. Sequences

C.4.1. Are global sequences supported in Shardman?

C.4.2. How to create a global sequence?

C.5. User Management

C.5.1. Does Shardman support global user roles?

C.5.2. How do I create a global user in Shardman?

C.5.3. How do I grant permissions to a global user?

C.6. Useful Functions and Tables

C.6.1. How do I see which tables and sequences are distributed?

C.6.2. How do I execute some SQL command on all nodes in the cluster?

C.6.3. How do I get Shardman configuration parameters on a selected node?

C.6.4. How do I update Shardman configuration parameters?

C.7. Disaster Recovery Cluster Requirements

C.7.1. Terms and Abbreviations

C.7.2. High-level Description of the DRC

C.7.3. Replication Topology

C.7.4. Hardware and Network Requirements

C.7.5. Replication Mechanisms

C.7.6. Monitoring and Management

C.7.7. Security

C.7.8. QA and Rollback

C.7.9. Backup in Geografically Distributed System

C.7.10. Documentation and Regulations