icefiredb / icefiredb Goto Github PK

Ask your question here

when I use command about mysql after successfully connecting,such as 'show databases;',it show above error.

Hello,

I was able to compile IceFireDB but have not found any documentation that shows the steps to start up a multi-node cluster and then make some queries?

I am interested in highly distributed P2P usage and scaling limits of IceFireDB
Thanks

is there any config file ?
how to start a cluster ?
thanks.

hello, do you hava plan to support lua script like traditional redis-server does ?
thanks.

Would it be possible to set up a MySQL cluster such that some participants have read-only access, and others have full admin access to the database?

The read-only participants would not be able to Create Table, Insert, Update, Drop, Delete, etc. But they would still receive and propagate updates made from the write-access participants.

From what I understand, when someone has your ipfs/p2p service_discovery_id and service_command_topic, they have full admin access to the database depending on the local MySQL User rights. So all nodes in the network must be trusted not to abuse the system.

Say, instead, we make two p2p IceFire-Proxy clusters: one service_discovery_id/_topic for the Writers, and another combo for the read-only access.

And then we set up both zones to the same local MySQL database, only using different MySQL local accounts with different access: a readonly user and the normal root user.

Any suggestions on how to hook up some rudimentary access control with the SQL Proxy?

Questions:

• Could the SQL Proxy pick up and publish changes made directly on the MySQL local db by another SQL Proxy instance in real time? Would we need to add triggers?
• What happens if the SQL Proxy receives a database error from the local node (say, from access denied)? Will it propagate the request anyway to the next nodes?
• What happens if the node receives an abusive SQL query that creates a database error from someone else? Will that be propagated to all participants too?

Thanks!

I now see that the Redis proxy has all commands configured as either read or write commands here: https://github.com/search?q=repo%3AIceFireDB%2FIceFireDB%20AddReadCommand&type=code

Say we abandon SQL and want to use Redis for this instead.

Could this system be used to check that Write commands only come from allowed nodes?

I want to understand what is the architecture. What is the process of configuring, adding, removing nodes?

How was raft integrated with redis, IE. where was raft end and redis begin?

1. can you implement tls into the system?
2. is this production ready?
3. who are the users of icefiredb?

Ask your question here

大家好：
我叫李益， 英文名 Rock, 我从2021年10月份开始在跟伙伴们开发一款开源的去中心化的、点对点数据库 P2PDB, 今天看到了@gitsrc对我的项目点赞，从而发现了IceFireDB

IceFireDB 令我感到惊讶、兴奋和激动，在详细阅读IceFireDB的文档后，我发现IceFireDB跟P2PDB的系统设计思路是何其的相似，虽然在具体实现上两个项目有较大的差异（如sqlite mysql服务端的实现方式）, 但是这依然让我感到兴奋， 因为长时间以来，我们一直在孤军奋战，难得有志向相同的同学一起在去中心化数据库这个领域深耕，特别大家都还是国人。

如果不嫌弃的话，希望能加个私人聊天方式，详细跟贵团队同学探讨一下合作的可能性。

私人邮箱：[email protected] 可以向该邮箱发送任何可以联系的方式 微信 qq telegrem ， 期待贵团队的回复。

Hello,

I have been doing research for a new P2P project in development and need to try and locate a DB that massively scales.

It appears that IceFireDB "might" be capable of this since it uses IPFS but I am not sure.

My project is a type of massively scaling P2P eCommerce system for which I need a good DB that can scale and also work P2P as nodes will be joining and leaving the network but if IceFireDB also replicates (shards) out data across nodes then that would provide for redundancy and a safety net when a particular node leave the network.

Can you please elaborate more on this for me?
Thanks and have a great day.

Do you plan to support ZRANK and SET in IceFireDB?

Hi,

The source code in the rafthub directory of this project is directly copied from https://github.com/tidwall/uhaha/blob/master/uhaha.go, which is 3K+ lines of original source code written and copyrighted by me.

The original copyright notice and LICENSE were omitted.

The Uhaha LICENSE states:

The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.

hello, is there any golang client library that can talk to IceFireDB, and can automatically do failover when one server node crashed ?

1. I assume it is using CRDT, right?
2. What I have found when studying the P2P source is that a generic not only local network only network is started. Is is possible to limit the P2P configuration to use just mDNS and stay within a local network without NAT and without default bootstrap pairs?
3. Is it also possible to use pre-created keys for the P2P identity and check them as access permission?

LedisDb limits key size to 1024 bytes. Does this limitation apply to IceFireDB too?