Dummies Guide

[GZMO786]

Hi, I need help on implementing this plugin into Wocommece, I'm using siteground and I keep hitting the 1gb database limit.

I've downloaded the zip, place the files where it says to, filled in the configuration file with the additional databases I think???

I get the error of the woocommerce has encountered an error.

Do I have to add the original database to the config file or only the additional ones? Also are the usernames and passwords supported to be in comma?

Just need help keeping it simple, I'm not a programmer, so any help can we keep it simple lol!

Regards

[GZMO786]

Hi, All
have a issue where this plugin seems to not activate, i've checked logs it comes up as
[13-Aug-2024 23:51:37 UTC] WordPress database error Table 'db4z2otolssick.fjq_postmeta' doesn't exist for query SELECT
[13-Aug-2024 23:51:37 UTC] WordPress database error Table 'db4z2otolssick.fjq_posts' doesn't exist for query SELECT

So both them tables are located in different databases, I've attached the config file, as I can see what I'm doing wrong.

`<?php

/**

LudicrousDB configuration file
This file should be copied to ABSPATH/db-config.php and modified to suit your
database environment. This file comes with a basic configuration by default.
See README.md for documentation.
*/
// Exit if accessed directly
defined( 'ABSPATH' ) || exit;

/**

This sets the default character set. Since WordPress 4.2, the suggested
setting is "utf8mb4". We strongly recommend not downgrading to utf8,
using latin1, or sticking to the default: utf8mb4.
Default: utf8mb4
/
$wpdb->charset = 'utf8mb4';
/*

This sets the default column collation. For best results, investigate which
collation is recommended for your specific character set.
Default: utf8mb4_unicode_520_ci
/
$wpdb->collate = 'utf8mb4_unicode_520_ci';
/*

This is useful for debugging. Queries are saved in $wpdb->queries. It is not
a constant because you might want to use it momentarily.
Default: false
/
$wpdb->save_queries = false;
/*

The amount of time to wait before trying again to ping mysql server.
Default: 0.1 (Seconds)
/
$wpdb->recheck_timeout = 0.1;
/*

This determines whether to use mysql_connect or mysql_pconnect. The effects
of this setting may vary and should be carefully tested.
Default: false
/
$wpdb->persistent = false;
/*

This determines whether to use mysql connect or mysql connect has failed and to bail loading the rest of WordPress
Default: false
/
$wpdb->allow_bail = false;
/*

This is the number of mysql connections to keep open. Increase if you expect
to reuse a lot of connections to different servers. This is ignored if you
enable persistent connections.
Default: 10
/
$wpdb->max_connections = 10;
/*

Enables checking TCP responsiveness by fsockopen prior to mysql_connect or
mysql_pconnect. This was added because PHP's mysql functions do not provide
a variable timeout setting. Disabling it may improve average performance by
a very tiny margin but lose protection against connections failing slowly.
Default: true
/
$wpdb->check_tcp_responsiveness = true;
/*

The cache group that is used to store TCP responsiveness.
Default: ludicrousdb
/
$wpdb->cache_group = 'ludicrousdb';
/*

This is the most basic way to add a server to LudicrousDB using only the
required parameters: host, user, password, name.
This adds the DB defined in wp-config.php as a read/write server for
the 'global' dataset. (Every table is in 'global' by default.)
/
$wpdb->add_database(
array(
'host' => DB_HOST, // If port is other than 3306, use host:port.
'user' => DB_USER,
'password' => DB_PASSWORD,
'name' => DB_NAME,
)
);
/*

This adds the same server again, only this time it is configured as a replica.
The last three parameters are set to the defaults but are shown for clarity.
*/
$wpdb->add_database(
array(
'host' => DB_HOST, // If port is other than 3306, use host:port.
'user' => DB_USER,
'password' => DB_PASSWORD,
'name' => DB_NAME,
'write' => 1,
'read' => 1,
'dataset' => 'global',
'timeout' => 0.2,
)
);
// Add the second database for handling fjq_postmeta table
$wpdb->add_database(
array(
'host' => 'localhost',
'user' => 'ukwgyhvosujdc',
'password' => '32&$n#31cei1',
'name' => 'dbg6waxvouhikg',
'write' => 1,
'read' => 1,
'dataset' => 'fjq_postmeta',
)
);

// Add the third database for handling fjq_posts table
$wpdb->add_database(
array(
'host' => 'localhost',
'user' => 'ukwgyhvosujdc',
'password' => '32&$n#31cei1',
'name' => 'dbnpicwhj2fcxq',
'write' => 1,
'read' => 1,
'dataset' => 'fjq_posts',
)
);

// Custom callback for query routing
$wpdb->add_callback('db_callback');

function db_callback($query, $wpdb) {
if (strpos($query, $wpdb->base_prefix . 'fjq_posts') !== false) {
return 'fjq_posts';
}
if (strpos($query, $wpdb->base_prefix . 'fjq_postmeta') !== false) {
return 'fjq_postmeta';
}
return 'global';
}`

It seems to keep requesting the tables from the main database but it should be requesting it from the correct database. I think it must have to do with the callback, but not much info on how to correctly set it up.

Thanks