HyperDB
HyperDB copied to clipboard
HyberDB Cannot add new posts
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?
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:~#