Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-28479

Deprecate Spider's high availability feature

Details

    Description

      Spider supports a high availability setting described in the following slides: https://www.slideshare.net/Kentoku/spider-ha-20100922dtt7

      However, this feature is difficult to use properly, and it makes the Spider implementation quite complex. I (nayuta.yanagisawa) strongly recommend using other HA solutions for high availability and using Spider just for sharding or federation. So, we deprecate the feature.

      Attachments

        Issue Links

          Activity

            yes @Michaël =)

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - yes @Michaël =)
            ycp Yuchen Pei added a comment -

            michaeldg, Aurelien_LEQUOY: thanks for explaining. How about using binlog with RocksDB for replication - is it not an option?

            https://mariadb.com/kb/en/myrocks-and-replication/

            says statement-based replication may break consistency, but one could use mixed or row-based replication, no?

            ycp Yuchen Pei added a comment - michaeldg , Aurelien_LEQUOY : thanks for explaining. How about using binlog with RocksDB for replication - is it not an option? https://mariadb.com/kb/en/myrocks-and-replication/ says statement-based replication may break consistency, but one could use mixed or row-based replication, no?
            Aurelien_LEQUOY Aurélien LEQUOY added a comment - - edited

            it's can be an option like InnoDB, but complicated to manage and in case of crash you can be sure all will be fine, have to deal with delay, crash etc... (more simple to manage it with Spider).

            For me I use spider with huge table, and it's non sense for me to keep it on InnoDB. (it's can be if you really want to be safe with your data).

            I got an apps for a client who insert 1.3 billion of rows each days, and InnoDB is not usefull for this case. an other one who got a mariadb with 50 Tb (all data inserted in one month, and rolling partitions)

            By the way i working on version 4 of Pmacontrol, this version will be able to manage and monitor spider.

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - - edited it's can be an option like InnoDB, but complicated to manage and in case of crash you can be sure all will be fine, have to deal with delay, crash etc... (more simple to manage it with Spider). For me I use spider with huge table, and it's non sense for me to keep it on InnoDB. (it's can be if you really want to be safe with your data). I got an apps for a client who insert 1.3 billion of rows each days, and InnoDB is not usefull for this case. an other one who got a mariadb with 50 Tb (all data inserted in one month, and rolling partitions) By the way i working on version 4 of Pmacontrol, this version will be able to manage and monitor spider.

            and I am pretty sure there is some companies again who use Spider with TokuDB even if this engine not supported anymore.

            Aurelien_LEQUOY Aurélien LEQUOY added a comment - and I am pretty sure there is some companies again who use Spider with TokuDB even if this engine not supported anymore.
            ycp Yuchen Pei added a comment -

            Aurelien_LEQUOY: sorry I was not suggesting that you switch to innodb. I was asking whether you could use binlog instead of spider/galera for replication. Do you mean that binlog does not work with rocksdb? The kb entries I referenced in my comment above seem to indicate otherwise. Granted the kb could be unclear or outdated but it would be good to know whether this is the case.

            Can Elkin chime in this discussion and tell us how well binlog supports rocksdb compared to its support of innodb?

            ycp Yuchen Pei added a comment - Aurelien_LEQUOY : sorry I was not suggesting that you switch to innodb. I was asking whether you could use binlog instead of spider/galera for replication. Do you mean that binlog does not work with rocksdb? The kb entries I referenced in my comment above seem to indicate otherwise. Granted the kb could be unclear or outdated but it would be good to know whether this is the case. Can Elkin chime in this discussion and tell us how well binlog supports rocksdb compared to its support of innodb?

            People

              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.