Changes between Version 2 and Version 3 of proxysql


Ignore:
Timestamp:
Dec 12, 2022, 2:33:48 PM (3 years ago)
Author:
Jamie McClelland
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • proxysql

    v2 v3  
    4444Use the `main` database and peruse the `mysql_users` table to see which users should be configured to use which backend MySQL servers. The `default_hostgroup` of 999 is the localhost. `default_hostgroup` 1 is lumumba and 2 is pachamama.
    4545
     46If you get an error when `mf-transfer` updates the MySQL user about not being allowed to set a MySQL user host to a different host than the database, that means you have a user with access to two different MySQL databases. The solution is to move on to the other database. Then, return to the original database. `mf-transfer` will not re-import an already imported database, it will simply ensure that the control panel items are properly up-to-date so you can safely re-run.
     47
    4648== Post Transition ==
    4749