Skip to content

HyberDB Cannot add new posts #166

@vncloudsco

Description

@vncloudsco

after implementing all features are great but we realized we can't create new posts while we can edit old posts how to fix this problem?

Image Image

I can't find any error logs, my config

<?php


$wpdb->add_database(array(
    'host'     => 'yyyyyyyyy',
    'user'     => 'repl_user',
    'password' => 'ReplPass123!',
    'name'     => 'mydb',
    'dataset'  => 'master',
    'write'    => 1,
    'read'     => 1,
));

$wpdb->add_database(array(
    'host'     => 'xxxxxxxxx',
    'user'     => 'repl_user',
    'password' => 'ReplPass123!',
    'name'     => 'mydb',
    'dataset'  => 'global',
    'write'    => 0,
    'read'     => 1,
));

error: You attempted to edit an item that doesn't exist. Perhaps it was deleted?

SLAVE status

root@ubuntu-s-2vcpu-4gb-sgp1-01:~# mysql -uroot -pStrongRootPass123! -e 'SHOW SLAVE STATUS\G'
mysql: [Warning] Using a password on the command line interface can be insecure.
*************************** 1. row ***************************
               Slave_IO_State: Waiting for source to send event
                  Master_Host: 10.130.0.10
                  Master_User: repl_user
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: mysql-bin.000001
          Read_Master_Log_Pos: 3139167
               Relay_Log_File: ubuntu-s-2vcpu-4gb-sgp1-01-relay-bin.000002
                Relay_Log_Pos: 3139336
        Relay_Master_Log_File: mysql-bin.000001
             Slave_IO_Running: Yes
            Slave_SQL_Running: Yes
              Replicate_Do_DB: 
          Replicate_Ignore_DB: 
           Replicate_Do_Table: 
       Replicate_Ignore_Table: 
      Replicate_Wild_Do_Table: 
  Replicate_Wild_Ignore_Table: 
                   Last_Errno: 0
                   Last_Error: 
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 3139167
              Relay_Log_Space: 3139567
              Until_Condition: None
               Until_Log_File: 
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File: 
           Master_SSL_CA_Path: 
              Master_SSL_Cert: 
            Master_SSL_Cipher: 
               Master_SSL_Key: 
        Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 0
                Last_IO_Error: 
               Last_SQL_Errno: 0
               Last_SQL_Error: 
  Replicate_Ignore_Server_Ids: 
             Master_Server_Id: 1
                  Master_UUID: cf28e49d-92e8-11f0-b1cf-56da8c11e7a1
             Master_Info_File: mysql.slave_master_info
                    SQL_Delay: 0
          SQL_Remaining_Delay: NULL
      Slave_SQL_Running_State: Replica has read all relay log; waiting for more updates
           Master_Retry_Count: 86400
                  Master_Bind: 
      Last_IO_Error_Timestamp: 
     Last_SQL_Error_Timestamp: 
               Master_SSL_Crl: 
           Master_SSL_Crlpath: 
           Retrieved_Gtid_Set: 
            Executed_Gtid_Set: 
                Auto_Position: 0
         Replicate_Rewrite_DB: 
                 Channel_Name: 
           Master_TLS_Version: 
       Master_public_key_path: 
        Get_master_public_key: 1
            Network_Namespace: 
root@ubuntu-s-2vcpu-4gb-sgp1-01:~# 

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions