mysql migrate datadir

mysql migrate datadir

mysql 迁移数据目录.

  1. config file:

my.cnf / my.ini (windows) / conf.d/mysql.cnf (ubuntu) …

  1. datadir
  • datadir=/path/to/data/dir

alternative tmpdir and slave_load_tmpdir:

  • tmpdir=/path/to/tmpdir
  • slave_load_tmpdir=/path/to/slave/load/tmpdir.
  1. copy all original data in datadir to new datadir

e.g.

cp -va /path/to/orig/data/dir/ /path/to/new/data/tmpdir
mv /path/to/new/data/tmpdir /path/to/new/data/dir

troubleshoots

  • windows, mysql 8, 修改 my.ini 配置并迁移原 data 目录后后启动服务失败 ?
    • 查看服务的用户,例如改为 administrator 并提供正确密码 !!.
    • 可以先将 ...err 错误日志文件删除,然后再启动,再查看错误日志,否则可能没有错误日志 !!

例如错误信息为:

> net start mysql80

MySQL80 服务正在启动
MySQL80 服务无法启动

服务没有报告任何错误

请键入 NET HELPMSG 3534 以获得更多的帮助

see also https://yuiwong.org/gitlab/database/database/blob/master/mysql/mysql-migrate-datadir.md

C++ 最佳实践之 M&M rule

C++ 最佳实践之 M&M rule

M&M rule: mutable and metux(or shared_mutex(rwlock) or atomic …) go together!!

首先典型的问题的由来:在设计一个类的时候,我们希望一些方法是 const 的,
然后呢,有些场景,我们又希望所有方法是线程安全,于是使用 shared_mutex 等,
但是 const 方法怎么办 ?不考虑一些 hack的方式,例如 const_cast、直接获取地址等,
— 于是就会使用 mutable 修饰 shared_mutex,这样 const 方法可以正常使用 shared_mutx
的对象的。

另外,

  • 在使用 lambda 表达式(closure)的时候,也可以使用 mutable 修饰,这样通过拷贝方式捕获的变量,也可以在 closure 中修改,但是只是修改了 closure 中的,外面的不受影响!当然如果不用修改,最好是 immutable 的!
  • 然后 C++98 也是可以使用 mutable,例如 gcc、vc 等都是支持的。

Guideline: Remember the “M&M rule”: For a member variable, mutable and mutex (or atomic) go together.

(1) For a member variable, mutable implies mutex (or equivalent): A mutable member variable is presumed to be a mutable shared variable and so must be synchronized internally—protected with a mutex, made atomic, or similar.

(2) For a member variable, mutex (or similar synchronization type) implies mutable: A member variable that is itself of a synchronization type, such as a mutex or a condition variable, naturally wants to be mutable, because you will want to use it in a non-const way (e.g., take a std::lock_guard) inside concurrent const member functions.


See also

One more circular buffer(normal queue)

One more circular buffer(normal queue)

Sometimes we prefer to use circular buffer: “like CircularBuffer, but NOT use size and next index, but use front and rear”, so an impletametation here.

See also
Write a CircularBuffer
std::queue
Full impletametation: circularqueue.hpp

/**
 * Var capacity circular queue.
 * NOTE:
 * - Like CircularBuffer, but if full, enque(push) will FAIL!
 * - And like CircularBuffer, but NOT use size and next index, but use front
 *   and rear.
 * - When use in multi-threads, should add lock or some other to sync.
 * @tparam T data type.
 * @sa CircularBuffer
 * @todo
 * - Add full CircularBuffer like features.
 * - Add iterators.
 */
template<typename T>
class CircularQueue {
public:
    /**
     * Ctor.
     * @param capacity the buffer capacity, should >= 1.
     * @throw std::logic_error when capacity invalid.
     */
    CircularQueue(int32_t capacity = 1, const T& initValue = T{});
    /**
     * Test whether container is empty
     * @return True if queue is empty, false otherwise.
     */
    inline bool empty() const noexcept;
    /**
     * Test whether container is empty
     * @return True if queue if full, false otherwise.
     */
    inline bool full() const noexcept;
    /// @return data size.
    inline int32_t size() const noexcept;
    /// @return queue capacity.
    inline int32_t capacity() const noexcept;
    /**
     * Inserts a new element at the end of the queue, after its current last
     * element. The content of this new element is initialized to value.
     * @param value Value to which the inserted element is initialized.
     * Member type value_type is the type of the elements in the container
     * (defined as an alias of the first class template parameter, T).
     */
    bool push(const T& value) noexcept;
    bool push(T&& value) noexcept;
    bool pop() noexcept;
    bool pop(T& value) noexcept;
    /// @throw std::logic_error when queue empty.
    T pop_front();
    /**
     * Get queue head(front) when not empty.
     * @return queue head(front) when not empty.
     * @throw std::logic_error when empty.
     */
    const T& front() const;
    T& front();
private:
    /// Pop index(current or next readable), init as empty.
    int32_t currRFront{ -1 };
    int32_t lastWRear{ -1 };///< Push index(last writeable), init as empty
    int32_t capa{ 1 };///< The buffer capacity, > 0.
    std::vector<T> buffer;///< The internal buffer.
};